Dear All,
I need to pick the total remaining amount for employee related transactions.
I need a filter by GL Account (expense) that's affected on the debit side after posting employee expense/surrender.
How should I filter by GL account in order to calcsum the remaining amount?
Do I have a GL Account field in Employee ledger Entry table or Detailed Employee Ledger Entry?
Should I use bal.Account no field be used?
Kindly assist
Hi,
Employee Ledger Entry has amounts that are sum of entries from Detailed Employee Ledger Entry table. So, you need to use Detailed Employee Ledger Entry. If you need the Remaining amount for a single employee then you achieve it simply by using the formula like this: Sum("Detailed Employee Ledger Entry".Amount WHERE (Employee No.=FIELD(No.))) I am using this formula on Employee table to get to know how much I have to pay to employee. If you want to get total remaining for all employees then use Sum("Detailed Employee Ledger Entry".Amount
Share
Report
All responses (
Answers (
487
