priceAgr = PriceDisc::findItemPriceAgreement( ModuleInventPurchSales::Sales, retailInformationSubcodeTable.triggerCode, InventDim::find(InventDim::inventDimIdBlank()), inventTableModule.UnitId, SystemDateGet(), 1, salesTable.CustAccount, salesTable.CurrencyCode, CustTable::find(salesTable.CustAccount).PriceGroup // salesTable.PriceGroupId ); price = conPeek(priceAgr, 1); /* Price group can be 1. salesTable.PriceGroupId 2. CustTable.PriceGroup 3. from PriceDiscGroup table: salesTableExtended = salesTable.krfSalesTableExtended(); if (salesTableExtended.RetailChannelTable) { while select RecId from retailChannelPriceGroup where retailChannelPriceGroup.RetailChannel == salesTableExtended.RetailChannelTable join GroupId from priceDiscGroup where priceDiscGroup.RecId == retailChannelPriceGroup.PriceGroup { priceGroup += priceDiscGroup.GroupId; } } */ // Retail price retailSalesTable = salesTable.retailSalesTable(); retailStoreId = retailSalesTable.RetailStoreId; if (!retailStoreId) { select firstOnly StoreNumber from retailStoreTable where retailStoreTable.inventLocation == salesTable.InventLocationId &&retailStoreTable.ChannelType == RetailChannelType::RetailStore; retailStoreId = retailStoreTable.StoreNumber; } if (retailStoreId) { price = RetailPricingEngine::getRetailPriceByItem(retailStoreId, retailInformationSubcodeTable.triggerCode, inventTableModule.UnitId, InventDim::inventDimIdBlank(), DateTimeUtil::newDateTime(((salesTable.VKDiscountDate) ? salesTable.VKDiscountDate : SystemDateGet()), timeNow()), ''); } // Simple varian, it requires SalesTable context. Does not create SalesLine but just using it to get all price related information salesLine.clear(); salesLine.SalesId = salesTable.SalesId; salesLine.ItemId = 'ItemId'; salesLine.SalesQty = 1; salesLine.initFromInventTable(salesLine.inventTable());
If you found value in what I share, I've set up a Buy Me a Coffee page as a way to show your support.
Buy Me a CoffeeNo comments. Be the first one to comment on this post.
DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics 365 FO.
Authors are allowed to set their own "buy me a coffee" link.
Join us.