Apply to customer entry (closing "by date")???

alantviti
Member Posts: 12
When I set on the customer card that their entries be closed "by date", and when I post the customer payment through the journal, it applies to and closes the oldest ENTRY (entry no.) in the table customer ledger entry regardless of the date it was created!!!
How do I make it apply to so it closes the oldest entry starting with the oldest DATE???
The sorting in the table customer ledger entry is done by the primary key Entry No. I am afraid I will mess up a lot of things if I set sorting by Date (making it a key in the table).
Does anyone have any explanation or advice?! Please help!
How do I make it apply to so it closes the oldest entry starting with the oldest DATE???
The sorting in the table customer ledger entry is done by the primary key Entry No. I am afraid I will mess up a lot of things if I set sorting by Date (making it a key in the table).
Does anyone have any explanation or advice?! Please help!
0
Comments
-
:shock:
I'm now looking at my "Apply Customer Entries Form". It appears to me that if you set "Apply to Oldest" as the Payment application method on the customer card it's applying it by "Oldest Due Date" not by Entry No.
Appling to oldest Due Date would make more sence.
By double clicking on the Customer Legder Entry Due date you can Change it. So Change one of them & Rerun the Apply Customer Entries From to see if it's Resorted.
Curiously waiting... :-k0
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