On-hand quantity for SalesLine

(1) Share

Report

Posted on by faiz7049

1,883

Hi Experts,

I am trying to get inventory sum on SalesTable Form by site , warehouse and inventory dimension.

I have created display method

[ExtensionOf(tableStr(SalesLine))]

final public class SFA_SalesLine_Extension
{
    [SysClientCacheDataMethod(true)]

    display Qty SFA_Physical()
    {
        InventDim            inventDim;
        InventDimParm       inventDimParm;

        inventDim.InventSiteId          =   this.salesTable().InventSiteId;
        inventDim.InventLocationId      =   this.salesTable().InventLocationId;
       inventDim.inventDimId            =  this.InventDimId;
       inventDim                        =   InventDim::findOrCreate(inventDim);
        inventDimParm.initFromInventDim(InventDim::find(inventDim.inventDimId));
       
        
        return InventSum::findSum(this.ItemId,inventDim,inventDimParm).AvailPhysical;
    
    }

}

But Inventory sum is not checking inventory dimension from SalesLine.

It is summing all quantities ignoring item dimension from SalesLine . Our Item/Product is Product Master type means it have Size, color, Style etc.

Please help me.

Thanks,

Faiz

All responses (2)

Answers (1)

faiz7049 1,883 on at

Like (1)

Report

On-hand quantity for SalesLine

Hi Martin,

Thank you so much.
Verified answer

Martin Dráb 230,370 Most Valuable Professional on at

Like (1)

Report

Display method on SalesLine

I see that your code uses the default site and warehouse on sales order header and it ignores the actual site and warehouse used by the particular sales line. That's wrong. If you want all dimensions, get the InventDim buffer simply by this.inventDim(). If you want just some dimensions, copy values from there, not from SalesTable.