Post
Ask Question
Bala V

Bala V

  • NA
  • 1
  • 878

Here I want to create JOBNO for my application in clientside

Jan 27 2015 10:54 PM

Here I want to create JOBNO for my application for each order. Every order has different customer, quote no, address…etc.

JOBNO=       MUM    XXXX    01    1415

                First 3digit =coming from port code data table (I already created table field)

                Next 4digit = serial no (ex:0001).which is auto generated one by one .but here next 2digit assumed   as current month .every month start the serial no has to begin with origin no(0001) and again ends in end of the month.

                Next2digit=current month

                Last 4digits=financial year (ex2014:2015) last two digits (1415).

Condition:

                When I choose the port name from dropdown list like before code is auto generated and place it to the JOBNO textbox.