Price Lists

Configured segment price lists in ims.PriceList with matrix rows in ims.ItemPrice and customer-specific overrides in ims.CustomerItemPrice.

IMS_Demo

Segment price lists drive invoice pricing by customer assignment. Select a list to browse its matrix rows on demand.

Import Price List

Pricing Operations Snapshot

Active Price Lists 5
RETAIL WHOLESALE CHOLON SUPERMARKET VIP
Pricing Records 14,762+ Effective-dated item prices
Customer-Specific Prices 500+ Contract and negotiated prices
Import Governance 100% Audit Trail Coverage

This pricing engine supports multi-segment distribution operations through effective dating, customer-specific pricing, Excel import automation, and full auditability.

Recruiter Impact
  • Large pricing dataset
  • Pricing hierarchy
  • Customer contracts
  • ERP governance
  • Business process complexity
Price Lists 5 lists
Code Name Matrix Rows Active
RETAIL Retail 14.762 Yes
WHOLESALE Wholesale 14.760 Yes
CHOLON ChoLon 14.760 Yes
SUPERMARKET Supermarket 14.760 Yes
VIP VIP 14.760 Yes
Import History
Recent pricing imports used to update Item Prices and Customer-Specific Prices.
Import Date File Name Rows Status Action
17-Jun-2026 Bang Gia IMS_Import_17.06.2026.xlsx 2 Success
16-Jun-2026 Retail_Q3_Price_Update.xlsx 5.120 Success
12-Jun-2026 VIP_Contract_Pricing.xlsx 248 Success
01-Jun-2026 Wholesale_Price_Adjustment.xlsx 4.875 Success
25-May-2026 Customer_Price_Overrides.xlsx 95 Success

Why This Matters

Pricing changes should be traceable and auditable.

Without import history:

  • Nobody knows which file changed prices
  • Difficult to investigate invoice disputes
  • Difficult to verify customer-specific pricing

With Import History:

  • Complete pricing audit trail
  • Faster issue investigation
  • Better pricing governance
  • Stronger ERP internal controls

Demonstrates ERP pricing administration

  • Bulk Excel Import
  • Validation Engine
  • Effective Dating
  • Customer-Specific Pricing
  • Pricing Governance
  • Audit Trail Design
  • ERP Internal Controls
  • Business Process Thinking
Price Matrix — —

No price list selected.

Sales Invoice Price Resolution

Sales Invoice Price Resolution Engine

When a user creates a Sales Invoice, the system automatically determines the correct selling price using a structured pricing hierarchy.

This eliminates manual lookups, improves consistency, and protects gross margin.

Pricing Resolution Flow

Step 1 Check Customer-Specific Price

CUS0007 + ITEM00022

Price = 23,500

If found: STOP

Step 2 Check Assigned Customer Price List

Customer: CUS0007

Assigned List: VIP

ITEM00022 — Price: 24,000

If found: STOP

Step 3 Apply Item Group Discount Rules

Price List Price: 24,000

Storage Discount: 10%

Final: 21,600

Step 4 Fallback to Standard Retail Price

Retail: 25,200

Used when no customer-specific price exists.

Step 5 Exception Handling

If no valid price exists:

  • Flag item
  • Prevent invoice save
  • Require pricing administrator review

Real-World Example

Customer
CUS0007
Customer Segment
VIP
Item
ITEM00022
Customer Price Found?
YES
Customer Price
23,500
Price List Ignored
Yes
Discount Rules Ignored
Yes
Final Invoice Price
23,500

Resolution Path

Customer Price 23,500
Price List Skipped
Discount Skipped
Retail Not used
Invoice Price 23,500

Pricing Engine Flow

Customer-Specific Price
Price List
Group Discount
Retail Price
Invoice Price

Why ERP Systems Use Pricing Hierarchies

  • Prevents incorrect pricing
  • Protects gross margin
  • Supports contract pricing
  • Supports wholesale and retail channels
  • Reduces invoice disputes
  • Eliminates manual price lookup
  • Improves auditability

Business Systems Thinking

This pricing engine demonstrates more than CRUD screens.

It models a real ERP pricing process involving:

  • Customer-specific contracts
  • Price list assignment
  • Effective dating
  • Discount hierarchy
  • Invoice automation
  • Audit controls

The design reflects how distribution, wholesale, and manufacturing ERP systems determine selling prices in daily operations.

Blank CustomerCode in import files updates the standard Retail matrix. Populated CustomerCode creates or updates customer-specific prices in ims.CustomerItemPrice.