I’ve got a part in inventory that won’t show up on the Stock Status Report. Well, it does show up. But its QOH is zero, while the Part Tracker, PartTran History and PartBin table shows a qty of 2. Part Tracker [image] Part Tran History [image] PartBin query [image] When I run the SSR (limit…

Turned out the problem was with trailing spaces in the PartNum field of some table records. Support gave me two SQL programs to run: FX_Upd_Field_Case.sql DATA FIX FOR CHANGE REQUEST 39940MPS - - Fix Field Case Sensitivity issues FX_Upd_TrailingSpaces.sql DATA FIX FOR CHANGE REQUEST 4088…

Hmmm … more info. There was a transfer order shipment on 01-21-2019, from plant MfgSys to plant GUTH, but I see no TO receipt. This would explain why SSR shows zero. But I would have thought that the PartBin would have been zero until received.

That doesn’t seem to be it. The PartBin.BinNumis in the same case as the BinNum in the PartTran table. I’ve also checked the cases of the plant and warehouse codes. All seem to match.

Try the Refresh PartBin QOH from PartTran or Refresh Part Quantities and Allocations? They’re both in the System Management / Rebuild Processes / Mfg/Distribution

I had already tried the “Refresh PartBin QOH from PartTran” Running the “Refresh Part Quantities and Allocations” now.

Running the “Refresh Part Quantities and Allocations” (in Report only mode) for just the part in question, shows: QOH - No changes (0 -> 0) Non-Nettable - No changes (0 -> 0) Demand - Change of (1 -> 0) TO Demand - Change of (1 -> 0) All other TO Qty’s (Reserve, Alloc, Picking, and Picked) - No …

@ckrusen - we have seen a similar issue with Stock Status report due to upper/lower case as mentioned. Tables are all fine the issue was a hard code in the report to only look for whse code or bin numbers with same case. I see from your screen shots your whse code - Main. That was our problem. …

I hope this is the issue, but still don’t see it. The site ID is GUTH The site desc is GUTHRIE The warehouse ID is Guth The warehouse desc is Main, GUTHRIE The BinNum is I-0001 All related fields of PartTran, PartBin, PartPlant have the same case

I have seen a similar issue due to DATES… the stock status report is date sensitive, showing the “Current” on hand balance as of the date you entered. SO you can run the report as of 1/31/2019, or 12/31/2018 and get two different results… Where THIS problem comes into play is when someone accidenta…

I’m very aware about transaction dates and the SSR (I learned the hard way)

Stock Status Report Qty doesn't match db tables

Epicor ERP 10

tsmith (Tyler Smith) April 26, 2019, 1:48pm 3

What version are you on? It looks like there’s a bug with this report where it’s case sensitive when SQL isn’t, so it doesn’t necessarily see all the stock on hand.

Topic		Replies	Views
Stock Status - Not Showing Inventory Epicor ERP 10 e10	24	7533	November 6, 2020
Stock Status Report not working having Stock in Hand Epicor ERP 10 reports	14	4393	January 18, 2019
Stock Status Report - Inactive Parts Epicor ERP 10 e10	11	1327	November 11, 2019
Stock Status Report - Zero Value on Part Epicor ERP 10	27	12619	June 1, 2022
Add BIN to Stock Status Report Epicor ERP 10 reports	3	2333	November 16, 2019

Stock Status Report Qty doesn't match db tables

Related topics