Skip to main content
Solved

How do I get Lot/Serial Numbers for Drop Shipments from a Sales Order Invoice?

  • 13 March 2024
  • 1 reply
  • 83 views

I’ve tried joining on Shipment and its line split, as well as via INTran and INTranSplit.

I wrote a query to pull some relevant data. It is later filtered from ARTran details in SO643000.

trans    ARDocType    ARRefNbr    POReceiptNbr    RefNbr    SOOrderNbr    SOShipmentNbr    Split    LotSerialNbr
INTran    INV    AR012036    PR002026    005940    SO007464    PR002026    INTranSplit    
INTran    INV    AR012035    NULL    005939    SO007463    005039    INTranSplit    SRF000005
INTran    INV    AR012035    NULL    005939    SO007463    005039    INTranSplit    SRF000006
INTran    INV    AR012035    NULL    005939    SO007463    005039    INTranSplit    20230307

 

The top one is what I have in the ARTran. The bottom three are what actually have the serials for the invoice in question. It doesn’t have serials, and I can’t find a single ID in common.
The test case I have is here. It has serialized items on the invoice, but getting them is the problem.

 

Any help is appreciated.

Best answer by dcomerford

I have done this before but cannot find my notes on it. From memory you need to go to the Purchase Receipt Line or Purchase Receipt Line split and get the details from there. 

View original
Did this topic help you find an answer to your question?

1 reply

dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 596 replies
  • Answer
  • July 22, 2024

I have done this before but cannot find my notes on it. From memory you need to go to the Purchase Receipt Line or Purchase Receipt Line split and get the details from there. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings