Custom details on AR/AP Exports

Owned by Malcolm Mackay
Last updated: Oct 18, 2021 by Maria Harreguy
1 min read

When exporting AR and AP Invoices and Credits, there are a variety of non-financial detail that can be configured.

Settings

SettingDescriptionValuesTags
Interface AP Invoice Line DetailsA template for populating AP Invoice LineDetails using tags which are substituted with dataText
<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 DetailsA template for populating AR Invoice LineDetails using tags which are substituted with dataText<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

EntityFieldValueMyOBXero
AP Invoice HeaderInvoiceIDAPInvoiceIDNumber-

InvoiceNumberInvoiceNumberSupplierInvoiceNumberInvoiceNumber

HeaderDetails
Journal Memo-
AP Invoice LineLineDetailsInterface AP Invoice Line DetailsDescriptionDescription

ProfitCentreProfitCentreCodeJobTracking Category





AR Invoice HeaderInvoiceNumberInvoiceNumberNumberInvoiceNumber

HeaderDetails
Journal MemoReference
AR Invoice LinesLineDetailsInterface AR Invoice Line DetailsDescriptionDescription

ProfitCentre

ProfitCentreCode

JobTracking Category





GL JournalHeaderDetailsBatchNo + ‘ – ‘ + BatchReferenceDescriptionNarration

LineDetailsTranDetailsLineDescriptionDescription

ProfitCentreProfitCentreCode
JobTracking Category