Archive for SAP Business One

Our SAP Business One resource center is now up.

We’ve just posted up a comprehensive sub-site focusing around SAP Business One.  This site contains, videos, articles, PDF’s and documents showing software in action, customer success stories, technical data etc.
Information on Crystal Reports and Xcelsius is also included.  Both these products work well with Sage MAS90 and MAS200.  Everything is wrapped up in an entertaining [...]

SAP Business One – A well written user Manual and Guide

Here is a very well written comprehensive user guide to SAP Business One. It’s in Microsoft Word format so you can customize it and make edits for your own company. We hope you find this helpful.
You can view it within the blog, or click on the link above the document to download it.
Download [...]

SAP Business One – How to Import AR Invoices, and then Import Applied Cash Receipts

Thanks to Don Shields for this overview on how to properly import Accounts Receivable (AR)  Invoices and then applied Accounts Receivable (AR) Cash Receipts into SAP Business One using the the Data Transfer Workbench ( DTW ).
Templates: (RECOMMEND TAB DELIMITED TEXT FILES FOR IMPORTS with no text identifier, stay away from .csv)
Make sure [...]

FourthShift Edition 9.0 released for SAP Business One

In a recent interview with Diane Palmquist, vice president and general manager of SAP Solutions for SoftBrands, she shared the vision that went into developing the Just Released FourthShift Edition 9.0.
From that vision came an ERP system, rewritten and streamlined with all new code (500 thousand lines v. 2 million), based on N-Tier architecture and positioned to [...]

SAP Business One XL Reporter: I added some fields, but the report produces nothing.

While listening to one of the expert sessions, I caught that XL Reporter will not show any information unless a measure (i.e., quantity, Dollar Sales, Etc.) is selected. I had created a simple customer list just to test it out and it kept returning no information. Once I added a value (measure) it produced the [...]

SAP Business One Issues Processing Vendor Payments

On several occasions I have had customers ask why they cannot process a check for a vendor. I am sure that there are many reasons, but more often than not, the A/P Invoice that they are trying to process does not have Pay To assigned to it on the Logistics Tab of the order. The [...]

SAP Business One How to Copy One Screen Layout to Another User

NOTE: This example is not recommended for novice users. You must have access to the SBO SQL Database and be comfortable with updating your production database. Updating your production database directly could void your SBO warranty and/or service agreement. Please consult with a DBA before proceeding. Updating queries cannot be run within the SBO query [...]

SAP Business One How to Access the Query Manager

Access the Query Manager in two ways:

From the drop-down menus at the top of the screen, go to: Tools -> Queries -> Query Manager

Click on the Query Manager icon located on the icon bar at the top of the screen.

The Query Manager window will appear…

Thanks to Ed Monk of SBONotes.com

How to Make a Print Layout (PLD) Report from a SBO Query

Follow these steps:

Create a Query in SAP Business One
Open the Query Manager
Find your Report
Highlight your report (single click)
Click on the Create Report button at the bottom of the window.
A window appears with the name of your query at the top of the window.
Window is divided into two parts: Top is existing reports, bottom is a [...]

SAP Business One Why do I have different passwords for each company?

A user just asked me this question, and many people have asked in the past. The answer is:

Although it may seem like you only have one login, you actually have two, one for each company. They just happen to have the same user name.
When you setup the system(s), the user names must [...]