SAP Business One How to Specify an On-Screen Field in a Formatted Search SQL Statement
When referencing an on-screen field in an SQL statement, specific syntax is required and unfortunately the only way that the syntax can be validated is by testing the formatted search. The error messages that result are not very helpful either.
Use the instructions in this document to build these references to on-screen fields.
Turn on the system information display via the menu path View > System Information
Hover over the desired field and look at the displayed system information in the lower left-hand corner of the screen. The information should look similar to the screen shot below:
The important pieces of information are found immediately after the “Item=” and the “Column=”
In this example, the Item designation is 178 and the column designation is 12.
When referring to this field in the query statements use the syntax:
$[$Field‘s Item Number. Field‘s Column Number.0]
So in the example we would have $[$178.12.0]
NOTE: When the field in in the header portion of the screen then the Column information will not be displayed. In this case, use a value of o (zero) where the column number would appear.
NOTE: there appear to be some cases where this syntax is modified slightly by adding a minus sign immediately in front of the Item information. So in our example the way that the tax code field would be referred to would be:
$[$-178.12.0]
- written by Joe Stevenson
Thanks to Ed Monk of SBONotes.com
© 2009, Mark Chinsky. All rights reserved. Formed in 2005. the 90 Minds Consulting Group is a collaboration of 100 Sage partners who independently join together online in a 24 x 7 private communication network to solve difficult issues for their customers. The group is not affiliated with Sage and our collaboration provides for unparalleled member access to early warnings of bugs and other issues which members in turn are encouraged to use to provide an exceptional customer experience.
« Extended Solution Hanging for MAS 90 and MAS 200 – Solved! | Home | SAP Business One Adding New Posting Periods »
Leave a Comment
You must be logged in to post a comment.