All Advance Payment transactions done at POS are not reflecting in SAP under AR Invoices
Version:
Not version-specific
Issue:
All advance payments transactions done at POS are not reflected in SAP under AR Invoices.
Solution:
Any transaction having only ARPayment flag true in TrxTransaction table in the store and HO databases (rest all marked zero) means it did not have a sale or any other transaction type associated with this transaction rather just advance payment is taken, and accordingly, there is no sale line for this transaction in SaleItem table. So this is the system by design that such Transactions get synced in SAP under Incoming Payment section and as per type of transaction this will not be visible in ARInvoice screen rather just will be visible under Incoming payment screen only.
Below is the screenshot where we can see how advance payment can be taken from POS.
Go to POS >> Select Transaction Mode >> Advance Payment >> Take payment >> Wait to replicate the records to Enterprise >> Wait to integrate the records to SAP B1 >> Search the Transaction at Incoming Payment Screen
Above is the process which explains about advance payment transactions and impact in SAP.
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 ...Discrepancies in payment transactions ( A/R invoices ) within SAP
Environment : iVend Version 6.6 with SAPB1 10 Problem: Discrepancies in payment transactions ( A/R invoices ) within SAP. Symptoms : Discrepancies in payment transactions ( A/R invoices ) within SAP so,due to this A.R. invoices being marked as open. ...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 ...How to cancel Advance Payment?
Query How to cancel Advance Payment? Solution Please follow below steps: - 1. Select the customer at POS 2. Change the transaction mode to Advance payment 3. Now below screen will appear 4. Put minus sign, “−“ and enter the amount that you want to ...