• Home
  • User Guide Main Modules
  • Company Profile
  • Contact Us
  • Customer Solutions
  • Blog
  • Home
  • User Guide Main Modules
  • Company Profile
  • Contact Us
  • Customer Solutions
  • Blog
Search

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.

Contact us to see how our web based software can improve efficiency and drive down costs for Manufacturing or Warehouse companies
Opening Hours - 
Monday - Friday
9 am - 5 pm
Telephone - 
01405 955 002
Email Us
Privacy Policy
  • Home
  • User Guide Main Modules
  • Company Profile
  • Contact Us
  • Customer Solutions
  • Blog