Close By Entry Field on the Cust. Ledger Entry Table

senna
Member Posts: 44
I am querying a problem that I have replicated in both 3.10 and 3.70 where based off how a payment is allocated to an invoice, I have found instances where the Close By Entry, Close by Date, Close by Amount are all left blank when you look at the entries in the Cust. Ledg Entry Table.
The method i am using to allocate payment is as follows :
1. Cash Receipt Journal - post payment in respect of an invoice (but not allocated at this stage).
2. Cust Card > Cust Ledg Entries > Apply Entries then locate the invoice and Post Application. (this would be at a later date when it had been identified what invoices matched the payment).
For info the customers used in these examples have their Payment Allocation set to 'Manual'
I just don't understand why the fields are left blank in the Cust. Ledger Entry Table when it is clear they have been closed off and applied to an existing entry.
Anyone with any knowledge about this, please reply to the post with any comments
Thanks in advance! :P
The method i am using to allocate payment is as follows :
1. Cash Receipt Journal - post payment in respect of an invoice (but not allocated at this stage).
2. Cust Card > Cust Ledg Entries > Apply Entries then locate the invoice and Post Application. (this would be at a later date when it had been identified what invoices matched the payment).
For info the customers used in these examples have their Payment Allocation set to 'Manual'
I just don't understand why the fields are left blank in the Cust. Ledger Entry Table when it is clear they have been closed off and applied to an existing entry.
Anyone with any knowledge about this, please reply to the post with any comments

Thanks in advance! :P
0
Comments
-
I have entries which are closed and the 'Closed by Date' and 'Closed by Entry No.' fields are blank
...noticed that payment/credit memo entries are always blank? I'm not a finance expert but that seems to be standard.
What is confusing me is the closed 'invoice' lines which have zero value, nothing applied and have 'closed by date' = blank ??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