Confused about the index

S0918423470
Member Posts: 159
Hi al,
Here are my case :
In the Sales Invoice form, i clicked the func Sales History with the Customer A , there were 400 posted invoices, and the show is ok.
I make another invoice with Customer B, there is only 1 posted invoice with 3 lines but the dialog appears with the content :
Counter : 29635
Table : Sales Invoice Lines
Keys : Document No, Line No.
I checked the key, they used the primary key and we dont need to Setcurrentkey explicitly.
Although i clicked another such as : Quotes, Orders... this dialog always appears.
I checked and found that the first line of the B's invoice is 14208th record in table 113 and i don't know why the dialog appears?
Maybe, the reason is the position of the record in the table??
I'm confused about that??
Any body can explain this for me??
Thanks
HN
Here are my case :
In the Sales Invoice form, i clicked the func Sales History with the Customer A , there were 400 posted invoices, and the show is ok.
I make another invoice with Customer B, there is only 1 posted invoice with 3 lines but the dialog appears with the content :
Counter : 29635
Table : Sales Invoice Lines
Keys : Document No, Line No.
I checked the key, they used the primary key and we dont need to Setcurrentkey explicitly.
Although i clicked another such as : Quotes, Orders... this dialog always appears.
I checked and found that the first line of the B's invoice is 14208th record in table 113 and i don't know why the dialog appears?
Maybe, the reason is the position of the record in the table??
I'm confused about that??
Any body can explain this for me??
Thanks
HN
0
Comments
-
Please try to debug it and track it through item application entry table.Mukesh Sharma0
-
Hello muksha,
I debuged several times, i didn't specify any strange things and not see where the table Item application was used. It's normal , i only clicked Sales History to show Form 7171.
On the form 7171, Subform PostedInvoices have :
Subform ID : form 7174
Subform view : Sell to Customer no. It's second key of T133 Sales invoice line table.
Subform Link : Sell to Customer No. = No.
These things are very normal, but sometimes the searching appears , sometimes it's ok.
I don't know how to explain this pb clearly.
](*,) ](*,)0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions