 |
|
Topic: Custom Changes
|
| By: Guest | Posted on: Mar 10 2021 at 04:49:35 AM | Does the company behind MiniMrp offer custom (cost) changes?
I.e. Custom reports?
Thanks | |
| By: Support | Posted on: Mar 10 2021 at 07:19:25 AM | | What kind of report would you like? | |
| By: Guest | Posted on: Mar 10 2021 at 08:26:33 AM | I hate to bring it up, but some form of average costing. So we was wondering if a report or excel output could be done that had all the receipts grouped by part, the cost of each receipt (ie the cost on the PO) then the total, and average of the group.
If the result could be shown aginst the standard cost, we could then change the standard when it was more that a certain amout out.
We love using the system, but we do see this as a problem, we want to be able to value our assemblies and stock based on average, not standard costs - this just helps us get closer to that.
It maybe to much, but just thought we would ask.
Thanks | |
| By: Support | Posted on: Mar 11 2021 at 05:56:38 AM | This is already Work In Progress.
You'll be able to cost assemblies and total inventory value based on the average cost of your OnHand inventory.
There'll be two options, well, three options actually. #1 would be to use the standard, manually inputted, cost. #2 would be to use FIFO/Average and #3 would be to use most recent purchase price.
Sorry. Can't give any time scale on this. During the summer I hope. | |
| By: Guest | Posted on: Mar 11 2021 at 08:45:17 AM | That is fantastic news!
Many thanks - | |
| By: Guest | Posted on: Aug 19 2021 at 02:27:34 AM | | Is this still on track? | |
| By: Support | Posted on: Aug 19 2021 at 03:49:07 AM | It's taking time. Not because it's difficult for us to do. But because we fear it will cause a lot of confusion.
The Math is done. We just need to decide how to use the result present it to the user in a meaningful way.
Look, for example, at the current system. You look in a BOM and you see the total cost of the BOM and can see the cost of individual components. You can select a component and go to that component's detail and see that the item cost shown in the BOM is indeed the current cost of the item from the supplier.
Now consider if instead of current cost we used an average cost paid for the item. That average would not be the same as the current actual cost. If we used the Average cost of components in a BOM that would skew the cost of the BOM but the user would not be able to directly see where each component price came from.
| |
| By: Guest | Posted on: Aug 19 2021 at 04:02:44 AM | But also consider that using 'past' average cost of components to show the cost of a BOM might not necessarily be a good thing.
It is correct that the average cost of components in my current inventory would be accurate for assemblies that I build using parts that are already in my inventory.
But I also use the Build Cost when I'm talking to my customers giving them quotes for future builds. In that case the past average is no good to me at all. The most recent cost would be better.
But currently the cost of materials is going up Up UP. Everything is more expensive and will be even more expensive in future. If I quote a customer a price based on historic average of stuff I bought in the past then I'm likely to loss money.
What we need is for mini mrp to look in to the future and average the cost of FUTURE prices and use that for my FUTURE build costs.
So. What I'm getting at is Yes. Use averages to report on current value of inventory (in the reports menu). But do not try to use it for calculating build costs of assemblies. | |
| By: Guest | Posted on: Aug 19 2021 at 05:01:51 AM | When I first asked about this, I was trying to replicate what our previous system did: -
Produced a valuation report showing "Average" or "Standard" cost.
Produced a report to value an assembly shown as "Average" and "Standard" cost.
Within each component and assembly, we had the three fields for costs - "Standard", "Last" and "Average". I am not sure if you need "Last" (although it could be helpful for components) - or if you even need to show this on the screen (maybe just in reports as extended information).
The valuation reports had three columns, last/average/standard (again not sure if you need last).
We are using the option to update component costs when goods received, this only works if the stock valuation can be averaged -
All materials are rising in cost, but I can't see how MiniMrp can give any future predictions on this, but at least when a component is increased on the system, it would not give false stock valuations and would provide a better guide to assembly costs rising over time, mainly caused when you must buy odd purchases at higher costs as a one off etc.
I think all this is just about giving as much information to the user as is reasonable, the user then must make decisions how to use it.
In the example given by support above, maybe if the information was only available in reports, which had the columns for standard and average, it would be clear how the totals were reached.
But it's great it's moving forward.
Many Thanks.
| |
| By: Support | Posted on: Aug 19 2021 at 06:15:52 AM | Yes. It is moving forward. But I fear it won't be exactly what you want. I can't imagine MiniMRP would benefit from 3 columns showing item cost/valuation calculated 3 different ways.
I want to emphasise the word MINI in the program name. | |
| By: Guest | Posted on: Aug 19 2021 at 10:10:32 AM | I agree.
I was just explaining what we had - all i (and others) really need is to know what the average value of the stock we have is, and ideally what the average cost of an assembly is.
| |
| By: Guest2 | Posted on: Dec 14 2021 at 02:36:36 PM | I also would really love to see this feature, especially the FIFO option. Ultimately what we want is a way to see the total costs of a Finished work order, which MiniMRP already provides, but it'd be great to see the build cost of each item in the BoM at the time the work order completed. Even better would be a way to trace the parts used in the work order to the PO, but that seems substantially harder.
Rather than 3 columns, maybe just have a global setting for how the Build costs should be displayed in the BoM? | |
| By: Guest | Posted on: Dec 14 2022 at 02:46:55 PM | Was this ever implemented? We would like to use average costing with our inventory as well. I see the option to use most recent cost in settings but do not see any way to use average costing.
I would just like to have the cost on the ItemDetail page under Cost(EA) show the average cost of on hand inventory. Most recent cost can go on the supplier tab for each supplier but the Id like to have item cost used for Build Cost to be average. | |
| By: Support | Posted on: Dec 16 2022 at 06:15:29 AM | It almost got done. But, to be honest, we just didn't feel comfortable with itit because there is no way for the user to confirm that the cost we display is actually correct/accurate. If there was an error in our average cost calculation then it could run for years before the inaccuracy was notice by the user.
So we decided that average cost was a step to far for a "Mini" mrp.
Sorry. It is still in the DoDo list but I just can't see it being completed any time soon. | |
| By: Guest | Posted on: Dec 20 2022 at 10:04:52 AM | Could you add an additional field to calculates average cost? Then it would just keep everything you display now the same but also provide the calculated average cost.
Could have a checkbox in settings that would use average cost for build cost for users who want that but would allow users who want to use most recent cost to keep that the same as it is now. | |
| By: Guest | Posted on: Dec 21 2022 at 01:40:40 AM | Take a look at other threads about average costs - they are not going to do it.
But, this is a REAL requirement for anyone that holds stock. | |
| By: Guest | Posted on: Feb 23 2023 at 10:29:53 AM | | I have gathered that the team at MiniMRP has decided not to implement an average cost for a variety of reasons. It has also been stated on this forum that the math is done and they figured out how to do average cost. Would it be possible to just add a field to the tblstockitems table that stores the average cost for each components and then the average build cost of assemblies? I do not need this information visible at all from within MiniMRP but I would like to use this data when I use Power Query to pull our cost data out to transfer to our accounting software. | |
| By: Guest | Posted on: Feb 24 2023 at 09:32:07 AM | I really hope if this is done, it would be available in the software for all.
We wanted avergae cost per component, and then the stock valaution report based on average, then you can use the autom price update feature.
| |
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.
|
|
|
