Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Link factbox based on temporary table to Sales Lines NAV2009
rsaritzky
Member Posts: 469
Hi all,
This question has been asked in a variety of ways/scenarios, but I did read as many topics as I could, but I don't think anyone confirmed this can be done.
This is NAV2009R2.
BTW, I did read the following thread - the last post on this thread is my question which is unanswered as far as I can tell.
viewtopic.php?f=5&t=20084&hilit=singleinstance&start=15
I will restate the scenario.
I want a factbox tied to the Sales Line table from the Sales order subform on the Sales order page.
The factbox is of type "Listpart".
What the factbox does is for the Item No. on the Sales line, it computes a bunch of availability information based on location - it's not the standard "Item Avail by location" info. So I built a function to compute this information and store the records in a new custom table "Item Availability Fact Box Source".
So, from a functional standpoint, what I want to do is:
a. When the user clicks on a sales line, the factbox recomputes the information for the item on that sales line
b. Redisplays the factbox with the current item's information.
The factbox needs to be a listpart because there are a variable number of lines.
In NAV2009, there's no OnAfterGetCurrRecord trigger. The only way I've read and/or discovered how to change the factbox contents in a subform is to use the ProviderID link, which means that the factbox must have the same source table as the calling subform.
Has anyone done this successfully? Steps? Examples?
Thanks
Ron
This question has been asked in a variety of ways/scenarios, but I did read as many topics as I could, but I don't think anyone confirmed this can be done.
This is NAV2009R2.
BTW, I did read the following thread - the last post on this thread is my question which is unanswered as far as I can tell.
viewtopic.php?f=5&t=20084&hilit=singleinstance&start=15
I will restate the scenario.
I want a factbox tied to the Sales Line table from the Sales order subform on the Sales order page.
The factbox is of type "Listpart".
What the factbox does is for the Item No. on the Sales line, it computes a bunch of availability information based on location - it's not the standard "Item Avail by location" info. So I built a function to compute this information and store the records in a new custom table "Item Availability Fact Box Source".
So, from a functional standpoint, what I want to do is:
a. When the user clicks on a sales line, the factbox recomputes the information for the item on that sales line
b. Redisplays the factbox with the current item's information.
The factbox needs to be a listpart because there are a variable number of lines.
In NAV2009, there's no OnAfterGetCurrRecord trigger. The only way I've read and/or discovered how to change the factbox contents in a subform is to use the ProviderID link, which means that the factbox must have the same source table as the calling subform.
Has anyone done this successfully? Steps? Examples?
Thanks
Ron
Ron
0