Share
ReportHello
in table 25 Vendor Ledger Entry , i need to add new field named Vendor Name exist in table 23 Vendor.
Can any one help me i m amateur developper
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hello
in table 25 Vendor Ledger Entry , i need to add new field named Vendor Name exist in table 23 Vendor.
Can any one help me i m amateur developper
*This post is locked for comments
think you
think you very much Alexander
You can add new field name as "Vendor Name" as Object ID of 50000 series.
Then you have to add code in Code Unit 12 to update the values in this field.
OR if you don't to write code u can use the look up option for that field in the table 25.
Create new feild-50001-Vendor name-go to properties of the field-Table Relation-give table name as 23 and field as "No."-save.
After doing this you will get the look up in the Vendor name field of the new table which will populate the data from 23 table.
Hope this will help you.
You can also add a new field and make it a FlowField. Set this up to lookup for vendor name in Vendor table by Vendor No. field, available in Vendor Ledger Entry.
In Development Environment, press "Design" on a Vendor Ledger Entry table. In the last row, create a new filed in 50,000 range (e.g., 50001) and name it Vendor Name, set it a text type with 50 length (check that it is not smaller then the Vendor Name field in 23 Vendor table). Then, in the properties of that field, select FlowField in the FieldClass property, and in the CalcFormula property setup a formula to lookup in Vendor table for Name by Vendor No. field. The formula should look like this: Lookup(Vendor.Name WHERE (No.=FIELD(Vendor No.))) . Compile the table and run it - you should have your name filed filled with data automatically.
This is quite easy option to add fields filled with data and avoid programming - however you should use it very carefully as many additional flowfields might critically degrade the database performance.
You can add field Vendor Name in 50000 series. You need to add code in CU 12 to fill the value in this field and you would require developer license for the same
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (