Getting total customer ledger entries by sell to customer


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
Sales (LCY)

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



Please sign in to leave a comment.