Error with report of Age Account Payable??
Pattys
Member Posts: 2
I prepare a report of Aged Account Payable, I need to know how many Vendor we have to pay this month.
To prepare the report I follow these steps:
Financial Management > Payable > Report > Aged Account Payable
Tab Vendor: Vendor Posting Group (3RD PARTY) and Outstanding Invoices
Tab Options: Aged of as (26/04/2012), Aging by (Due Date), Period of Length (1D)
This report show me, the list of the vendors with the due date of the invoices (aged overdue amounts). They are in the range of 1-30 days, 31-60 days, 61-90days, Over 120.
The problem is that only invoice of one vendor is on the range Over 120 days, but have to be between 1-30days because the Invoice Posting Date is: 02/04/12 and Due Date: 16/04/12, today is: 26/04/12
Do you know why this error happens? Because is only in this invoice that the report is wrong.
To prepare the report I follow these steps:
Financial Management > Payable > Report > Aged Account Payable
Tab Vendor: Vendor Posting Group (3RD PARTY) and Outstanding Invoices
Tab Options: Aged of as (26/04/2012), Aging by (Due Date), Period of Length (1D)
This report show me, the list of the vendors with the due date of the invoices (aged overdue amounts). They are in the range of 1-30 days, 31-60 days, 61-90days, Over 120.
The problem is that only invoice of one vendor is on the range Over 120 days, but have to be between 1-30days because the Invoice Posting Date is: 02/04/12 and Due Date: 16/04/12, today is: 26/04/12
Do you know why this error happens? Because is only in this invoice that the report is wrong.
0
Comments
-
:?:
16/04/12 is within the 30 day period of 26/04/12.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions