Hello,

What I have done in the past is to modify the Amount and Analytical Amount formulas on each line of the auto-journal and add the “ar2” rounding function.

For example, if the formula for the amount is:

V_COURSDEV*[F:SDD]NETPRINOT*[F:SDD]QTY*[F:STJ]QTYSTU/[F:SDD]QTYSTU

Then change it to:

ar2(V_COURSDEV*[F:SDD]NETPRINOT*[F:SDD]QTY*[F:STJ]QTYSTU/[F:SDD]QTYSTU)

What this does is force all amounts to be rounded to 2 decimal places.  Sometimes, that’s what the problem is.

Thanks,

Rafael

Thanks Rafael,

I will try this out.

really surprised that this problem actually exists in X3... really frustrating

I'll let you know what happens

Regards,

Mahmoud

Hi. This is an old aged issue we are dealing with in Sage X3, even in V6.5. When the rounding rules are applied, even to the 2nd decimal, my experience is that a 10-20% of all journals is unbalanced due to 1 cent difference. The only way I then know how to fix it is by applying the GTEST calculator method. This is however painful for both consultants and customers. 

Someone that is an expert in automatical journals once setup a automatic journal line code that balance these journals automatically, but unfortenaly this person left the industry many years ago.

Today come on the same error. The cause for it is, that when costs for production are written in WIPCOST table, which is called for accounting later, values can be written more till 4th decimal.

Later value for receipt product is a sum of all of those costs. When those entries are posted, the variation can increase with a number of cost lines, because each cost line is rounded separately in the journal entry, but receipt product is sum of them. So mathematically journal can be unbalanced, of course with help of auo-journals is possible to post it, but then there will be no balance in between accounts in the journal entry.

I have experience with other ERP and bookkeeping systems, many of them had a possibility to post those rounding differences in a separate account - some like with currency variation. 

Hi Girts, so, how have you resolved it, by using ar2()?

I did almost as it is in standard but with another logical interpretation of journal entry. 
For WIP journal activated - negative sums allowed NEGAMT=2.

For material, labour, machine costs (18,19,20) line I let as it is in the standard. 
Then for 28 line - Production (WIP) - modified so, that journal post negative amount. 

An account is read from the accounting code of site 8. line. In result, I become that all costs are posted in the debit side with positive values, except the last - for line 28, which is posted also in debit - but negative.

So - after posting WIP entry, when some variation in sums due to rounded values appears, there will be left some cents. So. such journal entry have been accepted also from accountants and auditors.