Print SO Line Number on Packing Slip & Invoices on crystarl report

Question

Hello Everyone, 
 
 Looking for a little help on how to print the sales order line number on Packing Slips & Invoices. 
 We are finding every time a partial order is shipped the line numbers are renumbered starting at one based on the remaining lines to be shipped. 
 We would like to retain and report the line number as reflected in the SO_SalesOrderHistoryDetails.tbl, but I am not finding any way to link the reported data back to this table. 
 Please note: the Item Number cannot be used, as there are many lines with duplicated item numbers, and these lines may not ship in the sequential order. 
 
 Thanks in advance for any help or ideas, 
 
 Bradley Wolosz 
 Hainbuch America 
 Plant Operations Manager

Kevin M · Accepted Answer

If you want a consistent line reference to the SO details, use the invoice detail table's "OrderLineKey" value. (Pass it through to the work table using a UDF). 
 The LineKey in the invoice detail table is the key for the invoice lines, not a reference to the SO detail LineKey.

David Speck · Answer

The detail table's LineKey field is very similar to most databases InternalId. Each time a new line is added, the next sequential value is assigned to the LineKey, if a line is deleted, is does not affect this sequence, if a line is reordered, it does not affect this sequence. This is a permanently assigned value to the line and is entirely based on the order of lines being added. 
 The detail table's LineSeqNo field is very similar to the LineKey field but will change when lines are reordered, Sales Order Entry uses this field to determine the display order of lines on the Lines tab.

Sage100Reports · Answer

I have done this before. The easiest solution was to create a UDF field in the SO_SalesOrderDetail table to store the original line number. Initially the user just entered the line numbers manually when entering the Sales Order, but eventually a script was written to store the value. Hope this help!

Sage 100

Print SO Line Number on Packing Slip & Invoices on crystarl report

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING