Customer Turnover

Anonymous

I am trying, in vain, to get the customer turnover from the "Customer Ledger Entry" table but am having no luck. ](*,)

Quite simply I want to get the sum of "Sales LCY" for each customer.

I want to be able to output the data to a file using a dataport and to be able to update a field in the customer card.

I hope someone could help.

Regards
Daniel Frampton

Mike1

Hi, have you tried report 119 Customer - Sales list.

It shows the total amount of sales for each customer.....

Savatage

Doesn't the customer card have a Sales (LCY) field already?

For me it's field 62 in the customer table "Sales ($)" ..NA version

Anonymous

I just want the figure to be calculated from the "Sell-to Customer", Not the "Bill-to Customer" as our system currently works it out from.

Dan

rsfairbanks

Try following Savatage's idea.
Copy field 62 to a new field and change the flow field to use sell-to customer inststead of Customer No