

First it need the object type and second it need the primary key If Golden Arrow type is Multi then in these columns you the needed data for the error. Multi Golden Arrow object type column + Multi Golden Arrow primary key column If type is not LB: UF then leave this fields blank. If you have defined the Golden Arrow type to Universal Function this is the UF run. If you however would like to control the column widths manually you can write the desired width in pixels here If made editable you can see it is a combo boxīy default, a SQL Report will try to best fit the columns based on the values. Turn technical value into meaningful value (NB: Technical value need to be alphanumeric for this to work.

You can however override the style of the column to be either Checkbox or Combo box If nothing is defined, then a SQL Report will just show values.
#Universal type client requested font windows
NB: IF YOU CHOOSE TO SEARCH ON DATES OR AMOUNTS YOU WILL NEED TO SEARCH USING THE WINDOWS FORMAT. NB: ONLY WORKS IF YOUR REPORT DOESN'T USE A COLLAPSE LEVEL AND IS SHOWN IN A WINDOW (NOT USE IN SQL REPORT TAB) If you check this, a search field will be added to the report and you will be able to search in this column of the report (you can mark several columns as searchable)

This is beneficial if you need technical values for additional work on the SQL Report (using B1 Validation system) or for the columns of object-type and primary key in use of Multi golden arrow. If you check this, then this column will be hidden. NB: Please note that if you make fields editable it is not possible to use the SAP Filter options (SAP Limitation) Open the column for editing (Used in combination with the Select-target option where the user should have the option to select a entered value back) Right Justify the data in the column (Example, it makes sense if prices are right-justified)Īdd a sum row for the column (This can only be done when column data is numeric and collapse level is not used) NB: to add an golden arrow going to a Beas work order position you need to create a combination key from the DocEntry and LineNumber to use the golden arrow on like shown below.ĬAST(T0.DocEntry AS NVARCHAR(254)) + '|' + CAST(T0.LineNumber AS NVARCHAR(254)) AS ObjectKey NB: Golden arrow Type LB:(Universal function) does not work on B1 Dashboards and will be ignored. In order for these to work the PMX WMS add-on need to be running and be version 2020.09 or higher

Here you can define the title of the column The column you are defining formatting forĭocNum is Col 1, CardCode is Col 2, CardName is Col 3 and DocTotal is Col 4
