Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
Our company is using EXO Business Version 2015
When ever we send out the statements to our customers, there is always some cents sitting on the aged balances
EXO> Reports> Debtor Reports> Debtor Statements> Last Period, then hit search
As seen on the table below, the cents are reflecting on the statements that debtors are receiving
Some even have up to 0.81 cents on 3+ months
However, if we check the balances on their account, the cents won't be there
Let us take the line that has a current balance of $385.25
EXO>Debtor> Type the Account number> Details 1
Aged balances for 3+ 2+ 1+ would be zero, but the statement they will be receiving will have an 3+ balance of 0$0.05
Customers are not happy because the cents just keep on accumulating every month.
Is there any way we can actually clear the cents relfecting on the statements they're receiving?
Solved! Go to Solution.
Within EXO Config there is a profile for Debtor Monthly and another for weekly statements that allow you to apply a SQL filter for the initial accounts list, you should be able to filter out those with a balance less than 1 cents.
Below is the setting to look out for, if you are unaware on how to apply this change then contact your business partner who can apply this change for you.
Debtor monthly statement SQL filter for initial account list
Enter a partial SQL WHERE clause to filter the selection when printing monthly statements. The content of the SQL statement is inserted after an 'AND' clause in the account selection logic. Example: AND ACCNO>0
AUTO_STATEMENT_LOGIC, Profile Type - User, Default Value - , Program Names - (Exonet 6000), Module Name - (Statements), Keywords - (Debtor), Field Level - Custom
Thank you for your response.
I understand that the SQL can filter out accounts with balances that are less than $0.
However, this will not remove the small cent values on the debtors aged balances.
Let us take account 4940 as an example
As we are now in the new month, we would like to send out the statments for the prior month
When customer receives their statement, the aging portion will look like this
But in fact, they have already cleared their old balance.
This is what it looks like in Details 1 of their account
So what happens is they keep on paying the extra $0.09 cents, thinking it would clear the old balance.
But it doesn't actually get cleared.
For the next month, the $0.09 cents or higher amount will still appear on their statement as an 'aged balance'
I reckon this is because of the 'rounding and adjustments' from allocations?
Please advise. Thanks!
I see what you mean, I checked the clarity report and the balance value := value + (Lines['amount']-dr_allocations['amount']);
This is probably why you are getting some rounding anomolies, the best advice would be to speak to your business partner and they can walk you through why these are occurring.
In Exo there is a Data Verification function that will check the Balances on Debtors against the transactions for each account. It has the ability to "fix" the balances when they are out from the calculated balance. THIS DOES NOT guarantee the difference will be found but is usually a good start (rather than trying to ignore it by adding filters).
You can find the option in Exo Config / Untilities. BEFORE RUNNING MAKE SURE YOU BACKUP THE DATABASE and ensure no-one is working in Exo.
The other option is as already suggested, contact your reseller and gt them to have a look.