get Invent Site (InventSiteId ) from WareHouse and Item by Code X++

(0) Share

Report

Posted on by Community Member

Hi all ! I want get auto InventSiteId for WareHouse ! On Grid , when I select WareHouse then auto get Invent Site of Item. ( I set Default Order settings InventSite and Warehouse for item). Help me by code or solutions. Thanks all !

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report
Copy link

Link copied!

Hi Nguyen,

static void _GetInventoryDimensions(Args _args)

{

InventTable inventTable = inventTable::find('Dxxxx);

InventItemOrderSetupType setupType = InventItemOrderSetupType::Invent;

InventDim inventDim;

;

// Default Site

inventDim.InventSiteId = inventTable.inventItemOrderSetupMap(setupType).inventSiteId(inventDim.InventSiteId, inventTable);

// Default Location

inventDim.InventLocationId = inventTable.inventItemOrderSetupMap(setupType,

InventDim::findOrCreate(inventDim).InventDimId)

.inventLocationId(inventDim.InventLocationId,

inventTable,

inventDim.InventSiteId);

// Default ConfigId

inventDim.ConfigId = inventTable.StandardConfigId;

// Find Default Item Dimension

inventDim = InventDim::findOrCreate(inventDim);

info(strFmt('Invent Dim. Id: %1', inventDim.inventDimId));

info(strFmt('Site Id: %1', inventDim.InventSiteId));

info(strFmt('Warehouse Id: %1', inventDim.InventLocationId));

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Kavitha Rajan ! but I need find InventSiteId with parameter is InventLocationId. I need auto display InventSiteId on Grid when I select InventLocationId on a record ! help me a method !

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!
Try this:

InventSiteId inventSiteId = InventLocation::find('myInventLocationId').InventSite().inventSiteId;

Was this reply helpful? Yes No
Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report
Copy link

Link copied!

Hi Nguyen,

if (inventDim.InventSiteId)

{

inventLocationId = inventTable.inventItemOrderSetupMap(InventItemOrderSetupType::Sales,

InventDim::findOrCreate(inventDim).InventDimId).inventLocationId(inventDim.InventLocationId,

inventTable,

inventSiteID);

print inventLocationId;

pause;

}

Was this reply helpful? Yes No