Skip to main content

How to get balance up to certain date of a certain account as of certain day using IAL or custom attribute in business reporter Cloud version 

Hi, 

Some accounts (for example AR Trade) allow a balance history so that IFS will create the balance history as well as the details relating to that balance. 

 

It would be helpful if the posting included examples of what type of account your seeking a daily balance. 

Many accounts, clients would never / rarely ever wish to see a detailed history of a balance by date. 

Best regards, 

Thomas


Hi @Thomas Peterson 

Thank you for the response.

I am creating report from business reporter and I want to fetch the opening balance of an account. Issue is , It is not clear for me how to get opening balance for specific account from business reporter for particular date.


Opening balance is usually the sum of period 0 to period N-1 where period N is the reporting period. 

For example, the opening balance is period 0..6 if we are running a report based on period 7.  This is same process as used with the old report generator process. 

In that context, open balance is never date specific - it is accounting period specific.  


Hello @Dharshankumaar Mahendran 

I created similar report similar report you described. See attached my BR report.

Parameters are Company (Book Level), Year (Book Level), VoucherDateFrom (Column Level) and VoucherDateTo (Column Level).

Column F for opening balance (<&VoucherDateFrom), column H for movement (BETWEEN &VoucherDateFrom and &VoucherDateTo) and column J for total.

 

Hope this helps


Hi @Furkan Zengin 

Thank you for the information 

 

Can you let me know for which IFS version you prepared this for?

 

Best Regards,

Dharshan.


Hi

This is created for IFS Cloud 23R1

 


Reply