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 Training
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;…
SAP Business One Year End Closing Instructions SAP kindly provide a 50 page document which provides in depth instructions on the Year End process but most people only need to know how to run the actual Year End process in SAP B1. Because it is a once yearly procedure, it is forgotten year to year. Here are the instructions for running the Year End process in Business One. Year End Process in SAP B1 To carry forward the balances of the P&L accounts to the corresponding account in the balance sheet (or several different balance sheets), you can use the period-end closing function. You can store the results initially as a report and then post them at a…
Using variables in SQL queries for SAP Business One is straight forward for simple select statements but what about the more complex variables or if you want to declare a variable for your SQL? Answer: You have to get a bit more creative! See the example below. To select a from and to date as a variable in a declare statement you have to add a nifty bit of extra code. /* /SELECT FROM [dbo].[VPM1] T0/ declare @fromdate as datetime /* WHERE */ set @fromdate = /* T0.DueDate */ ‘[%0]’ /SELECT FROM [dbo].[VPM1] T1/ declare @tilldate as datetime /* WHERE */ set @tilldate = /* T0.DueDate */ ‘[%1]’ select OVPM.docnum, VPM1.dueDate,VPM1.CheckNum, VPM1.Branch, VPM1.BankCode, VPM1.CheckSum, OVPM.CardName,…
If you are interested in writing your own SQL queries for SAP Business One the following will assist you. Basics of SQL Writing for SAP Business One SQL query and related terms Before going into the details of SQL query, I would like to briefly introduce some basic database concepts because SQL is a database language for managing data in Relational Database Management Systems(RDBMS). RDBMS RDBMS is a Database Management System that is based on the relation model. Relational here is a key word for RDBMS. You will find that data is stored in the form of Tables and the relationship among the data is also stored in the form of tables for RDBMS. Table Table is a key component within a database.…
We are currently taking bookings for training courses throughout August 2013. Our training courses can either be on your site for a maximum of 8 people or at an external location suitable for attendees from various companies. On site training is excellent for your employees as it will be specific to your system as it will be based on your Test system. External multi-company training is more suited for non specific training requirements and usually proves extremely useful for those candidates wishing to network with peers from other industries. Our SAP Business One training courses can be specifically tailored to your system and, dependent on time, our time can be used for consultancy questions. We will listen and…