Total Sale amount is different than the total in SAP

Total Sale amount is different than the total in SAP

Environment :

iVend 6.6

Problem Statement : 

Total Sale Amount shows the difference in SAP A/R Invoice then the iVend total after discount.

 

Symptoms:

We observed that all the item costs of the Invoice show some difference like in SAP item unit Price 17.35 and in iVend 17.3499200..

Cause:

In this scenario on SAP decimal place was 4, so unit price changed.

Resolution/Workaround :

We suggest to do a setting in SAP and test this.


1. Take the back up of production HO database and restore it on QA

2. Do the below setting on QA SAP

      a. Go to Tools -> User Defined Windows -> CXS_INTERLAND - Integration LandScape

      b. Open Integration LandScape and set Add Doc Total to 'True'.


3. Retrigger the problematic transaction and it will be integrated to QA SAP.

4. Compare the amount in iVend and SAP to check if there is any mismatch or not.


If all same then apply on production environment.



    • Related Articles

    • SAP Business One - iVend Retail Integration Points

      Introduction SAP Business One software is created specifically for small and midsized businesses. It is a powerful application and iVend Retail seamlessly integrates with it to help retailers better manage every aspect of their daily retail ...

    • X Tape receipt is showing wrong amount. Sale refund amount is getting added to total

      Problem statement Calculation mistake in Transaction Amount total Of X Tape report. Sales refund amount is getting added to total instead of substracting iVend Version 6.6 7702 Details The refunded amount is being added along with the sale amount ...

    • 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 ...

    • The Total Discount Changes the amount of the item in the line

      Environment : iVend 6.6 Patch 7747. Problem Description : The Total Discount Changes the amount of the item in the line. Scenario : The total discount changes the amount of an item(e.g T02689 in this case ) in the line when doing a sale edit and ...

    • Payment total in decimal digits does not settle in SAP and are taken as on account.

      Product Version: iVend 6.5 update 6 with SAP B1 Version 9.3 Problem Statement: ( INC00111059 )Invoices Integrated to SAP are not integrating at full amount in Receipt and decimal places are taken for on account payment Proposed Solution: The ...