From purchase order subform to posted purch. invoice subform
Nav-Noob
Member Posts: 5
Hi
I'm new to this site, but I already found some good tips just reading some of the posts. Now i have a question myself.
I have added a new field to table 39: Purchase Line & added the field to the "Purchase Order Subform" and all is well.
Now i want to add the field to the posted purchase invoiced lines (subform) as well. How do i go about that.?
What changes (and where) do I need to do?
The field is Type Code.
Kind Regards
Jan
I'm new to this site, but I already found some good tips just reading some of the posts. Now i have a question myself.
I have added a new field to table 39: Purchase Line & added the field to the "Purchase Order Subform" and all is well.
Now i want to add the field to the posted purchase invoiced lines (subform) as well. How do i go about that.?
What changes (and where) do I need to do?
The field is Type Code.
Kind Regards
Jan
0
Comments
-
Add the field with the same fieldnumber and fieldtype to table 123 "Purch. Inv. Line. Then the field gets automagically updated after posting the Purchase Order. This because the function TRANSFERFIELDS is used in codeunit 90, to copy the fields from table 39 to table 123.No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)0
-
Welcome to Mibuso.
Do you want to flow the same value from Purchase Order Sub form to Purch. Invoice subform?
If yes then simply add the field to table 123 - Purch. Inv. Line with same field ID as in Purchase Line table..0 -
Thanks guys ... i Like magic stuff happening on its own
0 -
-
One more thing ..
I have noticed that our Nav Consultant creates fields in the database while it's in production. Sometime this causes the the users having to restart their nav clients because of app. errors. Schould'nt you wait untill the Nav clients have all been logged off? Or can you just get away with that i Navision? (we are using Nav 5.0 Sp1).
Can i do the above change while in production?
Regards
Jan0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions

