QuickBooks Desktop Field Formats and Sizes

QuickBooks Desktop Field Formats and Sizes

Customers integrating into QuickBooks from Content Central or CapturePoint need to be aware of the field size limitations.
For Bills the size limitations and formats are:

Bill
*Vendor = 41 - Text
Ref No. = 20 - Numeric
Address = 20 per line - Text
Memo = Over 256 - Text
*Amount Due = 22 - Numeric
*Date = dd/mm/yy - Date
Bill Date = dd/mm/yy - Date

Expenses Tab
Account =  209 -Text - Usually pulled from QuickBooks, and has to match valid account 
Amount = 22- Numeric
Memo =  Over 256
Customer Job = 209 - Text
Billable = Yes/No

Items Tab
Item = 199 - Numberic
Description =  Over 256 - Text
QTY = 29 - Numeric
Cost = 29 - Numeric
Amount = 29 - Numeric
Customer Job = 209 - Text

* equals required field
Please note date of this KB, Intuite may change their requirements at any time.

    • Related Articles

    • Quickbooks Desktop Integration

      This applies to Content Central v7.5.7089 and above. Requirements for Quickbooks Integration Dedicated Quickbooks Desktop User Account Steps for Quickbooks Desktop Integration Login to Content Central as Admin or member of the Administrator Group. Go ...
    • External Data Sources (ODBC)

      External Data Sources (ODBC) One or more external data sources (ODBC [Definition: Open Database Connectivity] sources) can be linked to Content Central and used for automating field input in document types. After configuring one or more sources, you ...
    • Field Lookup Integration

      This applies to Content Central v7. External Data Source Field-Lookup Integration uses External Data Source that is linked to Content Central through ODBC Connection. External Data Source can be configured/linked to Content Central from the ...
    • Approval Process System Status Field

      Approval Process System Status Field An Approval Process can be configured to have a System Status Field. This Approval Process System Status Field is updated automatically based on the Approval Process Stages, and can be previewed in the Properties ...
    • Limiting Document Access by Global Field Value

      This applies to Content Central v7.5 and above. Limiting Document Access by Field Value A user, with SEARCH and VIEW permission to a Document Type, can be set to be able to access documents with specific Global Field Values only. This can be done ...