Today our AP Department called in and reported they were not able print checks, and when our AP Department calls in, some is wrong, they can handle almost any AP GP functions and issues. Got the error messages it just reads as follows:
As routine question asked the AP team, did you print the edit list and were there any errors reported on it ? As expected got a neatly organized and crisp report – no point reviewing it, sure it would have been already done, but I have asked it have to review it, completed the formality, as expected it wasn’t helpful.
Based on experience knew that one of the vendor in the check batch is not active which is causing the error, the problem is how do we identify the vendor for a batch of 60 odd checks ?
1) Generated just in time Dex SQL Log, which did list the last vendor information when error occurred. We were able to activate the vendor and when reprocessed the batch again the problem re appeared.
2) We realized that the recent vendor reorganization process where multiple vendors were inactivated (Yes – not from GP) is the root cause for the problem, another reason why we should not update GP tables outside GP. There are other vendors in the check batch who needs to be activated. Is there a easy way ? The Dex SQL is ok, but is sequential and stops after every error.
3) Decided to write a SSRS Report quickly to check vendor status of all check batch vendors. Which table is the payment info stored ? Identifying the table was not a problem, all I had to do was to connect to http://www.sanjaykumar.us/index.php/category/dynamics-gp/tables-dynamics-gp/pm/
and search for the word work….
The table we needed was PM10300. Writing the query there after was a flash….
DECLARE @batchnumb AS VARCHAR(21) SELECT @batchnumb = '?' SELECT vendorid, vendname, CASE vendstts WHEN 1 THEN 'Active' WHEN 2 THEN 'In Active' WHEN 3 THEN 'Temp' END AS status FROM pm00200 WITH (nolock) WHERE vendorid IN (SELECT vendorid FROM pm10300 WITH (nolock) WHERE bachnumb = @Batchnumb) AND vendstts <> 1
This query returns active vendors not active at check batch and is delivered through SSRS report. Now Our AP Department can manage this the situation themselves! Turned out to be Happy Halloween after all.