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 difference in the total amount of the invoices in iVend and SAP is due to the difference between line details of (Price+Tax) with line total of the items. This happens due to the rounding calculation done in SAP in a different way than the iVend. So from the iVend database find such transactions and observe the payment amount and match with the payment received in SAP, check for the difference in decimal digits and suggest the customer to change the Incoming amount difference and outgoing amount difference according to the difference in decimal places in "currencies setup screen in SAP".
The resolution will work on Invoices generated after performing this activity and not on the current invoices with the difference in amount, for correcting current invoices one will have to perform manual reconciliation in SAP through GV.
Steps if any:
None
Constraints / Scenarios:
NA
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 ...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 ...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 ...ISSUES WHEN INTIALIZING MASTER TABLES FROM SAP: "iVend 6.*.*.* add-on failed to update the database"
Product version 6.5 Update 6 Problem statement Getting Error "iVend 6.*.*.* add-on failed to update the database" when initializing master tables from SAP Reason CXSINTEGRATION DATABASE IS DELETED SAP database, already initialized with iVend database ...Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer"
*****************For Internal purpose********************* Product Version: iVend 6.6 Issue: Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer": Integration Error: System.Data.SqlClient.SqlException (0x80131904): ...