To be able to set the criteria for: Product code, Product group
Either: All, In, Between, Is
Preferably exportable to Excel. The same columns as the Construction Report but with Average cost price added and more importantly rolled up so that each BOM shows the components for all sub-assemblies exploded out (currently it will only show a single line for each sub-assembly, not the makeup of each one).
This would be a much quicker way to access costing data for multiple BOMs. I have just spent about 10 minutes copying and pasting stock codes from a spreadsheet into the Bill of Materials Cost module (there are over 1,000 in the group, so I can't cost the whole group or it will take hours).
The Excel report I'm proposing would allow me to run for all BOMS and then VLOOKUP/SUMIF on the ones on my original spreadsheet.
Tom Allsop
| Idea Benefit | This would be a much quicker way to access costing data for multiple BOMs. The Excel report I'm proposing would allow me to run for all BOMS and then VLOOKUP/SUMIF on the ones on my original spreadsheet. |
| How do you solve for this problem today? | I have just spent about 10 minutes copying and pasting stock codes from a spreadsheet into the Bill of Materials Cost module (there are over 1,000 in the group, so I can't cost the whole group or it will take hours). |
| Product Variant | Sage 200 Professional |
| Fixed in version | Report Design Service |
This report may be possible via our report design service, specific requirements depending. You get 3 reports per year, you can find all the details of the service, how to book and what's included in our article.