Custom report for sales margin by customer

I am trying to develop a report whereby I want to see the gross sales margin by customer. I am struggling to bring in the data for sales invoices. Can anybody please help me with this?

1 Like

I am having the same problem. There β€œIS” option is missing in General Ledger Account.

@Tut @lubos @VACUUMDOG Can you help out in this?

Try this one

1 Like

Thanks @Davide - the only change that I made to this is in the where section > general ledger account > isprofitandlossaccount > is checked

This change is required because it was picking up inventory on hand items.

I use only inventory kits to sell, so I cannot fully test the report.

1 Like

You can also add quantities if it is useful.

1 Like