Custom details on AR/AP Exports
When exporting AR and AP Invoices and Credits, there are a variety of non-financial detail that can be configured.
Settings
| Setting | Description | Values | Tags |
|---|---|---|---|
| Interface AP Invoice Line Details | A template for populating AP Invoice LineDetails using tags which are substituted with data | Text | |
| Interface AR Invoice Line Details | A template for populating AR Invoice LineDetails using tags which are substituted with data | Text | <LR> (Line Reference) <LD> (Line Details) <BN> (Batch No) <JC> (Job Code) <JD> (Job Description) <WC> (Work Centre Code) <SC> (Sales Code) <CN> (Company Name) |
Data mapping
| Entity | Field | Value | MyOB | Xero |
|---|---|---|---|---|
| AP Invoice Header | InvoiceID | APInvoiceID | Number | - |
| InvoiceNumber | InvoiceNumber | SupplierInvoiceNumber | InvoiceNumber | |
| HeaderDetails | Journal Memo | - | ||
| AP Invoice Line | LineDetails | Interface AP Invoice Line Details | Description | Description |
| ProfitCentre | ProfitCentreCode | Job | Tracking Category | |
| AR Invoice Header | InvoiceNumber | InvoiceNumber | Number | InvoiceNumber |
| HeaderDetails | Journal Memo | Reference | ||
| AR Invoice Lines | LineDetails | Interface AR Invoice Line Details | Description | Description |
| ProfitCentre | ProfitCentreCode | Job | Tracking Category | |
| GL Journal | HeaderDetails | BatchNo + ‘ – ‘ + BatchReference | Description | Narration |
| LineDetails | TranDetails | LineDescription | Description | |
| ProfitCentre | ProfitCentreCode | Job | Tracking Category |