on 06-23-2015 12:04 PM
Hi expert,
I need query to find particular customers transactions and delivery balances, AR invoice etc
Hi
can you add more info about your query?
Kind regards
Agustín Marcos Cividanes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vigneshwaran,
Its difficult to achieve (But possible) in a single query. Because all required informations are scattered in various tables.
For Eg: Sales Order, Deliveries, Return, AR Invoices, AR Credit Note Incoming payments, Manual JE, Manual Reconciliation.
But we can take most of the data from Journal entry table but this wont cover, Sales Order, Delivery and delivery return.
By the way, How you are booking expenses for customers??
Thanks
Unnikrishnan
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.