Tracking On Hand MRO part numbers

lkramp · November 17, 2021, 3:10pm

We need to track on hand quantities for non-inventory part numbers - expensed items called out in BOMS. I can turn the quantity bearing flag on but PO receipts do not increase the quantity on hand. The items create PUR-UKN transactions when received.

Has anyone successfully tracked non-inventory items?

Leighanne

bordway · November 17, 2021, 5:31pm

If Qty Bearing is false the system will not track the part qtys.

Have you already checked that Qty Bearing is set to true on the Site (Plant) sheet in part maintenance?
I’ve seen some confusion when Qty Bearing it is only set to true on the main detail sheet
but… set to false on the site sheet(s)?

lkramp · November 17, 2021, 5:42pm

Hi Bruce,

I double checked this as you suggested and the qty bearing box is checked in both places. I can manually add in a qty via an inventory adjustment and this qty is tracked. But it will not add in a quantity from a PO receipt, I am assuming because it creates a PUR-UKN transaction. I am looking for a way around this or a better way to set up MRO items maybe???

I was hoping someone out there had already figured this out.

Thanks,

Leighanne

bordway · November 17, 2021, 5:57pm

Type PUR-UKN, should not make any difference, system should still start tracking qtys.
Did you try creating a new PO after Qty Bearing was set/verified on the part master?

Or maybe you can provide more details on the record transactions, screenshots of the PO Rel and Receipt?

lkramp · November 17, 2021, 6:54pm

I created a new PO. Epicor made me assign an approved supplier before I could create one for this part number.

I am now getting this error message. I created one PO leaving the flag set as inventory. The account number on the release was correct for the expensed item so I thought this would work.

I received the PO and ran the Inv/WIP Reconciliation report. The amounts received posted to the raw material inventory account. I am not sure if this is a customization we have done here (to override the PO release account) or if it will always post this way with the inventory flag checked on the PO.

I will try to send you some print screens but I can only send one at a time.