Cancelled Sales Credit Memo

niimodinniimodin Member Posts: 142
Hello Experts
I want to know if it possible to filter from the Sales Invoice table all the invoices which have been Cancelled (Sales Credit memo)
Thanks

Comments

  • SavatageSavatage Member Posts: 7,142
    Are you talking about "Posted Sales Invoices" that have been cancelled, so you created a credit memo & posted it to reverse the entry?

    If so, I would put on the Credit Memo in the External Doc No. or enter it in the posting description "Order Cancelled" to "mark" a credit as being apart of a cancelled order.

    Plus if you use the Apply-To fields you will have the invoice# of the sales order you are cancelling.

    Then all the info you need in a report can be pulled from the "Posted Credit Memo"
  • kapil4dynamicskapil4dynamics Member Posts: 591
    niimodin wrote:
    Hello Experts
    I want to know if it possible to filter from the Sales Invoice table all the invoices which have been Cancelled (Sales Credit memo)
    Thanks

    U won't get them there. Check directly in Sales Credit Memo Header and Line.
    Kapil Khanna
  • matttraxmatttrax Member Posts: 2,309
    Yeah, you'll want to check the credit memos and see what they apply to. You can also check Customer Ledger Entries and see if the entry was closed by an entry that is a credit and not a payment.
Sign In or Register to comment.