Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Saturday, January 24, 2015

Relation between InventTable & InventDim table in AX 2012

Hi,

static void AlfasithInventDimInventTableRelation(Args _args)
{
    InventTable             InventTable;
    InventDim               InventDim;
    InventDimCombination    InventDimCombination;
    PriceDiscTable          PriceDiscTable;

    while select InventDimId from InventDim where InventDim.InventColorId == " "
                       &&   InventDim.InventStyleId == " "
                       &&   InventDim.configId == " "
                       &&   InventDim.InventSizeId == " "
        {
            select InventDimCombination where InventDimCombination.InventDimId == InventDim.inventDimId
                                        && InventDimCombination.ItemId == "1035";
            if(InventDimCombination)
            {
                print InventDimCombination.ItemId;
                print InventDimCombination.InventDimId;
            }
        }
Pause;
}

Regards,

No comments:

Post a Comment

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...