WIP Inventry tracking Issue

[Former Member]

Dear All,

In my scenario am using one raw material for producing one finished goods.

In B1 we can track the inventry for raw material and finished goods

but how can i track the inventry details for Work in progress items.

now i can able to track only value of WIP using WIP account

but i want to track the wip inventry level.

in my case am using 1 raw material for 1 finished good

Regards,

Guru

[Former Member]

Hi,

You can probably use query to get your report. All WIP material has unique order status to distinguish from others.

Let me know what columns do you like in your report.

Thanks,

Gordon

[Former Member]

Thanks Gordon

I want to Know what ever items are in WIP Stage

For Ex,

To produce one 10-15 mm Bolt i need 10 mg of

Raw Material-CCOPPER7648

I created a BOM for this above Bolt which includes the Raw Material-CCOPPER7648

when am creating production order and issue for production for this product Bolt

from my raw material 10 mg was reduced

i want to show the inventry for this 10mg of material are in WIP Stage

How it is possible

[Former Member]

I have some sample codes just created for specific requirement. You can check to see if anything useful for your need:

SELECT Distinct T0.ItemCode, T2.ItemName, SUM(T0.PlannedQty) as 'Planned Qty', T2.OnHand

From WOR1 T0

Inner Join OWOR T1 ON T0.DocEntry = T1.DocNum

Inner Join OITM T2 ON T2.ItemCode = T0.ItemCode

Where DATEDIFF(DD, GETDATE(), T1.DueDate) > 0 and T1.Status > 'L'

The bold part may not be suitable to you. You can take it out as you need. That will exclude any past due orders.

Thanks,

Gordon

[Former Member]

Thanks Gordon

But when am executing the query it shows an error

Column 'T0.ItemCode' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.

Column 'T2.ItemName' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.

Column 'T2.OnHand' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.

[Former Member]

Sorry, you need to add this in the end:

Group By T0.ItemCode, T2.ItemName, T2.OnHand

[Former Member]

can we have value of material affect in G/L

Rupesh

[Former Member]

Please post your question on a new thread.

Thanks,

Gordon