SAP Business One B1i SSL Integration Installation (Details)

See my video on the B1i installation process including my AutoSSL tool by clicking here.

Main SAP Note 2019275 (click for link)
NOTE: This article has been adapted from the main SAP note and expanded upon based on several installations.

Prerequisites

  1. You need to have B1i installed
  2. You need the current .keystore password located at: C:\Program Files (x86)\SAP\SAP Business One Integration\IntegrationServer\Tomcat\conf\server.xml
  3. Search the XML document for the keystorePass attribute. Default that I have observed has been sapB1iP
  4. You need a domain name associated with your raw IP address. IE, mobile.lhimports.com as an example. This must resolve to their static IP address with an A record in the subdomains DNS.

Initialize OpenSSL

  1. Go to: http://slproweb.com/products/Win32OpenSSL.html
  2. Download and install Visual C++ 2008 Redistributables (x64)
  3. Download and install Win64 OpenSSL v1.0.2d Light
  4. Install everything with default settings
  5. Read more

SAP Business One: EFT Bank File Format (Electronic Funds Transfer)

Since SAP Business One 9.0 I had been hearing about new EFT capabilities built right into the system and I had a client request this feature so I decided to really dig into the subject. So after a LOT of investigation and testing I will summarize in plain English what I found.

EFT_02

(NOTE: my focus here is on EFT files, NOT bank reconciliation files but SBO can do this as well. I will attempt to note this whenever possible.)

SAP Business One Has a Really Well Thought Out EFT System

It’s hard to find and understand but it is well thought out once you get the hang of it. It can do EFT files for payment, import files for bank reconciliation and generate CSV files in specific format for any other file type you would want to work with. I was using it specifically for an EFT outgoing payment file to a bank for payments.

Read more

Make a Pareto Chart in Crystal Reports

I had recently needed to make a Pareto analysis chart in Crystal Reports and couldn’t figure out how to do it through the chart expert.

The trick is to Record Sort the data into the order you want and it will sort the bar chart the same way. I did an SQL view to which listed my unique descriptions and then a COUNT() operation.

Read more

Tips & Tricks: Inventory Audit Report Doesn’t Match GL Balance

At some point in your SAP Business One consulting career you will get the question as to WHY the Inventory Audit Report (Inventory >> Inventory Reports >> Inventory Audit Report) doesn’t match the GL balances or balance sheet totals.

Generally this question is during the year end closing process where accountants want to see what makes up the balance of the inventory balance.

Read more

Tips & Tricks: Last Price Report in Sales Documents

I have had the request from several SAP Business One customers to view the last price given to a specific customer for a specific item. Well the only real solution I could come up with would be to make an FMS on the price with a query. This is an OK solution but I came across a much slicker solution when searching the SAP help file for something completely unrelated.

Read more

SAP® Business One: Crystal Reports Address Fix

Working with the different fields for addresses can be a pain.  They have many different fields which will confuse users and not to mention most fields won’t even print.

Even with careful control of all of the form settings you are likely to have issues where a user tries to enter a piece of information and it doesn’t show correctly (typically there are gaps in your address when printed).

Read more

Crystal Reports Conditional Grouping Method

Conditional grouping was a big challenge for me until I figured out this method. If I wanted to group by one thing then by another using a parameter or condition it was nearly impossible. The only solution was the occasional nested group with suppression but this is often not an ideal solution.

Read more

Automatic BP Numbering in SAP Business One

NOTE: THIS IS OBSOLETE IN SOME VERSION OF 8.82. THERE IS AN AUTOMATIC CUSTOMER, VENDOR NUMBERING MECHANISM UNDER THE DOCUMENT NUMBERING FORM

Hello,

I have been honing this code for a while now and wanted to share it.  I ended up using it again today and I impressed myself.

This will automatically sequence up BP codes splitting vendor and customers (+leads).  It also has an optional prefix.

Read more

Compliance. Best Friend of Process

I work closely with business processes in my career.  As I’m designing processes I need to keep in mind many things, accounting, operations, business analytics, etc.  BUT the one thing often left out is COMPLIANCE.  Not that I leave it out, just that I discovered the cool word for it.

Read more