Our Packing Lists needs LotSerialNbrs and I’m attempting to duplicate the process that we used in our Commercial Invoices, but having issues trying to figure out where those LotSerialNbrs would be coming from. Any help as far as letting me know the DAC’s involved would be appreciated.
Solved
When a Packing List is used, we want to use LotSerialNbr's, what DAC holds those numbers for Packing List? come from
Best answer by mbarrett
There are various paths for this depending on how the flow of the documents are being processed and also how/when the Lot/Serial numbers are being assigned.
- From Sales Order line:
- If the Lot/Serial number and line items are 1 to 1 such as one Sales Order line gets a singular Lot/Serial number assigned, then you can reference the SOLine DAC to pull the singular Lot/Serial number value.
- If the Lot/Serial number and line item are 1 to many such as one Sales order Line gets multiple Lot/Serial number assigned to the multiple qty’s then you would have to use the DAC SOLineSplit, you will find the multiple assigned values however you would most likely need to build a sub report for this due to the fact that you would face record duplication in your main report if you simply joined in the SOLineSplit table.
- From Shipment line:
- If the Lot/Serial number and line items are 1 to 1 such as one Shipment line gets a singular Lot/Serial number assigned, then you can reference the SOShipLine DAC to pull the singular Lot/Serial number value.
- If the Lot/Serial number and line item are 1 to many such as one Shipment Line gets multiple Lot/Serial number assigned to the multiple qty’s then you would have to use the DAC SOShipLineSplit, you will find the multiple assigned values however you would most likely need to build a sub report for this due to the fact that you would face record duplication in your main report if you simply joined in the SOShipLineSplit table.
Not sure if there is a different option to assign a Lot/Serial number at the time of using the “Pick, pack, and Ship” process, however, I also found a Split table in the database that could be referenced to return the Lot/Serial number value.(SOPickingWorksheetLineSplit)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.