Armanino Blog
Article

Stock Count Schedule Mass Add Is Not Working

January 19, 2011

Another day at the office managing support calls was a very good day until my colleague Doug Pitcher tells me that there was a customer issue and if I wanted to look at the problem.

What happened was that in most companies for this customer whenever they tried to Schedule a Stock Count, they started filling all the details, but when they clicked on the "Mass Add" button, the form appeared they actually selected the from and to fields and after they clicked ok to accept the parameters nothing appeared to work, they were returned to the main Stock Count Schedule window with no records to count.

Before they worked on this even they created a support case, the assessment from the engineer at Microsoft was right there was a bug in GP 10 SP4 and was fixed in SP5 so the answer was "Update to SP5 and the issue will be resolved".

We did what support plan was and after coordinating a downtime with the customer we proceeded to the upgrade, but to our surprise it was having the same behavior after the service pack.

My task was to try and find a solution to this, I started monitoring with DEXSQL.Log and everything appeared to be normal but no records were returned, so I went and review the tables involved and discover that 2 of them had invalid records. The invalid records had the column Itemnmbr left blank, so I wrote a script to be run for that company and fix those invalid records:

Delete IV10301 where ITEMNMBR =''

Delete IV00101 where ITEMNMBR =''

Delete IV00102 where ITEMNMBR =''

After this script I noticed that a few records were deleted from the DB (I did a select first to evaluate records, before I jumped into deleting data) we went to the Stock Count Schedule window, we did the steps and voilá!! now everything was working as expected.

Hope it helps!!

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Resources
Related News & Insights
Costco Travel Webinar
Webinar
One of the world’s top retailers reveals their cloud upgrade process.

May 19, 2022 | 11:00 AM - 11:30 AM PT
Overview of Sage Intacct R2 Release Webinar
Webinar
Learn the newest features and enhancements in Sage Intacct from the 2022 Release 2.

May 18, 2022 | 01:00 PM - 02:00 PM PT
Foundation Cuts Manual Data Entry, Empowers Staff With Robotic Process Automation
Case Study
RPA tech enables lasting growth, boosts savings and frees up staff to redirect their time to meaningful strategies.

May 18, 2022