How to import General Ledger Accounts with Visual Integrator, or Error: "partial G/L account number is not on file" in Job Log
Description
Cause
Resolution
[BCB:5:Third-party support:ECB]
  • GL Accounts may referred as AccountKey in Visual Integrator
  • GL Account = Account Key in Visual Integrator
  • When importing G/L Account Numbers, it must be the full account number, and must include separators in the sourcefile
    • Example: 1234-56-789
  • Select Skip Source Data Truncation on Configuration Tab if GL Account with separators is more than 9 characters
    • Note: If importing new GL Accounts in GL Account Maintenance, it is suggested to use General Ledger Exchange found in General Ledger, Utilities since it can automatically create Main Accounts and Sub Accounts

Defect ID
Steps to duplicate
Related Articles