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 |
| Division | Division | 000 |
| Transaction No (Required) | Transaction number | 0020002357 |
| 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 |
| GL Memo | A text comment that may have been added to the account line entry. | Ordered in December |
| Source | The module that the transaction originated from; AP = Accounts Payable AR = Accounts Receivable GL = General Ledger INVC = Inventory Count INVR = Inventory Receipts LWAY = Sales Deposit MFG = Manufacturing PAYR = Payroll PORD = Purchase Orders SORD = Sales Orders | AR |
| Type | Sub-category of transaction that was posted. Transactions originating in General Ledger will have a blank value. | CUST |
| Entity | The customer, vendor or employee code of the posted transaction. Some transaction types will have a blank value. | A1PAR |
| Document | The document number passed from the subledger posting, such as the invoice or check number. | 1001 |
| GL Account (Required) | GL account number | 11110 |
| Base Credit Amount (Required) | Base credit amount for the transaction | 0.00 |
| Base Debit Amount (Required) | Base debit amount for the transaction | 100.00 |
| Foreign Credit Amount | Foreign curreny credit amount | 0.00 |
| Foreign Debit Amount | Foreign currency debit amou | 80.00 |
| Rate method | Currency rate conversion method used; / = direct * = indirect | / |
| Rate | Rate for foreign currency | 1.25 |
| Currency | Curency 3 digit code | CAD |
| Job No | Job No | GRAHAM |
| Job Account No | Job Account No | FLOOR |
| Reconcile Date | Date in one of the formats from the Date Format drop down | 01/01/2024 |