This guide walks through the potential errors you may experience when importing or updating General Ledger (GL) Accounts in Tradogram.

CSV Column Headers Do Not Match

This indicates that the column headers in your import file differ from the headers in our official template.

To resolve this issue:

1. Click the Download Template button to obtain the latest, correct template.
2. Copy your existing import data into the newly downloaded template.
3. Save and re-upload the new file.

‍

‍

Name & GL Account Number is Mandatory

The GL Account Name and GL Account Number fields are both required. You cannot create or update a GL Account without a value in both fields. If your internal convention only uses a name or a number, you must enter the same value in both fields, as both are treated as alphanumeric text fields in Tradogram.

GL Account Name/Number Combination Already Exists

This error means the specific combination of the GL Account Name and GL Account Number on a row is already being used by an active GL Account in your system. To fix this, you must adjust either the Name or the Number on the import row to ensure the resulting combination is unique.

Not Found in Supplier List

This error occurs when you attempt to associate the GL Account with a supplier that does not exist or whose name does not exactly match a supplier in your active database.

• Mapping to One Supplier: Verify the spelling and status of the supplier name used in your import file against your active supplier database. The name must be an EXACT MATCH.

• Mapping to Multiple Suppliers: When listing multiple suppliers in a single field, you must use a semicolon (;) without spaces to differentiate them (e.g., Amazon;3M). Using a comma will result in this error.

Not Found in Item List

This error occurs when you attempt to associate the GL Account with an item that does not exist or whose name does not exactly match an item in your active item database.

• Mapping to One Item: Verify the spelling and status of the item name used in your import file against your active item database. The name must be an EXACT MATCH.

• Mapping to Multiple Items: When listing multiple items in a single field, you must use a semicolon (;) without spaces to differentiate them (e.g., DeskChair;Keyboard). Using a comma will result in this error.

Please Check Is Active Value and Try Again

This error occurs when the text entered in the Status column is incorrect. In this column, you can only use the terms "Active" or "Inactive." Any other text will result in this error. If you leave this field blank, the system will automatically assign an Active status.

Code not Found

This error is specific to when you are attempting to update existing GL Accounts. If the code in your import file (typically found in Column A) does not match the code of an existing record in the system, the system cannot perform the update. You must verify the codes by exporting the GL Account CSV and reviewing Column A.

GL Account Name/Number Combination Already Exists in the Current Import

This means that you have two identical rows within the same import file. Specifically, there is another row in the file with the exact same combination of GL Account Name and GL Account Number. Review your import file and remove the duplicate row.

‍