This sage export will allow you to import your purchase 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 purchase batch. Firstly more information is displayed than in the standard sage audit report. Also the detailed report breaks each remittance 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 the second line is the timesheet for the remittance 10003, with the third and fourth being the two expense items that are also contained within the remittance.
TransactionType – The transaction type of the invoice, so PI=Purchase Invoice, PC=Purchase Credit
AccountRef – This is the Supplier’s purchase ledger code entered in Supplier Entry
NominalCode – This is the nominal pay code for the Rate Code attached to the timesheet. This is entered in Rate Code Entry
DepartmentNumber – The department number is taken from the pay code of the sector that is attached to assignment in categories. It is entered in Sector Entry
TransactionDate – This is the date that the remittance was raised on the system
TransactionReference – The transaction reference takes the remittance 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
NetAmount – The net pay amount of the each pay line on the timesheets attached to the purchase 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 – Purchase Invoice Tax Amount: This is the tax amount of costing line of the timesheey, so it is dependent on the Sales Tax Type attached to the supplier in Supplier Entry
ExchangeRate – Currency Exchange Rate: This is the exchange rate between the pay/billing currency set up in the Assignment Entry>Costing
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