Here are a few basic SQL queries to be used in SAP Business One. You can copy and paste the queries into the Query window of Business One. Simply copy between from “–begin…” to “…–end” and paste into your Query window. SQL for Open Sales Orders –begin select t0.docnum, t0.cardcode, t0.cardname, t0.sysdoctotal from ordr t0 where t0.docstatus = ‘O’ –end By Date –begin select t0.docnum, t0.cardcode, t0.cardname, t0.sysdoctotal from ordr t0 where t0,docstatus = ‘O’ and t0.docdate between [%0] and [%1] order by t0.docdate –end SQL for Open Deliveries –begin select t0.docnum, t0.cardcode, t0.cardname, t0.sysdoctotal from odln t0 where t0.docstatus = ‘O’ –end SQL for Open Invoices –begin select t0.docnum, t0.cardcode, t0.cardname, t0.sysdoctotal from oinv t0 where t0.docstatus…
Category: SAP Business One Reports
A 10 minute video of creating an advanced Crystal Report for SAP Business One. A few hints and tips are contained in the video – so don’t share! With SAP Business One and SAP Crystal Reports, customers have access to leading solutions for printing and reporting that are in use all across the world by tens of thousands of businesses. Crystal Reports, combined with SAP Business One, the powerful, yet affordable, business management software, has been designed specifically for the needs of small and midsize enterprises. Every SAP Business One customer receives one free license of the report designer and every licensed user of SAP Business One can run reports built with Crystal Reports.