KB20201123/02: Sage X3 Tip & Trick – Increasing the limit of journal lines when the journal exceed the maximum lines that Sage X3 allow

Some companies on Sage X3 might use a third-party Payroll system like Sage 300 People and manually import their Payroll journals into Sage X3.

1) These journals can be thousands of lines and might exceed the maximum journal lines that Sage X3 allow.

2) The Sage X3 standard maximum is 10900 and if you increase higher than that you will get import errors.

Below is the solution how to increase that limit.

When you import a journal with thousands of lines, you might get the below error (this means you have to increase the number of journal lines that you can import).

If you increase the GAS – Number of accounting entry lines pass the system limit of 10900 lines and run the Dictionary validation for the relevant Activity code, you will get the below errors when importing the journal.

To successfully increase the number of journal lines that the system will allow to import you have to increase the below Activity codes respectively and perform a Dictionary validation after each Activity code increase.

GAS – Number of accounting entry lines = 28 000

VTP – Number of distributions per journals = 31 500

VTL – Number of breakdowns per lines = 1 200

Now when you import the massive journal, you will no longer experience the above-mentioned errors.