Description
The Timesheet Import feature has been designed to mimic what is required where manually keying in a timesheet. As such when using the import function only positive values are used for Adjustment Timesheets. The system’s strategy is an ‘as is / to be' strategy , for example where whereby when an adjustment is generated in FastTrack360 in the Historical Tab, the system replicates the original (target) timesheet (as is) and a user makes changes to support what that original timesheet should have looked like been (to be).
For example, in a Standard Rate Timesheet , the Ordinary item of quantity 8 , should have been quantity 7, so value 8 is altered to 7, and a reimbursement was missing, so this is added. All other values that have not changed, remain on the adjustment timesheet.
Where approved and interpreted, the system performs a balance of values between the original target timesheet and the adjustment , so in the example above, the Ordinary item balance value is -1 and a new value of Reimbursement is added. For values that have not changes a +/- transaction occurs in interpretation so these items are balanced out to zero. As such the original timesheet still stands as is and the adjustment timesheet only represents the items that have been altered.
For a Standard Rate timesheet, the system will accept negative Qty quantity values on import (this is not accepted in via the UIuser interface). Where negative values are used, the items are not interpreted in the same way, they will be treated purely as independent credit values. If your third 3rd party VMS system will only provide Debit / Credit data, you must ensure that in import a positive timesheet is first imported (as the first timesheet for that week ending date) and the first adjustment completely negates (credits) all of the individual items on the first timesheet.
...
Invoice for Timesheet 1234 for 8 * 5 Ordinary, and a reimbursement $100.
Credit Note for Timesheet 1235 for negative 8 * 5 Ordinary, and a negative reimbursement of $100.
Invoice for Timesheet 1236 for 8 * 4 + 1 * 7 Ordinary, and a reimbursement $100.
...