Voiding Erroneous SOPs

  • Voiding Erroneous SOPs

    Posted by DSC Communities on January 16, 2017 at 4:38 pm
    • Jon Iwanowycz

      Member

      January 16, 2017 at 4:38 PM

      Hello,

      I was wondering if anyone has found a way to deal with the issue of SOPs not voiding in the SOP tables. It would appear that using the standard void process on an SOP will void the records in the RM tables but completely ignores the SOP tables. The only thing I know to do right now is go into the SOP tables using SQL and change the void status.

      Any solutions are welcome.

      ——————————
      Jon Iwanowycz
      Staff Accountant
      Faithlife Corporation
      Bellingham WA
      ——————————

    • Blair Christensen

      Member

      January 17, 2017 at 10:03 AM

      I have run into a very similar thing where occasionally I have to match the voided records between the SOP and RM tables, but the only solution I have found is an SQL script to compare the void status and update where necessary.  Maybe we can ask for that to be incorporated into Dynamics GP.

      ——————————
      Blair Christensen
      Database Administrator
      Oppenheimer Companies, Inc.
      Boise ID
      ——————————
      ——————————————-

    • Brenner Klenzman

      Member

      January 17, 2017 at 10:33 AM

      Hi-

      This was an issue we faced with our own use of GP, so we created something to address it and added it our our GP PowerPack suite.  It’s called Auto-Apply Return to Copied Invoice.  The nutshell is: you use the SOP Copy functionality to create a Return from the Invoice you want to Void.  When you post the Return it automatically applies the “credit” from the Return to the original Invoice.  This isn’t exactly a “void”, but it does take care of clearing both the SOP and RM aspects of the transaction.

      GP PowerPack Sales Tweaks

      Regards,
      Brenner

      ——————————
      Brenner Klenzman
      Owner/Principle
      WilloWare, Inc.
      Wapella IL
      ——————————
      ——————————————-

    • Leslie Vail

      Member

      February 7, 2017 at 1:48 AM

      Brenner,
      You are a rock star. You have some of the coolest, most useful tool ever created.
      Leslie

      ——————————
      Leslie Vail
      Accounting Systems Consulting, Inc.
      Dallas TX
      ——————————
      ——————————————-

    DSC Communities replied 9 years, 9 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Voiding Erroneous SOPs’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!