Pages

Thursday, 21 August 2014

Ax 2009 Creating a Jobs for inserting Records in InventTable

  Sometimes we need to add new items into the system Table InventTable then we need X++ code to simplify the proccess for example we have  this items  :


static void creatingInventTableRecords(Args _args)
{
    InventTable inventTable;
    InventTableModule inventTableModule;
    InventItemLocation inventItemLocation;
    NumberSeq numberSeq;
    ;
    ttsbegin;
    numberSeq =    numberSeq::newGetNum(NumberSeqReference::findReference(typeid2extendedtypeid(typeid(ItemId))));
   //Insert the records in InventTable
    inventTable.ItemId = numberSeq.num();
    inventTable.ItemName = "HP";
    inventTable.ItemGroupId = "Television";
    inventTable.ModelGroupId = "FRP_PICK";
    inventTable.DimGroupId = "CF-W";
    inventTable.ItemType = ItemType::Item;
    inventTable.ItemIdCompany = "";
    inventTable.insert();
   //Insert the records in InventItemLocation
    inventItemLocation.ItemId = inventTable.ItemId;
    inventItemLocation.InventDimId = InventDim::inventDimIdBlank();
    inventItemLocation.insert();
   //Insert the records in InventTableModule for Inventory
    inventTableModule.ItemId = inventTable.ItemId;
    inventTableModule.Price = 1.00;
    inventTableModule.UnitId= "Pcs";
    inventTableModule.ModuleType = ModuleInventPurchSales::Invent;
    inventTableModule.insert();
   //Insert the records in InventTable for purchaseOrder
    inventTableModule.ItemId = inventTable.ItemId;
    inventTableModule.Price = 1.00;
    inventTableModule.UnitId= "Pcs";
    inventTableModule.ModuleType = ModuleInventPurchSales::Purch;
    inventTableModule.insert();
   //Insert the records in InventTable for sales
    inventTableModule.ItemId = inventTable.ItemId;
    inventTableModule.Price = 1.00;
    inventTableModule.UnitId= "Pcs";
    inventTableModule.OverDeliveryPct= 0;
    inventTableModule.UnderDeliveryPct= 100;
    inventTableModule.ModuleType = ModuleInventPurchSales::Sales;
    inventTableModule.insert();
    ttscommit;

}

No comments:

Post a Comment