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
- 295 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
Report 120 - Aged Accounts Receivable Customization
podolly
Member Posts: 84
Dear all,
I am trying to modify this report (NAV 4.0 SP3) to fulfill our finance requirement. Here is the scenario.
1. Run the report for customer 'DC001'
2. On the option tab,
Aged As Of: 31/12/2008
Aging by: Due Date
Period Length: 1M+CM
Print Details: Yes
3. The report shows no line for section 'TempCustLedgEntryLoop'
4. Run step 1-2 again with Aging by: Posting Date, 1 line shows
Posting Date: 15/10/2008
Due Date: 15/01/2009
Original Amount: 1,000.00
Balance: 1,000.00
Zeros for all periods
We want to show the lines even if due date is later than 31/12/2008 for step 2, so that we can inform the customer there is no overdue payment, but an invoice line will due on 15/01/2009. How can I modify this report?
I have studied through the C/AL code, but cannot understand the meaning of the line:
CustLedgEntryEndingDate := TempCustLedgEntry; [In TempCustLedgEntryLoop - OnAfterGetRecord()]
I tried to show all the entries for this customer, and found that for the specific record, having outstanding 1,000.00 on the customer ledger entries, shows 0.00 for balance and not due on this report.
Can anyone advice if this is a program bug or how the program should be modified? Thanks very much.
I am trying to modify this report (NAV 4.0 SP3) to fulfill our finance requirement. Here is the scenario.
1. Run the report for customer 'DC001'
2. On the option tab,
Aged As Of: 31/12/2008
Aging by: Due Date
Period Length: 1M+CM
Print Details: Yes
3. The report shows no line for section 'TempCustLedgEntryLoop'
4. Run step 1-2 again with Aging by: Posting Date, 1 line shows
Posting Date: 15/10/2008
Due Date: 15/01/2009
Original Amount: 1,000.00
Balance: 1,000.00
Zeros for all periods
We want to show the lines even if due date is later than 31/12/2008 for step 2, so that we can inform the customer there is no overdue payment, but an invoice line will due on 15/01/2009. How can I modify this report?
I have studied through the C/AL code, but cannot understand the meaning of the line:
CustLedgEntryEndingDate := TempCustLedgEntry; [In TempCustLedgEntryLoop - OnAfterGetRecord()]
I tried to show all the entries for this customer, and found that for the specific record, having outstanding 1,000.00 on the customer ledger entries, shows 0.00 for balance and not due on this report.
Can anyone advice if this is a program bug or how the program should be modified? Thanks very much.
0