Updating SAP B1 product and price information

Business Challenge

On a weekly basis an external system is providing all product and price information to the customer. These are always all 200,000 records as the external system is not able to create delta information although typically only around 50 changes may be involved. Also deleted items are not visible because you will just no longer find them in the file. The data is provided in an excel sheet. The product information in SAP B1 needs to be updated. In addition all new product information has to be sent to the customer’s e-shop.

Solution

We create a new B1iSN integration step. The inbound is SAP B1 event triggered. In the inbound phase we define a Key Expansion to additional extract data, related to the linked business partner object information. This key expansion is just a definition in B1iSN. The transformation of the enriched B1 purchase order is placing the B1 order number into the R/3 field for the external key. The R/3 is configured to send out sales order changes to the B1iSN (to be defined as a logical system in R/3). This guarantees that immediately after insertion in R/3 an IDOC is sent out to B1iSN, covering the R/3 sales order including the generated R/3 order key. B1iSN as an RFC server is receiving the IDOC and triggers a second integration step which transforms the data and sends it to SAP B1, identified by the B1 primary key, sent by R/3 as the external key. Now you have in both systems the both primary keys of SAP B1 and SAP R/3. After a while the delivery notification is created in R/3. Also here the R/3 needs to be configured to send it out to the B1iSN server. A third integration step is converting this notification and handing it over to SAP B1. As a last step the invoice is created in R/3. Based on the configuration, the invoice triggers our fourth integration step. This step is converting the invoice in the B1 format, retrieves order information from SAP B1 to complete all information and hands over the invoice to SAP B1. This process will fail in case the human step (to mark the products as delivered) is not yet done. In this case the message will be handed over to the B1iSN Error Inbox. We configure an automatic action in B1iSN to retry the handover automatically in a certain time interval till the invoice is handed over successfully.

Related Topics

B1i Integration Services

Business One Integration Framework (B1if)

Business One Branch Consolidation (B1BC)

Business One integration with SAP NetWeaver (B1iSN)


Integration Services

CitiXsys provides application integration services to large corporations with SAP ERP having subsidiaries, vendors and associated companies running SAP Business One.

Few companies using B1i Framework

Few companies using B1i Framework

Supply chain management applications (for managing inventory and shipping), customer relationship management applications (for managing current and potential customers), business intelligence applications (for finding patterns from existing data from operations), and other types of applications (for managing data such as human resources data, health care, internal communications, etc) typically cannot communicate with one another in order to share data or business rules. For this reason, such applications are sometimes referred to as islands of automation or information silos. This lack of communication leads to inefficiencies, wherein identical data are stored in multiple locations, or straightforward processes are unable to be automated.

Enterprise application integration (EAI) is the process of linking such applications within a single organization together in order to simplify and automate business processes to the greatest extent possible, while at the same time avoiding having to make sweeping changes to the existing applications or data structures. In the words of the Gartner Group, EAI is the “unrestricted sharing of data and business processes among any connected application or data sources in the enterprise.”

B1i Framework is the only integration framework with SAP Business One DI Adapter and integrates seamlessly SAP Business One with any application. CitiXsys is the leader of B1i integration services with largest number of B1i consultants globally engaged in several projects.

SAP B1 purchase order to SAP R/3 as a sales order

Business Challenge

You need to send an SAP B1 purchase order to SAP R/3 as a sales order. Unfortunately the “order” business object of SAP B1 does not contain all the information needed to create successfully an order in SAP R/3. After creation the generated R/3 sales order number has to be sent back to SAP B1. After delivery the delivery notification and the invoice has to be sent to SAP B1. The invoice can be created successfully only if the products are marked as delivered in SAP B1 through a human step.

Solution

We create a new B1iSN integration step. The inbound is SAP B1 event triggered. In the inbound phase we define a Key Expansion to additional extract data, related to the linked business partner object information. This key expansion is just a definition in B1iSN. The transformation of the enriched B1 purchase order is placing the B1 order number into the R/3 field for the external key. The R/3 is configured to send out sales order changes to the B1iSN (to be defined as a logical system in R/3). This guarantees that immediately after insertion in R/3 an IDOC is sent out to B1iSN, covering the R/3 sales order including the generated R/3 order key. B1iSN as an RFC server is receiving the IDOC and triggers a second integration step which transforms the data and sends it to SAP B1, identified by the B1 primary key, sent by R/3 as the external key. Now you have in both systems the both primary keys of SAP B1 and SAP R/3. After a while the delivery notification is created in R/3. Also here the R/3 needs to be configured to send it out to the B1iSN server. A third integration step is converting this notification and handing it over to SAP B1. As a last step the invoice is created in R/3. Based on the configuration, the invoice triggers our fourth integration step. This step is converting the invoice in the B1 format, retrieves order information from SAP B1 to complete all information and hands over the invoice to SAP B1. This process will fail in case the human step (to mark the products as delivered) is not yet done. In this case the message will be handed over to the B1iSN Error Inbox. We configure an automatic action in B1iSN to retry the handover automatically in a certain time interval till the invoice is handed over successfully.

