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

Constant values for Planned & Released

(0) Share

Report

Posted on by L.Stork

I'm using an external SQL tool to look at the data under the Prod_ Order Line & Purchase Line tables. Would anyone happen to know which status constants = Planned and Released

I'm seeing statuses of 2, 3 and 4

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

JAngle 123 on at

Like (0)

Report

RE: Constant values for Planned & Released

Based on all the option field choices I’d try this:

1 = simulated

2 = planned

3 = firm planned

4 = released

5 = finished

Very likely that it could be 0 as the first one. Do you not see different “No.” values? It does have fields for the other stages which is an added clue

Was this reply helpful? Yes No
L.Stork 5 on at

Like (0)

Report

RE: Constant values for Planned & Released

Thanks Josh, The values are either null or 2,3,4. As it likely the first value is a 0, I'm thinking I should be good going with 2 & 3.

I'm trying to replicate the calculation for Qty on Prod Order= (Sum("prod. order line"."Remaining Qty. (Base)" where (status=FILTER(Planned,Released))

I'll just have her validate the calculation after I'm done. If it's correct, I'll update here.

Was this reply helpful? Yes No