Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Closing zero dollar invoices in sales

Posted on by 2,035

We currently use inventory, sales order processing and convert these sales orders to invoices mainly to track inventory.  Our invoices are for internal customers and have zero dollar amounts.  (we don't actually sell anything)  However, all the invoices are still open in Sales with zero dollar balances.  Cannot remove these open invoices because, technically, they are still OPEN.

Is there any way to mark all these invoices (zero dollar) as paid so that we can remove the invoices and clean up the Sales module?

*This post is locked for comments

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Closing zero dollar invoices in sales

    This is an old but important topic, but requires attention

    Thomas has cleared the way for you to proceed. Unlike payable transactions, the sales order processing and receivable transactions are not moved to history automatically, you will have to run the "Paid Transaction Removal" routine.

    In this essence, the important question is (How about the zero dollar invoices !)

    When you run the paid transaction removal and check the option to clear "Paid" documents, zero price invoices are included since the current transaction amount of these documents is zero. Therefore, they will be moved to history along the other transactions which don't have a zero price, but fully paid.

    Let us know if you have any further concerns,

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Closing zero dollar invoices in sales

    There is no option available in GP to delete the open invoices. But, you can void those transactions using Posted Transaction window(Transactions-->Sales-->Posted Transaction).

    Hope this helps!!!

  • Suggested answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: Closing zero dollar invoices in sales

    Hi Deanne,

    Are these documents fully posted in Sales Order Processing? If so you should be able to run the Paid Transaction Removal routine (Microsoft Dynamics GP | Tools | Sales | Routine | Paid Transaction Removal). This should move any invoice that is fully paid such as a 0.00 invoice to the history tables.

    I highly recommend testing this in a test company prior to live.

    Hope this helps!

    ~Thomas Newcomb

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

    Dynamics GP Support

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

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

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans