Need to Netbalace (from Transaction Listing) 1

[ZABARVAN]

I need to print the net balance as of current date (from Transaction list) through financial reporter.
which field I should use .....

Thanks

 

[Jay Converse]

GLPOST.TRANSAMT

 

[Jay Converse]

Sorry, forget my first answer. The correct answer is "you can't, that's not how the financial reporter is built".

 

[ZABARVAN]

Is there any way to print the net balance of GL accounts (From Transaction Listing Report), we can generate report through crystal reports, which table and Fields I will have to use.
Thanks....

 

[Jay Converse]

GLAFS.NETPERDx + Sum(GLPOST.TRANSAMT)

 

[Jay Converse]

For example, if you need the balances in period 5 at a certain date, it's

GLAFS.OPENBAL + GLAFS.NETPERD1 + GLAFS.NETPERD2 + GLAFS.NETPERD3 + GLAFS.NETPERD4 + Sum(GLPOST.TRANSAMT) where period = 5 and date <= cutoff

 

[ZABARVAN]

Thank you will try it....