Time Phase On hand QTY/Part Transaction History Tracker running totals dont match

[JasonMcD (Jason McDermott)]

@BWagoner

on hand qty in Time phase is not matching with the running total of Part transaction History Tracker

This happened to me when there were PlantWhse records that were impossible. It’s a long explanation, but it’s because I was tinkering with a primary bin uBAQ. (Custom code to blame, for those following the widget thread…)

Point is, are there records in PlantWhse that should not exist? Like I have a PDC warehouse in the PDC site (only) and yet I had parts supposedly in the PDC warehouse in the MfgSys site.

Needed a fix from Epicor Support to get it right.

UBAQ to update Primary Warehouse and Bin

Well, this had some unintended consequences. The pic below is a BAQ on PlantWhse. There is honestly no PDC warehouse in the MfgSys site. It does not exist and is not shared. But records got created in PlantWhse for this imaginary warehouse. This has two consequences. Time Phase shows 129 for this part number in MfgSys alone, and that’s not true, and the running balance is calculated off of that number. Some parts of Part Tracker also show 129 (bin and site OH numbers). A report I made to rep…