Customer Transaction Entry - GL Distributions overview

Customer > Entry > Customer Transaction

Use the GL Distributions grid to manually distribute each transaction to specific General Ledger account codes.

You can distribute to a maximum of 500 account codes for each transaction entered. The General Ledger account codes from Customer Setup are initially displayed according to the transaction being posted. If the account codes are not located, the operator record in SA Operator Setup is checked. If General Ledger accounts do not exist per operator, the R&D operator record is checked for the correct account codes.

Import From Excel

To import transactions from an Excel spreadsheet, select Import From Excel after accessing the GL Distributions grid. Your Excel file must be formatted to include these fields as columns:

  • Account
  • Amount

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

Note: The order of the fields, or columns, does not matter. The columns can be in any order, but the column headings must be specified exactly as shown in the list.

The import process will parse the 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 you in SA Operator Setup-Other Options is validated. If an Excel file includes account numbers in a division in which you are not allowed to post to, an error is displayed when the data is validated.

Up to 999 lines can be imported at a time.

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.