Check GL vs. Sub Administrations
mgm
Member Posts: 126
One of my customers has a simple question that many of you must have been faced before.
He likes to have an overview (form, report, etc.) of Amounts posted in a period on a G/L Account, checked with the Entries in the Sub-Administration.
Eg. The Amount on the Receivables Account 1300 in a certain period should be the same as the sum of Cust. Ledger Entries (or Det. Cust. Ledger Entries) in the same period. The same with accounts for Vendors, VAT, Jobs, FA, etc.
Is there standard functionality for this, or has someone created a report for this?
I wonder how to do this: how to find the entries in a sub-administration that are of should have been posted to a certain G/L Account?
He likes to have an overview (form, report, etc.) of Amounts posted in a period on a G/L Account, checked with the Entries in the Sub-Administration.
Eg. The Amount on the Receivables Account 1300 in a certain period should be the same as the sum of Cust. Ledger Entries (or Det. Cust. Ledger Entries) in the same period. The same with accounts for Vendors, VAT, Jobs, FA, etc.
Is there standard functionality for this, or has someone created a report for this?
I wonder how to do this: how to find the entries in a sub-administration that are of should have been posted to a certain G/L Account?
0
Comments
-
I believe Busines Snapshot that's created by Cost Control Software has something to what you need.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 -
Thanx Alex, I'll have a look at it with my customer.0
Categories
- All Categories
- 73 General
- 73 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 328 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