SAP Business One Knowledge Base

A collection of tips, tricks and tutorials on all things SAP Business One.

Inventory Audit Report Does Not Match GL Account Balance

At some point working with SAP Business One you are going to get a question about GL account balances not matching the inventory audit report. Generally this is related to the year-end-closing process. Unlike accounts receivable and accounts payable, inventory…

Posted by: Michael Taylor

What are SP_TransactionNotification & SP_PostTransactionNotice?

Two handy features built deep into the Microsoft SQL backend of SAP Business One are SP_TransactionNotification and SP_PostTransactionNotice. These two stored procedures have different functions depending on what you are trying to accomplish with custom SQL code. You can use them to make subtle changes in the process flow.

Posted by: Peter Canale

Commission Groups and Sales Employees

Tracking commission by sales employee in SAP Business One is simple and easy to setup! If you have a stable of sales people on your team, you know how critical it is to get this part right. With a new system your team will be watching their numbers like a hawk to make sure they're getting paid exactly what they deserve. SAP Business One makes this a snap to track commission and create reports.

Posted by: Peter Canale

Journal Vouchers in SAP Business One

Journal vouchers are a way to create a draft of a journal entry. The voucher signifies intent to make an adjustment to the journal. Think of journal vouchers like a draft sales order or other marketing document in the SAP Business One system. Using vouchers is critical for maintaining a audit trail of your financial transactions and is included for use in SAP B1.

Posted by: Peter Canale

Prompting for User Input in SAP Business One Queries

SAP Business One actually has some very slick functionality when it comes to queries. One of those pieces of extra SQL is prompting a user for input. It provides an excellent way to create SQL queries that anyone can use without knowledge of writing SQL query.

Posted by: Peter Canale