Vendor Invoice Center Entry - Invoice Detail - GL Dist - Import From Excel overview

Vendor > Entry > Invoice Center

Use the Import From Excel option to import GL transactions for AP accounts.

The Excel file must be formatted to include these fields as columns:

  • 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.

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 parses 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 in SA Operator Setup-Other Options is 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. You must also be authorized to make manual GL postings based on the GL Manual Posting and GL Account authorization points.

Any errors are noted in the Status Message column in the Import From Excel Lines grid. You must resolve all errors before you can click Submit. No editing is performed in the Lines grid, with the exception of deleting records. Any corrections or changes to GL entries must be made in your Excel file and the file re-imported.

When you click Submit, the imported GL entries are added to the General Ledger Distribution Accounts grid.