Showing posts with label Getting MRP from inventTableModule based on item usng display method in Ax7. Show all posts
Showing posts with label Getting MRP from inventTableModule based on item usng display method in Ax7. Show all posts

Monday, 16 April 2018

Getting MRP from inventTableModule based on item usng display method in Ax7

/// <summary>
    ///
    /// </summary>
    display  MaximumRetailPrice_IN  Item_MRP()
    {
        InventTable                       inventTable;
        InventTableModule           inventTableModule;

        select inventTable
                 where inventTable.ItemId == this.ItemId
                     join inventTableModule
                        where inventTableModule.ItemId == inventTable.ItemId
                       && inventTableModule.ModuleType == ModuleInventPurchSales::Sales;

        return  inventTableModule.MaximumRetailPrice_IN;
    }