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.