**ERROR: Posting to table POP10600. Restore from a backup if possible.

  • **ERROR: Posting to table POP10600. Restore from a backup if possible.

    Posted by DSC Communities on March 7, 2017 at 1:43 pm
    • Russ Worth


      March 7, 2017 at 1:43 PM

      Hello all – we received this message 3 different times over the past week when posting a PO invoice match.
      Has anyone seen this error message and can tell me what it means? I checked all the PO/PA/PM/GL tables.
      I was expecting to possibly find a duplicate GL Journal Entry but that is not the case.



      Russ Worth
      GP Business Analyst
      Grand Isle Shipyard
      Galliano LA

    • Beat Bucher


      March 8, 2017 at 8:03 AM

      Hi Russ,
      This is the “Purchasing Shipment Invoice Apply” and you definitely want to know why it’s throwing an error.. it might be that you have some customization or 3rd-party product that plays in the game while you do the posting..
      The best (and quickest) was to find out is to use the GP Power Tools and start the ‘security profiler’.. this will tell you if there is an issue with a resource in GP that is not standard and may cause the error. If that doens’t return anything usefull, you may want to enable the DEX_SQL trace right before the posting and stop when the error occurs, so you can analyze in details what happened in the background (this is all very easy with GPPT).

      Beat Bucher
      Business Analyst, Dynamics GP MVP
      Ultra-Electronics Forensic Technology Inc.
      Montreal QC/Canada
      @GP_Beat http://dyngpbeat.wordpress.com/
      Montreal QC GPUG Chapter Leader
      GP2013R2 / MR2012 CU14

    • Bruce Strom


      March 8, 2017 at 9:03 AM

      Unfortunately, Check Links in PO checks the validity of the PO files themselves, but is not very thorough in verifying the validity of the POP10500/10600 link files.

      Even if you restored from a backup it is likely the duplicate records would be there from before the backup.

      Fortunately, the data structure in these two files are not impenetrable and is fairly simple.  Someone good with SQL and a basic understanding of the POP files can resolve this.  You probably need to bring in a consultant to fix the data files themselves.  Logically, you can deduce what should be in the link files from the PO and POP Invoice files themselves.

      Bruce Strom
      Programmer Analyst
      Associated Grocers of Florida
      sunrise FL

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

Sorry, there were no replies found.

Log in to reply.

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!