Skip to content

Instantly share code, notes, and snippets.

@davidalencar
Created January 10, 2018 11:20
Show Gist options
  • Save davidalencar/49f25042bd766b5a42e36ec74d792fa0 to your computer and use it in GitHub Desktop.
Save davidalencar/49f25042bd766b5a42e36ec74d792fa0 to your computer and use it in GitHub Desktop.
Create InventItemPurchSetup, InventItemSalesSetup and InventItemInventSetup for all itens.
static void updInventSetup(Args _args)
{
InventTable item;
InventDim dimSite, dimLocation;
InventSite site;
InventItemPurchSetup purchSetup;
InventItemSalesSetup salesSetup;
InventItemInventSetup inventSetup;
try
{
ttsBegin;
delete_from purchSetup;
delete_from salesSetup;
delete_from inventSetup;
while select item
{
purchSetup.clear();
purchSetup.ItemId = item.ItemId;
purchSetup.InventDimId = InventDim::inventDimIdBlank();
purchSetup.InventDimIdDefault = InventDim::inventDimIdBlank();
purchSetup.insert();
salesSetup.clear();
salesSetup.ItemId = item.ItemId;
salesSetup.InventDimId = InventDim::inventDimIdBlank();
salesSetup.InventDimIdDefault = InventDim::inventDimIdBlank();
salesSetup.insert();
inventSetup.clear();
inventSetup.ItemId = item.ItemId;
inventSetup.InventDimId = InventDim::inventDimIdBlank();
inventSetup.InventDimIdDefault = InventDim::inventDimIdBlank();
inventSetup.insert();
while select site
{
dimSite.clear();
dimSite.InventSiteId = site.SiteId;
dimSite = InventDim::findOrCreate(dimSite);
dimLocation.clear();
dimLocation.InventLocationId = site.SiteId;
dimLocation = InventDim::findOrCreate(dimLocation);
purchSetup.clear();
purchSetup.ItemId = item.ItemId;
purchSetup.InventDimIdDefault = dimLocation.inventDimId;
purchSetup.InventDimId = dimSite.inventDimId;
purchSetup.insert();
salesSetup.clear();
salesSetup.ItemId = item.ItemId;
salesSetup.InventDimIdDefault = dimLocation.inventDimId;
salesSetup.InventDimId = dimSite.inventDimId;
salesSetup.insert();
inventSetup.clear();
inventSetup.ItemId = item.ItemId;
inventSetup.InventDimIdDefault = dimLocation.inventDimId;
inventSetup.InventDimId = dimSite.inventDimId;
inventSetup.insert();
}
}
ttsCommit;
}
catch
{
ttsAbort;
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment