Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

incorrect invoices on the payables historical aged trial balance

Posted on by 1,005

I print the Historical Aged Trial Balance report for payables and an invoice is printing that should not be.  When I print the Aged Trial Balance the invoice is not displayed.  the invoice has a $0 amount remaining and are in history.  the credit memo applied to the invoice has no apply record and if I void the historical trx I still can't apply the CM as the invoice remains in history. I have checked the dates and they seem fine, nothing funky.

I have run Chechlinks and Reconcile and it soes not correct.  I have a very old KB article that says it soes not apply to GP 10.

Can anyone advise how to correct so the invoice does not show on the historical aged trial balance report

Thanks

*This post is locked for comments

  • Mirza Adnan Profile Picture
    Mirza Adnan 20 on at
    RE: incorrect invoices on the payables historical aged trial balance

    Hi Paula,

    I am facing the same issue. Would you please be able to confirm me the steps you took to remove the paid applied Invoices from Historical Aged Trial balance?

    Your assistance will be much appreciated.

  • PaulaCam1 Profile Picture
    PaulaCam1 1,005 on at
    Re: incorrect invoices on the payables historical aged trial balance

    yes, the record was as damaged..  I was able to get if off the ATB by following KB article 873948.  The article said the issue did not apply to GP v 10.  I restored a test environment and tested this procedure in GP 10 and luckily it worked fine.  

    Thanks for all the help

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: incorrect invoices on the payables historical aged trial balance

    Hello Paula,

    It looks like you have figured out that this record is damaged. Usually if a record truly is damaged I would recommend removing history on the record if you want to get it off the Aged Trial Balance. However without being able to take a look at the data in the tables its hard to say exactly whats wrong with it.

    If you still have questions on this or would like to have an engineer take a closer look at getting the invoice off your reports, I would recommend opening a support inident so we can look at the record in more detail.

    Thanks!

    Best regards,

    Dan Moore

    Customer Online Technical Community

    -----------------------------------------------------------------------------------------

    We hope you get value from our new forums platform! Tell us what you think:

    social.microsoft.com/.../threads

    ------------------------------------------------------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: incorrect invoices on the payables historical aged trial balance

    I think you're right Paula. Sounds like a corrupt record.

  • PaulaCam1 Profile Picture
    PaulaCam1 1,005 on at
    Re: incorrect invoices on the payables historical aged trial balance

    Yes, the check box is checked.  I think this apply record is corrupted.  When i zoom into the apply button there is no data.  In a test environment I tried to unapply the credit memo and I could not.  I tried to void thehistorical transaction, the sytem allowed that, but the inovice is still showing as historical yet showing on the historical trial balance report as open.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: incorrect invoices on the payables historical aged trial balance

    Is the 'Exclude Fully Paid Documents' checkbox checked in your Historical report options?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans