How to get Stock Qty for components of a production order item?

(0) Share

Report

Posted on by Community Member

Using: NAV 2009 R2

I've developed a custom Windows application program that queries the SQL database to find the components of a production order Item.

This is my question:

For Production Order articles - how to retrieve the stock quantities of the individual components from the database? Which tables/fields do I need to query to get the result?

*This post is locked for comments

All responses (5)

Answers (1)

Verified answer

Tharanga Chandrasekara 23,116 on at

Like (0)

Report

RE: How to get Stock Qty for components of a production order item?

You need to open the particular window using development environment from server. Then check the source table and source expression to check which table aand the field generate the value.
Community Member on at

Like (0)

Report

RE: How to get Stock Qty for components of a production order item?

Hi,

The client does not have the "Developer Edition" of NAV installed. This is a production system. Is there any other way to get this information?

Thank you in advance for any answers.
Suggested answer

ksundeep87 800 on at

Like (0)

Report

RE: How to get Stock Qty for components of a production order item?

Hi,

Go to the form design and see the Property : Source Table for Table details.

for field go to form design click on the specific control and check property : SourceExpr.
Community Member on at

Like (0)

Report

RE: How to get Stock Qty for components of a production order item?

The image once more for clarity:

What we need is the values for the column (Stock Qty for each component) surrounded with the RED rectangle:
Community Member on at

Like (0)

Report

RE: How to get Stock Qty for components of a production order item?

...