Archive for Reporting
SAP Business One: Commonly Used Tables for Queries
For those who would like to try their hand at doing some queries for formatted searches, alerts, or reports, but do not know what the common table names are, here is a short list. Check back and I will update the list from time to time. Master Files: OITM = Item Master OCRD = Customer, [...]
XL Reporter
I too a look at the sample report pack from SAP and I noticed that when they created a graph (even over expanding groups), they were selecting the cell below the value as well. When I first added the graph to the report, I selected the expanding row value (e.g., $B$6) only as the data [...]
Creating Custom Queries in SAP Business One
There are two tools for creating custom queries in SAP Business One, both of which will walk you through making your own query: Query Generator Query Wizard The end result of both tools listed above is a results window with the actual query statement in the top portion of the window and any data that [...]
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 [...]
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: [...]
