File Formats Supported by Denali for Importing Transactions
The format requirements for a successful import are covered in this topic. The file imported will contain multiple records, each having a CR/LF (carriage return/line feed) at the end and an “H” or “D” as the first character. Records with an “H” at the beginning are header or master records, and subsequent records with a “D” at the beginning are the detail lines (sometimes referred to as “child lines”) for that header record. For information about requirements specific to this module, refer to the user’s guide or the Appendix.
You can name the file anything you want, but the file extension must be .txt or the six character Denali company code, for example, GLXFER.TXT or Income.DMOACT.
The external text file must be in one of the formats supported by Denali:
• Column Position File (fixed length): Each field in the text file starts at a specific position and contains a fixed number of characters. This file type is sometimes referred to as “fixed length”.
• Tab Delimited File: The fields in the file to be imported are separated by tabs.
• Semi-Colon Delimited File: The fields in the file to be imported are separated by semi-colons.
• Comma Delimited File: The fields in the file to be imported are separated by commas.
The file format sample contained in this topic is for reference purposes only and might not reflect the same type of information as your text file(s).
Refer to Format Requirements for Importing Transactionsand select the module you are importing transactions to for a list of the required fields and the order of the fields.
This image is applicable to Accounts Payable, Accounts Receivable, Bank Reconciliation, General Ledger, and Sales. Click thumbnail for a larger view of image.
This image is applicable to Inventory. Click thumbnail for a larger view of image.
This image is applicable to Payroll. Click thumbnail for a larger view of image.
Published date: 12/03/2021