Skip to content
logo Knowledgebase

Bill of Materials / Manufacturing, Inventory: Selecting quantities for a specific bill component from multiple Lot Numbers on manufacturing process

Created on  | Last modified on  Highlight Matches

Summary

Let's show you how to select quantities for a specific bill component from multiple Lot Numbers on manufacturing process in Sage 200 Evolution.

Description

This article explains how to select quantities for a specific bill component from multiple Lot Numbers on a Bill of Materials manufacturing process.

This may especially be relevant when having insufficient quantities for the specific bill component item in a single Lot Number alone, but at least having sufficient quantities over multiple Lot Numbers.

Resolution

To help explain the solution, consider the following scenario:

1. Setup the Bill Master Item as below. Also notice the Usage Qty column below:

Image

2. The following quantities currently exist for Bill Component CHAIN over 3 different Lot Numbers:

Lot Number

Quantity

CH-LOT01

100

CH-LOT02

100

CH-LOT03

100

3. On a new Manufacturing Process, 250 units of Bill master Item BIKE need to be manufactured and entered that way.

4. That means 250 units of bill component CHAIN is also required.

Image

 5. When done, click the Save- and then the Auto Draw button.

Image

 6. Notice the single line for bill component CHAIN as expected below.

Image

7. Manually add two more Draw Inventory  transaction lines for bill component CHAIN and enter the quantities as can be seen below, to total up to 250 over the 3 lines.

Image

8. On the first Draw line for bill component CHAIN, select Lot NumberCH-LOT01

Image

9. On the second Draw line for bill component CHAIN, select Lot Number CH-LOT02Image

10. On the third Draw line for bill component CHAIN, select Lot Number CH-LOT03

 Image

11. Now manually add the Manufacturing transaction line.

Image

12. When done, process the manufacturing process as usual.