Category: NS Administration

All articles / code related to Netsuite administration

How to get the last year Purchase Bill and payed in next year

For auditing purposes, the client has requested a tracking of purchase bills that were initially booked during December 2022 and subsequently settled in the following year, 2023. This entails identifying bills that were open in the 2022 calendar year and paid in 2023. Solution Go to List > search> saved search > Transaction Enter name… Continue reading How to get the last year Purchase Bill and payed in next year

Unable Download Attachemnt from Transaction.

SCENARIO The client is not able to download the excel sheet attached to Purchase order. The purchase order is created from Subsidiary X and the employee is from Subsidiary Z. REASON There will be subsidiary restriction for the folder. SOLUTION Go to File cabinet. Type the name on the search bar. Click on the edit… Continue reading Unable Download Attachemnt from Transaction.

Search to pull list of items with a specific price level with zero or null values

Search to pull list of items with a specific price level with zero or null values 1) Navigate to Lists > Search > Saved Searches > New > Item 2) On the Criteria tab > Standard sub tab >  Select Formula (Numeric) > Formula=CASE WHEN NVL({pricelevel1},0)<=0 THEN 1 ELSE 0 ENDEqual to 1. **Pricelevel1 = where 1 is… Continue reading Search to pull list of items with a specific price level with zero or null values