Skip to main content

Adaco: Pricing Opportunity Report

Fourth Customer Success Portal
  • Updated

Pricing Opportunity Report

The Pricing Opportunity Report is used to see the product cost difference between the purchase order and the lowest cost active quote.
  • To run the this report, go to Report Centre>Purchasing Report>Pricing Opportunity Report.
  • Double-click Pricing Opportunity Report or select the report and click Run Report, to open the report criteria screen, as per Fig. 01.​
 
Pricing Opportunity Report
Fig. 01 - Running the Pricing Opportunity Report

Report Criteria

Enter report criteria below to get desired results, as per Fig. 02 below.
 
Pricing Opportunity Report Criteria
Fig. 02 - Report criteria for the Pricing Opportunity Report
 
Fields Description
From Date and To Date Purchase orders with a delivery date in the chosen date range will appear on the report.
Order Selection All Purchase Orders: generates the report with all purchase orders in the selected date range.
Selected Purchase Orders: generates the report with only the selected purchase orders.
Hide Lowest Price or Below Line Items Enabled by default, this will show only purchase orders which have the lowest cost for a product compared to active quotes will not be displayed.
Show Order Total Enabled by default, this will show the total costs of all the products on the purchase order.


Report Results

When the Pricing Opportunity Report is generated, the result should look similar to Fig. 03.
 
Pricing Opportunity Report
Fig. 03 - Pricing Opportunity Report results
 
Fields Description
Order Number The Adaco purchase order number.
Order Date The created date of the purchase order.
Delivery Date The selected Delivery Date on the purchase order.
Status Displays the Order Status of the purchase order in the Purchasing Centre.
Vendor The Adaco number and name of the vendor.
Phone The number entered into the Phone Number field on the Vendor Master, located under Property>Vendors. 
Line The line number in the purchase order.
Product The Adaco product number.
Product Description The name of the product.
Purchase Info The text entered in the Purchase Info field on the Product Master, located under Property>Products.
Purchase Unit The product's unit information is displayed as Purchase Unit [PackSize PackUnit (SubPackSize SubPackUnit)].
Quantity The amount of the product being purchased.
Price The cost of the product on the purchase order.
Price Diff The difference of the cost of product and the lowest active quoted cost.
  • Calculation: PRICE DIFF = COST OF PRODUCT ON PURCHASE ORDER - LOWEST ACTIVE QUOTED COST OF PRODUCT
Cost The total cost of the amount of product being purchased.
  • Calculation: COST = QUANTITY x PRICE
Cost Diff The difference of the total cost of the amount of product being ordered and the total of the lowest active quoted cost with the amount being purchased.
  • Calculation: COST DIFF = QUANTITY x PRICE DIFF
Order Total The total of the Cost and Cost Diff of the products on the purchase order.
Total The total of all the purchase orders' Cost and Cost Diff in the report.

Related articles

Comments

0 comments

Please sign in to leave a comment.