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…
Author: 1dash1
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…
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…
Exciting times at 1 Dash 1. Over the last 2 weeks we have been assisting an Oil industry client by building a Production Process solution to enable them to work more efficiently and provide their customers with the best service possible by ensuring that their…
A slip or a knock can send your iPhone to the ground with a crash and the screen is smashed! This happens to thousands of people a year but don’t worry; we can fix your screen fast and inexpensively! Simply contact us and we will…
Pay As You Go and Monthly Contract IT Support Packages We will tailor a monthly support package to your needs or simply pay for IT Support as you go (pay as you go)! IT isn’t easy; especially with multiple device types and the ever increasing…
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]’ …
Exciting times! Our SAP Business One support lines are now open! SAP Business One Support What’s included in our support services? Telephone Support Email Support Remote Access Support Ad Hoc Support Prices Only £37.50 + VAT per support call* Monthly Support Just £500 + VAT…
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…
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…