SAP Business One – Improving The Speed Of Reports Along with general consultancy, system implementations, training, interfaces and development of SAP Business One, one of the most requested jobs is to improve the speed of reports. Reports can be written in SQL Queries, Crystal Reports or any other reporting tool. As a rule of thumb, if a report is running slowly, it is due to either the way it was originally written or the data it is reporting on. With some out of the box thinking it is usually possible to massively reduce the way a report runs by approaching it from a different view point. I have personally managed to reduce report run times from 90 minutes…
Category: SAP Business One Support
An SAP Business One Stock Report with All Items The following stock report will display all Items with or without quantities in Stock. select t0.ItemCode, t1.ItemName, isnull(t3.OnHandQty,0) as ‘In Stock’, t2.BinCode, t2.SL1Code, t2.SL2Code from OITW T0 inner join OITM t1 on t0.ItemCode = t1.ItemCode inner join OBIN t2 on t2.AbsEntry = T0.DftBinAbs left outer join OIBQ t3 on t0.ItemCode=t3.ItemCode and t0.WhsCode = t3.WhsCode where t2.BinCode between [%0] and [%1] order by t2.SL1Code, t2.SL2Code, t0.ItemCode
This is a short and to the point Crystal Reports post to assist anyone trying to count the number of Groups in a report. If you are using Crystal Reports you will know that the Summary does not work on Groups. We hope you find the following useful! Crystal Report Group Count To count the number of Crystal Report group entries in a report, rather than the entries within a Group, use the following process: 1) Create a formula @GroupCountReset and place this formula in the page header and make it suppressed (hidden) whileprintingrecords; numbervar i:=0; 2) Create another formula @GroupCountEval place this in the group header where you want to count the entries and suppress if required whileprintingrecords;…
If you are looking for keyboard shortcuts for SAP Business One click to download the helpful little file on this post! Use SBO faster and more efficiently. Impress your colleagues. Click to download! SAP-Business-One-Keyboard-Shortcuts
SAP B1 Version 9 and above users – take note! SAP Business One users who are temporarily locked out whilst another machine is logged in as the same user isn’t an error! It is new, core functionality to stop license over usage (read as abuse!). Once the second machine has logged off the first user unfreezes. Please note: If a SAP B1 named user is being used for interfaces/ APIs then there are possibilities that locks or blocks will occur! Not good for an interface and there are better ways of overcoming this. A bit about the SAP Business One license model. SAP Business One licenses are based on a named user licensing model. Each user name needs…
SAP Business One Missing Months / Periods in Reports Have you run a Balance Sheet, Profit and Loss or Trial Balance in B1 V8.1, 8.2 or a recently upgraded V9 and discovered that you are missing periods or months from the report? Weird, eh? It is as much use as an Octopus tentacle snooker cue, but don’t worry, it can be fixed! The issue appeared in V8.x and is fixed in V9. The problem is, you upgrade V9 and the problem still exists. The problem has been fixed and will not occur again but you need to fix the cause of the issue to see the months again. All this requires is a quick fix to a users…