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,…
Category: SAP Business One 9
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…
SAP Business One 9.0 Business Accounting System SAP Business One 9.0 Advanced GL Account Determination SAP Business One 9.0 provides a flexible and centralised system to manage inventory G/L account determination. With the advanced G/L determination rules, you can assign inventory G/L accounts by item…