Skip to main content
Solved

Production Order Preassigned Serial # not showing in Lot/Serial Attributes table INItemLotSerialInfo

  • 12 June 2024
  • 3 replies
  • 37 views

We use the latest 23R1 Github Lot/Serial Attributes customization.  The new table name that houses the attributes information is INItemLotSerialInfo.

When we create a Production Order with a preassigned serial #, a record is created in the INItemLotSerialInfo table so that attributes can be added to the Inventory ID/Serial # record even before a Production Receipt brings the item into inventory.

However, when we update the preassigned serial number (once a VIN is assigned to the vehicle, we update the serial # to the VIN), a new record is not consistently created in the INItemLotSerialInfo table.  This causes us to have to wait until the Production Receipt has been completed to enter the Serial attribute information.

Any ideas for the inconsistent behavior and how to make sure a record is always created when a new preassigned serial # is assigned to a Production Order?

3 replies

S
Rank
Userlevel 3
Badge

Did you find a solution to this ?

D
Rank
Userlevel 4
Badge +1

I had a call with Acumatica customizations support and found out why a preassigned serial number does or does not show in the Lot/Serial list:

  • If a Sales Order is tied to the Production Order at the time the preassigned serial number was populated, no entry is created in the Lot/Serial list because the AVAILABLE quantity for that serial number is zero (the Sales Order is demanding that serial number)
  • If a Sales Order is NOT tied to the Production Order at the time the preassigned serial number was populated, an entry IS created in the Lot/Serial list because the AVAILABLE quantity for that serial number is 1 (no Sales Order is demanding it yet).

In summary, entries for preassigned serial numbers on open production orders are only created in the Lot/Serial list if the available quantity is one at the time the serial number was populated.  

Acumatica customizations support does not plan to change the way this works.  They are basing the way the customization works on Acumatica’s Item Plan tables as to whether the quantity available is greater than zero.

No matter what, once the production order is completed, the serial number will show in the Lot/Serial list.

Chris Hackett
Rank
Userlevel 7
Badge

Thank you for sharing the solution with the community @danielklumpp!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings