SalesDoc Architect makes it easy to incorporate customer-specific pricing whereby the seller is contractually obligated to sell specific items at agreed-to pricing. 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 Module.
VersionDate – the last update date of the price list that is referenced on SDA’s Pricing Module.
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:
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.
DID YOU KNOW…
Return to SDA User Guide Table of Content