how to calculate working balance

  • taminourine
  • Topic Author
  • Offline
  • New Member
  • New Member
More
13 years 7 months ago #11050 by taminourine
how to calculate working balance was created by taminourine
Hi,
I need to know how working balance is calculated, and where are future debits stored.
thanks for your help

Please Log in or Create an account to join the conversation.

More
13 years 7 months ago #11051 by durai611
Replied by durai611 on topic Re: how to calculate working balance
If you have set up for Available funds then you can see the update of available ladder in ACCOUNT record itself in fields AUTH.DEBIT.MVMT or UNAUTH.DEBIT.MVMT (Note it's based on set up).

In ONLINE.ACTUAL.BAL, the debit balance is updated. All other balances gets updated on the value date during COB in SOD.

Please Log in or Create an account to join the conversation.

More
13 years 7 months ago - 13 years 7 months ago #11052 by Gigiipse
Replied by Gigiipse on topic Re: how to calculate working balance
Working Balance is the balance at the start of the day plus all authorised and unauthorised.

Forward entries will be added to working balance at the start of the respective days.

There are several tables that might be what you're looking for. Try FBNK.FWD.ENTRY.
Last edit: 13 years 7 months ago by Gigiipse.

Please Log in or Create an account to join the conversation.

  • taminourine
  • Topic Author
  • Offline
  • New Member
  • New Member
More
13 years 7 months ago #11068 by taminourine
Replied by taminourine on topic Re: how to calculate working balance
thanks to all of you for your answers

in fact, I have an account that has working.balance different from ONLINE.ACTUAL.BAL but there are no unauthorised entries for that account.
I want to locate the transaction that created the difference , and I hope it is stored in some temp table or concat file, or just somewhere.
I even tried ENTRY.HOLD, but there is no reference for my account.

Thanks again

Please Log in or Create an account to join the conversation.

  • krishnakumarkr
  • Visitor
  • Visitor
13 years 7 months ago #11071 by krishnakumarkr
Replied by krishnakumarkr on topic Re: how to calculate working balance
further to the post by Mr.Durai. The working balance is the difference between ONLINE.CLEARED.BAL and any unauthorized debits and credits to an account. The balance is shown in the field WORKING.BALANCE in the account application.

Please Log in or Create an account to join the conversation.

More
13 years 7 months ago #11075 by Gigiipse
Replied by Gigiipse on topic Re: how to calculate working balance
Forward entries might affect this balance. Look for transactions in the future.

Please Log in or Create an account to join the conversation.

More
13 years 7 months ago - 13 years 7 months ago #11079 by durai611
Replied by durai611 on topic Re: how to calculate working balance
Have you checked ACCT.ENT.FWD?

Also if I am not mistaken there is a file RE.CONSOL.STMT.ENT.KEY, with ID as CAL key and processing date, under that entries are stored.

You can get the CAL key of the account from ECB.
Last edit: 13 years 7 months ago by durai611.

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
13 years 7 months ago #11091 by jpb
Replied by jpb on topic Re: how to calculate working balance
Dear Mustapha,

I don't know your release - but I remember that we had a lot of accounts with a wrong working balance after upgrade to R08 - all transactions of the day of upgrade were not correctly updated. This also affected OPEN.CLEARED.BAL and ONLINE.CLEARED.BAL.

We corrected it much later with a local routine as we only noticed this during account closure...

Please Log in or Create an account to join the conversation.

Time to create page: 0.042 seconds