x

Start now

Schedule a demo

  • Date Format: MM slash DD slash YYYY
  • This field is for validation purposes and should be left unchanged.
Field Mapping-AR Aging – OneSource: Inventory for QuickBooks Online Field Mapping-AR Aging – OneSource: Inventory for QuickBooks Online

Have a Question?

Field Mapping-AR Aging

< All Topics

Field Mapping Notes (for the OneSource Field Mapping Spreadsheet – AR Aging file)

Field Mapping Spreadsheet

Column Name

OneSource Field type Field length or Numeric Range Sample value Default Value

Additional Notes

           

Invoice Number

Text 20 ABC123   *** REQUIRED *** This field is the unique identifier (Primary Key) for the Invoice table.  This value cannot be left blank and must be a unique value.

Sales Order Number

Text 22 12345 or ABC12345

Null

 
Invoice or Credit Memo Text 1 I or C I

*** REQUIRED ***  I=Invoice; C=Credit Memo

Total Amount Still Due

Currency 15 100.00 0 *** REQUIRED *** This is the amount that is still due on the invoice.  This total will be the difference of the original Invoice amount less any payments to the Invoice.
Bill to Customer Number Text 15 12345 or ABC12345  

*** REQUIRED *** This is the Bill To Customer Number from your legacy system.  If this number will be a newly assigned number in OneSource, this will be the Customer Number in OneSource.

Ship to Customer Number

Text 15 ADA145   *** REQUIRED *** This is the Ship To Customer Number from your legacy system.  If necessary, this can be the same as the Bill To Customer Number.
Invoice Date Date N/A 08/01/2007

or 8/1/07

Date of Import

This text field is populated with the date that the Invoice was created.

Customer PO Number

Text 50 ABC123    

Source of Order

Text 50 Referral    
Payment Terms Text 20

1% 10 Net 30

   
Salesperson Text 30

John Doe

   

Shipped Via

Text 20 UPS Ground   This is how the Item {s} were sent ie FedEx USPS etc.
Comments Text 255    

Any Comments printed on the Invoice.

Bill to Contact Name

Text 255 John Doe   Contact Name printed on the Invoice Billing Address.

Bill To Company Name

Text 255 ABC Company  

The company Name printed on the Invoice Billing Address.

Bill to Address Text 255 12345 Somewhere Street  

Street Address printed on the Invoice Billing Address.

Bill to City State Zip

Text 255 Anaheim, CA  92806   City, State, and Zip printed on the Invoice Billing Address.
Ship to Contact Name Text 255 Mike Jones  

Contact Name printed on the Invoice Shipping Address.

Ship to Company Name

Text 255 ABC Company  

The company Name printed on the Invoice Shipping Address.

Ship to Address

Text 255 456 Ave   The street address printed on the Invoice Shipping Address.
Ship to City State Zip Text 255 City  

City, State, and Zip printed on the Invoice Shipping Address.

Date Shipped

Date N/A 08/01/07   The date the items were shipped.

Delivery Date

Date N/A 08/02/07  

The date the items are scheduled for delivery.

Due Date Date N/A 08/21/07  

The date the Invoice is due.

Previous Field Mapping–Suppliers & Vendors
Next Field Mapping-Chart of Accounts
Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Table of Contents