Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Attention: Customers with NetSuite Electronic Bank Payment (EBP) SuiteApp, version 2020.2 QA (ID 315896) must UPDATE (do NOT uninstall) their bundle to the Production version 2022.1 (ID 416781) by December 31, 2022. Note: If users fail to manually update the Electronic Bank Payments SuiteApp within the given time window, this version of the SuiteApp (ID: 315896) will be deprecated and the account will not be updated to Leading version (2022.1) of the Electronic Bank Payments SuiteApp. Please refer to the campaign email sent to impacted customers for more information.
Update your Profile with your Support type to get your Support Type badge.
NetSuite Release 2023.1 is here! Download the release notes and post your questions in the new Release 2023.1 category.

Relating transaction lines between purchase order and sales order

First, I apologize if this is covered somewhere already. I searched for a couple hours in various places and looked at the Records Browser, but could not find an answer.

Is there an transaction line field that relates lines between a purchase order and the sales order from which it was created. Take for instance:

Sales Order 1

  1. Item A
  2. Item B
  3. Item A
  4. Item B
  5. Item C

Purchase Order 1

  1. Item A (from line 3)
  2. Item B (from line 4)

Purchase Order 2

  1. Item A (from line 1)
  2. Item B (from line 2)

Purchase Order 3

  1. Item C (from line 5)

We need to know which line on the sales order each line on the purchase order is related to. Since an item can exist on an order multiple times, using the item name isn't possible. The line number fields on the transactions are specific to that transaction.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

This Week's Leaders

This Month's Leaders

All Time Leaders