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
- 269 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 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
Options
Relationship between three tables
Leshabela
Member Posts: 35
Hi, all.
can any1 tell me the relationship between these tables --> 1. Purch. Invoice Header 2. Vendor ledger Entry 3. Chech ledger Entry
we added a fields for names and some of the names are not been shown in check ledger entry and now I want to write script that will populate names in Check ledger entry from the Purch. Invoice Header, but it seems i've got to go through vender ledger entry.
thanks in advance.
can any1 tell me the relationship between these tables --> 1. Purch. Invoice Header 2. Vendor ledger Entry 3. Chech ledger Entry
we added a fields for names and some of the names are not been shown in check ledger entry and now I want to write script that will populate names in Check ledger entry from the Purch. Invoice Header, but it seems i've got to go through vender ledger entry.
thanks in advance.
Learning Never End.
0
Comments
Sales Invoice Header - No. field
Get Vendor Ledger Entry where Document No. = No. in Sales Invoice Header.
Get Bank Ledger Entry where Document No. = Document No. in Vendor Ledger Entry.
Get Check Ledger Entry where Bank Account Ledger Entry No.= Entry No. in BanK Ledger Entry.
hope you understood.