BeyondERP.Newsletter
Menu

Setup page · Pricing management

Trade agreement journals

A page where you create and manage sales trade agreement journals, which hold negotiated prices for specific products and customers.

Used by
Purchasing agent, Chief executive officer, Accounts receivable manager and 6 more roles
Business process
Set product prices
Menu item
GUPPriceDiscAdmTable_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 page where you create and manage sales trade agreement journals, which hold negotiated prices for specific products and customers.
What you do hereUse this page to create journals, add pricing rule lines that set which prices apply to which combinations of customers and products, and then validate and post them.
ExampleFor example, to give a customer a fixed net price that no other adjustment or discount can change, set Allow price adjustment to No and Prevent discount to Yes on the journal line.
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 pathPricing management › During-sales pricing › Sales trade agreement price › Trade agreement journals
Set up firstTrade agreement journal names Microsoft Learn Price component codes Microsoft Learn Pricing management parameters Microsoft Learn
Related pagesReleased products Microsoft Learn All customers 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 Pricing management > During-sales pricing > Sales trade agreement price > Trade agreement journals.
  2. Make sure that the Show field is set to All or Not posted, and then select New.
  3. In the Name field, select a trade agreement journal name, and then select Save.
  4. On the Action Pane, select Lines.
  5. Select New, choose the price attribute group combination and the customer and product conditions, and then select OK.
  6. Set the quantity range, Unit, Amount in currency, Currency, From date and To date for each line.
  7. Select Validate > Validate all lines.
  8. Select Post, and then select OK.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
NameThe trade agreement journal name, which must have price attributes enabled and the relation Price (sales).Microsoft Learn JournalName
Price/discount journal numberA number generated when the journal is first saved; it is then read-only.Microsoft Learn JournalNum
PostedShows whether the journal has been posted.Microsoft Learn Posted
Enable price attributesRead-only; taken from the selected journal name.Microsoft Learn
Allow price adjustmentWhen selected, margin component price adjustments can be added on top of the agreement price.Microsoft Learn PriceApplyAdjustment
Prevent DiscountWhen selected, no other discounts are applied to the line.Microsoft Learn
From / ToThe minimum and maximum quantities that a customer must order to qualify for the agreement price.Microsoft Learn
Amount in currencyThe price that applies to the line.Microsoft Learn

Test checklist

  1. Create a journal with a journal name that has Enable price attributes selected.
  2. Add a line for one customer and one item, enter Amount in currency and a From date / To date that includes today.
  3. Validate all lines, then post the journal.
  4. Create a sales order for that customer and item and check the trade agreement price is used instead of the base price.
  5. Open Trade agreements from the released product with Posted = Yes and Match value only = No and check the line is listed.

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: Once posted, a journal shows Posted and the price is live. Learn describes changing prices by creating a new journal (Select copies posted lines), editing the copies, and validating and posting them, not by editing the posted journal. Microsoft Learn
If you change it laterA posted sales trade agreement price takes priority over the item base price for the customers and products it covers. Microsoft Learn
Technical architect

6Technical

Menu itemGUPPriceDiscAdmTable_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
Who can open itPrivilegesMaintain sales trade agreement journals GUPTradeAgreementMaintainView sales trade agreement journals GUPTradeAgreementViewDutiesView sales trade agreement journals GUPTradeAgreementInquiryMaintain sales trade agreement journals GUPTradeAgreementMaintainInquire into product sales prices and discount master PriceDiscProdSalesPriceDiscMasterInquirMaintain product prices and discount master PriceDiscProductPriceDiscMasterMaintainApprove product prices and discounts PriceDiscProductPricesDiscountsApproveReview purchase order process performance PurchOrderProcessPerformanceReviewEnable quotation to sales order process SalesQuotationToSalesOrderProcessEnable
10 security rolesChief executive officer CompanyChiefExecutiveOfficerAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManager MCRTestUserRoleRetail service RetailServicePurchasing manager TradePurchasingManagerSales clerk TradeSalesClerkSales manager TradeSalesManagerPurchasing agent VendPurchasingAgent
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceSales manager TradeSalesManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerPurchasing agent VendPurchasingAgentTo use itSales clerk TradeSalesClerkPurchasing manager TradePurchasingManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerChief executive officer CompanyChiefExecutiveOfficerGive people one of these roles. On this system, 9 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): LinesChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=GUPPriceDiscAdmTable_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