Related Topics

B1i Integration Services

Business One Integration Framework (B1if)

Business One Branch Consolidation (B1BC)

Business One integration with SAP NetWeaver (B1iSN)


Integration Services

CitiXsys provides application integration services to large corporations with SAP ERP having subsidiaries, vendors and associated companies running SAP Business One.

Few companies using B1i Framework

Few companies using B1i Framework

Supply chain management applications (for managing inventory and shipping), customer relationship management applications (for managing current and potential customers), business intelligence applications (for finding patterns from existing data from operations), and other types of applications (for managing data such as human resources data, health care, internal communications, etc) typically cannot communicate with one another in order to share data or business rules. For this reason, such applications are sometimes referred to as islands of automation or information silos. This lack of communication leads to inefficiencies, wherein identical data are stored in multiple locations, or straightforward processes are unable to be automated.

Enterprise application integration (EAI) is the process of linking such applications within a single organization together in order to simplify and automate business processes to the greatest extent possible, while at the same time avoiding having to make sweeping changes to the existing applications or data structures. In the words of the Gartner Group, EAI is the “unrestricted sharing of data and business processes among any connected application or data sources in the enterprise.”

B1i Framework is the only integration framework with SAP Business One DI Adapter and integrates seamlessly SAP Business One with any application. CitiXsys is the leader of B1i integration services with largest number of B1i consultants globally engaged in several projects.

SAP B1 orders to external systems and SAP ERP

Business Challenge

Some of the orders created in SAP B1, needs to be sent to an external fulfillment system, some others to SAP R/3. There are also local orders not relevant for integration. Some of the orders are configured by an external configurator tool. For all the configured orders, before handover to any other system, the configuration needs to be checked for each line item by this tool. The result of the check needs to be sent back to the SAP B1. In case of a successful check the message has to be sent to the appropriate fulfillment system.

Solution

We create a new B1iSN integration step. The inbound is SAP B1 event triggered. This makes sure that all order changes will trigger this integration step. In the scenario setup we define the rule for receiver determination by a flag field in the order. In case the flag is set to “relevant for 3rd party” the message is sent to the external fulfillment system; in case the flag is set to “relevant for R/3” the message is sent to R/3. In all other cases the message will be ignored. In the processing flow we first check the condition if the order is a configured order. In this case we are doing “multiple calls” via HTTP to the external configurator for each line item. After all calls are done we send back the result via “single call” to the sending SAP B1 system. In case there is an error in at least one order item, the process is stopped. Otherwise the transformation is called. The transformation is checking if the order is relevant for the external system or R/3 and runs the appropriate transformation. Subsequently the order is handed over via RFC call to R/3 respectively via HTTP call to the external fulfillment system.

Related Topics

B1i Integration Services

Business One Integration Framework (B1if)

Business One Branch Consolidation (B1BC)

Business One integration with SAP NetWeaver (B1iSN)


Integration Services

CitiXsys provides application integration services to large corporations with SAP ERP having subsidiaries, vendors and associated companies running SAP Business One.

Few companies using B1i Framework

Few companies using B1i Framework

Supply chain management applications (for managing inventory and shipping), customer relationship management applications (for managing current and potential customers), business intelligence applications (for finding patterns from existing data from operations), and other types of applications (for managing data such as human resources data, health care, internal communications, etc) typically cannot communicate with one another in order to share data or business rules. For this reason, such applications are sometimes referred to as islands of automation or information silos. This lack of communication leads to inefficiencies, wherein identical data are stored in multiple locations, or straightforward processes are unable to be automated.

Enterprise application integration (EAI) is the process of linking such applications within a single organization together in order to simplify and automate business processes to the greatest extent possible, while at the same time avoiding having to make sweeping changes to the existing applications or data structures. In the words of the Gartner Group, EAI is the “unrestricted sharing of data and business processes among any connected application or data sources in the enterprise.”

B1i Framework is the only integration framework with SAP Business One DI Adapter and integrates seamlessly SAP Business One with any application. CitiXsys is the leader of B1i integration services with largest number of B1i consultants globally engaged in several projects.

