SELECT A.BASE_REF AS Docnum, A.DocLineNum, A.ItemCode, A. Dscription, T2.Quantity, t3.BinCodeFROM [B1_OinmWithBinTransfer] A INNER JOIN OIGE B ON B.DOCNUM = A.Base_ref AND CONVERT(VARCHAR, ...
Dear Experts,Am new to B1if i i need your help i am trying to create a BP from the sql table to sap b1 using B1if , i have created the Inbound , Outbound and struck in the processing.while trying to debug the processing and trying to check the SQL ca...
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 2. Capitalization document ...
Thank you for the kind and gracious welcome, @lenastodal.I am truly honored to be here and excited about the opportunity to collaborate with this amazing group! ️ Looking forward to working together!
HI Try this linkODLN T0 INNER JOIN dbo.DLN1 T1 ON T1.DocEntry = T0.DocEntry INNER JOIN dbo.OITM T2 ON T2.ItemCode = T1.ItemCode INNER JOIN dbo.OCRD T3 ON T3.CardCode = T2.CardCode ...
1- Sap Service Manager -> License Manager -> Settings -> Configure Security -> Logged in to System landscape director (by entering B1 site user password).2- Add a new connection with the IP address of the server.3- And then after refreshing, it showe...