|By: Guest||Posted on: Dec 21 2022 at 08:22:41 AM|
|I am using the excel Get Data feature to generate a COGs format that our accounting team can import into Quickbooks. This is working great except for one issue that has recently come up. |
I imported a bunch of COGs from a csv file and while they do show correctly in MiniMRP they do not show COGs in the excel file that references the MRP5DATA file. If I go to "View/Edit" for one of these items and make any change and save it will then show "xCost" correctly.
Is there something I can do to update the xCost that is saved in the tblstockitems table without manually going into every item and making a change and saving? I tried Settings > Database Maintenance > Check Resync Compact and this did not help.
|By: Guest||Posted on: Dec 23 2022 at 08:16:37 AM|
|The xCost column in tblStockItems is not the place to (constently) store item cost. It's a place where minimrp does some calculations. For example when looking at an assembly or sub assembly the xCost cell would show the total build cost of that assembly. But when looking at PARTs the xCost cell of components is used by the software when totalling up that assembly cost. With that in mind the xCost will not always contain anything.|
The actual cost is in tblItemSuppliers. Look in tblStockItems to get the ID from the ItemID cell and then look in tblItemSupplier for the item id. There may be more supplier's of the same item so potentially many to choose from. Look for the one with a "1" in the DefaultSupplier" cell.
|By: Guest||Posted on: Jan 16 2023 at 10:32:26 AM|
|Okay, that makes sense. |
We have been using the "Most recent purchased price." auto update feature. Ive noticed that this does change the price for the quantity received but does it also set this to the default price so that it will be used in build cost calculations?
|By: Guest||Posted on: Jan 27 2023 at 03:08:41 AM|
|I don't know (I'm just a 'guest' same as you). You'd need to check it. Should be easy to do. When you buy something from a non-default supplier go look in the item suppliers to see if that non-default is now the default.|
But personally I don't think it should. When I set a default supplier I do that because it's that supplier's price that I want to use when calculating build costs.
When I'm making my product price list that I publish and send to potential customers it's the default suppliers price that I want to use as the basis of my quote because that's the price that I'm most comfortable with. If I can then save money later by buying from a non-default supplier then that's good for me but I don't want that actual buy price to affect my published price list.
|By: Guest||Posted on: Jan 30 2023 at 09:56:19 AM|
|These are two different things, i think.|
Setting the "Standard" cost using the auto update, does just that, so it will be used when costing an assembly, however, this is bad if you keep any stock, becuase in a stock valuation it is also using the standard cost and just addin git all up.
Therefore when the auto update changes the standard cost, it will revalue anything you are holding as well.
The correct feature for COG's would be to eaither avergae the stock valuation report (which they will not do) or record the true value of the in-stock items (they won't do that either i think).
We have to accept that we turn off the auto update and make a manual decision when to increase the standard cost ourselves.
I wish that was not the case.
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.