Business Process for time sheet record
Every time a record in the timesheet table is added to or updated the following business process is automatically run for the that record.
1) Total labour cost- calculated as person rate * total minutes (On date time/off date time) /60 + resource rate (if provided in resource table) this value is stored as labour cost in the timesheet record along with the total time in minutes and hours:min format
2) Material cost of raw material is calculated if the product is stored in the time sheet. Material cost is calculated as the products wbs internal cost (This can be last purchase cost or average cost etc )* material quantity that is stored in time sheet . If any of these values are 0 the cost is set to 0. Stock master is called on every calculation. Stock master's Business Process is responsible for updating stock and is called from many places in the system. Click Here to see the full details
Following data is passed to stock master
@ProductID = ProductID of Material scanned,
@Qty = Quantities provided in scanning screen,
@LocationID = Location provided on the screen(if it is not provided then it will be taken from Products table) ,
@Source = 'TimeSheet New Record',
@StockAdjustment= Value is depending upon variable whether SageStock will update or not, --'Yes',
@Reason = 'From TimeSheet New Record',
@BatchNumber = always go NULL,
@CurrentUserID = CurrentUserID
.
(Note :- Stock master is called depending upon following conditions.
1) if System Setting 'A3' (which is 'Auto Reduce Stock From Timesheet Product Entry' ) is 'Yes' OR
2) If Product ID is provided.
1) Total labour cost- calculated as person rate * total minutes (On date time/off date time) /60 + resource rate (if provided in resource table) this value is stored as labour cost in the timesheet record along with the total time in minutes and hours:min format
2) Material cost of raw material is calculated if the product is stored in the time sheet. Material cost is calculated as the products wbs internal cost (This can be last purchase cost or average cost etc )* material quantity that is stored in time sheet . If any of these values are 0 the cost is set to 0. Stock master is called on every calculation. Stock master's Business Process is responsible for updating stock and is called from many places in the system. Click Here to see the full details
Following data is passed to stock master
@ProductID = ProductID of Material scanned,
@Qty = Quantities provided in scanning screen,
@LocationID = Location provided on the screen(if it is not provided then it will be taken from Products table) ,
@Source = 'TimeSheet New Record',
@StockAdjustment= Value is depending upon variable whether SageStock will update or not, --'Yes',
@Reason = 'From TimeSheet New Record',
@BatchNumber = always go NULL,
@CurrentUserID = CurrentUserID
.
(Note :- Stock master is called depending upon following conditions.
1) if System Setting 'A3' (which is 'Auto Reduce Stock From Timesheet Product Entry' ) is 'Yes' OR
2) If Product ID is provided.
