Question

Kinetic - PPV on Raw materials Question

  • 1 May 2023
  • 1 reply
  • 77 views
M
Userlevel 1

My Director of Finance came to me with a ‘finding’ from an audit around the recorded costs of raw materials.

We have Raw Materials set to Lot\Avg costing.

PO is created for $100. PO is received and then invoice comes in at $150.00, We do see the PUR-CST transaction for the difference but the Costs tab on the material Part is not updating. He is looking for the system to automatically update the lot or avg costs when these types of situations occur. 

To clarify, all cost seem to record on jobs correctly if material is Purchased Direct. It’s just they are looking for the value of the inventory to automatically update.

Is this possible and where can I learn more about how to setup and test it out?

Thanks for any direction you can provide

Melissa

1 reply

A
Userlevel 1

I’m not familiar with a Transaction Type PUR-CST. Even just pulled up the Inventory Technical Reference Guide to make sure.
From what I know, Average Costs for purchases recalculate on PartTran
line additions with the types PUR-STK and PUR-MTL.  Purchase to stock, purchase direct to job.

Sounds more like a part config issue to me.
I recommend querying the PartTran table for these transactions.

Reply


Terms & Conditions