Problem Statement:  

Special price list configured but didn’t pick correct price on iVend POS Transaction Screen

Environment:

iVend 6.5 Update 6 With SAP B1 9.2

Check Points:

There is one parameter in Enterprise Screen > Pricing Resolution

Note: If set to None, then the default pricing resolution order defined in the application will be followed.

Solve to Lowest:

If set to lowest, then the pricing resolution would go through the complete price resolution engine and then at the end pick up the lowest price available (or Highest discount available)

Solve to Highest: 

If set to highest, then the pricing resolution would go through the complete price resolution engine and then at the end pick up the highest price available (or lowest discount available)

SQL Table/query:

select PricingResolution, * from CfgEnterprise

Where:

If field set to 0= Pricing resolution is set to None
If field set to 1= Pricing resolution is set to ResolvedToLowest
If field set to 2= Pricing resolution is set to ResolvedToHighest

2. If a user configured a special price list in SAPB1/iVend and it is not displaying correct price on iVend POS, check the parameter “USE BP Price list for Retail” on SAPB1 Business Partner Master data screen

Go to SAPB1 > start the iVend Addon > then open the SAPB1 Business Partner Master data screen

SQL Table/query

select U_CXS_UCPR,* from OCRD

3. Once the user enables this parameter from SAPB1, it generates integration events from SAPB1 to iVend Enterprise and with Replication events, it will be replicated on Store(s).

4. Go to iVend MC > operations Business Master > Check if the parameter Price list is populated or not.

SQL Table/query

select * from PrcPriceList

select PriceListKey, * from CusCustomer

from the tables ‘prcPriceList’ one can find the list of price lists in iVend MC and can verify whether the price list is mapped with the business partner by observing the column ‘PriceListKey’

5. If it is correctly populated and still the price is not as per the special price list, then we need to compare the special price list between  SAPB1 and iVend.

6. Go to SAPB1 > Inventory > price list > Special price list

SQL Table/query 

select ListNum,CardCode,* from OSPP --spl price list

From the columns ListNum and Cardcode check the Price lIst no. and Business partner code respectively.

7. Corresponding information in iVend Enterprise MC

Go to iVend Enterprise MC > Operations > Price list > Special Price List

SQL Table/query

select BasePriceListKey,CustomerKey,ProductKey,* from PrcSpecialPriceListMaster

Check the base price list mapped with the Special price list corresponding to the price list mapped in SAP B1.

8.If replication is cleared from iVend Enterprise > Store, special price list events

9.Corresponding information in iVend Store MC  

Go to iVend Store MC > Operations > Price list > Special Price List

SQL

select BasePriceListKey,CustomerKey,ProductKey,* from PrcSpecialPriceListMaster

10.If it is different from SAPB1 to iVend Enterprise(Store), suggest to update the price from SAPB1 Special price list so Integration/Replication may generate new events towards iVend HO/Store and once integration/replication is cleared, check the above  iVend Enterprise/Store MC Special price list screen if they are same or not. If the same, reopen iVend POS and scan the product.