Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Direct Link from Ledger entry to Invoice & Credit Memo c
mhitendra
Member Posts: 6
Hi,
We want to have a direct link from the Ledger entry screen to the Invoice Card & Credit memo card. Once this is achieved we need to add this as a subform to the Customer Form.
We managed to get the direct link (in the Ledger entries form) by creating a button and setting its properties to link the No. in the Posted Invoice Form to the Document No. in the Cust. Ledger Form. But how can we make it dynamically select a Credit Memo card when a Credit memo entry is selected.
Also, the new challange is, when we try to add the 'Customer Ledger form' as a SUBFORM to the main Customer Form, it displays the ledger entries in the same screen fine but when clicked on the Invoice card there (present in the sub form) it gives the following error.
A value in the filter 'AHRAM UN P.CODE.11511' in the No. field in the Sales Invoice Header table is too long for the field type.
Type: Code20
The value it picks up is from the Address2 in the Main Customer Form.
Can you please help us out here.
Thanks
We want to have a direct link from the Ledger entry screen to the Invoice Card & Credit memo card. Once this is achieved we need to add this as a subform to the Customer Form.
We managed to get the direct link (in the Ledger entries form) by creating a button and setting its properties to link the No. in the Posted Invoice Form to the Document No. in the Cust. Ledger Form. But how can we make it dynamically select a Credit Memo card when a Credit memo entry is selected.
Also, the new challange is, when we try to add the 'Customer Ledger form' as a SUBFORM to the main Customer Form, it displays the ledger entries in the same screen fine but when clicked on the Invoice card there (present in the sub form) it gives the following error.
A value in the filter 'AHRAM UN P.CODE.11511' in the No. field in the Sales Invoice Header table is too long for the field type.
Type: Code20
The value it picks up is from the Address2 in the Main Customer Form.
Can you please help us out here.
Thanks
0
Comments
Just suggested something similar to solve this - check out this post
http://www.mibuso.com/forum/viewtopic.php?t=26190
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
1) The values used to filter can't be bigger than the size of the field filtered. Based on the description of the issue seems like the "no." field is being filtered by using the "description" field in the customer ledger entry instead of the document no. of the entry.
2) The filters to match a customer ledger entry with the posted document are not just the document no., but also the posting date.