Lot Generation - Formatting

Epicor ERP 9
1

Hi All,

E9.05.702A

Have others come up with a way to generate lot numbers that are formatted outside of the options found on the Lots tab in Part Entry?

For example, the request is for lot numbers to be generated as: YYMMDD## (## is a sequential number for that day, meaning it resets to 01 each day).
Ignoring the complexities of the lot number format for now (and the fact that a 2 digit year is short sighted), my question is how have others overcome the limitations of the lot numbering format?

My first thought was to create our own lot number generation system and replace all “Next Lot” buttons with a custom one but I thought I would check with the group before starting down this path.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL + DESIGN & DEVELOPMENT
Advancing Your Innovations For Health

261 Cedar Hill Street | Marlborough, MA 01752
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
EMAIL: JoRojas@ventionmedical.commailto:JoRojas@ventionmedical.com | WEB: ventionmedical.com http://www.ventionmedical.com/

THINK QUALITY. BE QUALITY. GO BEYOND.

This communication may contain information that is confidential, proprietary or exempt from disclosure, and is intended only for the use of the individual and/or entity it is addressed to. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone or by return e-mail, and delete this information from your computer.

2

The solution you mention seems very easy to implement (generating your own lot).

All you need is a var for PrintCounter and LastPrintDate. You could store both of these in UDCodes.

Pseudo code would be like:

string GenerateLotNum()
{
//get your values from UD here

   if(LastPrintDate != DateTime.Today)
  {   //reset counter if this is first print of day
     PrintCounter = 0;
  }

  PrintCount++;
string myLot =   MakeFormattedLot("{0}{1}{2}{3}", YY, MM, DD, PrintCounter) ;  //using like printf, etc

SaveToUD(PrintCount); //save current 
SaveToUD(LastPrintDate); //save current

return myLot;
}
3

Thanks Chris.

You feedback is really helpful and we are looking into this now.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL + DESIGN & DEVELOPMENT
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

1 Like