Inv value report part QOH not matching up

Get Help & Support
1

I have found three parts that prior to the 2021 update looks to have over consumed parts bin that was actually in them. how do I get the database line fixed as it looks like they changed a receipt and did an adjustment also creating a hidden value that is not seen on the UI?

2

Hello,

Could you send a link to the parts in question, and any information showing the overconsumption? I can then have one of our engineers review it and get back to you with a solution.

Thanks

Cetec ERP Support

3

the three parts are:
RAW10060 - Parts (flexforce.us)
RAW10059 - Parts (flexforce.us)
RAW10015 - Parts (flexforce.us)

there QOH count does not match the below report and looking through them it shows bins that do not zero out on consumption in historical data but are not on live part.
Parts - Reports (flexforce.us)

4

Do you know when the warehouse ‘SV’ was deleted?

Thanks,

Cetec ERP Support

5

from asking around no one is sure when it was deleted but was used temporarily. we should only have parts counts in our main warehouse.

6

Hello,

Upon speaking with engineering, the quantity shown on that report is a running total of inventory activity (whereas everywhere else QOH is a bin amount)

I focused on your first part example, and we were able to narrow down where the issue may have happened:

https://cetecerp.flexforce.us/part/activity_list?reloaded=1&web_grid_page=1&location=&prcpart=RAW10060&exact_prcpart=on&from_date=2017-01-01&to_date=2024-03-25&bin=NEW&username=&reason_text=Bin+Move&lot_code=&object_type=FIFOIX&object_id=7300

https://cetecerp.flexforce.us/part/activity_list?reloaded=1&web_grid_page=1&location=&prcpart=RAW10060&exact_prcpart=on&from_date=2017-01-01&to_date=2024-03-25&bin=NEW&username=&reason_text=Bin+Move&lot_code=&object_type=FIFOIX&object_id=7304

https://cetecerp.flexforce.us/part/activity_list?reloaded=1&web_grid_page=1&location=&prcpart=RAW10060&exact_prcpart=on&from_date=2017-01-01&to_date=2024-03-25&bin=NEW&username=&reason_text=Bin+Move&lot_code=&object_type=FIFOIX&object_id=8890

https://cetecerp.flexforce.us/part/activity_list?reloaded=1&web_grid_page=1&location=&prcpart=RAW10060&exact_prcpart=on&from_date=2017-01-01&to_date=2024-03-25&bin=NEW&username=&reason_text=Bin+Move&lot_code=&object_type=FIFOIX&object_id=11703

https://cetecerp.flexforce.us/part/activity_list?reloaded=1&web_grid_page=1&location=&prcpart=RAW10060&exact_prcpart=on&from_date=2017-01-01&to_date=2024-03-25&bin=NEW&username=&reason_text=Bin+Move&lot_code=&object_type=FIFOIX&object_id=11690

We suspect an inventory adjustment with the wrong reason text if you review these.

Thanks

Cetec ERP Support

7

how do i adjust the parts for the Inventory report count but not affect the QOH for the actual part? this way i can correct the mistake in the historical entries.