I would likie to run an aged debt report that shows just debit balances.
Unfortunately the report I am running is ignoring unallocated credits on the accounts and hence showing a higher balance o/s than there actually is.
Any ideas?
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Aged Debt Report - Debit Balances Only
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Use a search to find only customers with a balance >= 0 and then run the report you have been using.
(Cleaning up all the allocations would also make sense)
You can do the reverse find everyone with a 0 balance and then go in the bank do a 0 receipt and everything will match.
The reports don't normally exclude unallocated credits, they normally appear in their respective columns and the totals would normally be correct.
(Cleaning up all the allocations would also make sense)
You can do the reverse find everyone with a 0 balance and then go in the bank do a 0 receipt and everything will match.
The reports don't normally exclude unallocated credits, they normally appear in their respective columns and the totals would normally be correct.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: Semrush [Bot] and 2 guests