Product: Quickbooks (On-Premise) & Mapping Manager

Article Link:


Customer/Template Fields


Quickbooks Field

Reference

Mapping Manager

Customer:JOB

CustomerRef→

FullName

CLASS

ClassRef→

FullName

TEMPLATE

TemplateRef→

FullName

Header Fields


Quickbooks Field

Reference

Mapping Manager

S.O NO.

SalesOrderAdd →

RefNumber

P.O. NO.

SalesOrderAdd →

PONumber

DATE

SalesOrderAdd →

TxnDate

SHIP DATE

SalesOrderAdd →

ShipDate

DUE DATE

SalesOrderAdd →

DueDate

FOB

SalesOrderAdd→

FOB

SHIP VIA

ShipMethodRef→

FullName

REP

SalesRepRef→

FullName

TERMS

TermsRef→

FullName

OTHER

SalesOrderAdd→

Other

Item Fields


Quickbooks Field

Reference

Mapping Manager

ITEM

SalesOrderLineAdd→

ItemRef→

FullName

DESCRIPTION

SalesOrderLineAdd→

Desc

ORDERED

SalesOrderLineAdd→

Quantity

RATE

SalesOrderLineAdd→

Rate

AMOUNT

SalesOrderLineAdd→

Amount

SITE

SalesOrderLineAdd→

InventorySiteRef→

FullName

CLASS

SalesOrderLineAdd→

ClassRef→

FullName

TAX

SalesOrderLineAdd→

SalesTaxCodeRef→

FullName

OTHER1

SalesOrderLineAdd→

Other1

OTHER2

SalesOrderLineAdd→

Other2

Footer Fields


Quickbooks Field

Reference

Mapping Manager

CUSTOMER MESSAGE

CustomerMsgRef→

FullName

MEMO

SalesOrderAdd→

Memo

CUSTOMER TAX CODE

CustomerSalesTaxCodeRef→

FullName

TAX

ItemSalesTaxRef→

FullName

Quickbooks does not allow you to directly write to the Tax %, Tax Total, or Total fields as it will automatically calculate it

8/2/22

Did this answer your question?