Hi all, how we can get a monthlyreport which shows number of points or balance asigned to customers as Loyality points. please i need your help

[image] nkahat1: it works emre except the E.balance E.Balance was added in v5.1.55 … ensure you are running latest version. [image] SambaPOS V 5.1.55 - 5.1.56 Release Balance field added for {REPORT ENTITY DETAILS} tag You can use Balance field in Report Entity Details tag. For example {…

thanks every one it works emre except the E.balance :frowning:

[image] nkahat1: it works emre except the E.balance :frowning: E.Balance would be relating to the entity account balance not a custom entity data field which you implied you were using; [image] nkahat1: its V5 and im using seperated Field {Cusomer balance} What are you doing, accounts…

im using the existing customer account to add the loyality balance to

Actually my Version is V5.50, I’ll upgrade to V5.55 thanks

How can I exclude entities with a balance of 0? I have tried [Customers:1,1,1, 1] {REPORT ENTITY DETAILS:E.Name,EC.Address,EC.Phone,E.Balance:(ET=Customers) && E.Balance >= 0}

Try this. [Customers:1,1,1, 1] {REPORT ENTITY DETAILS:E.Name,EC.Address,EC.Phone,E.Balance.sum:(ET=Customers) && E.AccountId>0:::$4!=0}

[image] silentbob: No thats not working I’ve tested it and works fine for me. Maybe it does not work for you for a reason. Can you show how it’s not working?

[image] [Customers:1,1,1, 1] {REPORT ENTITY DETAILS:EC.Customer,E.Name,EC.Address,E.Balance:(ET=Customers) && E.AccountId>0:::$4!=0}

SambaClub Forum

Customer Loyality points/balance monthly report

V5 Question

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled