BeyondERP.Newsletter
Menu

Setup page · Sales and marketing

Attribute-based pricing details

A setup page where you create batch attribute-based pricing formulas that calculate the purchase price of a potency item. It is the same page as in Procurement and sourcing, reached from the Sales and marketing price setup.

Used by
Purchasing agent, Project manager, Purchasing manager and 1 more role
Business process
Procure goods and services
Menu item
PDSCalculationTable
Main table
PDSCalculationTable
Setup steps
2 on this page
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 setup page where you create batch attribute-based pricing formulas that calculate the purchase price of a potency item. It is the same page as in Procurement and sourcing, reached from the Sales and marketing price setup.
What you do hereUse this page to change the purchase price paid for a potency item with an equation based on its batch attributes, such as the actual and target potency of a received batch.
ExampleBEAT buys an extract with target potency 80 percent. Formula BEAT-00001 multiplies the purchase price by actual potency divided by target potency, so a batch received at 84 percent and 10.00 USD per kg is paid at 10.50 USD per kg.
Attribute-based pricing details 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 processProcure goods and services
Menu pathSales and marketing › Setup › Prices and discounts › Attribute-based pricing details
Set up firstBatch attributes Microsoft Learn
Used next byReleased products Microsoft Learn
Related pagesAttribute-based pricing details (Procurement and sourcing) 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.

Step by step, with screenshots

Set up Attribute-based pricing details1 screen

Use this page to change the purchase price paid for a potency item by using calculation equations based on its batch attributes.

  1. Screen 1

    Create the attribute-based pricing record

    Go to Procurement and sourcing > Setup > Prices and discounts > Attribute-based pricing details

    1. Select New and enter the name and description
    2. Under Elements, select Add variable
    3. Choose the equation element type and enter its value
    4. Select Save
    1Attribute-based pricing IDBEAT-00001
    2NameMarkup
    3DescriptionPrice markup factor
    Element AConstant 1.05
    Create the attribute-based pricing record (zoomed on the outlined fields)
    Show the full screenCreate the attribute-based pricing record
    page title tab to open what to set or check
Validate attribute-based pricing formulas for potency items

Set up and validate the formula that adjusts the purchase price of a potency item from its batch attributes.

Steps from Microsoft

  1. Go to Sales and marketing > Setup > Prices and discounts > Attribute-based pricing details.
  2. Select New to create a pricing formula line and enter a code in the Attribute-based pricing ID field.
  3. On the Equation FastTab, enter the equation that calculates the purchase price, and select Validate equation.
  4. On the Elements FastTab, select Add variable and enter the Equation element, Equation element type, Attribute and Constant values.
  5. Check that the batch attributes used in the equation are assigned to the potency item before batches are received.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Attribute-based pricing IDA code that identifies the attribute-based pricing formula.Microsoft Learn BEAT-00001CalculationId
EquationThe formula that calculates the purchase price of the potency item.Microsoft Learn CalculationText
Equation elementA name for a set of values used in the equation, written with letters only.Microsoft Learn Element
Equation element typeWhat the element stands for, such as purchase receipt quantity, purchase price, an actual or target batch attribute, or a constant.Microsoft Learn ElementType
AttributeThe batch attribute used in the calculation, for actual or target batch attribute elements.Microsoft Learn PdsBatchAttribId
ConstantA fixed value or quantity used in the calculation.Microsoft Learn Constant
NameThe name of the pricing formula.Checked in Dynamics 365MarkupName
DescriptionA description of the pricing formula.Checked in Dynamics 365Price markup factorDescription
Element AAn equation element row: the element A, of type Constant, with the value 1.05.Checked in Dynamics 365Constant 1.05

Common errors and fixes

MessageWhat to do
The Attribute field can't be filled for an element.Attribute is available only for the element types Batch attribute - Actual and Batch attribute - Target; for a fixed value use Constant. Microsoft Learn

Test checklist

  1. Create formula BEAT-00001 with elements for purchase price, actual and target batch attribute.
  2. Select Validate equation.
  3. Check that validation reports no error.
  4. Check that the Elements FastTab lists every element used in the equation.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Validate attribute-based pricing formulas for potency itemsOne formula per potency pricing rule, using Batch attribute - Actual and Batch attribute - Target elements, validated with Validate equation before the first receipt.The equation calculates the purchase price of the potency item, and Validate equation checks it before it is used on receipts.Should potency items be priced by batch attributes?Using Constant for a value that should come from the batch, so every batch is priced the same whatever its potency.Test: Formula validates

Feature management and licence

Licence or add-inOn the live system, Sales manager and Purchasing agent can maintain 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 undoneReversible: Formulas can be edited and validated again; receipts already priced keep their price. Microsoft Learn
If you change it laterThe formula changes the purchase price paid for potency items through their batch attributes, so changes affect receipts priced after the change. Batch attributes must be assigned to the product, with the batch dimension active. Microsoft Learn
Technical architect

6Technical

Menu itemPDSCalculationTable Checked in Dynamics 365
FormPDSCalculationTable Checked in Dynamics 365
TablePDSCalculationTableShown as “Calculation” in Record infoChecked in Dynamics 365
Who can open itPrivilegesMaintain attribute-based pricing PDSCalculationTableMaintainAttribute-based pricing view PDSCalculationTableViewDutiesInquire into sales agreement master AgreementSalesAgreementMasterInquireMaintain sales agreement master AgreementSalesAgreementMasterMaintainMaintain product prices and discount master PriceDiscProductPriceDiscMasterMaintainInquire into purchase order to invoice reference data PurchOrderToInvoiceReferenceDataInquire
4 security rolesProject manager ProjProjectManagerPurchasing manager TradePurchasingManagerSales manager TradeSalesManagerPurchasing agent VendPurchasingAgent
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerPurchasing agent VendPurchasingAgentTo use itProject manager ProjProjectManagerPurchasing manager TradePurchasingManagerGive people one of these roles. On this system, 4 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=PDSCalculationTable
Table definitionPDSCalculationTable columns and relations Microsoft data model
Everyone

8Sources