 |
|
Topic: Vital Requirement - Issue with costing
|
| By: Steve T | Posted on: Dec 7 2025 at 11:40:29 AM | Hi
I have just realised that assembly costings only show the value of all items inside the BOMs. But we have many assemblies that we can either build in-house or that can be purchased pre-assembled from our subcontractors.
We absolutely need a column in assemblies for the purchase cost, exactly like the one in components. This is “as well as” not “instead of” the build cost column because we will need both.
I am positive that there are many other companies who use MiniMRP who also buy assemblies externally and will need the purchase cost. The assemblies already have a feature to add multiple suppliers exactly like components do, so my hope is that it’s already set-up in a way that allows this feature, but I don’t know how much work that will be. | |
| By: Support | Posted on: Dec 8 2025 at 10:17:45 AM | I suppose it would be possible to add an extra column to show the "Buy" cost of an assembly that could be purchased. So one column for the build cost and another for the Buy cost.
But I fear that if we did that then you'd then ask for the inventory valuation report to know how many of the current OnHand inventory were purchased and how many were built inhouse and to show the total value taking the two different costs into consideration.
In any case you are the first person to ever ask for this so I don't think we'll do it
Please bear in mind that every user of MiniMRP would probably like a few very small changes. But if we did them all we'd have 'MaxiMRP' which is not what we, or most of our users, want. | |
| By: Guest | Posted on: Dec 9 2025 at 04:41:07 AM | | Maybe the one's that do, would pay for it. (I would) | |
| By: Steve T | Posted on: Dec 9 2025 at 10:47:07 AM | Given there's no way to see a report of all items received via Purchase Orders in specific dates, the only workaround to my original request is for me to export the "Purchasing > Completed Purchase Orders" view, expand them all, and use Excel to work out the latest and average cost for parts bought in.
But there are two problems, one major and one minor.
MAJOR: There's no column in "Completed Purchase Orders" for the UOM of items. Meaning it is showing screws as costing me up to £10 each, whereas the UOM being 500 means they are actually only £0.02 each. Could a column be added for UOM so that I can at least run a formula to work out the individual item cost?
MINOR: The other problem is more minor, but to see "Completed Purchase Orders" within set dates I only see the "More" button, which I have to press until I see the start ate I want to use. This then also includes everything past that date with no way to reduce it.
It's not a major issue but is there a way to add a way to see "Completed Purchase Orders" between two dates? | |
| By: Steve T | Posted on: Dec 9 2025 at 12:02:26 PM | Essentially, as it stands there is no way to work out how much components have cost us, either the last paid (as there's no UOM or Each price in any lists) or the average cost in a period (again, same cause).
In "Components" it will only show me the Each price based on the "Default" supplier option, but we don't always use the default.
And in "Completed POs" there's no UOMs only the total. | |
| By: MattQ | Posted on: Dec 10 2025 at 11:01:31 AM | My understanding is that the cost price you see in the 'All Components' grid is the one used to calculate build costs. It's meant to be simple.
minimrp can have an unlimited number of suppliers for an item with many different UOM criteria. Having many different columns showing many different suppliers and their different UOMs etc wouldn't make life easier. Not for me anyway.
As for assembly build costs. We used to use a bigger system that would look at all the prices paid vs what we had OnHand to calculate a build cost but there was no way to see (ie confirm) how that was calculated without going back and looking at every previous purchase order. So we just had to believe it. minimrp is much simpler in that it just shows a 'default' build cost based on the default supplier's price. In fact we rarely purchase from the default supplier because other suppliers might be cheaper on the day depending on the order quantity. But I like that Default build cost and I use it when quoting a customer - ie default pcost plus my profit margin. If I managed to buy the parts cheaper than default then that's a bonus.
That default component price. I've noticed in the setup that there's a checkbox to automatically update the item price based on the most recent purchase order price (when the order is received maybe?). I've never used that but maybe that would get you closer to your real cost? But as I said, I like that default cost. I wouldn't want my default cost to change to a low recent price because I might not be able to get that lower price in future and I'd be under quoting. | |
| By: MattQ | Posted on: Dec 10 2025 at 11:03:52 AM | Steve. Your comment about the missing UOM column is a valid point. I never noticed that before because I never look at the item price. I just look at total order values. But I can see how that missing UOM is not helping you. I'd suggest a price each column too.
Maybe something they can add in the next update? | |
| By: Steve T | Posted on: Dec 12 2025 at 10:16:01 AM | For me it's also good we can pick a "default" to take pricing from. When there's a part we have quotes for we can choose what we want our standard purchase quantity to be and use that for the "average".
It would be incredibly useful though to have an "each" price or show the UOM in the "completed Purchase Orders" view though, because then we can use the exported data onto excel to work out what our actual average cost is and the latest cost. This way we can make sure we are pricing things correctly. It's still not giving a full picture with FIFO movements, but it's enough to give us a good indication.
It's also a shame that GRNs can't be expanded with the "+/-" buttons to show the part numbers, prices, and quantities, but that's not the end of the world. We just need something to help us work it all out without having to manually go into each component in each BOM and sub-BOM for all our products. | |
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.
|
|
|
