account credit limit customers report

Dafna

is there a designated report for only customers with a credit limit and their balance?

 

• when i try export there is no filter option for only customers with credit limit which means i will get a report with all customers and will have to manipulate the file data which i am trying to avoid ...
• studio analytic doesn't have a report for it and also doesn't offer this filter in the customer lists..
• couldn't find anything in the reports page..

 

Deactivated Member

When you export the data, open the file in Excel. Then sort by the account credit field in descending order. This will give you all the customers with credit on top.

 

Scroll down to the first record with 0 account credit, delete it and any subsequent rows from your spreadsheet.