Connect SAP B1 bidirectional with SAP ERP

Business Challenge

Customer is running SAP NetWeaver including some SAP R/3 systems and SAP XI. The customer’s policies do not allow direct connection to their R/3 systems. Task is to connect SAP B1 bidirectional. The customer has old fashioned EDI interfaces for inbound from an external system and is providing data for external systems in an oracle database.

Solution

Send SAP B1 changes to SAP R/3

We are leveraging the customer’s existing EDI like Flat File interface of SAP XI to send data from SAP B1 to SAP R/3. This is possible by introducing a B1iSN integration scenario “SAP B1 to File”. The inbound is SAP B1 event triggered, the outbound is defined as TXT formatted outbound file. Automatically the data is converted to the required format by the defined outbound control document. The complete conversion is based on definitions (position, length, default values, left/right justify, leading zeros, etc.). This guarantees real-time updates from SAP B1 in SAP R/3 with minimal implementation effort, high change friendliness, aligned with the customer’s policies and optimal reuse of existing interfaces.

Send R/3 data to SAP B1

The SAP R/3 is maintaining tables in an oracle database. We create a new B1iSN integration scenario “DB to SAP B1”. With each new record SAP R/3 is maintaining an ‘open’ flag. In the ‘db inbound’ we specify the scheduler to retrieve data on an hourly basis and the sql-statement to retrieve the data of interest. The ‘where clause’ makes sure to retrieve only new not yet retrieved data which is flagged as ‘open’. By the definition of the clear statement, B1iSN will automatically set this flag to ‘closed’ after successful data import in the same transaction. By xsl transformation the data is formatted to the SAP B1 XML format and imported to SAP B1 by the DI API.

Related Topics

B1i Integration Services

Business One Integration Framework (B1if)

Business One Branch Consolidation (B1BC)

Business One integration with SAP NetWeaver (B1iSN)


Integration Services

CitiXsys provides application integration services to large corporations with SAP ERP having subsidiaries, vendors and associated companies running SAP Business One.

Few companies using B1i Framework

Few companies using B1i Framework

Supply chain management applications (for managing inventory and shipping), customer relationship management applications (for managing current and potential customers), business intelligence applications (for finding patterns from existing data from operations), and other types of applications (for managing data such as human resources data, health care, internal communications, etc) typically cannot communicate with one another in order to share data or business rules. For this reason, such applications are sometimes referred to as islands of automation or information silos. This lack of communication leads to inefficiencies, wherein identical data are stored in multiple locations, or straightforward processes are unable to be automated.

Enterprise application integration (EAI) is the process of linking such applications within a single organization together in order to simplify and automate business processes to the greatest extent possible, while at the same time avoiding having to make sweeping changes to the existing applications or data structures. In the words of the Gartner Group, EAI is the “unrestricted sharing of data and business processes among any connected application or data sources in the enterprise.”

B1i Framework is the only integration framework with SAP Business One DI Adapter and integrates seamlessly SAP Business One with any application. CitiXsys is the leader of B1i integration services with largest number of B1i consultants globally engaged in several projects.

iVend Loyalty released by CitiXsys Technologies

iVend Loyalty – a multi platform loyalty application released by CitiXsys Technologies

New York, NY, January 10, 2011: iVend Loyalty was released today at the NRF where CitiXsys Technologies is showcasing its flagship retail application – iVend Retail. iVend Loyalty, which is currently integrated with iVend Retail comes with web services based APIs making it possible to integrated it with any Retail or Enterprise Application. The application is designed on the latest technologies and platforms to provide scalability, maintainability and ease of use.

CitiXsys Technologies is one of the largest Software Solution Partner to SAP. With this release, CitiXsys reiterates its commitment to its partners and customers to reap business benefits from robust and intuitive applications.

“We are upbeat about the release and it has been our constant effort to provide all our partners/customers a more value driven and focused solution to address their business needs. iVend Loyalty is a highly configurable web services driven solution adding tremendous value to any business by configuring, managing and tracking all schemes for enticing the customers and maximizing the brand value of the merchant.” says Kamal Karmakar CEO CitiXsys Group.

About iVend Loyalty:

iVend Loyalty is an application platform which is designed to significantly improve customer retention by offering an enhanced value for their money. The cross platform application is well suited not only for the retailers but also in non-consumer industries like manufacturing and trading. iVend Loyalty is currently integrated with iVend Retail and has capabilities to integrate with any Business Management or Retail application using the universal and platform neutral web services based APIs.

Features offered by iVend Loyalty add tremendous value to any business by configuring, managing and tracking all schemes for enticing the customers and maximizing the brand value of the merchant. [Read more…]

iMatrix – Item Matrix Solution now certified on SAP Business One 8.8

CitiXsys Technologies now has its Product Variant Management Solution – iMatrix certified by SAP for SAP Business One 8.8

New York, January 4, 2011:  A must have in a retail environment; iMatrix – Item Matrix Solution for SAP Business One is a product variant management solution from CitiXsys Technologies. Normally licensed along with iVend Retail, and one of the most popular CitiXsys solutions in UK & EMEA, iMatrix – Item Matrix Solution for SAP Business One is now certified by Integration and Certification Center at SAP.

The certification confirms that the development of the solution is as per the SDK development guidelines prescribed by SAP and logically completes the Retail suite from CitiXsys Technologies – all certified by SAP. CitiXsys Technologies is one of the largest Software Solution Partner to SAP. With this certification, CitiXsys reiterates its commitment to SAP, its partners and customers to reap business benefits from robust and intuitive applications.

The certification is an expression of our commitment to adhere to the stringent guidelines laid by SAP. This (certification) will allow partners to confidently position iMatrix with iVend Retail in the market and will provide an assurance to the customers of licensing an SAP certified solution.” says Pankaj Mathur – Vice President, Solutions Delivery, CitiXsys Technologies.

About iMatrix  – Item Matrix Solution for SAP Business One:

iMatrix is a product variant management solution on SAP Business One designed for companies that sell, manage or procure items that have similar attributes such as size, color or style. A matrix item structure is identified by a parent item and categorized by child items having similar attributes.

It extends the single level item definition schema of SAP Business One and allows creation of variants and child items to a parent item. It does that by creating and attaching different attributes to parent items. These attributes can then be inherited by the child items.

It compliments SAP Business One in Retail Industry by allowing easily filtering of items with similar attributes allowing faster and error free order entry for multi-attribute items.

[Read more…]

Continuous Learning – A must for Successful Organizations

Recently I was talking to a few partners who created successful businesses selling CitiXsys products with SAP in their local geographies. I noticed that the most important aspect of their business success is also their biggest challenge – “User training”. A Retailer can have a world class ERP like SAP Business One, SAP Business All-in-One or similar products, with iVend Retail to streamline their Retail Operations. Customers with warehouses successfully implement Inventory Pro for their Inventory Management System with SAP Business One however the major challenge remains training the users who actually use the systems implemented for an agile function.

I have seen that every time a partner sells one of our products, he engages our consultant to train customer users. Larger partners have in-houses resources trained in CitiXsys products who in-turn impart training to the customer. This is not only expensive but also impractical at times. Getting all users in one room is a challenge. Not only this, but also the training resources need to block their calendar for individual training.

Considering all these aspects, we have developed e-learning lessons for all our products. These are very detailed training lessons hosted at http://learning.citixsys.com/. A partner can have their implementation & training consultants fully trained on our products. Customers can have their users undergo these online lessons at their own time and get fully acquainted with the system.

Business Growth Tool – E-learning is an essential tool for business growth. Employees need to be coached and their skill set must be upgraded on a continuous basis. If done correctly,this can produce great results by decreasing costs and improving performance. Unlike one time classroom session, online courses are available to every employee of the company.

Productivity Increase – Video based sessions are great tool to give the skills needed to enhance performance and productivity. Video based platforms are not bound by location or time; one can control training’s impact on production by training people at any time – whenever there is a need. By including online learning in your employee skill enhancement exercise, you’re asking people to do more with less.

Anytime Access – Classroom learning requires participants to align their schedules to the training calendar.  Online courses eliminates this because the courses can be accessed anytime, anywhere and from any location.  I have seen our own colleagues take lessons of product line to enhance their skill set.

Building interest – Interactive video based courses in combination of PowerPoint presentations and recorded demos can produce a very rich learning experience that is repeatable.  Some good practice sessions with feedback can make an environment help learners retain the course content that will produce positive results.

Reduced Training costs – With an effective learning schedule, each time the course is accessed by your colleagues, your ROI improves because you are not spending on classroom training.  You also have savings immensely by not hiring a consultant, reducing travel, and improving skill set.

Make it a part of your appraisal system – A well-trained employee is worth several times more than an unskilled employee. When you hire a new employee or you implement a new system, you need to train your existing employees; the biggest challenge is training them adequately to make them productive as soon as possible. E-learning bridges the gap between employee skill set and newly implemented system.  You get more from the software much more rapidly with a fully trained user.

