Skip to main content

End of Day Errors - 3rd Party General Ledger Export

Distributor troubleshooting for 3rd-party general ledger export errors at End of Day in Encompass (Xero, Sage, Great Plains, etc.): fix missing AP Account ListIDs and export file naming. v23.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 23.01

Pre-Conditions

Financial Close is being run


Companies.GeneralAccountingSystem = AFS, Global, Great Plains, Great Plains 10, Lawson, Navision, SAGE50, SAGE100, SmartConnectGP, Xero, or Xero_AUS

Documents generated for the General Ledger system use the updated naming convention:
​
​

  • Source, GL System, CompanyID, Start Date, End Date
    ​
    ​

  • Example: Purchases_Xero_1_20220915_20220915.csv

The following General Ledger systems follow this naming convention:
​
​

  • AFS
    ​
    ​

  • Global
    ​
    ​

  • Great Plains
    ​
    ​

  • Great Plains 10
    ​
    ​

  • Lawson
    ​
    ​

  • Navision
    ​
    ​

  • SAGE50
    ​
    ​

  • SAGE100
    ​
    ​

  • SmartConnectGP
    ​
    ​

  • Xero
    ​
    ​

  • Xero_AUS

Steps

Missing ListID on the following AP Accounts:
​
​

  • This error occurs when one or more AP Account(s) has the ListID field empty
    ​
    ​

  • ListID is required for export documents to properly import to the appropriate 3rd party GL system
    ​
    ​

  • To correct this, find the Vendor Number in the GL system and insert that value into APAccounts.ListID
    ​
    ​

  • Once the relevant AP Account(s) have ListIDs, users can re-run Financial Close to generate the export documents

Did this answer your question?