As Of refers to the date that the report will capture transactions. If As Of is set to yesterday, then the transactions that the Aging report will include will be all the transactions dated up to yesterday’s date. Age As Of refers to the date from which the report will count the age of transactions. If Age As Of is set… Continue reading Difference of As Of and Age As Of on Aging Reports
Author: Sreelakshmi R
Item Fulfillment – Address Update
Scenario A User Event script is loading the Item Fulfillment record dynamically and it appends details to the Attention (id: attention) field found in the Address subrecord. Appending values to the said field in the record level will automatically check the Override (id: override)checkbox that is also a part of the Address subrecord of the Item Fulfillment and set… Continue reading Item Fulfillment – Address Update
Apply Summary Search Result to a Field
Requirement: We need a reference in the Sales Order Advanced PDF template to distinguish whether the order has an invoice posted against it or Partially/Fully fulfilled. Solution: We can create a free-form text type field where we will add a summary search which shows the count of applying transactions (type= invoice or Item fulfillments) in… Continue reading Apply Summary Search Result to a Field
Creating Work Orders From Item Records
You can set an assembly item to default to create a work order by tagging the item record. Then, when the item is selected on a sales order, the box in the Create WO column is automatically checked. To set an assembly item to default to create a work order: Go to Lists > Accounting >… Continue reading Creating Work Orders From Item Records
Create Work Order From Sales Order
You can tag items to create work orders when you enter a sales transaction by checking the box in the Create WO column. Then, when you save or approve the order, NetSuite creates a work order that is linked to the sale. To create a work order from the sales order: Go to Transactions > Sales > Enter… Continue reading Create Work Order From Sales Order
Handling Matrix items – Netsuite Saved Search
1. Create an item saved search that excludes parent matrix items and includes all other inventory types and child matrix items. 1. Navigate to Lists > Search > Saved Searches > New > Item 2. Under Criteria tab > Standard subtab, add the filter: • Matrix Item = False 3. Hit Save & Run.… Continue reading Handling Matrix items – Netsuite Saved Search
Compare Address Fields on Entity and Transaction
Use case: This Solution can be used when we cannot get an exact match between Address text (Ship To address as referred here) in both transaction and customer, but can essentially compare between the address fields in the subrecord. Sample Scenario: When creating a Customer record, we often enter a default address. This default address is… Continue reading Compare Address Fields on Entity and Transaction
“RECALC” Replaced by “SUBLISTCHANGED”
Before we wrap up, there is one important change to SuiteScript 2.0 Client Scripts that impacts how we work with sublists. In 1.0 Client Scripts, there is an event called recalc. This event fires whenever a change has been made to a sublist that impacts the total of a transaction. Let’s say you are editing a… Continue reading “RECALC” Replaced by “SUBLISTCHANGED”
Points to Note While using Sourced Fields in Other Customizations
Saved Search Case – A field made in a record that is sourced from another search not shown in another Saved search of the same record: A body level field (Free-from text) made in a transaction which is sourced from another search based on line fields join fields which fetches the items record’s field which… Continue reading Points to Note While using Sourced Fields in Other Customizations
Working with Address Override
A user may want to set a default value, whether marked or unmarked as default, for the Override box in the Address field of their transaction recordsSolution:For transactions that will be created manually in the NetSuite UI. the default value of the Override box in the Address field of transaction records depends solely on the default value set on the Address field in the Customer/Vendor records.For instance,… Continue reading Working with Address Override