Information Systems:CCP - Customer/Contract Pricing - Revision history

Norwinu at 17:15, 30 June 2016

2016-06-30T17:15:12Z

Norwinu: Norwinu moved page Information Systems:CCP Description to Information Systems:CCP - Customer/Contract Pricing

2016-06-30T17:14:51Z

Norwinu moved page Information Systems:CCP Description to Information Systems:CCP - Customer/Contract Pricing

New page

There are no fixed selling prices; instead they are the result of a calculation based on the contents of several different files.

- File IXPRICP (CPP – Item Base Pricing) contains the vendor base cost (price type of VEBA) for all items.

- File IXMARKP (CCP – Item to mark Up Class Linkages) contains the markup class for each item. (For example ‘FS 5.5/7.5’, which is front store items with 5.5% markup for shareholders, and 7.5% for non-shareholders.)

- File MKCUPR (CCP – Customer to Price Links Master) gives the price list for each customer. (For example ‘SHARE-BC’ or ‘NON-SH-AB’.)

- File MKPERCP (CCP – Mark Up Percentages by Date Range) gives the markup percent for each price list within each markup class.

RPG program IXRUP500 (CCP – Item pricing lookup routine) is the black box that does all price lookup. Basically, it receives item, customer, and date, then returns all related price fields.

The high level process is –

- Read IXMARKP to get the item’s markup class.

- Read MKCUPR to get the customer’s price list.

- Read MKPERCP by markup class and price list to get the markup percentage.

- Read IXPRICP to get the vendor base cost.

- Multiple the vendor base cost by the markup percentage, and add it to the cost.

There is more to it; for example –

- Because of government legislation, vendors can have different selling prices by province. There is not a field for province on IXPRICP, so we use the warehouse field. ‘MAI’ for BC price, ‘CGY’ for Alberta, or ‘*ANY’ if the price is the same for both provinces.

- Items can be on contract, or on promo (see next two sections), so the black box must search for the lowest selling price effective on the requested date, that the customer is eligible for.

‘VEBA’ is not the only price type in IXPRICP. There are also –

CUSU customer suggested retail price
CURE customer rebate
VERE vendor rebate

==Contracts==

This is when we get special prices from vendors. The effective prices for purchasing are in CXITPRP. Price types in this file are -

CUSU customer suggested retail price
SUBS subsidy (by uniPHARM)
VEBA vendor base cost
VEDI vendor debit – charged back to the vendor or rep
VEOI off invoice – taken off the purchase price at time of payment

There are also sales dates in this file, or these special prices can be moved into a promotion.

==Promotions==

This is when we give special prices to our customers. The effective prices are in PXPRICP.

CUSU customer suggested retail price
SUBS subsidy (by uniPHARM)
VEBA vendor base cost
VEDI vendor debit – charged back to the vendor or rep
VEBA vendor base cost

Sheilav: /* CPR – Customer Product Restrictions */

2015-10-19T19:43:53Z

CPR – Customer Product Restrictions

Sheilav: Created page with "=CPR – Customer Product Restrictions= There are no fixed selling prices; instead they are the result of a calculation based on the contents of several different files. -..."

2015-10-19T19:42:27Z

Created page with "=CPR – Customer Product Restrictions= There are no fixed selling prices; instead they are the result of a calculation based on the contents of several different files. -..."

New page

=CPR – Customer Product Restrictions=

There are no fixed selling prices; instead they are the result of a calculation based on the contents of several different files.

- File IXPRICP (CPP – Item Base Pricing) contains the vendor base cost (price type of VEBA) for all items.

- File IXMARKP (CCP – Item to mark Up Class Linkages) contains the markup class for each item. (For example ‘FS 5.5/7.5’, which is front store items with 5.5% markup for shareholders, and 7.5% for non-shareholders.)

- File MKCUPR (CCP – Customer to Price Links Master) gives the price list for each customer. (For example ‘SHARE-BC’ or ‘NON-SH-AB’.)

- File MKPERCP (CCP – Mark Up Percentages by Date Range) gives the markup percent for each price list within each markup class.

RPG program IXRUP500 (CCP – Item pricing lookup routine) is the black box that does all price lookup. Basically, it receives item, customer, and date, then returns all related price fields.

The high level process is –

- Read IXMARKP to get the item’s markup class.

- Read MKCUPR to get the customer’s price list.

- Read MKPERCP by markup class and price list to get the markup percentage.

- Read IXPRICP to get the vendor base cost.

- Multiple the vendor base cost by the markup percentage, and add it to the cost.

There is more to it; for example –

- Because of government legislation, vendors can have different selling prices by province. There is not a field for province on IXPRICP, so we use the warehouse field. ‘MAI’ for BC price, ‘CGY’ for Alberta, or ‘*ANY’ if the price is the same for both provinces.

- Items can be on contract, or on promo (see next two sections), so the black box must search for the lowest selling price effective on the requested date, that the customer is eligible for.

‘VEBA’ is not the only price type in IXPRICP. There are also –

CUSU customer suggested retail price
CURE customer rebate
VERE vendor rebate

==Contracts==

This is when we get special prices from vendors. The effective prices for purchasing are in CXITPRP. Price types in this file are -

CUSU customer suggested retail price
SUBS subsidy (by uniPHARM)
VEBA vendor base cost
VEDI vendor debit – charged back to the vendor or rep
VEOI off invoice – taken off the purchase price at time of payment

There are also sales dates in this file, or these special prices can be moved into a promotion.

==Promotions==

This is when we give special prices to our customers. The effective prices are in PXPRICP.

CUSU customer suggested retail price
SUBS subsidy (by uniPHARM)
VEBA vendor base cost
VEDI vendor debit – charged back to the vendor or rep
VEBA vendor base cost

← Older revision		Revision as of 17:15, 30 June 2016
Line 56:		Line 56:
	VEDI vendor debit – charged back to the vendor or rep		VEDI vendor debit – charged back to the vendor or rep
	VEBA vendor base cost		VEBA vendor base cost
		+
		+	[[Category: Extensions]]

← Older revision		Revision as of 19:43, 19 October 2015
Line 1:		Line 1:
−	=CPR – Customer Product Restrictions=
−
	There are no fixed selling prices; instead they are the result of a calculation based on the contents of several different files.		There are no fixed selling prices; instead they are the result of a calculation based on the contents of several different files.