B1UP macro wrong decimal separator
Hi,
we have a EN-GB set database where users are working with different regional settings. The user accounts are linked with User Defaults that has corresponding date and numeric separators set. All numbers and dates in the system are displayed correctly to these users and they can enter all data in line with their regional settings which is correctly undertood and stored in SAP B1.
But we keep having crashes with our B1UP macros when storing calculated values within sessions of these users. Tried various approaches (incl. https://support.boyum-it.com/hc/en-us/articles/4410540556561-How-to-work-with-decimal-format-in-SQL-Set-command-if-comma-is-used-as-decimal-separator ) to no avail. B1UP macro seem to run within the database-set formatting (thousand separator comma, decimal separator period) but such format is not recognised within user's session context.
Using
Set($[$38.23.0]|SQL:SELECT CAST(@STORE203 AS FLOAT));
Or
Set($[$38.23.0]|SQL_INVARIANT:SELECT @STORE203);
Keeps the value in DB set format, ie. period as decimal separator which is not valid within user set formatting context.
Any ideas how to make sure the claculaeted values are formatted within user set regional options??
Please sign in to leave a comment.
Comments
0 comments