GLPOST

This has all the transaction amount posted to each accounts with journal date. But, how can I find out the balance of particular account on a specific date. Similar to GL - Trial Balance report, this has option to print only " Year/Period" but I want to design as of specific date.

This has all the transaction amount posted to each accounts with journal date. But, how can I find out the balance of particular account on a specific date. Similar to GL - Trial Balance report, this has option to print only " Year/Period" but I want to design as of specific date.

You write your own report using GLPOST and GLAFS together.

You need to sum the transactions in GLPOST by date. The balance is not stored by date in any table.

It is also possible to design a date sensitive report in the Financial Reporter using the FRTRNA function.  You might find it easier.