BeyondERP.Newsletter
Menu

Setup step on the Trade agreement journals page · Sales and marketing

Register and post sales price agreements in a trade agreement journal

Use this journal to register new or changed prices and discounts and post them so that they take effect.

Business process
Develop sales pricing strategy
Menu item
PriceDiscAdmTable_Sales
Main table
PriceDiscAdmTable
Data entity
TradeAgreementJournalHeaderEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 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, BEAT agrees a price of 18.50 per unit for item BEAT-ITEM-0420 with customer BEAT-000123 from 1 January 2027. The pricing clerk enters one line with Party code type Table in December, posts the journal after approval, and order lines from 1 January get 18.50 instead of the base price of 21.00.
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

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.

Setup steps on this page

Register and post sales price agreements in a trade agreement journal

Use this journal to register new or changed prices and discounts and post them so that they take effect.

Steps from Microsoft

  1. Go to Sales and marketing > Prices and discounts > 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 meansExample
Party code typeSets who the line applies to: one customer (Table), a customer price group (Group) or all customers (All). Group needs customer price groups.Microsoft Learn Table
Product code typeSets which products the line applies to. A Price (sales) line must use Table, because a price is an absolute value for one product.Microsoft Learn Table
ToThe maximum quantity above which the agreement's price no longer applies. Each quantity break is a From and To pair.Microsoft Learn 100
Amount in currencyThe agreed price.Microsoft Learn 18.50
From dateThe date from which the agreement is valid.Microsoft Learn 2027-01-01

Common errors and fixes

MessageWhat to do
A posted price isn't used on new sales order lines for the customer.Check that the combination (for example Customer and Item for Price) is activated on Activate price/discount, that the line's From date has been reached and that the order quantity is inside the From and To range. Microsoft Learn

Test checklist

  1. Create a trade agreement journal with a journal name whose Default relation is Price (sales).
  2. Add a line: Party code type Table, the customer, Product code type Table, the item, From quantity, Amount in currency and From date.
  3. Validate the selected lines, then post the journal.
  4. On Released products, select Sell > View trade agreements and check the new price; create a sales order line for that customer and item and check the unit price.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Register and post sales price agreements in a trade agreement journalUse a journal name whose Default relation is Price (sales) for price changes, enter the lines in a journal ahead of time, validate the selected lines, and post only when the prices are approved.A trade agreement can be prepared in a journal and posted at a later time, for example when journals must be approved first. Once posted, its price is used instead of the product's base sales price.Posting agreements for a combination that isn't activated on Activate price/discount; trade agreements are used only for the combinations that are activated.Test: A posted price trade agreement prices the sales order line

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

Feature management and licence

Licence or add-inOn the live system, Sales manager, Accounts receivable manager and the rental managers (maintain), and Sales clerk, Accountant, Accounting manager and the rental roles (use) use this page.

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: Lines can be changed until the journal is posted. After posting, a change needs a new journal; old agreements can be kept as history.
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 itSales manager TradeSalesManagerRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentRental sales manager RentalSalesManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerTo use itSales clerk TradeSalesClerkRental representative RentalRepresentativeRental purchasing manager RentalPurchasingManagerAccounting manager LedgerAccountingManagerAccountant LedgerAccountantGive 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.Load order: No default configuration template places these entities. Load the journal headers after the trade agreement journal names they use, then post the journals in the system so the prices take effect.Load first: Trade agreement journal names, Customers and customer price/discount groups, Released productsMicrosoft Learn
Table definitionPriceDiscAdmTable columns and relations Microsoft data model
Everyone

8Sources