Adding Total Button in Form No. 20 General Ledger Entries

Sbhat

One of our user is requesting a Variable Field called 'Total Amount' button on Form no. 20 General ledger entries, whenever user drills down from Chart of accounts to Form no. 20 at the bottom they want to see a Total of Amount field from G/L entry, even if they filter on the Form no. 20 G/L entry the Total amount should change showing the Amount total for Filtered lines.

Is this doable and If yes, can someone please tell me how.

Many Thanks

S.

jglathe

Hi,

yes this is doable. Maybe different in pages... What you need:

- a variable to store the current filters on the table,
- a function to do the calculation and save the result to a display variable,
- use of the apropriate triggers and properties. You would need to set UpdateOnActivate, and you should call the calculation on activation, and when a record is fetched. The actual calculation should only be performed when the filters on the table have changed (in that spirit, anyway).

with best regards

Jens