Skip to content
logo Knowledgebase

Error ‘@X3/TRT/CPTAUTO$adx (1811) Error 20: File non-existent TBCCE1 (12000)’ when closing Fiscal Year

Created on  | Last modified on 

Summary

Error ‘@X3/TRT/CPTAUTO$adx (1811) Error 20: File non-existent TBCCE1 (12000)’ when closing Fiscal Year When running SIMULFINEX no errors displayed Customer specific parameters for X3: MAXVANA general parameter set to 4000 GAS Activity code to 12000 VTP Activity code to 12000 VTL activity code to 4000 The following rule must be respected: MAXVANA = VTL and VTP = 3 VTL when setting the values for the parameters. The values must not exceed 32766.

Description

WARNING: if some entries have already been created in the system with 12000 lines, you won't be able to see those entries anymore in GESGAS.

Cause

Resolution

This error message is common when the carry forward manages analytical flows.
So, closing entry generation is following a split rule when there are more general movements than maximum lines allowed by the system.
It means that when a year-end triggers 1000 accounts defined as ‘Carry Forward’, and if the GAS value is defined as 300, we are going to have 4 carry forward documents.

3 first ones with about 300 lines (a few lines are kept for rounding lines’ purpose).
Last one with more than 100 lines.

In our example having GAS as 12000 is too high and impacts the number of lines displayed in journal entry screens, as well as the work masks used by the scripts like the accounting interface, which impacts performance.
So increasing the GAS value causes a single GL document for all the carry forward flows and as a consequence, all the analytical movements are going to be managed in this single document.

In our example, the entry creation crashes because the maximum analytical management is reached/exceeded.
VTL is the maximum number of analytical flows by general line
VTP is the maximum number of analytical flows per journal entry

So, decreasing GAS (standard value of 300 would be enough) will reduce the number of analytical movements in each carry forward, and defined VTP and VTL values would be sufficient for the closing context and get the Carry Forwards documents created.

The best way to perform the analysis, after decreasing GAS which is advised in this particular case, is to run the year-end in simulation mode (SIMULFINEX) and then retrieve (using Sql management request) the GACCFIYENA and GACCFIYEND data to analyze this analytical limit. In short, you will need to analyse the maximum number of lines on the existing GL documents to set up the more relevant GAS value.