Keeping the benefits of video based online interactive courses in mind, CitiXsys has developed e-learning lessons of all products. Some lessons are available in interactive mode with powerpoint slides and online demo combined whereas some are available in the good old youtube.com and other media. Idea is to make a lesson available in whatever form for the users so that learning remain continuous. There are new lessons uploaded on a weekly basis. Enjoy learning and happy holidays.

Upgrade to iCharge 10.0 – An SAP Certified and PCI Validated Solution

iCharge 10.0 is an enhanced, upgraded version of CitiXsys Credit Card solution.

iCharge – Credit Card Application is the complete credit card processing SAP certified application. iCharge processes credit card information between sales transaction in SAP Business One and payment processor service that obtains authorization information needed to approve the transaction. For all sales transactions generated in SAP, iChargeauthorizes and settles payment in real time and integrates them back into SAP.

iCharge 10.0 is an SAP Certified and a PCI Validated Solution which is currently available as a Beta release and will be available as GA (General Availability) from 16th Dec 2010

Please get in touch with your local reseller or directly with CitiXsys to schedule an upgrade

Why Upgrade

  • Synchronized processing between Credit Card Gateway and Document Posting in SAP Business One
    Do you face situations where the document that was posted successfully in SAP and the credit card authorization/settlement failed? Or let’s or say, the authorization/settlement of credit card was done successfully and the document did not post in SAP? With iCharge 10.0 you can now keep your payment gateway and the SAP completely synchronized.
  • Draw multiple base documents while Authorization / Settlement of Credit Cards
    Do you want to create one invoice for multiple deliveries for a customer? Do you want to create one delivery for multiple sales orders?With iCharge 10.0 you can now draw multiple base documents for creating a single target document.
  • Void Authorized transactions
    With iCharge 10.0 now you need not to go to Payment gateway and void the payment manually. Voiding the authorized transaction is just a click away with iCharge 10.0
  • Support for SAP Business One Approval Procedures
    Does your business process require the document to pass through many approval stages?With iCharge 10.0 you can now have sales orders, deliveries and invoices go through SAP Business One configured approval processes.

What’s New?
To read more about What’s New, please click here for a detailed comparison between the two versions of iCharge.

iVend Retail 5.4 certified on SAP Business One 8.8 by SAP ICC

CitiXsys Technologies now has its flagship application iVend Retail certified by SAP for SAP Business One 8.8

New York, October 22, 2010: After releasing iVend Retail compatible with SAP Business One 8.8 in February, CitiXsys Technologies now has iVend Retail certified by Integration and Certification Center at SAP.

The certification confirms that the development of iVend Retail is as per the SDK development guidelines prescribed by SAP and comes just in time when the retailers are gearing up for the festive season. CitiXsys Technologies is one of the largest Software Solution Partner to SAP. With this certification, CitiXsys reiterates its commitment to SAP, its partners and customers to reap business benefits from robust and intuitive applications.

“The certification is an expression of our commitment to adhere to the stringent guidelines laid by SAP. This (certification) will allow partners to confidently position iVend in the market and will provide an assurance to the customers of licensing an SAP certified solution.” says Pankaj Mathur – Vice President, Solutions Delivery, CitiXsys Technologies.

“I’m very impressed with the overall functionality of iVend.  I’ve worked on “RetailPro” and “BeanStore” in the past and iVend is by far the most user friendly POS software I have used” says Marco Albrecht, Director Operations, In Add Minus, Los Angeles, CA

[Read more…]

iVend Retail gets Commidea payment processor certification in United Kingdom

London, October 18, 2010: iVend Retail, a complete Retail Management Solution from CitiXsys Technologies gets Commidea payment processor certification in UK for Ocius for PC.

CitiXsys Technologies got iVend certified for Commidea’s Ocius for PC solution – the leading credit card processing solution in the market today.
iVend is seamlessly integrated with the latest version of SAP Business One 8.8. With this certification, CitiXsys reiterates its commitment to the UK market and its partners in UK & EMEA to reap business benefits from robust and intuitive applications.

“The certification process was done on-site which involved executing a set of test scripts. We were able to execute the test scripts flawlessly. iVend now has certified integration with Commidea payment processor in UK for Ocius for PC. We congratulate the iVend team and CitiXsys Technologies to have achieved this certification.” says Michael Dunkling – Implementations Consultant, Commidea Ltd.

“Commidea certification has been eagerly awaited by our Customers and Partners in UK & EMEA. I feel happy and proud that this certification will help our customers carry out credit card transactions with ease. This certification will also benefit our partners to confidently position iVend Retail in UK&EMEA” says Abinesh Agarwal – Product Manager iVend, CitiXsys Technologies

[Read more…]