[Russ Worth]

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.

Thanks,

Russ 

——————————
Russ Worth
GP Business Analyst
Grand Isle Shipyard
Galliano LA
——————————

[Beat Bucher]

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
+1-514-489-4267
@GP_Beat http://dyngpbeat.wordpress.com/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
——————————
——————————————-

[Bruce Strom]

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
——————————
——————————————-