...

Merge • Automate • Validate • Audit


Daily Payroll to Job Cost

This app creates job cost records before payroll is processed thus allowing the user to have labor related (cost type = 2) job cost records available to them when doing billing before the payroll period ends. Since this app creates job cost records and Sage's payroll processing (5-2-3 Compute) creates job cost records duplicate records will exist. After Sage's 5-2-3 compute process is done, the user must run the z050206A02 - Void Duplicate Job Cost Records app to remove the duplicate records.

Setup:

  1. 1) Run z050501A04 - Daily Payroll to Job Cost for the first time
  2. 2) User will be prompted to select a field to store the job cost record number
  3. in the daily payroll table. The user has the choice to use the description
  4. field (dscrpt) or the notes field (ntetxt).
  5. This value will be used later in the z050206A02 - Void Duplicate Job Cost Records app
  6. to void the duplicate records

Steps:

  1. 1) From the 5-5-1 screen verify that pay rate is populated and saved for each employee's record
  2. 2) Run this app - This will create jobcost records and links in the dlypyr table to each new corresponding jobcost record
  3. 3) Do billing (The purpose of this app is to create labor job cost records before the pay period ends)
  4. 4) When it is time to run payroll, from the 5-5-1 screen click "Create Timecards" In the dialog box, enter your date range and click "Create Timecards". Time card records (in tmcdln) will be created with the corresponding jobcst.Recnum value in the dscrpt or ntetxt field (depending on user's pref).
  5. 5) From the 5-2-3 screen do a final compute on the records just created. You can use a record number range if you know that, or a date range
  6. 6) Now you can run the z050206A02 - Void Duplicate Job Cost Records app to remove the duplicate records