on 03-29-2017 9:40 AM
for example, first field + second field = third field, confirm what I want is more difficult than 1+1 = 2, Just want to know is there possible to add formula into field?
Below show the image I try to open Meter Reading tab to edit, however cannot open to view tab inside Visual Studio for SAP B1.(same thing happen when I open inside SAP Business Studio)
Johan
Thank you for reply.
How if we create a totally new form by add on, so that i can put formula in the field I want through SAP Busines ONE visual studio.
But problem is
1) How create new table in database, I create table "MASTERDATA" inside the SQL database, but when I use it inside visual studio datasource, when I execute it, it show tables not found?
2) What code need for find, add and cancel button in this SAP B1, just normal code for c# window form?
3) When I click add in new form, is that new form can use "previous" , "next" , "first", and "last" button?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chris,
For this purpose we have the Formatted Search (popularly known as FMS). The FMS allows you to apply formulas using SQL code.
So for example if you want first field + second field = third field then you apply an FMS with a query, and regular refresh to the third field. The query would look something like this: SELECT $[table.FirstField] + $[table.SecondField]
Only drawback of FMS for your scenario, is that it only allows for a single triggering field, so either first field or second field, but not both.
Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.