Error 13 : Calculation capacity exceeded in Accounting Task

Posted By chunheng 24 days ago

Hi,

Context:

- Sage X3 v12p34.

- Working with both US Dollar and Indonesian Rupiah and 1 USD = 15,888 IDR from Google as a reference.

- The company is big so the client would like to know the currency max limit supported by Sage.

When checking the Query Management, observed that the accounting task is canceled:

When checking the reason of canceled:

```

@X3.TRT/CPTBAL$adx (329) Error 13 : Calculation capacity exceeded d:

JenkinsSlave

workspace

runtime_Release_release_R096.001

src

sqlodbc.cpp.748.

at @X3.TRT/FIN_BATCH$adx

at @X3.TRT/CPTBAL$adx

at @X3.TRT/BATCHCPT$adx

at @X3.TRT/ASYRSRVBATCH$adx

at @X3.TRT/ASYRMAIN$adx

at @UATV11.STC/OBJECT$adx

Query terminated with error (Calculation capacity exceeded) (11013)

```

When I checked the internal Accounting task queue:

Amount (IDR, converted from USD-equivalent): 54,593,345,089,963.3400000000000

When I checked the purchase receipt record for it:

I am current using a temporary solution to ignore the task using a FLG_0 that is not 0.

I have tried raising the MD1 and MD6 data type to 16.2, data type validate followed by complete validation, but no results.

Question:

- How should I proceed in this case as now there is a journal entry record that cannot be inserted into the system?

- Why the standard screen does not stop and deny the creation of the purchase receipt entry if there will be an issue?

Sage X3