B1 Newbie - Need Help

[Former Member]

Hi all,

I'm new to SAP and need to write an app that exchanges data with SAP B1 - Its going to be between a Point of Sale app and SAP

The Problem is that I dont know were to start(with SAP).

Has anyone written a point of sale or similar using SAP?

I Have many questions, here are a few - My app will import data sent from the POS app - the data will be transactions eg Sales,Payments etc... How would I import this into SAP?

What Tables would I use?

All suggestions,advice,help welcome.

Thanks

[Eneveux · Accepted solution]

Avish,

I guess the first question is do you have the SAP Business One SDK and are you a programmer? Integration via the SAP Business One SDK requires programming using Visual Basic, Visual Basic.Net, C++, Java, etc. You can use any program language and development tool(s) that can work with/use COM objects.

If you do not want to use the SAP Business One SDK and create a program to do the integration, the suggestion to use the iBolt product from Magic Software is one solution. Another thought is to use the Data Transfer Workbench (DTW) which is a data integration took that is from SAP. The DTW uses the DI API or the Business Logic Layer, you can import external data into SAP Business One. Using the DTW you can integrate transactions in "batch mode", which also begs the question if you need to do realtime integration or batch.

Hope this helps,

Eddy

[Former Member]

Hi Avish,

I have been involved in integrating 2 point of sale systems with SAP business one. My advantage being that I have worked with SBO and also a bit with the SDK. I would not suggest integrating with SBO at all if you don't know anything about the product. SBO has a very comprehensive SDK, but still quite complex. I would suggest working through a training course or training material. Also don't write data directly into the database as a lot of tables are being updated with one simple transaction. The SDK was developed for your needs so learn to use it and have fun!

Regards,

Adele

[Former Member]

Thanks Adele,

I agree with you but unfortunately the project requires that SAP be used. I am also working with the objects exposed thro' the DI API - I just need to know the basic operations required for exchanging data with regards to a POS.

Thanks Again

[Former Member]

Avish - you might want to check into a middleware application that can help you out. Perhaps something like MagicSoftware's iBolt. (no, I don't work for them

Anyway, it wraps the DI functionality for you.

www.magicsoftware.com

Just a thought.

Also, you can do a lot through XML with business one. Even though the DI server is young and a little quirky it is very powerful. A great common ground for integration is XML. There are some excellent tools out there for helping map/translate XML data from one source to another. For instance, the Altova products or Stylus studio. Even visual studio itself has decent XML tools built in.

Good luck with your project!