Effective Date Selling Rates Report

Overview

The Effective Date Selling Rates report shows selling rates and related cost information for a selected effective date.

Use it to answer questions such as:

What selling rate and cost price apply to this product, and what margin does that produce?

The report can be filtered by product, Product Master, Price List, billing term, currency, and Product Identifier to help investigate specific pricing.

For instructions on generating and downloading reports, see Generating Reports.

What to Look at First

Start with the Selling Rates (Filter) sheet.

Use the available filters to narrow the report to the product or pricing configuration you want to review.

The results show:

• Selling Rate: the selling price applicable to the product;
• Cost Price: the corresponding recorded cost;
• Gross Margin: the difference between the selling rate and cost price; and
• GM %: the gross margin expressed as a percentage.

Look for selling rates, cost prices, or margins that do not match the expected pricing for the selected effective date.

Understand the Effective Date

Selling Rates and Cost Prices can change over time through effective-dated pricing records.

The effective date selected when generating the report determines the point in time used for the pricing view.

This is useful when investigating historical or future-dated pricing because the latest pricing record is not necessarily the record that applies to the selected date.

Investigate a Pricing Difference

If a value does not match what you expect:

1. Use the filters on Selling Rates (Filter) to identify the affected product and pricing record.
2. Compare the Selling Rate and Cost Price.
3. Review the resulting Gross Margin and GM %.
4. Confirm the applicable Product, Price List, Billing Term, and effective-dated pricing configuration in Varibill.
5. Correct the pricing configuration where required.

Where a product does not have an applicable Selling Rate, use the supporting report data to investigate the missing pricing configuration.

Missing Selling Rates

The workbook includes a VB#NoSellingRate sheet containing products for which an applicable Selling Rate was not identified.

Use this data when a product expected in the report does not have pricing available for the selected effective date.

Check the product’s Selling Rate configuration, including the applicable Price List, Term, and Effective Date.

Supporting Report Data

The workbook includes supporting VB# sheets containing Product, Product Master, Price List, Forex, Selling Rate, and related pricing data used to build the report.

These sheets can be useful for deeper pricing investigation or reconciliation when the filtered view does not provide enough detail.

For most pricing reviews, start with Selling Rates (Filter) and use the supporting data only when further investigation is required.

Important Considerations

• The selected effective date determines the point in time used for the pricing view.
• Selling Rates and Cost Prices may have different effective dates.
• Gross Margin is based on the Selling Rate and Cost Price represented in the report.
• Missing or unexpected pricing should be checked against the underlying Product, Price List, Term, and effective-dated pricing configuration.
• Use the filtered view first and the supporting VB# sheets for deeper investigation where required.