on 08-27-2015 6:39 AM
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.
Hi Kevin,
Could you please write down your requirement in more detail??
Regards,
Harikrishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.