Context unordered?

rocketman

I have two proceses txbal1 and txbal2

txbal1 creaes a non persistent bo then does a find and orders by txdate, then calls txbal12
txbal2 is set to accept the npbo and the TX bo as input.

it is meant to retrospectively create opening and closing balances on the TX's by reading a number from the npbo, setting this as opening bal, then adding it to the nett value of he ransaction to create the closing bal then writing the closig bal back into the npbo.

According to the logs, The calculations work fine except that the process doesn't start at the first tx date as expected, it starts at some random place in the list and seems to be totally unordered. Subsequent entries in the list then have incorrect opening balances

Am I missing something here

aware_support

The context should be ordered according to the query that puts object into the context

rocketman

Thanks.

Putting IN BATCHES OF 1 in the FIND statement fixed the issue. (for newbies - this forces a commit to the database after each calculation as per the manual, which I'd forgotten about)

tford

Hi Rocketman,

That's why it's a good idea when asking for help on an issue like this to post the actual rule syntax you are using. I assumed you were already using IN BATCHES OF 1 since you are an old pro 😃

Glad you got it sorted out.