How can i create a report which have credit balance by custom field.?
I have 5 salespersons to sell products in market and 2 or more sales persons visit same outlets how i saparate these credit balance report.
What is credit balance? Are you asking how to see invoice amount per custom field?
I think he means that two sales persons may have sold goods to a same customer. So he wants to filter the customer balance per Salesperson (which is a custom field placement at invoices and might be on receipts too im assuming).
1 Like
I also believe that is what he meant, my suggestion would be if possible @lubos for the name of staff/salesperson or user (by who) to appear on each transaction just as TIMESTAMP reflects.
Yes exactly i want this type of report.
Credit balance means when i make 2 invoices in sane customer account but the sales persons is different and i am using custom field for sales persons when amount come take in reciepts with different reciepts and name in custom field.
But when i check remaining balance of this customer the balance shows accumulate.
I want to make a report Customer balance by sales persons
You can make advanced query which groups sales invoices by Sales person (which is your custom field on sales invoice level)
2 Likes