I was just creating a view when I ran into a problem.
I want to give the condition "not equal(!=)" to the condition of the relation,
but I can't put it in the view of D365.
If you know how to put 'not equal' conditions on the relation , please leave a comment
================================================================================================================================================
//detail 4
while select SumOth
where SumOth.ItemId == this.ItemId
join DimOth
where DimOth.inventDimId == SumOth.InventDimId
&& DimOth.InventSiteId == this.InventSiteId
join LocaOth
where LocaOth.InventLocationId == DimOth.InventLocationId
&& LocaOth.TYM_PartsSalesBranchOffice == NoYes::Yes
join CusOth
Where LocaOth.TYM_BranchOffice != CusOth.SegmentId
&& CusOth.AccountNum == this.CustAccount
{
// ResultSumFac += SumFac.availPhysicalCalculated();
ResultSumOth += SumOth.AvailPhysical;
}
this.OtherStock = ResultSumOth;
================================================================================================================================================
It's a supplementary explanation.
The 'not equal(!=)' condition I mentioned is the
'LocaOth' in the 'while' statement above "TYM_BranchOffice != CusOth.SegmentId" part.
I want to save the value of the above while statement in the view.
And I got stuck in the relaxation part while working.
I am currently using dynamic365(Finance&operations) as the visual studio 2017 version .
I'm sorry if I didn't understand your answer correctly. thank you
