Description
...
For a Standard Rate timesheet, the system will accept negative quantity values on import (this is not accepted via the user 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 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.
| Note |
|---|
It is important that you use one strategy or the other, do not mix the strategies within a Job’s timesheets as the results in interpreter will not be as expected. If your client requires debit then full credit invoices for iterations of the timesheet, this method must be followed in all the data. For example: W/E Date 15/09 TS Iteration 1 Normal Qty 5 W/E Date 15/09 TS Iteration 2 Normal Qty -5 Balance is now zero W/E Date 15/09 TS Iteration 3 Normal Qty 3 W/E Date 15/09 TS Iteration 4 Normal Qty 2 Balance is now -1 In the above example, the TS 4 data did not negate the prior iteration of TS 3 to set back to zero. As such TS 4 interpreted as a balance between TS 3 & 4, so was 3 units now 2, balance of -1 Qty. In this case the client will receive a TS 1 debit, TS 2 full credit, then TS 4 debit invoice, then TS 4 will be a credit of -1 Qty. |
Using this strategy for 3 iterations of a timesheet for Week Ending Date 23/06/24, the following would be imported to support full Debit/Credit invoicing where changes needed to be made to the original 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.
...