Below is a description of the Spire Fields for this Import.
Please refer to the User Manual for more information on how to do Imports.
Spire 3.11 Fields | Explanation | Example |
Customer No (Required) | Customer No | ABC123 |
Transaction Type (Required) | Invoice = I, Payment = P, Credit Memo = C, Debit Memo = D, Service Charge = S, Write Off = W | I |
Transaction Date (Required) | Date in one of the formats from the Date Format drop down (yyyy-mm-dd, yyyy/mm/dd, mm/dd/yyyy, dd/mm/yyyy, mm/dd/yy, dd/mm/yy) | 01/01/2024 |
Total (Required) | Total of the Invoice, Payment, Credit Memo, Debit Memo, Service Charge or Write Off | 100.00 |
Subtotal | Subtotal (before taxes) of the Invoice, Payment, Credit Memo, Debit Memo, Service Charge or Write Off | 95.24 |
Payment Account | Payment GL Account | 11120 |
Memo | Memo | For Postage |
Reference No | Reference No such as Invoice No | 1001 |
Exchange Rate | Exhange Rate for foreign currency | 0.75 |
Sales Tax 1 | Sales Tax 1 Amount | 4.76 |
Sales Tax 2 | Sales Tax 2 Amount | 4.76 |
Sales Tax 3 | Sales Tax 3 Amount | 4.76 |
Sales Tax 4 | Sales Tax 4 Amount | 5.76 |
Terms Code | Payment Terms Code | COD |