Exclude 0 Transactions from weighted Purchase Costs calculation

I am curious why there are zero cost purchase orders.

The purchase price from a supplier can be higher so I understand the discrepancy.   Is either company using the last and average purchase fields on the inventory cost tab for analysis and/or part cost calculations?   

Hey Christy,

it’s a requirement i have encountered at quite a few customers and i have yet to see a good solution for it. It goes under the name  “Shipment Relevant Parts”. Details differ from customer to customer, but usually you sell an end product and either you have to add parts belonging to this (but already included in the total price, could be anything from screws to spare parts.) in the shipment or the complete product gets assembled at the customer and you need to send pieces (but sell only one product). 

In this case the product is configured, meaning the content will change based on configuration, so you cannot use package parts either. Pricing is done on characteristics in the CTO part.

We need to be able to separately pick and pack these parts in the Shipment Warehouse, declare them separately to customs and so on… 

All of these points leads to creating additional customer order lines as ”Add-ons” for the product purely for logistic and document purposes. 

All Sites have set the calculation method of purchase parts to “weighted average” if that is what you are asking.  I looked at the calculation method for the average pricing and it seems it would be quite easy to customize it to exclude transactions with 0 price from that method (the one that updates average purchase price in Inventory part), but i guess that would not solve our issue on stock value...

Hey Christy,

not sure i understood you correctly, but we order the parts from internal suppliers (same Supplier, Same Parts), but with 2 different processes. If they are spare parts they have a price, if they are SRPs (Shipment Relevant Parts) they have a 0 price.  Might be a dumb question as i am not very good in costing, but what exactly do you mean by  “implement a business process that excludes internally sourced product costs/lines”?

Regards,

Johannes

I believe the disconnect in our discussion is price v cost.   The part costs the same either way (as a charged item v an uncharged item).   The price would be the difference item.

Does that make more sense?

Yeeess… standard costs. Sorry my bad. Thanks for your suggestions, i will look into it.