Track when the item will arrive in your warehouse by updating the Expected Receipt Date.
Template Layout
๐ก Tip: It is best to check out the forms and fields and identify the header, column, and required fields in NetSuite that you may need to build the template.
If you are using NetSuite Classic Interface you can go to:
Transactions>Purchases>Enter Purchase Orders > List
Tran Id
Tran date
Entity
Memo
Item List: Item
Item List: Quantity
Item List: Rate
Item List: Expected Receipt Date
Item List: Replace All (Optional, set to FALSE - this is used for other line item fields not exposed on the template to not be affected after the update)
Different Approach to Update
Using Formulas
Calculate the dates using formulas. Learn more about it here.
Change the cell format to General.
Click the cell and enter the formula to recalculate and display the value
Copy and Paste from other Systems
If you have data from other systems, you can prepare them beforehand and easily use the copy/paste feature of Excel and you are ready to upload to NetSuite in a few clicks!
XLOOKUP or VLOOKUPs
Return the results of expected delivery date to match with the item and vendor.
Manually Type Data
Type in the cell to manually enter the dates then upload to NetSuite!