Is it possible to generate a simple buy list for a top level assembly of a structured bom listing the total quantity for each item and the total cost per line item?.
Posted on: Sep 5 2019 at 12:52:39 PM
There's no actual button to generate a 'Buy List' but the way I do it is to go to the menu "Assemblies" and search or scroll to the assembly you're interested in. Right Click it and select the option to view indented parts list.
You'll see columns for:-
"Total Qty" (The total required by that assembly)
"OnHand" (The quantity you have of the item in your inventory)
"OnOrder" (The quantity, if any, that are already on order but not yet received)
It also shows cost each and the supplier's name.
If you don't see those columns go to the top menu button and select the option to 'Show/Hide' columns and enable the columns you're interested in.
In the top right corner of the window is a 'Qty' button. If you were to set that to, for example, 10 and click 'refresh' it'll do all the multiplication for you telling you how many of everything you need to build 10 assemblies.
That isn't specifically a 'Buy List'. But you can easily see what's missing, where to buy it and what it's going to cost.
But there's also the shortage reports whch you really should be using especially where you might have multiple work orders waiting to be kitted and some of those work orders may be demanding the same common components.
By: Ken at DTS
Posted on: Sep 5 2019 at 02:25:54 PM
This is how we generate a "buy list" for top-level assembly:
1. "View Indented Parts List/BOM"
2. "View as Consolidated Pick List"
3. Change the "Qty" to the quantity of the assemblies that you want to buy parts for.
4. Click the refresh button.
Posted on: Sep 9 2019 at 02:50:44 AM
Thanks for the answers;
I think the consolidated pick list is doing exactly what I was after.
In the structured bom view P&V used to have a nice graphical element with a total for each sub assembly but this giving us enough useful information to see where the main costs lay etc.
Although you can add lots of suppliers as far as i can see it doesn't have the option to select the cheapest supplier when showing a bom cost. This would be useful as would the option to add volume discounts so that the more you buy the less the whole product is shown to cost.
Posted on: Sep 9 2019 at 08:45:54 AM
The BOM cost always uses the 'default' vendor's prices rather than cheapest/quickest or whatever. Although the latest version has a an option in SetUp where you can tell it to use the most recent buy price when calculating build cost of assemblies. It looks like it's still using 'Default' vendor but that when you create a PO the vendor and the price on that PO automatically become the default.
I also hear there's another update in the works which will use FIFO on your PO's to get a rolling average cost of OnHand components.
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.