QuickBooks Transaction History Export | Denali Field | Notes |
---|---|---|
*At least one level of subgroups containing a line type | Line types include stock items, parts, services, other charges, and discounts | |
*Trans # | Numeric | |
*Type | Text; no size limit; if the value is “Sales Receipt”, it imports as a cash transaction; if the value is anything else, it imports as an AR Charge | |
Last modified by | User ID/Salesperson | 6 characters |
Date | Transaction Date; UDF 5 default value; closeout deposit; return date | Date format |
*Num | Invoice Number | 50 characters; cannot be blank; if it’s not unique Denali will add lowercase letters to make it unique |
Name Contact/Name Street 1/Name Street 2/Name City/ Name State/ Name ZIP | Billing Address | 35 characters all fields |
Name Phone # | Billing and Shipping phone number | 50 characters |
Name Fax # | Billing and Shipping Fax number | 50 characters |
Name E-Mail | Billing and Shipping email | 255 characters |
Name | Customer, Customer Name | 50 characters each field; these should match customers imported into AR |
Memo | Trans. Detail Description | 120 characters; if this field has text, it will be used instead of Item Description |
*Item | Stock Number, IN Code | 50 characters, imports into the strStock field; if the item was imported with Inventory, it will match the stock number and the IN Code will be included |
Item Description | Trans. Detail Description | 120 characters |
Sales Tax Code | Taxable | This sets the taxable flag and does not match Denali’s Tax Code; only “Non-Taxable Sales” are not taxable |
*Qty | Quantity Ordered, Quantity Shipped | Numeric; defaults to 1 if blank |
*Sales Price | Unit Price | Numeric |
*Amount | Extended Price, Transaction Subtotal, Transaction Total Payment | Numeric; this amount is compared to the opposing line in GL and if they don’t match a warning will be generated |
Ship To Address 1/Ship To Address 2/Ship To City/Ship To State/Ship To ZIP | Shipping Address | 35 characters all fields |