• Skip to main content
  • Skip to primary sidebar
  • Home
  • About
  • Recommended Readings
    • 2022 Book Reading
    • 2023 Recommended Readings
    • Book Reading 2024
    • Book Reading 2025
  • Supply Chain Management Guide
  • PKM
  • Microsoft Excel

Ali Raza Zaidi

A practitioner’s musings on Dynamics 365 Finance and Operations

How to get trade agreement price for An Item or for customer Dynamics Ax 2012

February 1, 2015 by alirazazaidi

When we make trade agreement, there are 3 possibilities

  • On some products we make discounted price for all Customers.
  • On some products we make discounted for selected Customers
  • All products have discounted or fixed prices for some customers.

Third case is exceptional, but there is possibility that organization set sales prices on all items for some customers or all customer.

If we dig deep, we find that trade agreements stored in

PRICEDISCTABLE and PriceDiscAdmTrans

 

I am sharing code which just check that particular item exists in trade agreement. These both table have item variant level detail. You can extended the code according to your need. Code is running on Contoso data.

 

PRICEDISCTABLE _PRICEDISCTABLE,priceDiscTable;

PriceDiscAdmTrans  _trans;

ItemId _Item=”C10034″;

ItemId itemRelation=”C0001″;

ItemId _itemWithCustomer =”D0011″;

CustAccount  accountRelation =”US-001″;

Price _price;

PriceType  relation =PriceType::PriceSales;

NoYes _RelationExist=NoYes::No;

// Item scenerio for all customer.

//  _RelationExist= PRICEDISCTABLE::existItemRelation(PriceType::PriceSales,_Item);

 

 

/// First if  trade agreement exist for Item for all customer.

 

 

select firstonly RecId from priceDiscTable

where priceDiscTable.Relation           == relation                 &&

priceDiscTable.ItemCode           == TableGroupAll::Table  &&

priceDiscTable.ItemRelation       == itemRelation

&& priceDiscTable.AccountCode ==  TableGroupAll::All;

 

if (priceDiscTable !=null)

{

 

info (“found”);

}

 

 // trade agreement exist for particular item for particular customer

    select firstonly RecId from priceDiscTable

where priceDiscTable.Relation           == relation                 &&

priceDiscTable.AccountCode        == TableGroupAll::Table   &&

priceDiscTable.AccountRelation    == accountRelation &&

priceDiscTable.ItemCode           == TableGroupAll::Table  &&

priceDiscTable.ItemRelation       == _itemWithCustomer;

if (priceDiscTable !=null)

{

 

info (“found”);

}

 

   // third possibility is that when Customer have to all product with same price of amount.

 

 

 

      select firstonly RecId from priceDiscTable

where priceDiscTable.Relation           == relation                 &&

priceDiscTable.ItemCode           == TableGroupAll::All  &&

priceDiscTable.AccountRelation    == accountRelation &&

priceDiscTable.AccountCode ==  TableGroupAll::Table; //&&

//   priceDiscTable.AccountRelation == accountRelation;

 

 

 

 

if (priceDiscTable !=null)

{

 

info (“found”);

}

 

Hopes this helps

 

 

 

 

 

Filed Under: Dynamics AX 2012, Tips and tricks Tagged With: Dynamics Ax 2012, Trade Agreements Dynamics Ax 2012, X++

Primary Sidebar

About

I am Dynamics AX/365 Finance and Operations consultant with years of implementation experience. I has helped several businesses implement and succeed with Dynamics AX/365 Finance and Operations. The goal of this website is to share insights, tips, and tricks to help end users and IT professionals.

Legal

Content published on this website are opinions, insights, tips, and tricks we have gained from years of Dynamics consulting and may not represent the opinions or views of any current or past employer. Any changes to an ERP system should be thoroughly tested before implementation.

Categories

  • Accounts Payable (2)
  • Advance Warehouse (2)
  • Asset Management (3)
  • Azure Functions (1)
  • Books (6)
  • Certification Guide (3)
  • Customization Tips for D365 for Finance and Operations (62)
  • D365OF (59)
  • Data Management (1)
  • database restore (1)
  • Dynamics 365 (58)
  • Dynamics 365 for finance and operations (135)
  • Dynamics 365 for Operations (165)
  • Dynamics AX (AX 7) (134)
  • Dynamics AX 2012 (274)
  • Dynamics Ax 2012 Forms (13)
  • Dynamics Ax 2012 functional side (16)
  • Dynamics Ax 2012 Reporting SSRS Reports. (31)
  • Dynamics Ax 2012 Technical Side (52)
  • Dynamics Ax 7 (65)
  • Exam MB-330: Microsoft Dynamics 365 Supply Chain Management (7)
  • Excel Addin (1)
  • Favorites (12)
  • Financial Modules (6)
  • Functional (8)
  • Implementations (1)
  • Lifecycle Services (1)
  • Logseq (4)
  • Management Reporter (1)
  • Microsoft Excel (4)
  • MS Dynamics Ax 7 (64)
  • MVP summit (1)
  • MVP summit 2016 (1)
  • New Dynamics Ax (19)
  • Non Defined (9)
  • Note taking Apps (2)
  • Obsidian (3)
  • Personal Knowledge Management (2)
  • PKM (13)
  • Power Platform (6)
  • Procurement (5)
  • procurement and sourcing (5)
  • Product Information Management (4)
  • Product Management (6)
  • Production Control D365 for Finance and Operations (10)
  • Sale Order Process (10)
  • Sale Order Processing (9)
  • Sales and Distribution (5)
  • Soft Skill (1)
  • Supply Chain Management D365 F&O (3)
  • Tips and tricks (278)
  • Uncategorized (165)
  • Upgrade (1)
  • Web Cast (7)
  • White papers (4)
  • X++ (7)

Copyright © 2025 · Magazine Pro On Genesis Framework · WordPress · Log in