When using the table builder i want to create a report that gives me a total spend of sales by customer
is there a way to create a report that gives a total of the invoiced amount by sell to account.
the current process i am using only brings up the first cust ledger entry.
tables included are
No & Name
Bill to Customer
Cust Ledger Entry Table
Sell to customer and link the sell to to the No
Add in a filter for the posting date.
The report is only showing the first entry when what i want is the total sales for the month
Getting total customer ledger entries by sell to customer