VAT Information Exchange System (VIES)

VIES VAT number validation (online)
You can verify the validity of a VAT number issued by any Member State by selecting that Member State from the drop-down menu provided, and entering the number to be validated. http://ec.europa.eu/taxation_customs/vies/vatRequest.html

FAQ
http://ec.europa.eu/taxation_customs/vies/faqvies.do#item_13

WSDL file
http://ec.europa.eu/taxation_customs/vies/checkVatService.wsdl

European VAT ID number directory
You can search here for European Value Added Tax identification numbers (often called “VAT registration numbers” in the UK) for making international payments as required by law. This service is free of charge and you do not need to register.
http://www.vat-reg-no.org/

Link to xPath tutorial

XPath is used to navigate through elements and attributes in an XML document.

• Expressions
• Standard Functions
• xPath and XSLT

Tutorial is here on this page:

http://www.w3schools.com/xsl/xpath_intro.asp

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

Little programming: recursive function call

I have found this good example on stackowerflow.com as an illustration of the recursive function call. This is really beautiful:

A child couldn't sleep, so her mother told a story about a little frog,
  who couldn't sleep, so the frog's mother told a story about a little bear,
     who couldn't sleep, so bear's mother told a story about a little weasel
       ...who fell asleep.
     ...and the little bear fell asleep;
  ...and the little frog fell asleep;
...and the child fell asleep.

In SQL SERVER a recursive query is good to compose a tree of Bill of Materials (BOM).

Coresystems Webinar - UDT Handler

SAP Business One 9.2 review

Finally I had time to review the highlights of the new version. My favourite is the Support User, means no more please logout while I have a look... This is so cool! :-)

oAuth tutorial

"The idea behind OAuth is simple: Provide a standard way for accessing to protected resources, without the need of sharing passwords." 

 Link to the tutorial: http://blog.oauth.io/oauth-tutorial

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

SAP Business One 9.1 PL09 is out

Just upgraded my SBO system on my laptop. Have to do the same on the servers.

As I saw the upgrade of the HANA version is available as well.

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.

 

 

SAP Business One v9.1 PL08 - Connected Clients

SAP Business One v9.1 PL08 (MS SQL, and HANA)

Finally you can disconnect the clients in a nice and easy way.
Utilities / Connected Clients

B1 integration framework v1.22 - new Cockpit

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