Customer acount report

V5 Question
1

Hi Emre,

I need a customer debit report in total. We work as an “open acount” with our customer and they pay their amount monthly. So i need a report like attached pict.

I have checked the tips but no way :frowning:

Could you please help me

Thank you

2

Here is one I use:

[Customer Balances:1,2,3, 1]
{REPORT ENTITY DETAILS:E.Name,EC.Full Name,EC.Address,E.Balance.Sum;0.00;-0.00;0.00:(ET=Customers) && E.AccountId>0:{0}|{1}|{2}|${3}::$4!=0:}
>> TOTAL||| {REPORT ENTITY DETAILS:E.Balance.Sum;0.00;-0.00;0.00:(ET=Customers) && E.AccountId>0:${0}::$1!=0:}

NOTES:
Now much depends on your own setup such as:

  1. “EC.” prefixes are my Custom Fields;
  2. My ENTITY Customer is actually called Customer;
  3. Using Debit and Credit in this report “!=0” so change it to suit.
1 Like
3

Hi Pauln,

Thank you for your sport… But did not work… I did copy-paste and the screen is ok but no result :slight_smile: What would be the reason…

Thanks again

4

You cant just copy it. You must modify it for your system.

1 Like
5

Is there any way to learn this. ı am stuck :frowning: and I don’t know where i made a mistake. I also need other reports so i need to learn this language… please help

Thank you

6

First what is your entity type that you want to report on?

1 Like
7

Hi Kendash
customer acounts