155
Hi NAV experts
I have the following requirement:
On the Items pane I can see Item's price by vendor with the following fields
"Item No.", "Vendor No.", "Direct Unit Cost", etc
My question is... how can I add the vendor name field on that form?
Thanks in advance
*This post is locked for comments
Angel, you should be able to create additional fields; try putting all your additional objects within 50.000+ objects range. It is the range for additional objects for users.
If you try creating field in 50000 Series, it should definitely work in your license as well . Check the screenshot attached in my earlier thread.
Thanks for help, I tried this way too, but my license don´t allow me to add fields to Purchase Price Table.
So I decided use a variable in the form
Thanks again
You can also add a Vendor Name field in the Purchase Price Table and define it as a FlowField, that would LookUp by Vendor No. in the Vendor table and take the Vendor Name from Vendor Table.
That would not require programming as such, and enable the Vendor Name in all current Purchase Price tables. But, beware that adding too many flowfields can degrade database performance.
Thanks both for answer the Variable solution works great
Hey Angel,
You have two solution here.
1. Add a Field in the Purchase Price Table. - "Vendor Name". Write this code on the OnValidate Trigger of Vendor No.
Vendor.GET("Vendor No.");
"Vendor Name" := Vendor.Name.
Vendor is the the Varibke referencing Vendor Record.
2. Add a Varible in the Form and Name it as "Vendor Name". Write this code on the OnAfterGetRecord of the form.
Vendor.GET("Vendor No.");
"Vendor Name" := Vendor.Name.
Add Vendor Name in your Page.
You can create new flow field "Vendor Name" in Purchase Price Table (Table ID - 7012). Refer below screen shot.
Later you can add this Vendor Name in Page 7012 - Purchase Prices.
The form that I'm trying to modify is "Purchase Prices (7012)"
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (