Skip to main content
Updating Expected Receipt Date for Purchase Orders

ExtendInsights Data Management | Know how to easily update the Expected Receipt Date for Purchase Orders

Updated over 2 months ago

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!

Did this answer your question?