Ah, the dreaded “Date Deviates from Permissible Range” error. It always seems to pop up at the worst possible moment—usually when you’re in a hurry to post transactions. Don’t worry, though. This error is your system’s way of reminding you that it’s time to create a new posting period. Let’s fix that and get you back on track with some clear and easy-to-follow instructions. Why Posting Periods Matter Posting periods in SAP Business One are time frames during which your company’s transactions can be recorded. They’re essential for keeping your financial data organised and ensuring your reports align with specific accounting periods. Without them, your transactions will be left out in the cold—or, more accurately, rejected with that…
Tag: SAP Business One
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…
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 !!
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
Shared by Owen Slater on the SCN SAP Business One SQL Batch or Serial Number Quantities in a specific Bin Location declare @WhsCode nvarchar(9), @ItemCode nvarchar(21), @BinLocation nvarchar(228) set @WhsCode = ’01’ set @ItemCode = ‘B10000’ set @BinLocation = ’01-ABC’ select T0.BinAbs, T0.ItemCode, T2.onHandQty, T4.DistNumber, T4.MnfSerial, T4.LotNumber, T5.DistNumber, T5.MnfSerial, T5.LotNumber, T4.AbsEntry, T1.BinCode, T4.AbsEntry, T5.AbsEntry, T1.WhsCode from OIBQ T0 inner join OBIN T1 on T0.BinAbs = T1.AbsEntry and T0.onHandQty <> 0 left outer join OBBQ T2 on T0.BinAbs = T2.BinAbs and T0.ItemCode = T2.ItemCode and T2.onHandQty <> 0 left outer join OSBQ T3 on T0.BinAbs = T3.BinAbs and T0.ItemCode = T3.ItemCode and T3.onHandQty <> 0 left outer join OBTN T4 on T2.SnBMDAbs = T4.AbsEntry and T2.ItemCode = T4.ItemCode left outer…