Auto Apply Customer/Vendor Payments

depro
Member Posts: 46
Hello,
I`m trying to auto apply customer/vendor payments during bank statement import.
I`m importing Bank Statement directly to General Journal Lines.
Then serching for matching entries and put GenJnlLine."Document No." in "Customer/Vendor Ledger Entries"."Applies-to ID";
But during posting my payment does not apply with invoises.
I`m examinating Codeunits 101, 111 and Forms: 232 and 233.
But in code there i can not find any other field which is beeing modified during applying entries.
Probably i`m missing somethig, but in debugger i can`t find my mistake.
Regards,
I`m trying to auto apply customer/vendor payments during bank statement import.
I`m importing Bank Statement directly to General Journal Lines.
Then serching for matching entries and put GenJnlLine."Document No." in "Customer/Vendor Ledger Entries"."Applies-to ID";
But during posting my payment does not apply with invoises.
I`m examinating Codeunits 101, 111 and Forms: 232 and 233.
But in code there i can not find any other field which is beeing modified during applying entries.
Probably i`m missing somethig, but in debugger i can`t find my mistake.
Regards,
0
Answers
-
You need to fill the "Applies-to ..." fields from the General Journal Line. Try to see how the standard fills those fields when doing it manually.
Salut!Laura Nicolàs
Author of the book Implementing Dynamics NAV 2013
Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.0 -
Thank you very much kitik!
Works great!0 -
welcomeLaura Nicolàs
Author of the book Implementing Dynamics NAV 2013
Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.0 -
Did you try to apply multiple lines (while posting them via General Journal) to a single Ledger Entry?
If yes, could you share the solution?
I tried by entering applies-to id, but it only applies the first line of many posted lines, despite the fact they all share the same applies-to id.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