Production Report

[Former Member]

Hi,

I need a query/report what are all the

child items can be issued for Particular Main FG

Ex :

BOM Structure :

FG

SemiFG 1

RawMaterial 1

RawMaterial 2

RawMaterial 3

SemiFG 2

RawMaterial 3

RawMaterial 4

RawMaterial 5

SemiFG 3

RawMaterial 6

RawMaterial 7

RawMaterial 8

RawMaterial 9

I need i select a FG it shown what are the

issue can be done for RawMaterial only.

the selection of FG based on Production order

date.

Regards

Jambulingam.P

[Former Member]

Hi,

When i select a FG i need

Item Code, Issue Quantity and Issue for Productin Date

(Data shown based on Issue for production)

Regards

Jambulingam.P

[marcella_rivi]

Dear Jumbulingam,

I am not sure about the question. Do you want a query that will tell you which are the child items of a parent items? do you want to know how much quantity you have in stock? Is it this a BOM tree?

Below there is a query that I wrote to find the stock quantity for the child items of the parent fg.

If this query is not enough, let me know what exactly you need and we can modify the query to fit your needs.

SELECT T1.ItemCode, T0.ItemCode, T2.OnHand, T2.IsCommited, T2.OnOrder FROM WOR1 T0 INNER JOIN OWOR T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T0.ItemCode = T2.ItemCode WHERE T1.ItemCode = T2.ItemCode and T0.ItemCode = 'fg'

Kind Regards,

Marcella Rivi

SAP Business One Forums Team