Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Best way to close Open Payables Invoice in Historical Year

(0) ShareShare
ReportReport
Posted on by

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

  • Community Member Profile Picture
    on at
    RE: Best way to close Open Payables Invoice in Historical Year

    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.

  • Community Member Profile Picture
    on at
    RE: Best way to close Open Payables Invoice in Historical Year

    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
    on at
    RE: Best way to close Open Payables Invoice in Historical Year

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

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans