Post Calculation Cost Distribution Load (%WPR0997UEMP (Weekly), %WPR1997UEMP (Monthly), %WPR2997UEMP (2-Weekly), %WPR3997UEMP (4-Weekly)) lets you redistribute timesheet cost data for a specific item using an Excel spreadsheet file. Post Calculation Cost Load is more flexible: see Post Calculation Cost Load file format.
To use Post Calculation Cost Distribution Load, first output a file in the format expected by the load routine, using the previous option on the menus, Excel Cost Distribution; this contains the current costing for the single item which this covers. Then update this in Excel to redistribute the values for the one item against contracts (which appear in column headers) and load up again using the load option. You would not attempt to create the file from scratch as it is Excel XML and not CSV.
The item is specified by the period type specific Payroll parameter JOBTIME.
P0/JOBTIME
Item and optionally total input amount for contract time distribution
The Payroll item number to load to (used by Post Calc Cost Distribution Load) and to report on (used by Excel Cost Distribution).
The format is:
<item no.>[,<total input amount for the item>]
for example: 20,100
where the total input amount is optional and is useful when the item's input amount is fixed (for example, total contracted hours in a period). It is used by the report only to display an additional column showing any amount not allocated to a specific job.