Partner Zone
Partner Zone

Aged Receivables Detail Report

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
Trusted Cover User SPerera
32 Posts
Trusted Cover User
Australia
SPerera
Trusted Cover User

32Posts

11Kudos

2Solutions

Solved: Go to Solution

Aged Receivables Detail Report

I have been using Aged Receivables Detail report for 7 years. We haved switched to Account Right Live recently. And I have got an issue with aged receivables detail report displaying some customer invoices with zero balances. All these invoices were paid ones. These Zero balances are even showing in customer statements. What is the reason for this?

15 REPLIES 15
Ultimate Partner David_Cree
456 Posts
Ultimate Partner
Australia
David_Cree
Ultimate Partner

1009Posts

322Kudos

129Solutions

Re: Aged Receivables Detail Report

Hello Sandy @SPerera

Rather than using the Aged Receivables Report use the Receivables Reconciliation Report for the date you require.

Cheers

David

 

DAVID CREE
MY Business Locum MBA, LCGI, MICB
MYOB Certified Consultant
Ph: 0418 622 163 Fax: 08 8362 2163
mybl@senet.com.au
St Peters South Australia
Trusted Cover User SPerera
32 Posts
Trusted Cover User
Australia
SPerera
Trusted Cover User

32Posts

11Kudos

2Solutions

Re: Aged Receivables Detail Report

Thanks David. I have done Receivables Reconciliation Report after your reply. I can see the same issue.

 

Thanks

Sandy

Ultimate Partner Mike_James
1,773 Posts
Ultimate Partner
New Zealand
Mike_James
Ultimate Partner

4281Posts

1878Kudos

540Solutions

Re: Aged Receivables Detail Report

Hi @SPerera, if you select the Advanced filters option, is the option to display zero balances ticked or not?


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)
New: S.T.P. Reporting solution for (Aust) v19 users, email for details

Trusted Cover User SPerera
32 Posts
Trusted Cover User
Australia
SPerera
Trusted Cover User

32Posts

11Kudos

2Solutions

Re: Aged Receivables Detail Report

Thanks Mike. It is not ticked. 

Ultimate Partner David_Cree
456 Posts
Ultimate Partner
Australia
David_Cree
Ultimate Partner

1009Posts

322Kudos

129Solutions

Re: Aged Receivables Detail Report

Hello Sandy

 

make sure this tick box is off.

 

Capture.JPG

if that does not help put tick on, re display the report, take off tick and redisplay.

Cheers

David

DAVID CREE
MY Business Locum MBA, LCGI, MICB
MYOB Certified Consultant
Ph: 0418 622 163 Fax: 08 8362 2163
mybl@senet.com.au
St Peters South Australia
Trusted Cover User SPerera
32 Posts
Trusted Cover User
Australia
SPerera
Trusted Cover User

32Posts

11Kudos

2Solutions

Re: Aged Receivables Detail Report

Thanks David. Have done all. Same result. 

 

We are using a MYOB certified third party add on software called Seratec Central. Is this can be a rounding issue with import/export transactions process?

 

Regards

 

Sandy

MYOB Moderator Neil_M
2,000 Posts
MYOB Moderator
Neil_M
MYOB Moderator

11596Posts

1335Kudos

1632Solutions

Re: Aged Receivables Detail Report

Hi Sandy ( @SPerera )

 

Welcome to the MYOB Community Forum, I hope you have been finding it a great resource.

 

My apologies in the delay in responding to your question.

 

It is possible that your add on is having an impact on this. To help test that are you able to open the Clearwater sample company file. Once the file has been opened make sure that at least one of the customers has a current balance of 0. As long as there is a customer with a zero balance, then please try and run the same reports to see if you get the same results.

 

Do let us know how you get on testing this in your Clearwater file.

Regards,
Neil

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Trusted Cover User SPerera
32 Posts
Trusted Cover User
Australia
SPerera
Trusted Cover User

32Posts

11Kudos

2Solutions

Re: Aged Receivables Detail Report

Thanks Neil.

I did run the reoprt in Clearwater file. It is not displaying the same issue in there.

 

Regards

Sandy

MYOB Moderator Neil_M
2,000 Posts
MYOB Moderator
Neil_M
MYOB Moderator

11596Posts

1335Kudos

1632Solutions

Re: Aged Receivables Detail Report

Hi Sandy ( @SPerera )

 

Thanks for doing that check, as Clearwater isn’t showing the issue, it would suggest something specific to that file, but it will mean a bit more digging to find out exactly what is causing this to happen, as this is definately an issue outof left field.

 

Are you able to clarify a couple of things for me?

  • Across the four reports, Aged Receivables summary and detail, and Receivables Reconciliation summary and detail, do these customers with the zero balance invoices appear on all four reports for the same date?

 

  • Are you able to provide us with a screenshot showing one of these customers and the zero dollar invoices? Just so that I can see exactly what the report is doing on your screen, as I am not able to reproduce this on our end.

 

  • If you have a client with these zero-dollar balance invoices that shows as having a zero-dollar total balance on the report, are you able to go into that customer’s card and see if there is a balance showing in there?

 

  • Is the file that this is happening in a cloud file or a file just on your computer? You can tell this by looking in the bottom right hand corner of the window then the file is open, you will see either a green bar if the file is online, a purple bar if the file is stored on yoru computer or network or an orage/red bar if the file is checked out from being online.

 

Do let us know how you get on checking these few things as they should give us more of an idea as to where the problem lies so we can get this resolved for you

Regards,
Neil

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

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