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

I ♥ Podcasts

I am a podcast freak.  I listen to probably two per day while working, doing yard work, travelling, random projects or really any time I’m occupied (I find it better than music in some cases because I don’t need to change the track or album and it keeps me focused).

What is a Podcast?

A podcast is a periodic radio show that you subscribe to.  Typically audio only but occasionally video as well.  Using the Apple podcast app on your iPhone (or however you get it on Android) you subscribe to the individual shows and as new episodes are published they are automatically downloaded (kind of like an audio only PVR).  Podcasts are the replacement for radio shows and while you can normally listen to them live you would normally just listen to them at your convenience.  As opposed to having to ‘tune-in’ at times convenient for the radio stations.

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

Block Websites on Windows Easily

I have experimented with productivity software and browser control apps, etc.

This is the most simple way to block sites you don’t want people to access on your machine including yourself. IE, Facebook, Twitter, etc.

Navigate in My Computer to C:\Windows\System32\drivers\etc and open a file called ‘hosts’.

Read more

Dramatically Shrink File Sizes for MS Word Manuals

If you are composing a technical document containing screenshots you will find the file size balloon very quickly. This makes it difficult to transmit via email and just wastes space on your hard drive.

There is a very simple way to compress the entire document without losing any of your details or pretty pictures, screenshots or diagrams.

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

Use Your Phone as a Wifi Hotspot

Just a quick tutorial. The driver for my laptop suddenly crashed whether due to some sort of hack attack or just general Microsoftery. I thought that tethering my iPhone using WiFi might kick it back on since my laptop recognized wireless networks but just didn’t display them to be connected. I discovered something interesting and I thought I would share it.

All you really have to do is have a newer iOS version (my example uses 4.3.2), an iPhone cable (technically you can wirelessly connect to your phone as well but as mentioned my phone had no wireless at the time) and just switch on the setting.

Read more