Tuesday, February 28, 2012

InventAllBlank to default price

static void InventAllBlank(Args _args)
{
InventDimId InventDimId;
InventItemInventSetup InventItemInventSetup;
InventItemSalesSetup InventItemSalesSetup;
InventItemPurchSetup InventItemPurchSetup;
inventtable inventtable;


;

while select * from inventtable where inventTable.ItemId
{
//invent
select forupdate * from InventItemInventSetup where InventItemInventSetup.ItemId == inventtable.ItemId
&& InventItemInventSetup.InventDimId == "AllBlank"
&& InventItemInventSetup.InventDimIdDefault == "AllBlank";
if(!InventItemInventSetup.ItemId)
{
ttsbegin;
InventItemInventSetup.ItemId = inventtable.ItemId;
InventItemInventSetup.InventDimId = "AllBlank";
InventItemInventSetup.InventDimIdDefault = "AllBlank";
InventItemInventSetup.insert();
ttscommit;
}

// sales
select forupdate * from InventItemSalesSetup where InventItemSalesSetup.ItemId == inventtable.ItemId
&& InventItemSalesSetup.InventDimId == "AllBlank"
&& InventItemSalesSetup.InventDimIdDefault == "AllBlank";
if(!InventItemSalesSetup.ItemId)
{
ttsbegin;
InventItemSalesSetup.ItemId = inventtable.ItemId;
InventItemSalesSetup.InventDimId = "AllBlank";
InventItemSalesSetup.InventDimIdDefault = "AllBlank";
InventItemSalesSetup.insert();
ttscommit;
}
//purchase
select forupdate * from InventItemPurchSetup where InventItemPurchSetup.ItemId == inventtable.ItemId
&& InventItemPurchSetup.InventDimId == "AllBlank"
&& InventItemPurchSetup.InventDimIdDefault == "AllBlank";
if(!InventItemPurchSetup.ItemId)
{
ttsbegin;
InventItemPurchSetup.ItemId = inventtable.ItemId;
InventItemPurchSetup.InventDimId = "AllBlank";
InventItemPurchSetup.InventDimIdDefault = "AllBlank";
InventItemPurchSetup.insert();
ttscommit;
}

}

}

No comments:

How to identify the user that was used to change an object from AOT in AX2012

Get the object name for which we need to track these (user and date&time) information's. Login to SQL Server Management Studio an...