Question:


I am trying to import into the IV_TRX_WORK_Serial_Lot table for my Inventory Transaction and am confused on the difference between the Line SEQ Number and the Serial/Lot SEQ Number fields. What do I populate these fields with?


Answer:


When you are working with Serial Lots, each Serial Lot has it's own sequence number (Serial/Lot SEQ Number), and the item itself has it's own sequence number (Line SEQ Number). Use the following example as a guide:


Line SEQ NumberItem Number# of Serials

110013

210200

310504


Here, you see that there are 3 separate items. Items 1001 and 1050 are serialized items and Item 1020 is not. This would be the information you use to import into the IV_TRX_WORK_LINE table for the Line SEQ Number field and the Item Number fields. The # of Serials column shows how many serial/lot numbers there are for that item and is just informational and not used in the actual import into the IV_TRX_WORK_LINE table. The next example shows how you would distinguish between the two line sequence number fields in the IV_TRX_WORK_Serial_Lot table:


Line SEQ NumberItem NumberSerial/Lot SEQ Number

110011

110012

110013

310501

310502

310503

310504


Notice that there is no information here for the second item (Item 1020) since it has no Serial/Lots and therefore would not be included in the IV_TRX_WORK_Serial_Lot table. The Line SEQ Number field is the same number you used in the IV_TRX_WORK_LINE table for each item. The Item field and Line SEQ Number fields would remain the same for as many Serial/Lots there are. The Serial/Lot SEQ Number would start with 1 for the first serial/lot and then increment by 1 for however many there are.




This article was TechKnowledge Document ID:9582

TechKnowledge Content

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×