BeyondERP.Newsletter
Menu

Setup page · Retail and Commerce

Trade agreement journals

A journal page where you create, validate and post trade agreements for sales prices and discounts.

Business process
Set product prices
Menu item
PriceDiscAdmTable_Sales
Main table
PriceDiscAdmTable
Data entity
TradeAgreementJournalHeaderEntity
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA journal page where you create, validate and post trade agreements for sales prices and discounts.
What you do hereUse this journal to register new or changed prices and discounts and post them so that they take effect.
ExampleFor example, you can prepare price changes in a journal now and post them later, after the journal is approved.
Trade agreement journals page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processIntroduce products › Set product prices
Menu pathRetail and Commerce › Pricing and discounts › Trade agreements › Trade agreement journals
Set up firstTrade agreement journal names Microsoft Learn Customer price/discount groups Microsoft Learn Activate price/discount Microsoft Learn
Used next byFind prices Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Steps from Microsoft

  1. Go to Retail and Commerce > Pricing and discounts > Trade agreements > Trade agreement journals.
  2. Select New, and in the Name field select a journal name.
  3. On the Action Pane, select Lines.
  4. In the Party code type field, select Table, Group or All, and then select the account in the Account selection field.
  5. In the Product code type field, select Table, and then select the item in the Item relation field.
  6. In the From and To fields, enter the quantity range.
  7. In the Amount in currency field, enter the price.
  8. In the From date field, enter the date the agreement starts.
  9. Select Save, then Validate > Validate selected lines.
  10. Select Post, and then select OK.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Party code typeSets who the line applies to: one customer (Table), a customer group (Group) or all customers (All).Microsoft Learn
Product code typeSets which products the line applies to; sales prices must use Table.Microsoft Learn
ToThe maximum quantity above which the agreement's price no longer applies.Microsoft Learn
Amount in currencyThe agreed price.Microsoft Learn
From dateThe date from which the agreement is valid.Microsoft Learn

Test checklist

  1. Create a journal with a name whose relation is Price (sales).
  2. Add a line with Party code type Group for a channel price group, Product code type Table, an Amount in currency and a From date.
  3. Validate the selected lines, then post.
  4. Open the released product and select View trade agreements to check the price is there.
  5. Run the Price simulator for a channel on that price group and check the price is used.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Number sequences

ReferenceShared or per companyNote
Price/discount journal numberPer companyNew records on this page take their Price/discount journal number from the PriceDiscJournalNum reference; BEAT uses number sequence Sale_51. Checked in Dynamics 365
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: Until posted, journal lines can be edited or deleted. After posting the price is used before the base price; to stop it, post an end date (expire the agreement) rather than relying on deletion. Microsoft Learn
If you change it laterOnce a trade agreement is posted, its price is used instead of the product's base sales price. Microsoft Learn
Technical architect

6Technical

Menu itemPriceDiscAdmTable_Sales Checked in Dynamics 365
FormPriceDiscAdmTable Checked in Dynamics 365
TablePriceDiscAdmTableShown as “Trade agreement journal table” in Record infoKey field: JournalNumChecked in Dynamics 365
Data entitiesTradeAgreementJournalHeaderEntityTrade agreement journal headers Microsoft data model TradeOpenTradeAgreementJournalHeaderV2EntityTrade agreement journal table V2 Microsoft data model
Roles to set it up and use itTo set it up or change itRetail service RetailServiceSales manager TradeSalesManagerRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentRental sales manager RentalSalesManagerTo use itSales clerk TradeSalesClerkRental purchasing manager RentalPurchasingManagerRental representative RentalRepresentativeAccounting manager LedgerAccountingManagerPurchasing manager TradePurchasingManagerGive people one of these roles. On this system, 14 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=PriceDiscAdmTable_Sales
Integrate withTradeAgreementJournalHeaderEntity data entity Microsoft data model
Data migrationTradeAgreementJournalHeaderEntity (Trade agreement journal headers): loaded for each company.TradeOpenTradeAgreementJournalHeaderV2Entity (Trade agreement journal table V2): loaded for each company.Microsoft Learn
Table definitionPriceDiscAdmTable columns and relations Microsoft data model
Everyone

8Sources