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) / Negative invoices
Microsoft Dynamics GP (Archived)

Negative invoices

(0) ShareShare
ReportReport
Posted on by construction 105

Our sales invoices are imported into Receivables Management and in error a negative invoice was posted.  I have tried to apply a Debit Memo to it, but you cannot apply negative invoices in GP.  I have also tried to void via the RM Posted Sales Transaction screen, but receive the message that it first must be unapplied, but it is not applied.

Does anyone know how to remove?

Thank you

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    How did you import this transaction.  Did you try to run checklink against RM.

  • Suggested answer
    Justin Thorp Profile Picture
    Justin Thorp 2,265 on at

    Hi,

    From my very short test, GP doesn't seem to like these Negative RM Sales Transactions.

    Advice:

    1.)  Run paid transaction removal.  This will put the document in History

    2.)  Run Reconcile on Customer Debtor Information (this will adjust the figures by taking this negative amount out of the Customer Balances).

    3.)  Back out the transaction from GL.

    4.)  You may need to also check any of your Tax tables (just to see if they need adjusting).

    5.)  Re-enter the transaction as a positive value.

    Thanks,

    Justin

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    If you have solved this problem, can you post for the knowledge of the others that might be experiencing this type of error.

    I have not seen this happen, but am interested to know how you fixed the situation.

  • Verified answer
    construction Profile Picture
    construction 105 on at

    NOTE:  Please make sure that you have a restorable backup prior to performing any troubleshooting steps.

    1.    Test in a test company with live company data.

    2.    Create a complete backup of live before processing in live.

    3.    Run the following select and update statement to correct the Current Transaction amount.

    a.    Use the select statement to verify the correct record is being updated.

    Select * from RM20101 where DOCNUMBR = JC205251

    b.    Run the update statement to update the amount.

    update RM20101 set CURTRXAM = '-56974.17000' where dex_row_id = 71586

    4.    Once you have verified this is the correct record and have updated the Current Transaction Amount you can now void the Invoice.

    a.    Sales | Transactions | Posted Transactions.

    b.    Document Type = Sales/Invoices

    c.    Number = the Invoices Document Number.

    d.    Enter the correct Void and Posting Date.

    e.    Click Void

    f.     Verify the report.

    5.    Post the GL batch that was created from the void.

    6.    Verify your reports are correct.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I ran into a similar issue today where one of the returns got posted as an invoice but found a solution which worked for me, where I was getting the similar error on the invoice and the invoice would not show up on the Apply Sales Document window.

    Under Tools>Utilities>Sales>Reconcile, and selected the customer with the negative invoice for reconciliation, which made the negative invoice start showing up on the Apply Sales Document Window as well as became available to void.

    After that, it was the standard process to void the invoice and post it again correctly as a proper return.

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
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans