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

[Vera2]

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.

 

[RobertC22]

To achieve this reliably you would need to put some indication on the reversing document that it is such a document.
You might use the Description field with 'REVERSAL XXXXXX' where XXXXX is the document ID that you are reversing.

Just using the Apply details available would not be reliable. A credit note raised could be fully applied against an invoice even though the credit note it not for the purpose of a reversal.

To then list with Smartlist, you would create a custom object with SLB. This SLB Object based on a SQL view that can check the document with its apply details, and if the description field starts with "REVERSAL" knows that it will fulfil the condition you seek.

Finally you conclude with "How in the world can I use these parameters to get a report."
You will need a custom coded SQL view that can then be used in Smartlist.

------
Robert

 

[Vera2]

Thank you Robert for you reply. Unfortunately I don't see any field to allow me entering any comments on neither Sales Series Post (when I post invoices) or on Apply Sales Documents window where I match the credit to a debit invoice.

Thanks again

 

[RobertC22]

You would need to enter into the description on each individual document that you have created for the reversal.

If you are not entering these reversal documents within DynamicsGP, then I cannot offer a way forward that would allow a mechanism to match the pair of debit and credit documents.

------
Robert