Blogs by

Kennedy T

SELECT A.BASE_REF AS Docnum,        A.DocLineNum,        A.ItemCode,        A. Dscription,        T2.Quantity,        t3.BinCode FROM   [B1_OinmWithBinTransfer] A        INNER JOIN OIGE B             ON  B.DOCNUM = A.Base_ref             AND CONVERT(VARCHAR, B.ObjType) = CONVERT(VARCHAR, A.Transtype)

Many have encountered an issue in B1 9.0 version. Whenever they entered AP invoice for fixed asset procurement, fixed assets got capitalized. But the quantity didn’t update to fixed asset master data. 1. Invoice document

SELECT   T6.SeriesName,   T6.Series,   T0.[DocNum] ‘PO No.’,   T0.status ‘Status’,   T0.POSTDATE,   T0.[ItemCode],   T1.[ItemName],   T0.[PlannedQty],   T2.DocEntry ‘Rec Doc’,   T3.DocDate ‘Rec Date’,   T2.[Quantity],   T0.CmpltQty AS “Completed Qty”,

SAP Business One 9.1 Configurable UI &  Hide Functions…. In my past experience i have come across  many clients asking for the UI to Removed or Hidden, also they want to remove certain functionality from

In SAP Business One 9.1 we can use the Copy and paste option in the marketing documents simple steps. 1. Arrange the form settings for the rows as per the data in the excel 2.

Query for Material Consumption Reports SELECT T1.[ItemCode], T1.[Dscription],T2.[CardCode],T5.[CardName],Sum(T1.[Quantity])[Required For Month Order],Sum(T3.[Quantity])[Consumption],Sum(T1.[Quantity])-Sum(T3.[Quantity])[Net   Requirement],T2.[MinOrdrQty],T2.[MinLevel],T2.[OrdrIntrvl],T6.[Name],T2.[OrdrMulti], T2.[OnHand],T2.U_MinInvDays, ( Sum(T1.[Quantity])-Sum(T3.[Quantity]))/24 [Coverage Days] FROM OPOR T0  INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry   Inner join oitm T2 on T1.ItemCode=T2.ItemCode

Dear Experts.. In the last one year i am contributing to this place where i found many question related to how to set UDF field mandatory or Need TNSP for the UDF  as user forget

Dear All, I found many of the user asking the same question of Raw Material Consumption Query, here i have posted the sample sql code,  you can build your Own report based upon the below

Tax Query Sample for Item Group Wise for Indian Localisation …. SELECT DISTINCT(T0.[DocNum]) AS ‘INV NO’,    T0.[DocDate] AS ‘INV DATE’,    T0.[TaxDate] AS “Document Date”,    T0.[NumAtCard] AS ‘ Vendor Ref. No’,    T0.[CardName]

Query For AVG Price SELECT Distinct T0.[ItemCode], T0.[DfltWH],   T0.[AvgPrice],   T0.[OnHand] FROM OITM T0  WHERE (T0.[AvgPrice]is Null or T0.[AvgPrice] = ‘0’) and   T0.[OnHand]>=0 and T0.ByWH =’N’ and  T0.EvalSystem <> ‘F’ Union ALL SELECT Distinct T0.[ItemCode], T0.[WhsCode],