Business Process Scanning a Job card

When person scans a barcode on a Job Card the system does the following: 

1) The scanning screen will first read the  barcode and person ID and quantity from the screen if supplied. Then it will determin if the barcode relates to an operation on the Job card or  Material which can also be shown on the Job card.
2) The barcode holds multiple information so the system will split out the information in the barcode and store the following Manufacture Order ID , Routing ID, Stage No., Barcode Type.
3) If Barcode begins with a  'B'  then it is a 'Bill of Material' Scan and if it is 'P' then  it is 'Process /routing process' scan.  The system will  do further validation then proceed on scan an operation or add product. 
​

​ Scan an operation :- (Barcode begins P )
The scanning screen will decide whether  the operator is scanning ON or Off  by looking to see if there is already a  record with the same information with no off date
The selection Criteria is (where  DateTimeON is not null and PersonID = Person ID sent from User and ManufactureOrderID = ManufactureOrderID available in Barcode and routing ID = RoutingID available in barcode and DateTimeOff is null and BarcodeType='P' )

If it finds a record then it must be a scan off else it will consider it a scan ON

i) Scan ON an operation :  
When WBS calculates that it must be a scan ON a record will be automatically inserted in to timesheet directly from the scanning screen using above information.
The screen will also update Created Date (Server DateTime ), Date Time ON (Server DateTime),  (Stock is not adjusted as there is no product ID this will not affect the stock as stock master is not called) and User Text values if there is anything in time sheet table.
After a record has been inserted into the time sheet table a further Business Process is always called but in this case it will not calculate anything as there is no material supplied and no log off date    Click Here to see the detail  

ii) Scan OFF an operation : 
When WBS calculates the person is scanning OFF an Operation/Routing a record on the timesheet Table is updated with the following information:  
Date Time OFF(Servers datetime), Material Quantity(if any) , scrap quantity(if any) User Text  values if there is anything for the existing Timesheet Id(already scanned operation).
After the record has been updated with the Off date a further Business Process is always called which in this case will calculate the employee cost.  Click Here to see the detail 

 

Scan Material  : -   (Barcode begins B)
When User scan Material and entered quantity and person barcode, then systems will add record in timesheet .Timesheet will then automatically call stock master to update the stock and record the entry in stock audit .
Timesheets below fields used to insert data
ManufactureOrderId (from barcode), PersonId (From screen), ProductID(from barcode), MatetialQty (from screen), DateTimeOn (Server date time), Barcode_Type (barcode type 'B' is updated always for material scan), ScrapQty (Scrap quantity if any provided on screen) and other user text fields.
 
When the time sheet table is added to or updated a further Business Process   is always called to calculate material used. Click here to see the detail