Boyum IT - SAP Business One CRM for Outlook Overview Video

Nice integration, with quite a few very nice features. Worth watching, and it is even not so expensive...

Delete data from SAP Business One with DTW (Data Transfer Workbench)

Just a quick note: to delete data use '/' (backslash) in your template instead of the data. It will delete the content of the field. Note: you can delete data, you can't delete entire record from the database with DTW.

For example to delete the name of the customer, the template would look like this:

CardCode,CardName

CardCode,CardName

C001,/

C002,/

Uploading PaymentTerms with DTW and setup the defaults

Step 1, create the payment methods
Step 2, prepare a DTW file for the payment methods: CRD2 - BPPaymentMethods

Structure:
ParentKey, LineNum, PaymentMethodCode
CardCode, LineNum, PymCode
S001, 0, LLOYDS_CHQ
S002, 0, LLOYDS_CHQ
S003, 0, LLOYDS_CHQ
S001, 1, LLOYDS_GBP_BACS
S002, 1, LLOYDS_GBP_BACS
S003, 1, LLOYDS_GBP_BACS

Step 3, prepare a DTW file for to set up the default payments methods: OCRD - BusinessPartners

Structure:
CardCode, PeymentMethodCode
CardCode, PymCode
S001, LLOYDS_CHQ
S002, LLOYDS_GBP_BACS
S003, LLOYDS_GBP_BACS

The default payment method for supplier one (S001) will be Cheque, for the others (S002, S003) will be BACS.

B1if Debugging: red arrows are not displaying on the flow diagram

When you test the processing of the scenario step design by default the integration framework is not displaying the debug information.

Go to the config file, and change the logging level.

C:\Program Files (x86)\SAP\SAP Business One Integration\IntegrationServer\Tomcat\webapps\B1iXcellerator\xcellerator.cfg

Defaults you have to change:
.level= SEVERE
com.sap.b1i.bizprocessor.level = SEVERE
com.sap.b1i.coordservice.level = SEVERE
com.sap.b1i.utilities.level = SEVERE
com.sap.b1i.dblayer.level = SEVERE
com.sap.b1i.xcellerator.level = SEVERE

New values for debugging:
.level= CONFIG
com.sap.b1i.bizprocessor.level = CONFIG
com.sap.b1i.coordservice.level = CONFIG
com.sap.b1i.utilities.level = CONFIG
com.sap.b1i.dblayer.level = CONFIG
com.sap.b1i.xcellerator.level = CONFIG

Re-start the SAP Business One Integration Service, start testing again and voilà:

B1if note: switching on WebDAV

Edit the file: C:\ .. \tomcat\webapps\B1iXcellerator\xcellerator.cfg

Enable WebDAV in B1if as changing the parameter to:

xcl.webdav=full

Re-start the SAP Business One Integration Service

How to predict the future?

The Answer is Simple. The Answer is SAP HANA.

SAP Business One mobile multiple device - User / device id

I connected my iphone, and my ipad to our demo system.

One user can use multiple devices. I had to use forward slash (/) as a separator when I entered the device ids for my user.

 

 

B1 integration framework v1.22 - new Cockpit

I like this new Cockpit in the B1if. :-)

Multi level drill-down in SAP Crystal Reports

Creating a new report with drill-down is fun and easy with Crystal reports. I've just finished a full drill-down Profit and Loss report with multi level drill-down. The first level of drill-down displays the details, with the second level you can go directly to the transaction in SAP.

Drill down to SAP was easy, only small challenges:
- I had to find a golden arrow picture. I just cut it one from my screen, and paste it to my report.
- Drill Down to SAP Business One from the report requires a link. Remember: when you add the link, click on the button next to the field of the link, and add the link. It was not enough just to fill in the field.

This is the syntax what I used for linking:
'http://$b1$/link?table=OJDT&key='+CStr({Command.TransID}, 0)

If you use this sample, you will be able to drill down to the Journal Entry in SAP B1.

Note: you will need the TransID to add to your report before you do the linking.

Easy?

SAP Business One mobile app for Android

Installation:

- Go to Play Store
- Search SAP Business One
- Select SAP Business One (SAP AG)
- Press Install
- Start SAP Business One
- Configure the logon information or just start the Demo

Quick and easy.

Crystal reports Add-in menu is missing?

You are using Crystal reports and with one of the SAP Business One, or Crystal Reports upgrade you lost your Add-in menu, and you are not able to save your reports back to SAP Business One?

Try this:
Step-1
Go to Crystal reports installation package, and find the directory "SAP CRAddin Installation"

Step-2
Run the application "SAP Business One Crystal Report Integration Package" as administrator

Once you are ready, enjoy your Add-in menu again, and Save your nice reports to SBO.