Thanks for the reply. I have written this job by using these tables.
------------------------------------------------------------------------
static void WarehouseUpdation(Args _args)
{
InventTable inventTable;
InventDim inventDim;
InventItemPurchSetup inventItemPurchSetup;
InventItemSalesSetup inventItemSalesSetup;
InventItemInventSetup inventItemInventSetup;
int noOfRecords;
;
inventDim.InventLocationId = "020305";
inventDim = InventDim::findOrCreate(inventDim);
while select inventTable
where inventTable.ItemId like "YS3*"
{
ttsbegin;
select forupdate inventItemPurchSetup
where inventItemPurchSetup.ItemId == inventTable.ItemId;
{
inventItemPurchSetup.InventDimIdDefault = inventDim.inventDimId;
inventItemPurchSetup.doUpdate();
}
select forupdate inventItemSalesSetup
where inventItemSalesSetup.ItemId == inventTable.ItemId;
{
inventItemSalesSetup.InventDimIdDefault = inventDim.inventDimId;
inventItemSalesSetup.doUpdate();
}
select forupdate inventItemInventSetup
where inventItemInventSetup.ItemId == inventTable.ItemId;
{
inventItemInventSetup.InventDimIdDefault = inventDim.inventDimId;
inventItemInventSetup.doupdate();
}
ttscommit;
noOfRecords++;
}
info(strFmt("No of Records updated is : %1",noOfRecords));
}
