Reconciliation of vendor account

Hi Everyone, I have some doubts regarding the calculation of Opening balance for a vendor in the AP/GL tables. (F0411, F0413 and F0414). Has anyone encountered a similar requirement..?
I would appreciate any ideas/logic on how to develop a report to calculate the opening balance.. Thanks

XE B7333/SP23/AS400

If you run the R04413, this should agree with the Supplier Ledger Inquiry view which is based on the open items in the F0411.

You should also generate the integrity reports to insure that there is not any data corruption that might affect vendor balances.