PLM 360 General Discussion

PLM 360 General Discussion

Reply
*Expert Elite*
scottmoyse
Posts: 1,642
Registered: ‎06-10-2009
Message 1 of 7 (141 Views)

Reporting on BOM Quantities

141 Views, 6 Replies
10-02-2012 04:18 PM

I want to know how many times a Battery or a light is used on a particular project. Specifically so I can order them. Is there any way to automatically extract that quantity information for a given project/product & either export it or generate a purchase order?

 

it seems like you would have to go to the Where Used tab for that Item, or go to the parent BOM item for that project/product then view the flat BOM, scroll down until you find the item & then manually extract the quantity information then type it into the Purchase Order....?

Cheers
Scott Moyse

Please use Mark Solutions!.Accept as Solution &Give Kudos!Kudos to further enhance the value of these forums. Cheers!


   

Product Support
piggeej
Posts: 280
Registered: ‎03-27-2012
Message 2 of 7 (127 Views)

Re: Reporting on BOM Quantities

10-03-2012 07:44 AM in reply to: scottmoyse

Scott,

 

Unfortunately you hit the nail on the head so to speak. We do understand that the BOM is lacking some in that automation and are working on giving the BOM a little more oomph to it, so to speak.  

 

However, one could add a field to the BOM called “quantity”  and manually enter that information, and do a report on that …….

 

Stay tuned.



Joe Piggee
Support Specialist
Product Support
Autodesk, Inc.

*Expert Elite*
scottmoyse
Posts: 1,642
Registered: ‎06-10-2009
Message 3 of 7 (122 Views)

Re: Reporting on BOM Quantities

10-03-2012 01:36 PM in reply to: piggeej

piggeej wrote:

 

However, one could add a field to the BOM called “quantity”  and manually enter that information, and do a report on that …….

 


Blaaahh!

 

There's is way too much double entry in PLM at the moment to get what you need. My latest issue is needing two way relationships, but that same info needs to be in the item details as well...

 

you know I love this product, however, it really does have a long way to go to become more efficient to use. Thanks for getting back to me.

Cheers
Scott Moyse

Please use Mark Solutions!.Accept as Solution &Give Kudos!Kudos to further enhance the value of these forums. Cheers!


   

Valued Contributor
BiggePLM
Posts: 97
Registered: ‎03-18-2013
Message 4 of 7 (65 Views)

Re: Reporting on BOM Quantities

07-25-2014 11:30 AM in reply to: scottmoyse

I too am facing this issue?

 

Two possible functions that could help with this (Although my use case does not require auto generation of project total quantities)

 

1. Have a flat customizable view like you have for nested. Then you could do something like what Joe indicated with an easier reference to the flatened (summed) quantity for a project. My intent would be to use this for our project manager to authorize the purchase of a quantity of an item in the project BOM. As it stands now I have to switch views back and forth with the flat and nested (Custom view) to do that.

 

2. Have a item details field that you can put in the BOM View then filter the view to show only those items in the list that match the filter selected (Similar to excel filtering), This would also work in the Flat - Custom view if it existed

 

I will put these in the Idea Station.

Employee
gasevsm
Posts: 61
Registered: ‎01-17-2013
Message 5 of 7 (61 Views)

Re: Reporting on BOM Quantities

07-25-2014 11:40 AM in reply to: scottmoyse
Greeting,

BOM quantities are calculated on the fly in the frontend due to aggregation and rollup behavior. Reporting is a backend operation as such doesn't understand or have access to rollups presently.

Neat idea; will need to consider in future to either allow reporting to not only report but have BOM specific understanding or get somehow creative in another direction.

Thanks for bringing it up. This needs some thinking and rearchitecting few modules.

Regards,
--
Martin Gasevski | Product Manager | Autodesk PLM 360



--
Martin Gasevski | Product Manager | Autodesk PLM 360
Valued Contributor
BiggePLM
Posts: 97
Registered: ‎03-18-2013
Message 6 of 7 (55 Views)

Re: Reporting on BOM Quantities

07-25-2014 02:01 PM in reply to: gasevsm
Employee
jared.sund
Posts: 70
Registered: ‎11-04-2011
Message 7 of 7 (51 Views)

Re: Reporting on BOM Quantities

07-25-2014 03:29 PM in reply to: scottmoyse

Scott, 

 

I see the value in the enhancements listed in this thread, however I'm a little confused about your original request.  Purchase orders are generally not PLM functionality, and would commonly be an action that would be performed within an ERP system.  Is my thinking here too rigid about the boundaries between PLM and ERP functionality?

 

 -Jared

Jared Sund
Sr. Product Line Manager, Product Lifecycle Management
Autodesk, Inc.
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.