former_member675796
Participant
Member since ā€Ž04-30-2020

User Statistics

  • 49 Posts
  • 1 Solutions
  • 10 Kudos given
  • 3 Kudos received

User Activity

Hi there, Iā€™m experiencing some problems with SAP Business One where when creating a query that will prompt a user for a value (such as an ItemCode or a CardCode) I am unable to create the query successfully. Strangely, this also throws different...
Hi experts! Based on Boyum's documentation it would seem that it is possible to assign the result of a Subquery to a @STOREXX value, like: @STORE1 = (SELECT LastPurPrc FROM OITM WHERE ItemCode LIKE '[$38.14.0]'). However, this doesn't seem to b...
Hi Experts! I have some code that creates a SQL string and then uses it as a query with the 'Recordset.DoQuery' method of the SAP Business One .NET framework. I have been following an online tutorial. However, I am not able to get the code to run...
Hi experts! I would like to use the results of an SAP B1 SQL query in the SQL condition of a B1 UP validation. I am aware that I can't use a parameter for this, but I am struggling to find an alternative method to perform this kind of operation. ...
Hi experts! I am currently replacing some SAP Business One alerts in SAP Business One by using B1 Usability Package validations. However, it seems that they have no 'System Information' for identifying them in the form? If you tick 'System Inform...