Skip to Content
avatar image
Former Member

Credit memo report filtered by month

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 03, 2008 at 07:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 03, 2008 at 07:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded