Accounts receivable manager, Retail merchandising manager, Retail operations manager and 5 more roles
Business process
Set product prices
Menu item
GUPVendPriceAdm
Main table
GUPVendPriceAdmTable
Data entity
GUPVendPriceAdmTableEntity
Setup steps
1 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 is
A page where you record the vendor's general price catalogue for items, with a valid date period.
What you do here
Use this page to keep vendor list prices at item and inventory dimension level, so that they can be the starting point for calculating the sales price of an item.
Example
For example, a retail or distribution business that buys products from vendors and sells them to customers can derive the sales price from the vendor's list price.
The page in Dynamics 365. page title tab to open what to set or check
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
Set up Vendor list price
Use this page to keep vendor list prices at item and inventory dimension level, so that they can be the starting point for calculating the sales price of an item.
Test checklist
Record a vendor list price for one item and inventory dimension with a valid period that includes today.
Add a vendor price term agreement for the same vendor and site.
Check that the calculated item base price equals vendor list price plus the agreement price.
Add a lower list price from a second vendor and check that the lower calculated price is used.
One vendor list price per item and inventory dimension, each with a valid date period, adjusted by vendor price term agreementsThe vendor list price holds the vendor catalogue at item and inventory dimension level with a valid period. The item base price is then the vendor list price plus the vendor price term agreement price.
Loading the same item from several vendors and expecting the preferred vendor's price to win. The item base price has one active value per site, so only the lowest calculated price is used.
Solution architect
5Design impact
Can it be undone
Reversible: Prices are kept with a valid date period. A change affects the next item base price calculation; only the lowest calculated price per site is used. Microsoft Learn
If you change it later
A change to a vendor list price changes the calculated item base price for each site; where several calculated prices exist, only the lowest is used. Microsoft Learn
Technical architect
6Technical
Menu item
GUPVendPriceAdmChecked in Dynamics 365
Form
GUPVendPriceAdmChecked in Dynamics 365
Table
GUPVendPriceAdmTableShown as “VENDOR LIST PRICE JOURNALS” in Record infoChecked in Dynamics 365
Data entities
GUPVendPriceAdmTableEntityVendor list price tables Checked in Dynamics 365
Who can open it
PrivilegesMaintain sales base price GUPVendorListPriceMaintainView sales base price GUPVendorListPriceViewDutiesInquiries into sales base price GUPBasePriceInquiryMaintain sales base price GUPBasePriceMaintainInquiries into policies governing pricing setting process GUPMasterDataInquiryEnable pricing setting process GUPMasterDataMaintain9 security rolesAccounts receivable manager CustInvoiceAccountsReceivableManagerMCRTestUserRoleRetail merchandising manager RetailMerchandisingManagerRetail operations manager RetailOperationsManagerRetail service RetailServiceRetail store IT RetailStoreITPurchasing manager TradePurchasingManagerSales clerk TradeSalesClerkSales manager TradeSalesManagerChecked in Dynamics 365
Roles to set it up and use it
To set it up or change itRetail service RetailServiceSales manager TradeSalesManagerRetail merchandising manager RetailMerchandisingManagerPurchasing manager TradePurchasingManagerRetail store IT RetailStoreITTo use itSales clerk TradeSalesClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerGive people one of these roles. On this system, 8 roles can open this page.Checked in Dynamics 365
Actions on the page
(Action Pane without tabs): Adjustment, Enable, CopyChecked in Dynamics 365
Developer
7Developer
Open it by URL
https://<your-environment>/?mi=GUPVendPriceAdm
Integrate with
GUPVendPriceAdmTableEntity data entity Checked in Dynamics 365