Added Fulfillment plan in sales transaction at POS but did delivery in SAP B1 instead of in iVend

Added Fulfillment plan in sales transaction at POS but did delivery in SAP B1 instead of in iVend

Version

Not the version-specific

Issue

The cashier added the fulfillment plan in sales transactions and received the incoming payments at POS in iVend. But they did Delivery in SAP Business One instead of in iVend.

Means Delivery note created and A/R reserve invoice closed from SAP, which causes the stock mismatch for the items in iVend.

Products are already issued from the system and the in-stock and available balance in SAP are ok.
But the available stock in iVend doesn’t match with SAP.

The step-by-step of this process is as below:

1. The cashier creates the Sales transaction in the POS.
2. The cashier added the Fulfillment Plan (Delivery Plan) in this transaction.
3. The cashier completes this transaction and receives the incoming payment in the POS.
4. There are 2 transactions created in SAP Business One – 1. A/R Reserve Invoice and 2. Incoming Payment.
5. Later, the accountant found out that there are a few A/R reserve invoices that still have “Open Status” in the SAP system.
Then the accountant did the Delivery Notes in the SAP system against the Opened A/R Reserve Invoice. Consequently, the particular A/R Reserve Invoices are already closed.
And the Stock Balance in the SAP System seems to be correct.
Now in the iVend System, the available balance is still negative for this item so the user cannot create any transaction for this item.

Solution

It is recommended, not to close the AR reserve invoice by creating delivery documents directly in SAP. Instead of that need to close the AR reserve invoice from iVend by creating a corresponding delivery document on the relevant store.
​
Now to correct the stock in iVend, the Stock matching exercise needs to be performed on the databases level through the running scripts.

This KB article concludes here.


    • Related Articles

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

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

    • Automatic fulfillment

      Automatic Fulfillment Fulfillment plans defined in the Management Console, can be attached to a Sale, a Special Order and a Layaway transaction at the POS. Now with the introduction of iVend Retail version 6.5, this process is now automated. What ...

    • Query about Sale Delivery Transaction

      Environment: iVend 6.6 Product Query: There is a sale that is generated at store 2 and then a fulfillment plan has been added at Store 1. After that sale transaction delivery is fulfilled at Store 1, And finally sale return transaction has been made ...

    • Layaway item can not be added to the plan

      Environment: iVend 6.6 8567 Problem Statement: Layaway item can not be added to the plan.select a plan with inventory method as: Sale Layaway item can not be added to the plan.select a plan with inventory method as: Delivery Symptoms: Not Applicable ...