Share
ReportHello,
I need to extract the Reserved Physical Qty in an extension to use in a report.
I'm new to D365FO / X++ and still learning.
I keep getting 0 for a result on all my lines, this is my code can someone please help?
SalesLine salesLineLocal = SalesLine::findRecId(_line.RecId);
InventTrans inventTransLocal;
InventTransOrigin inventTransOriginLocal;
Qty totalReserved = 0;
InventTrans inventTransLocal;
InventTransOrigin inventTransOriginLocal;
Qty totalReserved = 0;
select sum(Qty) from inventTransLocal
join inventTransOriginLocal
where inventTransOriginLocal.RecId == inventTransLocal.InventTransOrigin
&& inventTransOriginLocal.ReferenceId == salesLineLocal.SalesId
&& inventTransOriginLocal.ItemId == salesLineLocal.ItemId
&& inventTransLocal.StatusIssue == StatusIssue::ReservPhysical;
join inventTransOriginLocal
where inventTransOriginLocal.RecId == inventTransLocal.InventTransOrigin
&& inventTransOriginLocal.ReferenceId == salesLineLocal.SalesId
&& inventTransOriginLocal.ItemId == salesLineLocal.ItemId
&& inventTransLocal.StatusIssue == StatusIssue::ReservPhysical;
totalReserved = abs(inventTransLocal.Qty);
_addingRecord.addCalculatedField('TFReservedPhysicalQty', totalReserved);
Thanks,
Pierre
Categories:
I have the same question (0)
All responses (
Answers (
239,116
