Question

Recover the value of a field named "NULL"

  • 28 December 2021
  • 3 replies
  • 99 views
T
Rank
Userlevel 5
Badge +11

Hello to all,
In the "Inventory Part Availability Planning" screen, I want to retrieve the value of the "Projected" field:


Only, when I go to the "System info" tab, it does not show me the name of the column but "NULL": 


Is it possible to retrieve the value of this field?
Thank you for your help! 

This topic has been closed for comments

3 replies

S
Rank
Userlevel 5
Badge +9

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

Dilan Senevirathne
Rank
Userlevel 5
Badge +13

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.

T
Rank
Userlevel 5
Badge +11

Thank you for your answers.
It was very helpful!

Terms & ConditionsCookie settings