cancel
Showing results for 
Search instead for 
Did you mean: 

Credit memo report filtered by month

lucas_fischer
Active Participant
0 Kudos

Hello,

I have a customer that requires a report that shows all credit memos entered for a specific month.

I was wondering, what would be the easiest way to accomplish this in the system?

Thanks in advance,

Lucas

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Lucas,

The easiest way is by a query. Something like this:


select T0.docdate, T0.docnum, T0.cardcode, T0.cardname, 
T0.Doctotal From ORIN T0
where T0.docdate between '[%0]' and '[%1]'

Thanks,

Gordon

Answers (1)

Answers (1)

jitin_chawla
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

As per standard system such report is not available.

However, as mentioned by Gordon you can create a custom query if you want to have it by month.

If you want to have all the Credit Memos for a BP, Item ; you can use the Drag and Relate functionality. It would list all the documents Open and Closed.

Regards,

Jitin Chawla

lucas_fischer
Active Participant
0 Kudos

thank you both for your swift responses!!

warmest regards,

Lucas