Skip to main content

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?

Did you find a solution to this ?

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.

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

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved