Inventory requirements including Subassemblies

(0) Share

Report

Posted on by swenger

150

We are looking for a report which can tell us what raw materials we are short. Currently it looks at any orders which have this item as "items on orders". However if an item is used in an assembly which is on a sales order it will not include this as reducing the quantity.

As an example, if we have a screw called SD432 which is used as 5 pieces on Assembly called Chair-65 and someone orders a 3 x Chair-65, we can't figure out how to show us that we have in inventory 100 x SD432 but 15 pieces are needed to complete an order.

We know that if we create a Production Order to build this Chair-65 than it will calculate properly, but we want to know if there is a way without creating the production order.

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

TeddyH 12,868 Super User 2024 Season 1 on at

Like (0)

Report

RE: Inventory requirements including Subassemblies

As suggested, you can use the Requisition Worksheet so NAV will suggest you to restock or reorder accordingly based on your setup. It will also look at your BOM as well.
Suggested answer

azelaya59 2,807 on at

Like (0)

Report

RE: Inventory requirements including Subassemblies

By default, the only time NAV will look at the Assembly BOM vs Raw Materials on hand is at the time of generating a Sales Order:

Otherwise, you will have to write a custom report. \

Good Luck!
Suggested answer

azelaya59 2,807 on at

Like (1)

Report

RE: Inventory requirements including Subassemblies

The best way is to run the "Planning Worksheet" Populate your parameters and when you're done you can simply print the worksheet or send it to an Excel spreadsheet.

Good Luck!