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,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 ...