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…
Content SearchVideo Training
When running your year-end-closing reports it is common that your trial balance and your aging reports not to match initially. I frequently receive support requests claiming that something must be wrong with the system because the two balances do not…
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.
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.
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.
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.