Partner Zone
Partner Zone

Remove cents on debtor statements

This thread is now closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Highlighted
janejanejane
2 Posts
User
New Zealand
janejanejane

2Posts

0Kudos

0Solutions

Solved: Go to Solution

Remove cents on debtor statements

Hi

 

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

 

cents.png 

 

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

bal.png

 

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?

Please help!

 

Thanks!

 

4 REPLIES 4
MYOB Staff Post CarlBrooks
84 Posts
MYOB Staff Post
Australia
CarlBrooks
MYOB Staff Post

225Posts

62Kudos

25Solutions

Re: Remove cents on debtor statements

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

 

janejanejane
2 Posts
User
New Zealand
janejanejane

2Posts

0Kudos

0Solutions

Re: Remove cents on debtor statements

Hi Carl,

 

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

1.png

 

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

 

2.png 

But in fact, they have already cleared their old balance.

This is what it looks like in Details 1 of their account

3.png 

 

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!

MYOB Staff Post CarlBrooks
84 Posts
MYOB Staff Post
Australia
CarlBrooks
MYOB Staff Post

225Posts

62Kudos

25Solutions

Accepted Solution Solved Solution

Re: Remove cents on debtor statements

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. 

Valued Partner Steve_Marriott
63 Posts
Valued Partner
Australia
Steve_Marriott
Valued Partner

193Posts

48Kudos

14Solutions

Re: Remove cents on debtor statements

Hi @janejanejane and @CarlBrooks

 

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.

 

Regards

 

Steve.

 

Steve Marriott
Very Impressive Software
steve@veryimpressive.co.nz
Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post