Archive for Customization
The Anatomy of a SQL Statement – The Basics (Part 1)
The Basics Writing your own query for SAP (or any system) can be very satisfying and cost effective, if you are a user of SBO. Once you understand the basics, you will be able to direct your computer to give you exactly what information you are looking for from the system. Most systems have some [...]
SAP Business One Need the Current Date to Use Within Your Query?
Get the current system date using the GetDate() value within your query… Examples: SELECT GetDate() Returns the current date Use the date for comparisons: SELECT * FROM OINV WHERE DocDate <= GETDATE() Thanks to Ed Monk of SBONotes.com
SAP Business One Query: Drill Downs from GL to the Sub-Ledgers
If you find that you need to access the sub-ledger (detailed transactions) for a query you would first start with the GL Accounts Table (OACT). Then you will need to join in the detailed journal entries in (JDT1) the join between those two tables looks like this: SELECT * FROM OACT Inner Join JDT1 ON [...]
Disable the SAP Business One Splash Screen
One way to disable the splash screen that appears when you start SAP Business One (the movie that plays with the water drop, just before the sign on screen) is just to rename the file in the program directory. I found mine in this directory: C:\Program Files\SAP\SAP Business One The file name is "sapss", right [...]
SAP Business One How to Make a Print Layout (PLD) Report from an 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: [...]
SAP Business One Importing Data from Excel
A very helpful tool to be able to create/edit large quantities of items in the Item master data is to generate an excel file with the information and then import it through the tool that SBO has for it. Since the documentation is rather poor, I’m not sure how to use all of the options, [...]
SAP Business One How to Specify an On-Screen Field in a Formatted Search SQL Statement
When referencing an on-screen field in an SQL statement, specific syntax is required and unfortunately the only way that the syntax can be validated is by testing the formatted search. The error messages that result are not very helpful either. Use the instructions in this document to build these references to on-screen fields. Turn on [...]
