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...
Hi Johan,Thanks very much for this advice - it's very helpful! Ideally I want to be able to provide a validation like a pop-up with a message. That is why I was trying to use B1UP validations. It seems very limiting that it's not possible to use valu...
Hi Johan,Thanks for this. Is it possible to use the result of a formatted search inside of a validation?I would prefer to alert a user at the point at which they're entering a unit price, that the unit price is very different to the last purchase pri...
Hi Johan,Yes, I know about the issue with the '$[$4.0.0]' being part of the string. I was just showing my code like that to illustrate what I was trying to do (i.e. use the UI value in the .NET dynamic code). Yes, I have tried what you suggested (and...
