RKL eSolutions Blog Trends and Insights

Aligning Lot Numbers with Work Order Numbers

Some companies would like to create their Finished Good products with a Lot Number that is the same as the Work Order Number that created the product. This can making tracing the Lot easier.
If you would like to know how to do that, please see below:

First go to Set up > General Parameters > Parameter Values
Choose Chapter GPA from the left list, Group MIS.
Then make sure that LOTMGT parameter is set to ‘In Release’. This will cause the Lot Number to be created at the time the Work Order is Firm.

Workorder-lotnumbers-1

Next go to the Product – Common Data > Products > Products

Make sure the Lot Management setting is ‘Mandatory lot’ and under the Lot Sequence – this MUST be blank.

Workorder-lotnumbers-2

Workorder-lotnumbers-3

From the Product record – Jump to the Product Category:

Keep in mind that after making the Product Category changes – it will affect all Products in this category for future transactions but you should still make sure that the Product settings from above have been made.

Under Lot Management please make sure the ‘Mandatory Lot’ is checked and LOT sequence is blank.  Save and then scroll down to Receipts

Workorder-lotnumbers-4

Workorder-lotnumbers-5

Workorder-lotnumbers-6

Once you scroll down to Receipts – go to the Work Order Issue line – scroll over to Lot Entry and change this to ‘Free’ and then change Lot by default to ‘Document number’…..Save.

Workorder-lotnumbers-7

Now when you enter a Work Order for that Parent Product FIN048 the Lot number will automatically be populated with the Work Order Number.

So this is how you set up SEM to have your Lot Number for a Finished Good be the same as the Work Order Number that created it.

Workorder-lotnumbers-8

RKL Team

Written by RKL Team

Since 2001, RKL eSolutions has helped growing companies maximize their technology resources and investment. Over the years, we have helped hundreds of small and medium sized businesses as their strategic business partner. We specialize in the needs of Entertainment, Software & SaaS, Professional Services, Manufacturing, and Non Profit organizations. Our experienced consultants have a passion for making every facet of your business successful and are intent on building a long-term relationship with every client.