Skip to main content
Solved

When a Packing List is used, we want to use LotSerialNbr's, what DAC holds those numbers for Packing List? come from

  • 15 March 2024
  • 1 reply
  • 53 views

Forum|alt.badge.img+1

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.

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)

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

1 reply

mbarrett
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 10 replies
  • Answer
  • March 21, 2024

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


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