This sage export will allow you to import your sales invoices where you want to have the invoice posted to more than one nominal code. For this report the nominal code is taken from the Nominal Pay code field on the Costing Rate code.
The Sage Detailed reports offer a more detailed overlook of the invoices within a sales batch. Firstly more information is displayed than in the standard sage audit report. Also the detailed report breaks each invoice down into individual timesheets, so each one appears on a separate line. This means that any timesheets and expense items are shown individually, as can be seen above.
For example, in the above report the first three lines are expense sheets for the invoice 10007, with the final line being the timesheet that is also contained within the same invoice.
TransactionType – The transaction type of the invoice, so SI=Sales Invoice, SC=Sales Credit
AccountRef – This is the Client’s sales ledger code entered in Client Entry
NominalCode – This is the nominal bill code for the Rate Code attached to the timesheet. This is entered in Rate Code Entry
DepartmentNumber – The department number is taken from the bill code of the sector that is attached to assignment in categories. It is entered in Sector Entry
TransactionDate – This is the date that the invoice was raised on the system
TransactionReference – The transaction reference takes the invoice number
TransactionDetails – This field is split into the following data
A - This is the description entered in the timesheets cost description field, or the rate code description if the previous is empty. The expense description entered by the candidate will be present if an expense code is used
B - The candidates name
C - The timesheet end date
D - Timesheet number
E – Purchase order number, entered in Purchase Order Entry
NetAmount – The net bill amount of the each bill line on the timesheets attached to the sales invoice.
*Note: if the NetAmount is a negative it will be displayed as a negative value when the transaction type is SI. For a SC transaction, the negative amount will be displayed as a positive)
TaxCode – T1- If tax value of the timesheet costing line is not Zero, T0 - If the tax value is Zero
TaxAmount – Sales Invoice Tax Amount: This is the tax amount of the timesheet costing line, so it is dependent on the Sales Tax Type attached to the client in Client Entry
ExchangeRate – Currency Exchange Rate: This is the exchange rate between the pay/billing currency set up in the Assignment Entry>Costing and the agencies currency setting
ProjectReference – The project reference is taken from the Reference 1 field in the Assignment>Categories page
ProjectCostCode– The project cost code is taken from the Reference 2 field in the Assignment>Categories page