SAP Business One - iVend Retail Integration Points

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 operations. SAP Business One is an affordable, easy to use, and quick to implement ERP and has more than 30,000 installations worldwide.

iVend Retail integrates with SAP Business One using the standard DI APIs provided as a part of the SAP Business One Software Development Kit. iVend Retail also integrates UDFs (User Defined Fields) defined on the Business Partner and Item Master in SAP Business One into iVend Retail.

There are over 25 masters and numerous transactions which integrate between iVend Retail and SAP Business One.

When installed, iVend Retail configures two (2) services – Integration and Replication which are utilised for integrating the two applications and to also replicate retail data and transactions across the retail network.

Considering the sensitivity of retail operations, only a few masters have a bi-directional integration. Most of the others are defined in the core ERP – SAP Business One and are integrated into iVend Retail and the entire Retail network.

iVend Retail and SAP Business One are normally configured at a central location, typically the Head Office. Retailers prefer to configure these applications on two (2) separate servers with the iVend Retail server having a static IP (one that can be searched on the Internet). This is done so that the store servers are able to ‘locate’ the central iVend Retail server, called the iVend Enterprise, for the purposes of integration and replication.

The application is so designed that it is not necessary for the stores to be “Always Connected” to the central iVend Retail server (iVend Enterprise). The synchronisation between the store operations and iVend Enterprise can be scheduled on a pre-defined frequency and whenever the Internet connectivity is restored, the store operations get synchronised with iVend Enterprise.
All the stores are configured as warehouses in SAP Business One. In-transit warehouses are also configured to track the inventory while in-transit from the distribution centre to the retail store.

By implementing SAP Business One with iVend Retail, retailers can:

  1. Streamline their In-Store and Head Office operations by seamlessly integrating key business processes.
  2. Integrate their retail process including sales, fulfilment, inventory, finance, taxes, etc.
  3. Take proactive control of their business through automatic alerts, workflows and respond to key business events and customer needs.

You can customise SAP Business One to support your changing needs and individual user preferences with easy-to-use customisation tools.

List of Masters Integrated between iVend Retail and SAP Business One

Country

Alternate Item

State

Discount Group

Codes/Groups

Sales Employee

Shipping type

Item Attributes

Item Group

User Defined Fields

Manufacturer

Serial Number Initialization

Customer Group

Batch Number Initialization

Business Partner

Exchange Rates

Items

Tax

BP Catalogue Number

Warehouses

BOM

Currency

Freight

Price lists

 

Price List:

On fresh installation iVend, price list will be set to "No" by default. For integration of Price list from SAP B1 to iVend, select price list and set to "Yes”. Once price list is set to "Yes", the prices and special prices of the products in the selected price list are required to be updated in SAP. Only updated prices in SAP B1 will get integrated into iVend.
 
On upgrade from earlier iVend Retail version price list will be set to "Yes" by default.


 


Once price list is set to "Yes" as retail price list, it cannot be re-set to no. A pop up displays a message "This action cannot be reversed. Are you sure you want to select this Price list as Retail?". On Pressing the Update button on the Price Lists master, the system will integrate all prices defined for the items in the price lists to the iVend Application.

List of Transactions Integrated into SAP Business One

Retail Transactions

Payment Integration

 

Sales

-

Refund/Exchange

-

Sales Order/Sales order Update

-

Delivery

-

Layaway/Layaway Cancellation

-

Gift Certificate Sale

 

 

-

Cash

-

Credit Cards

-

Debit Cards

-

Gift Certificates

-

Travelers Checks (Cheques)

-

Checks (Cheques)

-

Foreign Currency, Loyalty, Voucher

-

Custom Tenders, On Account

 

Business (Inventory) Transactions

Purchase Orders

Goods Receipt PO

Goods Receipt

Goods Issue

Goods Return

Stock Transfers

Kits Build/Break

Expenses (Management Console)

Inventory Counting (Stock Take)

 

Other

Store Expenses (POS)

Cash Till Variances

 


    • 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 ...
    • 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): ...
    • SAP Business One Integration

      Introduction iVend Retail-SAP Business One Integration Extensibility is used for writing add-on application to customize integration logic. Integration extensibility Add-on allows to write business logic for orchestration of scenarios for new objects ...
    • SAP Business One Integration - Videos

      iVend Addon Installation SAP Business One - iVend Integration Service Configuration Manager Retail Warehouse Accounting Setup Retail Settings Initialisation Retail Transactions in SAP Business One SAP Business One - PO and SO Integration With IVend ...
    • iVend POS - Multicurrency Payments Integration with SAP Business One

      Introduction With iVend versions 6.2 and above, there is now full support on the Cash tender type for multiple foreign currencies. Foreign Currency payments processed at the Point of Sale (POS) can now be integrated to SAP Business One (SBO) in ...