A report to show credit invoices vs reversed (canceled) ones

Vera
Member Posts: 2
Hi there. Here is my problem.
1-credit invoices issued to client
I generate invoices (debits and sometimes credits) to bill our customers
in eSM and post them in GP/Dynamics.
When the customer "take the credit", on a payment check they will list the debit
and the credit invoices paid on that cash receipt. When I enter the payment in GP,
I start with the credit invoices and I apply them to the debit invoices on
that receipt.
2-Sometimes, after generating a live invoice, I have to reverse/cancel it
(a mistake in amount, we decided not bill at that time etc; that invoice will
not be sent to client). Because the original invoice (can be a credit or
a debit invoice) was lived and posted in eSM (Paradigm software) and GP,
I have to issue and opposite sign invoice and after posting in GP,
in order to purge them from the AR, I have to use Apply Sales Document
and offset the initial and the reversal invoice.
My problem is, if it is possible to get a report (preferably in
Smartlist, because only the Administrator has access to the Reports Module)
to distinguish between invoices reversed/canceled and credit invoices
that were included on a client payment.
I hope it makes sense what I am trying to explain here.
I looked to various screen transactions and the only difference that
I see between a credit invoice which reverses a debit inv vs. a credit
inv. on a client payment is that:
a-the first check, no difference; in both cases it will show in Applied
To Debit screen the invoice to which was applied
b-the 2nd check, it will show in Applied From Credits screen the invoice
to which the credit was applied and also a payment line (PYMNT000000977),
Type PMT. How in the world can I use these parameters to get a report.
Thank you so much.
1-credit invoices issued to client
I generate invoices (debits and sometimes credits) to bill our customers
in eSM and post them in GP/Dynamics.
When the customer "take the credit", on a payment check they will list the debit
and the credit invoices paid on that cash receipt. When I enter the payment in GP,
I start with the credit invoices and I apply them to the debit invoices on
that receipt.
2-Sometimes, after generating a live invoice, I have to reverse/cancel it
(a mistake in amount, we decided not bill at that time etc; that invoice will
not be sent to client). Because the original invoice (can be a credit or
a debit invoice) was lived and posted in eSM (Paradigm software) and GP,
I have to issue and opposite sign invoice and after posting in GP,
in order to purge them from the AR, I have to use Apply Sales Document
and offset the initial and the reversal invoice.
My problem is, if it is possible to get a report (preferably in
Smartlist, because only the Administrator has access to the Reports Module)
to distinguish between invoices reversed/canceled and credit invoices
that were included on a client payment.
I hope it makes sense what I am trying to explain here.
I looked to various screen transactions and the only difference that
I see between a credit invoice which reverses a debit inv vs. a credit
inv. on a client payment is that:
a-the first check, no difference; in both cases it will show in Applied
To Debit screen the invoice to which was applied
b-the 2nd check, it will show in Applied From Credits screen the invoice
to which the credit was applied and also a payment line (PYMNT000000977),
Type PMT. How in the world can I use these parameters to get a report.
Thank you so much.
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