Skip to main content
Question

Generate Pre-assigned Lot/Serial Nbr in production order based on full box qty

  • July 15, 2025
  • 3 replies
  • 70 views
C
Freshman II
Forum|alt.badge.img

We have production orders set to ‘Preassign lot serial numbers.’ We can populate each one manually but it is extremely cumbersome.  I am trying to get the below result(base on full box qtys of 60) through an import scenario

The import scenario functionality has this at the order level but there is no where to specific qty. 



At the line details level it looks like I would need to manually assign lot # and qty 

 

At the end of the day we are looking for a non-manual way to serialize our full cases of product. I know there have been several product ideas around this but I am look for a practical solution, not to pray and wait.

Has anyone implemented anything like this?

3 replies

R
Captain II
Forum|alt.badge.img+2

​@chese79 

Please try the below option.

You can define the lot size in the stock item, and based on that, create a Generic Inquiry using a SQL View that duplicates the lines according to the lot size.

For example, if your Qty to Produce is 100 and the Lot Size is 10, the SQL view can generate 10 rows, each representing a production batch of 10 units. This allows you to see the data split by lot in the Generic Inquiry.

You can then use this view in your GI to display the duplicated lines, and further use a Business Event along with an Import Scenario to create related ten rows in production order line details tab.

🚀If I have helped you, "Like" my post. If it solves it mark "Best Answer". 🚀
angierowley75
Chris Hackett
AndreasKleinfeld72
C
Freshman II
Forum|alt.badge.img
  • chese79
  • Author
  • Freshman II
  • July 16, 2025

How do you get to the SQL view? This is new for me.

 

thx

Chris

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • September 24, 2025

Hi ​@chese79 were you able to find a solution? Thank you!

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*.
Terms & ConditionsCookie settingsAccessibility statement
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