Topic: Option to omit obsolete parts from Complete-Inventory-Valuation reports
|By: igalloway||Posted on: Dec 30 2020 at 06:41:27 PM|
|Is there a way to omit obsolete parts from showing up in the "Complete Inventory Valuation " report?|
- could a flag be created
- or, could an additional report be created
Is there a way to omit obsolete parts from showing up in the "Parts Not Connected to Any Assembly" report?"
|By: igalloway||Posted on: Dec 30 2020 at 06:45:16 PM|
|If you can do a flag option, then I expect there is value in also adding a flag to omit hidden items as well?|
|By: Support||Posted on: Jan 2 2021 at 04:54:33 AM|
|We'd need to think about this.|
If you have a quantity of obsolete parts then, in a way, their value still counts and the report serves as a reminder that you need to do something about all those obsolete parts. Sell them or scrap them. If you want to keep them then they have a value.
But, I agree, having an option to exclude them would be an idea.
On the other hand. What about leaving them in the report but showing the totals at the bottom with wording such as "Total = nnnnn.nn of which 1234.56 in obsolete parts"
What about that?
|By: Claire||Posted on: Jan 3 2021 at 03:48:41 PM|
|Hi. We had this same dilemma. Our way round this is slightly complicated I'm afraid!!|
We do not use the obsolete or hidden flags so cannot comment on their affect on valuation reports. We keep all our parts/ assemblies in the main lists and put OB in front of the part number when a part becomes obsolete.
At the end of each month, I export the valuation report to Excel and have a spreadsheet set up which removes any items starting with OB and any items in the MISC category to give the overall figures. This allows us to monitor the obsolete stock value too. My spreadsheet also highlights any negative stock figures which have been missed before the report was exported.
Clunky (as most of my solutions are) but it's working for us!
SUPPORT- Yes please to the report showing the totals like this. Could it be split further to show parts, CSAS, MISC?
|By: Support||Posted on: Jan 4 2021 at 04:32:41 AM|
|Claire. Yes. I suppose sorting or grouping TYPE (CSAS, MISC etc) and showing total values of each type is possible.|
|By: Support||Posted on: Jan 4 2021 at 04:39:57 AM|
|We could also split it further to show the value of CSAS vs HiddenCSAS vs ObsoleteCSAS. But there's dozens of possible variations and to suit everyone we'd need a large panel full of buttons or checkboxes to set the options. It starts to add more complexity for the majority of people who are quite happy without a ton of options.|
I want to add that most people come to MniMRP because it does not have a plethora of options.
Claire, in her comment above, uses Excel. - Excel is a great tool and many pages in MiniMRP have an export button.
If MiniMRP isn't doing exactly what you want then export to excel. we really don't want to add complexity AND COST to MiniMRP when that complexity is well served by tools such as excel.
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.