AnsweredAssumed Answered

Calculation

Question asked by filemakernew on Nov 7, 2013
Latest reply on Nov 7, 2013 by philmodjunk

Title

Calculation

Post

     kindly help me to make a calculation to generate our own Lot No. if I click a new record. In our SOP, if we receive a material we are following this format to generate a certain lot no. for materials we receive. The first two digits is the last two digit of the present year, the second two digits is the  number of the month and the last three digits are sequential of 3 digits base from the number of materials received from that  month.

     below is the example if I received material today my lot no. will be 1311001 if I receive another material tomorrow 1311002.....1311003...

      (13 - last two digit of the current year ; 11 - Number of the current Month ; 001 last three sequential digit based from the materials received from this month

      

     Thank you.

Outcomes