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
SAP Business One. ERP system solution. Small & Medium Business system.
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.
SAP Business One – Date Deviates From Permissible Range The ever popular Date Deviates From Permissible Range error message appears for two reasons and IS easily solved! The usual occurrence is in the New Year when new posting periods need to be created. To resolve this simply create a new posting year/period in (and watch out for your sub-periods!): Within SAP Business One in the Main Menu or top menu Modules option go to – Administration –> System Initialisation –> Posting Periods The second occurrence is when you are trying to post documents with a due date that is not covered by the created Posting Periods Due Date range. This usually occurs towards the end of the year. You can solve this…