web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Best way to close Open...
Microsoft Dynamics GP (Archived)

Best way to close Open Payables Invoice in Historical Year

(0) ShareShare
ReportReport
Posted on by Community Member

I have an OPEN Payables Invoice dated 8/4/2015 for $ .01 which I would like to move to HIST. What is the best practice for dealing with old invoices that are OPEN in closed years? I am not talking about the most recent closed year. In this instance, the OPEN invoice is two years back. I do not want anything to affect the closed year (2015) financials.

Thank you.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    You could void the open transaction and change the void date to the current date

  • Community Member Profile Picture
    Community Member on at

    Micki,

    Thank you for responding to my question. The invoice that is still OPEN, in a History Year, with .01 left, is really a large invoice for $3,293.73 with a payment applied of $3,293.72. That is why there is only .01 remaining. I do not wish to void the transaction. I simply want to apply a Credit memo or something along this line that moves the invoice to HISTORY without affecting the closed financial year (2015).

    Thank you.

  • Community Member Profile Picture
    Community Member on at

    Here's what we decided to do.

    1. Make a SQL backup of the company.

    2. Went to GP>>Tools>>Setup>>Posting>>Posting.

        a. Series: Purchasing.

        b. Origin: Payables Trx Entry.

        c. Uncheck "Post Through General Ledger Files settings".

        d. Click Save.

    3. Went to Purchasing>>Transactions>>Transaction Entry.

        a. Selected Document Type: Credit Memo.

        b. Vendor ID: As needed.

        c. Purchases: .01.

        d. Document Number: As needed.

        c. Distributions button: Select GL Accounts as needed.

        e. Apply button: Select desired invoice on which the Credit Memo will be applied.

    4. Posted the transaction.

    5. Went to GP>>Tools>>Routines>> Master Posting.

    6. Select the Credit Memo transaction to delete.

        a. Check then uncheck the box for the desired transaction.

        b. Click on the Batch ID link (blue link).

        c. Click on the Delete button.

    7. Went to GP>>Tools>>Setup>>Posting>>Posting.

        a. Series: Purchasing.

        b. Origin: Payables Trx Entry.

        c. Check "Post Through General Ledger Files settings".

        d. Click Save.

    8. Verified nothing posted to the GL and the invoice was now in History.

    Thank you.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans