Recover the value of a field named "NULL"

Hi @TheoB 

This ‘colnProjectedQty’ column value is not fetched from the database. that's why it shows NULL for ‘SQL Column’ in system info. this Projected value is calculated from client application

As a example

colnProjectedQty.Number = frmAvailabilityPlanning.FromHandle(this.i_hWndParent).dfQtyOnHand.Number + colnSupplyQty.Number - colnDemandQty.Number;

Hope this may helpful

Thanks & Regards
Shan

Hi @TheoB 

Projected field shows the “Usable quantity projected for the date of the line. Based on the usable qty.”

At the header level of "Inventory Part Availability Planning" screen you can see “Usable Qty”
For that field system info is available. Hence you should be able to retrieve the value of the "Projected"

Best Regards,
Tharaka.

Thank you for your answers.
It was very helpful!