Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics GP (Great Plains) > GP - General
  New Posts New Posts RSS Feed - A report to show credit inv vs. cancelled inv
  FAQ FAQ  Forum Search   Register Register  Login Login

A report to show credit inv vs. cancelled inv

 Post Reply Post Reply
Vera View Drop Down Member Member

Joined: March 19 2010
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote Vera Quote  Post ReplyReply Direct Link To This Post Topic: A report to show credit inv vs. cancelled inv
    Posted: March 19 2010 at 10:19pm

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

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 they "take the credit", on a payment check they will list the debit
 and the credits 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; 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.
Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Copyright 2013 All rights reserved. is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com