Do you have customers with whom you’ve signed long-term contracts to provide specific products and services at agreed-to pricing?

SalesDoc Architect makes it easy to incorporate customer-specific pricing into quotes for situations where the seller is contractually obligated to provide specific items at agreed-to pricing.  You can also incorporate customer-specific costing, such as when a manufacturer provides lower costing to the reseller to support the lower pricing that the reseller provides to a specific end customer.

An SDA user can incorporate customer-specific pricing and costing into a specific quote by connecting to an external price list in a properly formatted Excel file.  The SDA user simply browses for the file by clicking the Architect button, then “Connect to external price list”.

The Excel file containing the price/cost list must be placed in the user’s Data folder (usually c:\CorsPro\PQuote\Data) and must contain the following named Excel ranges*:

• PriceListName: this is the name of the price list that is referenced on SDA’s Pricing tab.
• VersionDate: the last update date of the price list that is referenced on SDA’s Pricing tab.
• PartNumber: this named range should be a single cell range in the part number column, one row above the first part number.
• UnitSell: this OPTIONAL named range should be a single cell range in the unit sell column, one row above the unit sell price for the first part number.
• UnitCost: this OPTIONAL named range should be a single cell range in the unit cost column, one row above the unit cost for the first part number.

As mentioned above, UnitSell and UnitCost are each optional.  Usually, only UnitSell is used in the external price list file.  However, in cases where the manufacturer provides customer-specific costing to the reseller, UnitCost can also be used.

Below is a sample of how the external price list file might look…

For situations where the customer-specific pricing must be referenced by multiple SDA users, Architect managers/administrators can push out customer-specific price lists to all users via the normal SDA updates process by placing the external price list Excel file in the SDA server’s Data folder.

* For further information on named Excel ranges, see Excel’s help topic “About labels and names in formulas”