I am trying to get the quantity and value of a part on a specific date. I’ve been trying to do this with PartTran and rebuilding to the day selected, however, if I do it for today, I end up with a value that does not match what is in PartBin. Is there a good way to do this? Is there something built…

So it appears that the big problem was Qty Bearing being changed. I changed one of the questionable parts to Qty Bearing true and reran the refresh and it fixed it. So ultimately, the fix was the refresh but changing Qty Bearing was required for me to fix it. Marking this as the solution in case a…

I don’t imagine those tables it is using for that report are available anywhere? I see StkActivity and StkPart as data sources for that report but can’t find them anywhere. The report has most of the information we need, but my boss is wanting something more like a dashboard to make it easier to rea…

If you use PartTran and calculate a running qty… can you get the quantity correct on a given day? [image] Calc Field for Running Qty: SUM(PartTran.TranQty) OVER (PARTITION BY PartTran.PartNum ORDER BY PartTran.TranNum)

No. That’s what I was doing and it doesn’t match what’s in PartBin if I run it up through today. I also tried using the starting and ending qty fields on PartBin, but those don’t even match each other (Starting Qty does not match Ending Qty of previous transaction) Example: Top part is publishing P…

Are these purchased or Manufactured parts?. I don’t see any PUR-STK or MFG-STK transactions in your summary to increase you inventory counts.

What module are you looking at there? Is it possible the dataview isn’t showing all transactions?

Hi Todd, have you seen this solution? [image] Stock Status Report - Zero Value on Part Epicor ERP 10 Bev_StockStatus.baq (41.8 KB) My Stock Status BAQ to calculate Running Total On hand at any given date, and this is the query phrase in case if you are on early than 10.1…

Both, that just happened to be a purchased part with that one. Same behavior on manufactured.

Running a query on PartTran wide open with no limitations (yes it takes a bit but need the info to troubleshoot)

Downloaded and ran it. Looked good on the first one but the second one is not. [image] If I’m reading this right, should have 29 in inventory. Part Advisor: 13 [image]

Have you run the Refresh PartBin QOH from PartTran process in Report Only mode to verify your PartBin records match your PartTran records? We have some parts that will pop up on this once in a while because an MES station’s session is in the wrong plant or (seemingly) random bugs that cause the Part…

Part Quantities and Values

Kinetic ERP

A.Baeisa (Al) October 1, 2024, 3:09pm 8

Hi Todd,
have you seen this solution?