Member since ‎11-19-2013

User Statistics

  • 129 Posts
  • 1 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

Hi All,I need to add sub query in main query. Main Query:SELECT distinct T0.[DocNum], T0.[DocDate], T3.Series,T3.[DocNum], T3.[DocDate], T3.[CardName], T3.[Address], T3.Address2, T3.[DocTotal], T3.[RoundDif], T2.[ItemCode], T2.[Dscription], T2.[Quant...
Hi All,Presently I'm using SAP B1 9.2 version. I'm trying to create some custom alerts using query but they are not working. I never faced this issue in any previous versions. same queries are working perfectly. and Standard alerts are working in 9.2...
Hi All,I'm using multiple UOM. I created one udf under item master data warehouses as ' U_SinU' (Field Type is Quantity).I tried like this but i know somewhere i'm wrong.fms:IF $[OITM.CntUnitMsr] = 'Cases1'Select $[OITW.OnHand.number] * 24ELSE 0 END ...
Hi all,Doctime field in SAP is showing as 12:33PM. But if I'm trying to fetch the doctime field in CR, it is showing as 1233(numeric).How to convert this into TIME?Thanks&Regards,Saikrishna.
Hi all,I have two UOMs . 1) Gallon 2) KgsConversation factor is 1 Gallon = 3.785Kgs.Stock is always in Kgs.But sometimes I raise sales order in kgs and sometimes in Gallons.If I raise in kgs . there is no problem.But if I raise order in Gallons, how ...