evandergoot Posted January 21 Share Posted January 21 I have a database that contains the complete buildup of a machine. in this machine specific parts are used multiple times at different levels. now when a Bill Off Materials (BOM ) is generated, the parts and their values are shown at their own positions. For building this is great, for purchase not so. What I need is the report to show a single line of each part but the amounts of each instance summed up to one value. any Ideas ?? Link to comment Share on other sites More sharing options...
Swapnil Pawar Posted January 29 Share Posted January 29 Hello , Could you please elaborate more on this issue by providing the video or more description on this? thanks! Link to comment Share on other sites More sharing options...
evandergoot Posted January 30 Author Share Posted January 30 Hi , I have attached two files, one is the report as it is genereated, the other is the jrxml file. in both row 123 and 158 I find the same part with different quantities. I would like to be able to run a report that has only on line of any part with the total quantity since this is what needs to be ordered in this case 6 x KDN0906 The columns in front tell the location in the assembly / sub assembly in this case this is not relevant. Regards defaultBomReportTemplate.jrxml A0000046-EM02560-BOM+Report-20240130-2037.xlsx Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now