Refresh Part Quantities and Allocations

Kinetic ERP
1

We run the Refresh Part Quantities and Allocations as part of the month close process.
This resulted in a doubled OnhandQty in the PartWhse table for the entire inventory.

The last time this happened was in September last year running 2022.1.4.
We are now on 2022.2.9.

This tool is supposed to fix the sync issue, not create it.

Has anyone experienced this?

Thanks
Fred

2

We had problems related to the PartWhse records that were due to varying case of the site id MfgSys vs mfgsys.

Make a quick BAQ (or check in SSSM) to see if this is what is doubling up your entries.

3

Crazy

4

Also, doesn’t that process have a “Report Only” option to show you what the changes would be without implementing them?

Kind of hindsight now, but maybe instead of automatically running it on a schedule, schedule it to do the Report Only version, and email the results to someone who can then determine if it should be run to update the system.

5

Yes, I have had this too. Epicor had a data fix.

6

…

“body seems unclear, is this a full sentence?”

7

Support always told me that running the process without parameters (e.g. part numbers) was not supported.

8

Is that truly why it doubled things though?

I also do not run it wide open. Every morning I print an excel formatted list of results in “report only” mode and then copy and paste those into the filter to then run it in “update” mode.

9

I do not know, just imparting what support told me. Basically, they said they would not support any issues that arise from using it incorrectly. :man_shrugging:t2:

I have never actually had support refuse to help though, so take it with a grain of salt. :salt:

10

L-O-ehfing-L

11

Interesting. For us this is not a multiple records issue. Rather the tool simply updated the table by doubling the current quantity in PartBin. I suspect this issue happened due to the user running it multiple times.

12

PartBin qty’s is derived from the sum of all PartTran records for that part. The “Refresh Part Qty…” process runs by doing a summary of parttran records.

I would run the process again, in Report Only mode. Maybe just a handful of parts as a test. See if it thinks everything is okay.

Then use Part Tran History for the part and export the data (make sure to include Whse and Bin columns). Then summarize that data for a specific Whse and Bin. You’ll probably first need to apply a “direction factor” based on the trantype, as the Tran Qty sign is dependent on the trantype

I’d think would only be an issue if the second time was started right after the first (and before the first finished)