Tag: saved search

Scheduling Fixed Asset Creation

Scenario: If the bill/journal contains lines that don’t have fixed assets created is greater than 100,  The script will create fixed assets with scheduled process. The script will be scheduled for every 1 hour. And the scheduled script will send the email to the bill owner after creating the fixed asset for that bill. Solution:… Continue reading Scheduling Fixed Asset Creation

Scheduled Email through Saved Search

Scheduled email serves a regular update on the saved search results. Saved search results mailed according to the scheduled and also gives alerts when there is any add or update. it can be sent from search owners email address, or default address as company preferred. and also we can customize the content on the message… Continue reading Scheduled Email through Saved Search

Search is not working in the Extension

The search is not working in the extension. But the search is working in Netsuite. Issue: There are two functions in the extension for getting details of files and folders from the backend(suitescript file), In the execution log of the corresponding ssp application, it is showing as blank object value is not getting. Solution 1:… Continue reading Search is not working in the Extension

Report to Show Bills Paid via Electronic Payments.

When paying Entities (Vendors, Employees, Customers) using EFT Bill Payment, there is no feature right now to extract the Bills paid via the Payment File Administration record. To get a list of the Bills paid per PFA, you may use the following saved search setup and export the results for further reconciling:  1. Navigate to Lists > Search > Saved Searches > New > Transaction 2. Under… Continue reading Report to Show Bills Paid via Electronic Payments.

Formula To Get Item Child Name Only

Use the below formula to return only the item child name in a saved search. REGEXP_REPLACE(REGEXP_SUBSTR({name},’: [^:]+*$’),’: ‘,”) For example without the formula a parent : child item will display as: Parent Item Name : Child Item Name Using the formula only Child Item Name will display.

Remove Parent Item Name in Saved Searches

When creating Item Saved Searches, the Name field displays the parent matrixitem name before the matrix child, (example: Parent Item : Matrix Child).The Ability to remove the parent matrix item in Inventory Reports is not availableyet in the system and Enhancement # 161435 has been filed requesting for this.As a workaround to display only the… Continue reading Remove Parent Item Name in Saved Searches

Update Labor Cost And Unit Cost

Proposal summary This proposal covers the scope of updating employee Labor Cost per month. Requirement  Neutrinos need to update the employee cost which is used for labor costing calculations in the project module, according to the change in their payroll amounts in Adrenalin. Our Solution The Unit Cost field in the project task record is… Continue reading Update Labor Cost And Unit Cost

Saved Search for show the Related Records of Transactions

We have created a transaction search with Criteria set as :- FILTER DESCRIPTION Main Line Is false Tax Line Is false Shipping Line Is false COGS Line Is false Under Results > Columns , enter the following fields:- FIELD SUMMARY TYPE Internal ID Group Type Group Name Group Document Number Group Date Group Amount (Foreign Currency) Amount (Transaction Total)… Continue reading Saved Search for show the Related Records of Transactions