Price list configured but didn't pick correct price on iVend POS Transaction Screen

Price list configured but didn't pick correct price on iVend POS Transaction Screen

Problem Statement:

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

Version:

iVend 6.5 Update 6 with SAPB1 9.2

Check Points:

There is one parameter in Enterprise Screen -> Pricing Resolution




SQL Table/Query : select PricingResolution,* from CfgEnterprise

None: If set to None, then the pricing resolution order 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)

1. If price is not getting correctly , then need to compare the price list between SAPB1 and iVend.





SQL Query/table : select * from OPLN –price list table in SAP


SQL Query/table : select * from prcpricelist –price list table in iVend

2. Corresponding information in iVend Enterprise MC
   select * from prcpricelist (refer step 1)
3. Go to iVend Enterprise MC -> Operations -> Price list
IS there a pricelist detail table in ivend DB for below screen




SQL Query/Table:
select ProductKey,PriceListKey,Price, * from PrcPriceMatrix where PriceListKey='enter PriceListKey ' and ProductKey='enter ProductKey'

4. If replication is cleared from Enterprise MC -> Store MC, then Check the same information on Store MC
5. Go to iVend Store MC -> Operations -> Price list



6. If it is different from SAPB1 to iVend Enterprise(Store) , suggest to update the price from SAPB1 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 same, reopen iVend POS and scan the product.

For integration : Select * from repintegrationlog where SourceType=80
For replication : select * from RepReplicationTransaction where SourceType=80




    • Related Articles

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

      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 ...
    • While searching product on iVend POS Screen, it doesn't display the incorrect price

      Product Version : iVend 6.5 Update 6 with SAPB1 9.2 Problem Statement: While searching product on iVend POS Screen, it doesn’t display the incorrect price. Proposed Solution :- If price is getting different from view inventory price so need to update ...
    • General Settings in SAP Business One

      Introduction The iVend Add-on helps in setting up some configurations required for integrating iVend with SAP Business One. The following sections of this document capture the functionality of the new screens created and new fields added to the SAP ...
    • iVend Hospitality Feature List

      Note: This Feature List is based on iVend Hospitality version 1.1 Restaurant Master Data Management iVend Hospitality provides highly configurable system settings. It comes with default data, multiple masters, data mapping screens and views, which ...
    • iVend Hospitality Feature List

      Note: This Feature List is based on iVend Hospitality version 1.1 Restaurant Master Data Management iVend Hospitality provides highly configurable system settings. It comes with default data, multiple masters, data mapping screens and views, which ...