Exclude Posting Groups from Customer List

MBRAVO
Member Posts: 5
Hi
Our tax laws forces us to arrange invoices of the advanced deposits we receive by the clients as the posting group DEF ( Deferred ). The question is that once I run the Aging to check out the debt of the clients after invoicing them I have a customer balance that is not correct.
The client paid, I arranged the invoice and while I cancel the DEF, I still have wrong balance.
Can I exclude from the aging the DEF and only leave the invoices.
It is quite complicate.
Thanks
Mbravo
Our tax laws forces us to arrange invoices of the advanced deposits we receive by the clients as the posting group DEF ( Deferred ). The question is that once I run the Aging to check out the debt of the clients after invoicing them I have a customer balance that is not correct.
The client paid, I arranged the invoice and while I cancel the DEF, I still have wrong balance.
Can I exclude from the aging the DEF and only leave the invoices.
It is quite complicate.
Thanks
Mbravo
0
Comments
-
This problem is resolved in 5.0 with the Prepayment feature. Is it possible to upgrade to 5.0 for your implementation?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 -
Before Navision 5.0 usually you could insert a negative G/L Entry to the amount customer has previous paid. Can you insert some thing line that?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