Dynamics Community Forum Thread Details

While select statement in X++

Hi Team

Below code i am writing to achieve my requirement.

Here if custPackingSlipTransView.DlvTerm don't have the data then also loop is going inside the while.

  while select custPackingSlipTransView order by SalesId desc                where custPackingSlipTransView.OrderAccount == salesTable.CustAccount                  && custPackingSlipTransView.DeliveryDate == deliveryDate                  && custPackingSlipTransView.Qty > 0.00                notexists join salesLine where custPackingSlipTransView.InventTransId == salesLine.InventTransIdReturn                exists join dlvTerm where custPackingSlipTransView.DlvTerm == dlvTerm.Code                  && dlvTerm.DlVstatus == NoYes::Yes

If i remove below join from above condition in that case loop is going inside the while, if table data has match with the condition.

  exists join dlvTerm where custPackingSlipTransView.DlvTerm == dlvTerm.Code                  && dlvTerm.DlVstatus == NoYes::Yes

Please let me know how to add above join with while select statement, if custPackingSlipTransView.DlvTerm == dlvTerm.Code have data then only loop should go inside the while else not.

while select custPackingSlipTransView order by SalesId desc where custPackingSlipTransView.OrderAccount == salesTable.CustAccount && custPackingSlipTransView.DeliveryDate == deliveryDate && custPackingSlipTransView.Qty > 0.00 exists join dlvTerm where custPackingSlipTransView.DlvTerm == dlvTerm.Code && dlvTerm.DlVstatus == NoYes::Yes notexists join salesLine where custPackingSlipTransView.InventTransId == salesLine.InventTransIdReturn

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL