Dear All,

I am new to sql in LN ERP.

How could get the "calculation" field from easy sql?
For my case, I am try to get the "Expected Inventory" (ID: stoc.balance) under session whinp1500m000.

Cheers

If you are using easy sql then you need to write a query to do the calculation that is in that session. You can't use easy sql to pull a field from a session - typically those fields are calculated in the code of the session.

Hi Thanks.

By the way how could get the formula of calculated field?

You would have to own source code - then edit the code and find where the field is calculated. Then you can see how it is calculated - might not be so easy in easy sql.