Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Tieing an Item Receipt TransLine to the Original Line of the Transfer Order.
I am trying to create a SQL query to pull in all transaction lines on a transfer. I am trying to get the received field but it looks like it is calculated behind the scenes and not easily accessible from the normal fields on a TL.
The 'quantityshiprecv' field will always show the same amount that was picked on the order.
I have tried joining the item receipt lines back to the transfer but if I have lines with the same SKU I do not see a way to tie it back to the corresponding line.
line sequence numbers do not correspond to eachother nor do lineids.