Small and medium business | Business Central, N...

Getting FG count relevant to raw materials

(7) Share

Report

Posted on by Niki

439

Hi Experts,

I am using D365 Business Central manufacturing module for my battery manufacturing company. I receive raw materials once a month. So, I need to identify that how much finished good quantity i have produced using a raw material relevant to a purchase receipt. How can I identity that using dynamic 365 BC.

Example:

Let say I received raw material items for this month ( October) as follows:

* RM 1------------50 Quantity

* RM 2------------20 Quantity

* RM 3 -----------10 Quantity

* RM 4------------60 Quantity

* RM 5------------26 Quantity

If I manufacture finished good using above raw materials, I need to identify how many FG quantity could produce using above raw materials. I will be use above raw materials for one or more FG items. Further, To produce some production order , I will have to use two purchase receipt relevant to two months.

Basically I need to get , using RM 1 ,How many FG items I could produced?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

KasparsSemjonovs 4,817 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

You BOM contains information, of how much raw materials are needed for each finished good.

I don't think there is any direct report that will show, that from all raw materials purchased in october, You have produced, for example, 50 finished products. You can have 2 different report, to show all that You bought in October, and other that shows all that You produced in October, but the links You will need to do yourself.

Was this reply helpful? Yes No
Suggested answer

Dharmesh 344 on at

Like (2)

Report
Copy link

Link copied!
From the BOM (Bill of Material) you already know expected quantity per FG

Example:

1 FG requires:

RM1 = 5 kg

RM2 = 2 kg

RM3 = 1 unit

RM4 = 3 kg

RM5 = 0.5 kg

But you want actual production-to-material usage, not BOM theory.

Follow these steps:

> Go to Item Ledger Entries, apply a Posting Date filter as required, set Entry Type = Output and Consumption, and apply a third filter for Source No. (Finished Good Item).

>Then switch to Analyze mode, add Entry Type in Row Groups, and select SUM(Quantity) or any other fields you need.

For each Production Order:

You can check:

Consumed Quantity of each RM

Produced Quantity of FG

Then calculate manually:

>FG produced per unit of Raw Material = Output / Consumption

>>Purchase Receipt tracking:

If RM consumption comes from different purchase receipts:

✔ BC tracks using FIFO/LIFO/Specific/Standard costing

✔ Item ledger entries show Applied-to Entry linking consumption to specific purchase receipts

You can see:

Which purchase receipt was used

What quantity applied

Which production order used it

Which FG it produced

>>Where to see applied entries?

Go to Item Ledger Entries

Open the Consumption entry

Click Applied Entries (or “Navigate → Applied Entries”)

You will see:

Purchase Receipt Entry No.

Quantity applied

Posting date

Cost applied

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,732 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

To identify how much finished goods (FG) were produced using specific raw materials in D365 Business Central's manufacturing module, you should enable item tracking (lot numbers) for raw materials at the time of purchase receipt.

This allows you to trace which lots were consumed in which production orders, and link them to the FG output.

By analyzing Item Ledger Entries, Production Order Lines, and Consumption Entries, you can determine how much of each FG item was produced using a particular raw material (e.g., RM 1).

For a consolidated view, you can build a custom report or Power BI dashboard that connects purchase receipts, consumption, and FG output.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,918 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

There are two options based on your inventory levels. I think these are newer options, so you'll want to test both to see if they match your requirement.

Item Availability by BOM Level - Run for a single Item (Manufacturing or Assembly) to show which Raw Materials will cause bottlenecks in your production process. Does NOT calculate Total Quantity you can produce, but it does show if any materials are short or will run short.

Item - Able to Make (Timeline) - Excel calculation that can be run for more than one Item. Attempts to calculate what you can make based on current inventory.

It is important to note this is a very difficult, backward calculation. It assumes you are only making the one Item, and doesn't take other Finished Good production into account. If the Raw Materials received are used on other Finished Goods you may not be able to make as much of the Finished Good based on other demands for those raw materials.

The more standard process is to determine what you are going to make, then use Planning to calculate how much of each Raw Material you will need to procure to make those Finished Goods. This may not be feasible in your company/industry, but this is more traditional manufacturing.

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,766 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Use Item Ledger Entries with Production Order Components or the Item Tracing feature to see which raw materials (by receipt) were consumed in producing finished goods. Reports like BOM – Raw Materials or Production WIP can also show this link.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,152 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

The Item Availability by Bom Level page will do exactly that, I talk about it briefly here - 4 Ways to View How Much Inventory You Have in Dynamics 365 Business Central - Dynamics 365 Business Central Insights

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following helps as well.

https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-how-availability-overview?wt.mc_id=DX-MVP-5004336

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,219 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Business Central does not provide a standard report that directly links finished goods back to specific purchase receipts.

If raw materials and finished goods use lot tracking, you can trace lots through production orders to see which finished goods came from which receipt.

You can build a query or custom report that gives traceability from raw material receipt to finished goods produced.

Thanks

Rishabh

Was this reply helpful? Yes No