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…
Category: SAP Business One Consultancy
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 B1 Version 9 and above users – take note! SAP Business One users who are temporarily locked out whilst another machine is logged in as the same user isn’t an error! It is new, core functionality to stop license over usage (read as abuse!). Once the second machine has logged off the first user unfreezes. Please note: If a SAP B1 named user is being used for interfaces/ APIs then there are possibilities that locks or blocks will occur! Not good for an interface and there are better ways of overcoming this. A bit about the SAP Business One license model. SAP Business One licenses are based on a named user licensing model. Each user name needs…
Want a list of your Business Partners email address for marketing? Email your business partners from your favourite email marketing site by using this report query. It’s SQL that you run from within Query Generator or SQL Server. Simply copy the code between the /* … and … */ for your version of SAP B1 and paste into the Query Generator. Here’s something for free! Have a great bank holiday weekend! SAP Business One SQL Server version – /* –Start. Marketing Email List V1.1 select t1.CardCode, t2.cardname, t1.E_MailL from ocpr t1 inner join OCRD t2 on t1.CardCode = t2.cardcode and t2.cardtype = ‘C’ –End. Author Stuart Folley www.1dash1.co.uk 0843 886 1449 */ …
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…
Senior Implementation Consultant – SAP Business One (SAP B1 ) Home Based in Bedfordshire, Buckinghamshire, Cambridgeshire, Hertfordshire, Surrey, Oxfordshire, Northamptonshire £35k – £50k + Bens SAP Business One (SAP B1) Implementation Consultant SAP Business One Certified ERP Project Definition & Costing Project Life Cycle Pre-Sales Data Migration Installation Configuration Product Training Accounting background (ideally AAT) SQL CRM SQL Server Crystal Reports DTW Senior Implementation Consultant – SAP Business One, SAP B1 A Senior SAP Business One (SAP B1) implementation consultant is required by 1 dash 1. We want an experienced and enthusiastic SAP B1 Senior Consultant with an ERP/ SAP Business One implementation background to join our team. An Accounting background would be an advantage. ERP Consultant? Do you…