InventSum - blank InventDimID x++

(3) Share

Report

Posted on by SachinMittal

152

i need to caclaute some value basis on dimensions from inventsum but all values are blank why is this happening,

 [SysClientCacheDataMethodAttribute(true)]
 public display Real MinimumStock()
 {
     ReqItemTable    reqItemTable;
     InventDim       inventDimReq,inventDimOnHand;
     InventSum   inventsum;
     str I = this.InventSiteId;
     str G =  this.InventLocationId;
     select * from reqItemTable where reqItemTable.ItemId == this.ItemId
         join inventDimOnHand where reqItemTable.CovInventDimId == inventDimOnHand.inventDimId
         && inventDimOnHand.InventSiteId == this.InventSiteId
         &&  inventDimOnHand.InventLocationId == this.InventLocationId;
     return reqItemTable.MinInventOnhand;
 }

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (1)

Answers (0)

Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report
If you mean why inventSum is empty, it's because you've never put any value to it. It seems you intended using it in the query but you haven't done it yet.

Your current code can be simplified to this:

[SysClientCacheDataMethodAttribute(true)] public display real minimumStock() { ReqItemTable reqItemTable; InventDim inventDimOnHand; select reqItemTable where reqItemTable.ItemId == this.ItemId join inventDimOnHand where inventDimOnHand.InventDimId == reqItemTable.CovInventDimId && inventDimOnHand.InventSiteId == this.InventSiteId && inventDimOnHand.InventLocationId == this.InventLocationId; return reqItemTable.MinInventOnhand; }

Was this reply helpful? Yes No