...
Sample InTime Sage 50 export file - sage50_InTimeSample.csv.
Sage 50 Specification:-
| InTime Field Mapped | Column | Field | Type | Size | Validation | Precision | Import Type | |
sc = Client Credit, si = Sales Invoice, pc = Purchase Credit pi = Purchase Invoice, pa = Purchase payment line, pr = Purchase Credit payment line | → | A | Transaction Type | text | 2 | BP, BR, CP, CR, JC, JD, PA, PC, PI, SA, SC, SI, VP, VR | Standard/Extended | |
| Accounts Ref of the Client/Worker/Provider | → | B | Sales/Purchase/Account Ref | text | 8 | Look up | Standard/Extended | |
Sales: Timesheets - Nominal code on the client, Expenses: NominalCode on the expense type Purchase: Timesheet and Expenses Nominal code are on the worker or provider (depending who the invoice is for) Payment lines: value from 'Sage50PANominalCode' config. VAT only invoices value from 'Export.Sage50.VatOnlyNominal' config. | → | C | Nominal Code | text | 8 | Look up | Standard/Extended | |
Placement Purchase Cost Centre if it is the same for all placements. Left blank and creates warning if they differ. The value from the placement can be mapped to alternative values with the 'SageDepartmentMapping' config. Value of the 'ConsultantDepartmentNo' Tag on the Placement Consultant. 'ConsultantDepartmentNoOverride' config. | → | D | Department Number | Int | 3 | 1-999 | Standard/Extended | |
| Invoice date | → | E | Transaction date | Date | 10 | Date | Xx/xx/xxxx | Standard/Extended |
| Invoice number | → | F | Transaction (invoice) ref | Text | 30 | Standard/Extended | ||
| limited to 60 characters | → | G | Transaction detail | Text | 60 | Standard/Extended | ||
| Net amount | → | H | Net Amount | Decimal | 11 | 8 digits + 2d.p | Standard/Extended | |
| Invoice VAT Code. "T" prefix removed if in AccPacc mode | → | I | Tax code | Int | 3 | T0-T99 | Standard/Extended | |
| VAT amount | → | J | Tax amount | Decimal | 11 | 8 digits + 2d.p | Standard/Extended | |
| Exchange Rate between Invoice currency and Base currency | → | K | Exchange rate | Decimal | 11 | Extended | ||
| Blank (COLUMN ONLY APPEARS WITH PROJECTS MODE ENABLED) | → | L | Extra Ref | Text | 30 | Extended | ||
| Blank (COLUMN ONLY APPEARS WITH PROJECTS MODE ENABLED) | → | M | Username | text | 32 | Extended | ||
| Placement Sales Project (COLUMN ONLY APPEARS WITH PROJECTS MODE ENABLED) | → | N | projectRef | Text | Extended | |||
| 'Export.Sage50.timesheetCostCode' value if configured and exporting a timesheet otherwise the Shift/Expense Item Pay Element Code (COLUMN ONLY APPEARS WITH PROJECTS MODE ENABLED) | → | O | costCode | Text | Extended |
If you require the sage 50 exporter to have the projects mode enabled please contact support.
...