Archive for Queries
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 [...]
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: [...]
