[ExtensionOf(classstr(InventOnHandQty))]
final class ABCInventOnHandQty_Extension
{
//InventOnHandCompositeCriteria advancedCriteria;
public InventQtyAvailOrdered availOrdered(boolean _inclAvailPhysical)
{
next availOrdered();
if (itemUsesWHS)
{
this.setInventSum();
this.setAvailability();
return _inclAvailPhysical ? inventSum.AvailOrdered : inventSum.AvailOrdered - inventSum.AvailPhysical;
}
else
{
Qty Qty;
;
Qty = (_inclAvailPhysical ? this.availPhysical() : 0) + this.ordered() + this.arrived() - this.reservOrdered();
return (_inclAvailPhysical ? this.availPhysical() : 0) + this.ordered() + this.arrived() - this.reservOrdered();
}
}
public InventSumDelta findSumDeltaWithAdvancedCriteria()
{
next findSumDeltaWithAdvancedCriteria();
Query onHandQuery;
QueryRun onHandQueryRun;
InventDim dimCriteriaLocal;
InventDimParm dimParmCriteriaLocal;
if (inventDimId)
{
dimCriteriaLocal = InventDim::find(inventDimId);
dimParmCriteriaLocal = dimCriteriaLocal.toDimParm();
}
else
{
dimCriteriaLocal = inventDimCriteria;
dimParmCriteriaLocal = inventDimParm;
}
onHandQueryRun = new QueryRun(onHandQuery);
onHandQueryRun.next();
return onHandQueryRun.get(tableNum(InventSumDelta));
}
public InventSum findSumWithAdvancedCriteria()
{
next findSumWithAdvancedCriteria();
//Query onHandQuery;
QueryRun onHandQueryRun;
InventDim dimCriteriaLocal;
InventDimParm dimParmCriteriaLocal;
if (inventDimId)
{
dimCriteriaLocal = InventDim::find(inventDimId);
dimParmCriteriaLocal = dimCriteriaLocal.toDimParm();
}
else
{
dimCriteriaLocal = inventDimCriteria;
dimParmCriteriaLocal = inventDimParm;
}
//[dimCriteriaLocal, dimParmCriteriaLocal] = this.getDimCriteriaForAdvancedQuery();
Query onHandQuery = InventSum::newQuery(null, itemId, dimCriteriaLocal, dimParmCriteriaLocal, null);
onHandQueryRun = new QueryRun(onHandQuery);
onHandQueryRun.next();
return onHandQueryRun.get(tableNum(inventSum));
}
}