Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

HOW TO REMOVE FROM AGING OF A SUPPLIER PAID INVOICE

Posted on by 6,825

Here iam trying to remove the remove the payment of 950 against an invoice of 950....

but it is not appearing in the  Transaction>Purchasing>Apply payable documents....

*This post is locked for comments

  • zulfi721 Profile Picture
    zulfi721 6,825 on at
    RE: HOW TO REMOVE FROM AGING OF A SUPPLIER PAID INVOICE

    HI IAN,

    thx for the help....

    In the Historical aged trial balance

    in the earlier report i used...print/Age as of...begining of the period

    now i checked it with .....print/Age as of....End of the period

    Historical aged trial balance report shows no amount is due to supplier

    i also confirmed it from vendors credit inquiry..

    And also as per my physical record no amount is due to supplier

  • Verified answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: HOW TO REMOVE FROM AGING OF A SUPPLIER PAID INVOICE

    Your invoice and payment aren't showing as they are fully applied and on history.

    The Historical Aged TB you ran first is showing you the status as of the date you selected, which was presumably before they were applied and moved to history.

  • zulfi721 Profile Picture
    zulfi721 6,825 on at
    RE: HOW TO REMOVE FROM AGING OF A SUPPLIER PAID INVOICE

    NORMAL AGED TB

  • Suggested answer
    RE: HOW TO REMOVE FROM AGING OF A SUPPLIER PAID INVOICE

    Ian is correct you are running historical trial balance change the same Aged Trial balance with options and run and check it.

  • zulfi721 Profile Picture
    zulfi721 6,825 on at
    RE: HOW TO REMOVE FROM AGING OF A SUPPLIER PAID INVOICE

    screen shot 

  • Suggested answer
    RE: HOW TO REMOVE FROM AGING OF A SUPPLIER PAID INVOICE

    Hi Zulfi,

    Did you type the creditor ID before press the lookup button please share the screen shot of the apply payment window.

  • Verified answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: HOW TO REMOVE FROM AGING OF A SUPPLIER PAID INVOICE

    You're running the Historical TB, but I can't see the date you're running it for. That might be why the report is including the invoice and payment.

    Try running the normal Aged TB which will show the transactions as of now.

  • zulfi721 Profile Picture
    zulfi721 6,825 on at
    RE: HOW TO REMOVE FROM AGING OF A SUPPLIER PAID INVOICE

    Hi babu,

    thx for the help...

    iam using the same way but in look up this invoice of 950 is not appearing but when i go to view the aging both invoice and payment are appearing in it.

    i have used the filter exclude fully paid invoices...but this is still there....

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: HOW TO REMOVE FROM AGING OF A SUPPLIER PAID INVOICE

    Hi,

    Confusion here is that you don't want to show 'fully paid' transactions into your aging or you really want to void your transactions.

    If you want don't want to show Fully Paid transaction from your report just check 'Exclude Full Paid Documents' and it won't show it in your Aging. Otherwise follow other bloggers suggesstion i.e. voiding transactions.

    Thanks

    Sandip

  • Suggested answer
    RE: HOW TO REMOVE FROM AGING OF A SUPPLIER PAID INVOICE

    Hi Zulfi,

    I think you wanted to apply the 950 to the invoice to remove it from the aged trial balance.  After going to Transaction->Purchasing->Apply payable documents press the lookup button above the document type payment and select the 950 from the list, once you select apply against the invoice which will be listed on the same window.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans