Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Inserting Additional text line in Combine Shipments through event subscription
mfh
Member Posts: 27
Hi,
I want to add functionality that inserts the Sales Shipment Header field 'Your Reference' as a text line in the Sales Invoice, before the Sales Shipment Lines are inserted. I am using R295 Combine Shipments or the function 'Get Receipt Lines from the invoice card.
In order to do this without modifying the standard object T111 Sales Shipment Line, I would like to use an event from this table:
OnBeforeInsertInvLineFromShptLineBeforeInsertTextLine
In a CodeUnit, I wrote below code. However, this gives me the error 'Record in Table Sales Line already exists: Line No.=10000.
I guess I'm doing something wrong here (besides not hiring a skilled developer
), but what?
I want to add functionality that inserts the Sales Shipment Header field 'Your Reference' as a text line in the Sales Invoice, before the Sales Shipment Lines are inserted. I am using R295 Combine Shipments or the function 'Get Receipt Lines from the invoice card.
In order to do this without modifying the standard object T111 Sales Shipment Line, I would like to use an event from this table:
OnBeforeInsertInvLineFromShptLineBeforeInsertTextLine
In a CodeUnit, I wrote below code. However, this gives me the error 'Record in Table Sales Line already exists: Line No.=10000.
I guess I'm doing something wrong here (besides not hiring a skilled developer
), but what?Regards,
Michiel
Michiel
0
Answers
That's not the solution. Even if I use a "Line No." := 5000, I would receive the same error, but then on line 5000, of course.
But I did found out why I am getting the 'Line No.=10000 already exists' error: the Insert at the end of my code is not necessary, because this is handled by the original code in T111 after having returned from the extension. So I was Inserting a second time on the same record. Without the Insert in my extension, the result is this:
And that's almost what I expected, except for the fact that I am now missing the default 'Shipment No.:' text on the first line. For this particular case this is fine, but I would actually rather have the new text line inserted after the default 'Shipment No.:' line. I guess there should be an Insert of this line before going into the event, but I do not now how to achieve this. Any ideas?
Michiel