In SmartList, the Receivables Transactions SmartList (SL) is what you want to run. To pull currently open (due) receivables open the Receivables Transaction SmartList list by clicking on the expansion + button. Here you see a list of previously built reports – the asterisk * is a default report provided by Microsoft. Any of them with an Asterisk were built by Microsoft – and they are okay, but for adequate reporting you’ll likely want to add columns.
For the SL you are wanting, in the command bar click COLUMNS and then ADD and highlight and choose any of the aging buckets – i.e. 31-60 days, etc to see the clients balance in that bucket – otherwise you want to pull in the following columns:
Document Amount – the original invoice or credit memo amount
Current Transaction Amount – the amount left owed on the document
Due Date –
Void Status
Posted
At least these columns – but choose any others you want to see – you are NOT altering this for anyone else – only you can see it.
Now, in the command bar, choose ‘Search’ and in the first search criteria choose the column “Current Transaction Amount” and in the filtering command choose ‘Is Not Equal To’ and enter zero (0) – this will filter out all transactions that have been fully paid.
In Search, also choose to search on the column Void Status and choose either ‘is equal to’ ‘Normal’ and the next search field, choose the column Posted and filter that to ‘is not equal to’ ‘No’
You are now left with a list of exactly what is left due in Receivables – but importantly this is a snap of what is due RIGHT NOW – not yesterday or next week, for that you must run the Historical Aged Trial Balance report in the Sales Module.
Good luck and let us know if you have any other questions!
Login
Report
There was a problem reporting this post.
Block Member?
Please confirm you want to block this member.
You will no longer be able to:
See blocked member's posts
Mention this member in posts
Invite this member to groups
Message this member
Add this member as a connection
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.
Report
You have already reported this .
Welcome to our new site!
Here you will find a wealth of information created for people that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!