# Stock Status Report not working having Stock in Hand **URL:** \ **Category:** Epicor ERP 10\ **Tags:** reports\ **Created:** [March 13, 2018, 6:35am UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318 "2018-03-13T06:35:10Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Prakash\_Bankar](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/a87d85/32.png) [@Prakash\_Bankar](https://www.epiusers.help/u/Prakash_Bankar)\ **Post date:** [March 13, 2018, 6:35am UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/1 "2018-03-13T06:35:10Z")
Hi all, very interesting behavior i found while running the Stock Status report for few parts, where the stock is available in part tracker (PartBin). After running the stock Status for the same displays blank Report ?? Any reason behind it ? I have refreshed the PartBin qty to PartTran process, rechecked there is no allocated or reserved qtys. Also ran the same report with SSRS report style. Here are the screenshots, 1. part Tracker ![2018-03-13_1148](https://epiusers.help/uploads/default/original/2X/d/dadbe4ac6c80cfd293818e43726c4c1bd238a852.png) 2.Stock Status selection ![2018-03-13_1154](https://epiusers.help/uploads/default/original/2X/5/59b4f2f3ea9ca19a05b1da2f9d7094c84e35999e.png) 3.Report with Blank lines ![2018-03-13_1157](https://epiusers.help/uploads/default/original/2X/6/659bc1e635d0cec5e8753d6dbaf7a93be0db78da.png) Thanks ---
**Author:** ![E102016](https://www.epiusers.help/letter_avatar_proxy/v4/letter/e/f1d935/32.png) [@E102016](https://www.epiusers.help/u/E102016)\ **Post date:** [March 13, 2018, 3:35pm UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/2 "2018-03-13T15:35:55Z")
Are two parts marked as “Non-Stock Items”? ![](https://epiusers.help/uploads/default/original/2X/a/a3fc2f8a5790a7667b1148a88ca7132b0bb67f08.png) ![](https://epiusers.help/uploads/default/original/2X/1/1d11be5ae0f2ff2dd6c2888aaa2aac5773188437.png) ---
**Author:** ![MartyF](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/b5a626/32.png) [@MartyF](https://www.epiusers.help/u/MartyF)\ **Post date:** [March 13, 2018, 10:57pm UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/3 "2018-03-13T22:57:57Z")
What update level are you on? There was a bug in this report prior to about update 10.1.400.18. Fixed in later updates. ---
**Author:** ![Prakash\_Bankar](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/a87d85/32.png) [@Prakash\_Bankar](https://www.epiusers.help/u/Prakash_Bankar)\ **Post date:** [March 14, 2018, 3:15am UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/4 "2018-03-14T03:15:54Z")
@MartyF- Currently we are on 10.1.600.4… so i need to fix the bugs ? ---
**Author:** ![Prakash\_Bankar](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/a87d85/32.png) [@Prakash\_Bankar](https://www.epiusers.help/u/Prakash_Bankar)\ **Post date:** [March 14, 2018, 3:17am UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/5 "2018-03-14T03:17:14Z")
@E102016- No, the part is Quantity Bearing part…I have already cheked with non-stock option on Stock Status Report form. ---
**Author:** ![MartyF](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/b5a626/32.png) [@MartyF](https://www.epiusers.help/u/MartyF)\ **Post date:** [March 14, 2018, 3:27am UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/6 "2018-03-14T03:27:30Z")
It would have been fixed prior to 10.1.600 being released, so I doubt our issue was the same as yours. ---
**Author:** ![Prakash\_Bankar](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/a87d85/32.png) [@Prakash\_Bankar](https://www.epiusers.help/u/Prakash_Bankar)\ **Post date:** [March 14, 2018, 3:41am UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/7 "2018-03-14T03:41:22Z")
So i have to update to a latest Update ? now i have a latest update 10.1.600.18 with me on test server. I will put the live database on this update and will check the results. will let u know the status…Thanks ---
**Author:** ![bordway](https://www.epiusers.help/user_avatar/www.epiusers.help/bordway/32/30753_2.png) [@bordway](https://www.epiusers.help/u/bordway)\ **Post date:** [March 14, 2018, 4:32pm UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/8 "2018-03-14T16:32:47Z")
Have you already tried running the refresh utility? System Management --\> Upgrade --\> Mass Regeneration --\> Refresh Part Quantities and Allocations The table where summarized Part Quantities are stored can get out of sync. I’ve seen it enough that I run this utility at least once every couple of weeks. ---
**Author:** ![MartyF](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/b5a626/32.png) [@MartyF](https://www.epiusers.help/u/MartyF)\ **Post date:** [March 14, 2018, 7:08pm UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/9 "2018-03-14T19:08:15Z")
Prakash, the version we had the bug in was 10.1.400 (note the 400). So what I am saying is that because you are on 600 (18 months later) the bug we encountered will probably have already been fixed in your version already. ---
**Author:** ![PaulMorgan](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/e9c0ed/32.png) [@PaulMorgan](https://www.epiusers.help/u/PaulMorgan)\ **Post date:** [March 14, 2018, 11:29pm UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/10 "2018-03-14T23:29:49Z")
Hi Prakash, This could be an issue relating to upper/lower case. If you look in transaction history was the stock transferred to say bin 1ab1 where your master file bin is actually 1AB1?? if so the stock status report will ignore it. This has been fixed in 10.2…we upgraded from 10.1.600.16 to fix this issue. Apparently Epicor have fixed certain reports/programs in different versions but all of the case related issue have been fixed in 10.2. We were told by Epicor that we either needed to implement some BPM to ensure capitals were used and run a sql script provided to convert the data. Hope this helps, Cheers Paul ---
**Author:** ![caleb.grundmeier](https://www.epiusers.help/letter_avatar_proxy/v4/letter/c/a4c791/32.png) [@caleb.grundmeier](https://www.epiusers.help/u/caleb.grundmeier)\ **Post date:** [March 16, 2018, 4:22pm UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/11 "2018-03-16T16:22:50Z")
> [@PaulMorgan](#): > > This could be an issue relating to upper/lower case. I agree, we have been fighting this issue since upgrading to E10.1.600. Support gave us two “fixes”. SQL fix to run on the database “_This fix program goes through the given tables and updates certain fields that are not the same case as the fields on the table where they are a primary key_”. The other is a trailing spaces datafix. Both helped but we have to run those each time before we run the report to get an accurate number. You will also have this problem with the Slow Moving Stock Report but this one also seems to be fixed in 10.2. If I were you, I would report the issue to Epicor if you haven’t already. They haven’t given me an sense that they are working hard on fixing this report (on the 10.1 version) that our managers use to make business decisions. They just gave me the fixes and sent me on my way. The more people report it, maybe they will get their act together. Depending on the cost of the part that is missing, you could have a severely inaccurate report and you may not even know it! ---
**Author:** ![BoostERP](https://www.epiusers.help/user_avatar/www.epiusers.help/boosterp/32/13342_2.png) [@BoostERP](https://www.epiusers.help/u/BoostERP)\ **Post date:** [May 23, 2018, 2:12pm UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/12 "2018-05-23T14:12:58Z")
Working on a 10.1.600.15 version and seeing the same exact issue with Stock Status as reported here. The Bin is correctly all caps in this case. wondering what the end results was for your fix. Inventory dollars are missing from report because of this. Thanks. Brad ---
**Author:** ![Prakash\_Bankar](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/a87d85/32.png) [@Prakash\_Bankar](https://www.epiusers.help/u/Prakash_Bankar)\ **Post date:** [May 24, 2018, 3:10am UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/13 "2018-05-24T03:10:56Z")
We have reported the case to epicor. Still the the issue has not resolved. will update soon… ---
**Author:** ![BoostERP](https://www.epiusers.help/user_avatar/www.epiusers.help/boosterp/32/13342_2.png) [@BoostERP](https://www.epiusers.help/u/BoostERP)\ **Post date:** [May 24, 2018, 11:33am UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/14 "2018-05-24T11:33:42Z")
The support fix did the trick in our case. Thanks for the update. Hope yours gets resolved also. Brad ---
**Author:** ![emarkus](https://www.epiusers.help/letter_avatar_proxy/v4/letter/e/a88e4f/32.png) [@emarkus](https://www.epiusers.help/u/emarkus)\ **Post date:** [January 18, 2019, 7:41pm UTC](https://www.epiusers.help/t/stock-status-report-not-working-having-stock-in-hand/43318/15 "2019-01-18T19:41:01Z")
I am adding this comment for future users with this same issue. Overall the issue has to do with the Case sensitivity within most of the Inventory tables. Epicor may send you a fix, but it doesn’t work perfectly. Check PartTran and you might find that the fix didn’t reach this table. Use SQL (sorry, really sorry; I had no other way to resolve this) to change Whse & Bin to: example: UPPER(WarehouseCode). Miraculously, you’ll find that the Stock Status Report returns all records.