Author: Mike
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 You need to have B1i installed You need the […]
Tips & Tricks: Make Life Easier for Sending Email Screenshots
When working with my support clients I often request screenshots. I see many different variations in terms of what I receive. Some use clipper programs and some literally print the screen, highlight and then scan it back into the system. PRO Tip: Add crop to your Quick Access toolbar in […]
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 […]
How to Pull UDF Dropdown Descriptions into Queries / Crystal Reports SAP Business One
When you make a dropdown list in SAP the data is stored as a code in the system. When trying to do an SQL query or Crystal Report you will find that only the code is output so the user reading the query / report doesn’t see the description.
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 […]
Advice You Didn’t Ask For: A Word On Your Thoughts
Positive self-talk sounds pretty hippy-dippy but it can make a huge difference in your every day life. If you walk around all day telling yourself you suck and that you are ugly and that you can’t do it (whatever IT is) then it will become true. “Your mind will be […]
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 […]
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 […]
“The cure for anything is salt water. Sweat, tears, or the sea.”
This is an excerpt