Aged Receivables Summary incorrect

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
TomD
Trusted Cover User
134 Posts
Trusted Cover User
Australia
Trusted Cover User

134Posts

19Kudos

3Solutions

Aged Receivables Summary incorrect

Running the Aged Receivables Summary Record for the end of the Financial Year 2022, I am being shown transactions that were only entered in July for the new FY. These are not supposed to be shown as of 30.June?

8 REPLIES 8
LRBooks61
Ultimate Cover User
1,054 Posts
Ultimate Cover User
Australia
Ultimate Cover User

1,054Posts

211Kudos

124Solutions

Re: Aged Receivables Summary incorrect

Hi

 

Run the aged recievables reconciliation report a few down

 

Lisa

TomD
Trusted Cover User
134 Posts
Trusted Cover User
Australia
Trusted Cover User

134Posts

19Kudos

3Solutions

Re: Aged Receivables Summary incorrect

Lisa,

thanks for that but why is the Aged Receivables Summary Report wrong?  Is that a bug? Shouldn't a report as of 30/6 show the details from that date?

LRBooks61
Ultimate Cover User
1,054 Posts
Ultimate Cover User
Australia
Ultimate Cover User

1,054Posts

211Kudos

124Solutions

Re: Aged Receivables Summary incorrect

Hi

 

I just ran the report as at 30/6/22 to see what happens.

 

Although I changed the date to 30/6/22 when the report was produced it was as at todays date,.

 

I then changed the date again as at 30/6/22 from the produced report and the date was then corrected.

 

So a problem /glitch definately - so just check that out

 

Lisa

TomD
Trusted Cover User
134 Posts
Trusted Cover User
Australia
Trusted Cover User

134Posts

19Kudos

3Solutions

Re: Aged Receivables Summary incorrect

Lisa,

 

for me changing the date after having run the report does not change anything. The result will still be wrong. 

I just tested that the same goes for the Aged Payables, also shows July entries under 30/6.

MYOB should take note and fix this.

LRBooks61
Ultimate Cover User
1,054 Posts
Ultimate Cover User
Australia
Ultimate Cover User

1,054Posts

211Kudos

124Solutions

Re: Aged Receivables Summary incorrect

Sorry 

I should have said to change the date in the produced report screen and then rerun from there

 

That worked for me

 

Lisa

Mike_James
Ultimate Partner
5,868 Posts
Ultimate Partner
New Zealand
Ultimate Partner

5,868Posts

1,028Kudos

756Solutions

Re: Aged Receivables Summary incorrect

Hi all, the Aged Receivables report is for all open invoice amounts in the file, regardless of invoice date. Its report date is for aging purposes only. 

 

The Receivables Reconciliation report date is a cut-off (or as-at) date, therefore if you need a back-dated report, this is the one to use. 


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)

Bulk download of attachments (more details...)

LRBooks61
Ultimate Cover User
1,054 Posts
Ultimate Cover User
Australia
Ultimate Cover User

1,054Posts

211Kudos

124Solutions

Re: Aged Receivables Summary incorrect

Apologies 

I just tried it with a july entry and you are 100% right

 

there is a bug

 

Lisa

LRBooks61
Ultimate Cover User
1,054 Posts
Ultimate Cover User
Australia
Ultimate Cover User

1,054Posts

211Kudos

124Solutions

Re: Aged Receivables Summary incorrect

This is happening in the reconciliation report also though

 

Lisa

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