Tag: SAP Business One Training

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…

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…