Get The Most Out Of SAP Business One You have been using SAP Business One for some time; it could be months or years – but are you getting the most out of your system? Here are a list of questions to ask yourself: Are you using spreadsheets for a system process? Are your reports giving you data that you have to then transfer to Excel or Word before they are submitted to someone else? Are you calculating VAT outside of SAP Business One? Are you calculating anything outside of SAP Business One? Do you enter payments manually into your bank? Are you sending documents one by one via post or email? Are you missing data within SAP…
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…
I have been asked this on site a few times over the last few months and thought it worthwhile to post the answer for anyone looking for an answer. Question: Is it possible to change the order of the User Defined Fields (UDFs) in SAP Business One? Answer: The system automatically assigns a numbering order to the UDFs as they are created. It is possible to change the order of the UDFs. You have to open the form that you wish to change the UDF order of and ensure that you can see the UDF window. You then go to Tools/ Customisation Tools/ Settings/ Order and reassign the numbering order here. Number 1 will be the top UDF displayed.…
SAP Business One SQL Prompt Variables /* SELECT FROM [dbo].[OSLP] T1 */ declare @slpName as varchar(155) /*WHERE*/ set @SlpName = /* T1.SlpName */ ‘[%0]’ /* SELECT FROM [dbo].[OCRD] T2 */ declare @CardCode as varchar(15) /* WHERE */ set @CardCode = /* T2.CardCode */ ‘[%1]’ SAP Business One HANA Prompt Variables /* select from [dbo].[OINV] T0 */ /* select from [dbo].[OSLP] T1 */ Declare FromDate timestamp; Declare ToDate timestamp; Declare SALESEMP char(155); SALESEMP := /* T1.”SlpName” */ ‘[%0]’; FromDate := /* T0.”DocDate” */ ‘[%1]’; ToDate := /* T0.”DocDate” */ ‘[%2]’; !! Remember to end your HANA SQL Script with a semicolon and replace the single and double quotes above which are enforced formatting !!
Bookings are now being taken for September and October 2015 so don’t miss out! Courses available: SAP Business One – All Modules Crystal Reports SQL Queries for SAP Business One Implementation best practices 1 dash 1 can assist you with selecting the best ERP or Accounting software for your business.
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