I have incorrect HATB for 2010. Two vendors have invoices showing up in the 91 and over column, but they are not 'real'

(0) Share

Report

Posted on by Robin Wiebe

955

Two invoices show up in the over 91 days. They do not really exist. They don't show up on current Trial Balances. I can't locate the internal invoice anywhere to delete them. Help?

Thank you very much

*This post is locked for comments

All responses (7)

Answers (1)

Verified answer

Robin Wiebe 955 on at

Like (0)

Report

Re: I have incorrect HATB for 2010. Two vendors have invoices showing up in the 91 and over column, but they are not 'real'

Thank you for your attention. I did use a Microsoft "Incident" to help me solve this problem. I had received product into 2010 instead of 2011. I was able to reverse and reenter everything. Thank you again.
Community Member Microsoft Employee on at

Like (0)

Report

Re: I have incorrect HATB for 2010. Two vendors have invoices showing up in the 91 and over column, but they are not 'real'

Befor you try and debug this issue - first run a checklinks, and then run a reconcile.

Also - if your HATB report is modified, switch back to the unmodified version.

Ian.
Community Member Microsoft Employee on at

Like (0)

Report

Re: I have incorrect HATB for 2010. Two vendors have invoices showing up in the 91 and over column, but they are not 'real'

do a search on the MC020105 table for the document numbers. Also do a search by vendor for the historical records.

I am betting you had an exch gain or loss - which will cause these to show up on the HATB because the gain loss offset is posted to AP when you do the apply.

BTW - same thing happens for AR.
Robin Wiebe 955 on at

Like (0)

Report

Re: I have incorrect HATB for 2010. Two vendors have invoices showing up in the 91 and over column, but they are not 'real'

I ran it just now, and No, it did not fix.
veeyeskay on at

Like (0)

Report

Re: I have incorrect HATB for 2010. Two vendors have invoices showing up in the 91 and over column, but they are not 'real'

Robin

Can you run the Payables Reconcile process from Utilities >> Purchasing menu after ensuring that all users are out of the system, and see if that fixes the problem?
Robin Wiebe 955 on at

Like (0)

Report

Re: I have incorrect HATB for 2010. Two vendors have invoices showing up in the 91 and over column, but they are not 'real'

Payables. I simply ran the Historical Aged Trial Balance for 2010, and two vendor ID's have amounts in the 91 and over column. These are not 'real'

Thank you
David Bader on at

Like (0)

Report

Re: I have incorrect HATB for 2010. Two vendors have invoices showing up in the 91 and over column, but they are not 'real'

Hi Robin,

I see you are referencing to Vendors and the HATB. Can you clarify if you are working with the Receivables module or the Payables module? Once we have that information we can direct your inquiry to the correct area.

Have a great day!