...
Purpose of Sales Price Groups:
Sales Price Groups define different pricing tiers for customers based on their category or volume of business.
In this case, Retail Contractors are divided into three groups based on previous purchase volume:
Preferred: Highest tier, largest discount (e.g., 25%).
Established: Middle tier, moderate discount (e.g., 22%).
Contractor: Basic tier, smallest discount (e.g., 20%).
Application of Discounts:
Discounts are applied to the standard price of an item.
The system must calculate the discounted price automatically when the sales order is created.
Discounts should appear line by line on the sales order, showing the standard price, discount percentage, and final price.
Creation of Sales Price Records:
Sales price records must be created for every item that could be sold to a retail contractor, with pricing for each of the three discount tiers.
Manual Process: Without automation, creating these records would require entering three pricing records for every item.
Proposed Automation:
Use the standard price and apply the discount percentages automatically to calculate the sales prices for each group.
Bulk-import these calculated prices into the system to minimize manual entry.
Alternative Proposal:
Instead of creating separate sales price records for each item and group, dynamically calculate the discount during sales order entry:
The standard price populates the sales order line.
The system calculates and displays the discount and final price directly on the line item.
This approach would reduce the need for maintaining separate price records and ensure discounts always reflect the current standard price.
Sales Order Customization:
Retail contractors will only see their discounted prices on sales orders and invoices.
Customers paying full price (e.g., Retail Customers) will not have discounts applied.
Challenges and Solutions
Managing Bulk Updates:
Prices and costs change frequently, and maintaining accurate sales price records for all items across all groups can be time-consuming.
Solution: Implement logic to bulk-update prices based on a percentage markup or discount off the standard price.
System Limitations:
Some functionality, like applying dynamic discounts, might require a system change or customization in GoldFinch ERP.
Proposed Approach:
Use a trigger to calculate and populate discounts dynamically when a sales order is saved.
If this approach is insufficient, escalate the request to GoldFinch’s development team for a potential package update.
Flexibility:
Discounts should be editable on sales orders for exceptions.
The team wants the ability to easily update discount percentages (e.g., changing from 20% to 25% for a specific group) without modifying every individual sales price record.
Action Items
Automate Price Setup:
GoldFinch will calculate the initial sales price records using the standard price and predefined discount percentages for each group.
Bulk-import these records into the system for all applicable items.
Explore Dynamic Discounting:
Investigate using a trigger to calculate discounts dynamically during sales order creation.
Confirm if this can be implemented without requiring changes to the GoldFinch package.
Streamline Bulk Updates:
Develop a process to bulk-update standard prices and discounts based on changes in costs or markup percentages.
Test Sales Order Workflow:
Ensure the sales order displays gross price, discount percentage, and final price for transparency.
Verify that discounts are correctly applied based on the customer’s sales price group.
Criteria for Sales Price Groups
Sales Price Groups must reflect the correct discounts automatically based on the customer’s group.
Bulk price updates should be easy and intuitive, minimizing manual data entry.
Line-item discounts must be visible and editable for exceptions.
Dynamic discount calculations should always reference the current standard price to avoid outdated records.