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:

*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 ...
    • Configuring Index-Field Rules

      Rules Properties The Index-Field Rules can be reconfigured in the "Rules Properties" menu prompt. Launch CapturePoint. From the Menu Panel, click "Index-Field Automation"  (index briefcase) icon to go to the "Index-Field Rules" Panel.  "Index-Field ...
    • 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 ...
    • 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 ...