cancel
Showing results for 
Search instead for 
Did you mean: 

Inventory Cost

Former Member
0 Kudos

Hello,

Does anyone how you can distribute some generic costs to update the Inventory Cost of a material ?

With materials that are Produced you can use overhead rules to distribute costs to Production Lots using Material Cost Estimates - and then update the Inventory Cost/Unit Price

However with materials that are not Produced i.e. sourced externally, it is not possible to use Material Cost Estimates.

We can use the Material Cost Accumulation and FIFO Cost Determination to look at the related PO/GR and IR costs and provide a new Inventory Cost (via FIFO Periodic Value), however this method does not allow us to include others generic costs from a specific GL or Cost Centre to apply to the estimated Inventory Unit Cost.

Do you know how we can get these generic costs from a GL or Cost Centre into some sort of estimated/calculated Inventory Unit Cost ?

Thanks,

Kevin.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Kevin,

Could you please write down your requirement in more detail??

Regards,

Harikrishna

0 Kudos

Hello Kevin,

there is no way of distributing costs to automatically update material costs. Maybe you can check, if the moving average (with regular GI/IR runs) would help. Here the material price gets updated from the actual costs from the supplier invoice. This is what you described.

Adding overhead costs on the material cost - not sure, if this is legally correct.

If you think it is correct, then you can calculate the totals outside ByDesign and then update material costs using the A2X ‘ManageMaterialValuationDataIn’. Here you can update the material unit costs, also for Price Type = ‘Estimated Cost’.

Best regards

Marlene Katzschner

ByDesign Platinum Engineering