Custom details on AR/AP Exports
- Malcolm Mackay
- Bao TRINH
- Maria Harreguy
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 | <LR> (Line Reference) <LD> (Line Details) <BN> (Batch No) <JC> (Job Code) <JD> (Job Description) <WC> (Work Centre Code) <AC> (Activity Code) <AD> (Activity Description) <CN> (Company Name) |
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 |