TL;DR — Quick Summary
Fix Aspel SAE price list errors: customer assignment, volume discounts, Excel import, multi-currency pricing, and promotional price configuration.
Price List and Customer Discount Errors — Aspel SAE
Price lists in Aspel SAE allow different pricing for different customer types: wholesalers, retailers, distributors, or customers with special pricing. When configuration fails, invoice prices do not match agreed rates, causing customer disputes and incorrect profitability reports.
The Error
The most common price list errors in Aspel SAE are:
- “Error assigning price list to customer” — appears when saving the customer catalog if the list number does not exist or is inactive
- Wrong price on invoice — the system applies a different list without showing an error message
- “Error importing price list” — when importing from Excel if product codes do not match the catalog
- Discounts not applied — the discount percentage does not appear on the invoice despite being configured on the customer
- Incorrect VAT on prices — the product-level tax configuration overrides the price list setting
Root Cause
Nonexistent or inactive price list
SAE supports up to 10 price lists (numbered 1–10). If you assign list 5 to a customer but no products have prices entered for that list, the system falls back to list 1 (base price) or shows an error.
Conflicting discount levels
SAE applies discounts in this priority order:
| Priority | Type | Where configured |
|---|---|---|
| 1 (highest) | Promotional discount | Expiration date set |
| 2 | Customer discount | Customer catalog |
| 3 | Volume discount | Quantity ranges |
| 4 (lowest) | List price | List assigned to customer |
When multiple levels are active simultaneously, the system may not combine them as expected.
Currency and exchange rate misconfiguration
If the price list is in USD but the invoice is in MXN, SAE converts using the system exchange rate. If this rate is not current or the customer’s currency is misconfigured, the resulting prices will be incorrect.
Product codes do not match during Excel import
The Product Code field must match exactly (including case and spaces) with the catalog. “PROD-001” and “prod-001” are treated as different codes.
Step-by-Step Solution
Step 1 — Verify existing price lists
- Go to Inventories > Products
- Open any product and check which lists have prices entered
- In System Configuration > Inventories, confirm the name assigned to each list
- Note which list number corresponds to the problem customer
Step 2 — Correct the customer price list assignment
- Go to Sales > Customers
- Open the affected customer’s catalog
- Select the Commercial Conditions tab
- In the Price List field, select the correct number (1–10)
- Save with F9 or the Save button
Step 3 — Review discount configuration
- In the same customer catalog, locate the Discounts section
- Verify the fixed commercial discount percentage is correct
- For volume discounts, confirm quantity ranges do not overlap
- Check whether active promotions are overriding the expected discount
Step 4 — Fix Excel import issues
- In Inventories > Mass Price Update, use Export first to get the current system template
- Fill in prices using the exported template (do not create your own format)
- Verify all product codes match the catalog
- Use Import with the corrected file and confirm changes in the preview
Step 5 — Validate VAT configuration
- In the product catalog, check the Taxes configuration
- Product-level tax settings take priority over the price list
- Ensure prices consistently include or exclude VAT across all lists
- Use Inventories > Reports > Price List to verify final prices with taxes
Alternative Solution
If direct correction does not work, rebuild the customer pricing:
- Export the customer catalog to CSV from Sales > Customers > Export
- Delete and recreate the customer (or create a temporary new one with correct data)
- Assign the price list and discounts from scratch
- Verify with a test quote before using in production
For price lists where many products show incorrect prices after a failed mass update, run Utilities > File Reconstruction to regenerate database indexes and relationships.
Prevention
- Name your lists clearly in System Configuration (List 1 = Retail, List 2 = Wholesale) to avoid confusion when assigning customers
- Always export the SAE template before importing prices — never use a custom Excel format
- Establish a review process before changing price lists: generate the price report before and after the change
- Use expiration dates on promotions so they expire automatically without manual intervention
- Update the exchange rate daily if you manage USD prices: go to Configuration > Exchange Rate each morning
- Restrict price list editing permissions in Configuration > Users to prevent accidental changes
Related Issues
Historical price reports do not match issued invoices
Historical reports reflect the price at the time of sale. If you modified the price list after invoicing, the historical report shows the original (correct) price. If the invoice price differs from what was expected, check whether a price was manually overridden during invoicing.
Maximum of 10 price lists reached
SAE has a hard limit of 10 lists. For more segmentation, combine a price list with a customer-level discount. For example: List 2 (Wholesale) with 5% discount for gold distributors, List 2 with 0% for standard distributors.
Prices do not update on existing customers after modifying the list
Modifying a price list updates product prices, not individual customer conditions. If a customer has a personal price override in their catalog, that takes priority. Check whether individual prices are set directly in the customer catalog.
Summary
- Aspel SAE supports up to 10 price lists per product; verify the assigned list has prices entered
- Discount priority: Promotion > Customer > Volume > List; a higher-level discount can hide lower ones
- For Excel price imports, always export the SAE template first — product codes must match exactly
- For USD pricing, update the exchange rate daily in Configuration
- Price lists do not override individual prices set directly in the customer catalog
- Use Utilities > File Reconstruction if prices remain incorrect after manual correction