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
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"
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.
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.
Comments
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"
http://www.BiloBeauty.com
http://www.autismspeaks.org
U won't get them there. Check directly in Sales Credit Memo Header and Line.
My Blog - nav.education