New Excel import of GL transactions

You can now import GL transactions using the Import from Excel feature in these functions:
  • GL Transaction Entry
    A new Import from Excel option can be selected in the Transaction grid to import GL transactions. The Excel file can be formatted to include these fields:
    • Account
    • Amount
    • Reference
    • Vendor
    • AP Invoice Number
    • Customer
    • Invoice Number
    • Check Number
    • Extended Reference

    All fields are optional except for Account and Amount. The account number must be the full GL account number, without asterisks, and must match an existing account in GL Account Setup for the current year.

    The import file is validated against your existing GL account codes, and vendor and customer records, if applicable, during the import. You must be authorized to update GL accounts, including entries for allowable divisions based on your SA Operator Setup-Other Options settings. You must also be authorized to make manual GL postings based on the GL Manual Posting and GL Account authorization points.

    Any errors in the imported data are noted in the Status Message column. You cannot click Submit until all errors are resolved. In addition, no editing can be performed in the Import lines grid, with the exception of deleting records. Any corrections or changes to transactions must be made in your Excel file and the file re-imported.

    Note: The new Excel Import process is an alternative to the existing GL Entry Batch Import Report function in Distribution SX.e. The new Excel Import process is performed directly in the GL Transaction Entry grid, and does not require that you transfer your file to a cloud server before importing.
  • Customer Transaction Entry
    A new Import from Excel option can be selected in the Customer Transaction Entry grid to import GL transactions for AR accounts. The Excel file must be formatted to include these fields:
    • Account
    • Amount

    The Account number must be the full GL account number, without asterisks, and must match an existing account in GL Account Setup for the current year. The Amount should not include currency symbols or comments. Negative amounts are imported as credits. As with the GL Transaction Entry-Import from Excel process, account and security validation is performed when the file is imported, and column headings are verified.

  • Vendor Invoice Center Entry
    A new Import from Excel option can be selected in the Invoice Detail-General Ledger Distribution Accounts grid to import GL transactions for AP accounts. The Excel file must be formatted to include these fields:
    • Account
    • Amount
    • Posted At Costing

    The Account number must be the full GL account number, without asterisks, and must match an existing account in GL Account Setup for the current year. The Posted At Costing field is a Y/Yes or N/No value; Y indicates the transaction should be posted at Costing, N indicates the transaction should be posted at Update.

The import process will parse the full account number into the proper GL account format, Division #-Department #-Account #-Subaccount #, based on your account structure in SA Administrator Options-Financials-Account Structure. Division security assigned to the user performing the import will be validated. If an Excel file includes account numbers in a division that the operator is not allowed to post to, an error is displayed when the data is validated. Allowed divisions are assigned to users in SA Operator Setup-Other Options.

Up to 999 lines can be imported at a time. This time-saving feature allows you to easily import GL transactions in Distribution SX.e from an Excel spreadsheet.