Forum

Hello.
I have a very strange issue with getting accumulation register balance.

I have a accum. register "Cash", some documents which are the expenses and receipts to cash desk and the document "Closing". In this document the real cash balance is saved. So, when it is posted, it compares the register balance with the real life balance and writes the difference to register.
Also I save the difference in the document. And sometimes (not always) the difference calculated at the moment of posting is not equal to the difference calculated now. I see, that when it differs, usually, reg. balance calculated at the moment of posting not includes the last 1 or 2 movements in register. And the time between the first not included movement and document "Closing" could be up to 7-10 min.

The database is used in the single-user mode. All documents are being posted in the real-time mode and changing the posted document is prohibited. I looked at the log and documents are definitely not changed.

Can you help me with advice - in what direction can I search the roots of the problem?

Hello, Mikhail!

Try to look at the period that you set for the Closing document when calculate the difference.
Also try to update the platform to the latest version.

Hello. I calculate the balance by this code:

Final = New Boundary(CurrentObject.Date,BoundaryType.Excluding);
Saldo = AccumulationRegisters.Cash.Balance(Final,New Structure("Company",CurrentObject.Company),,"Value").Total("Value");

Mikhail, try to use "PointInTime()".