Filter Credit Memo's from Invoice Reports

[Former Member]

Hi All,

The SPM extractor for Invoices includes a filter based on Posting Key to only include types of 21, 22, 31, 32 which are Credit Memo, Reverse Invoice, Invoice, and Reverse Credit Memo. We have a requirement on our Invoice based reports to exclude Credit Memos, Reverse Invoices, and Reverse Credit Memo's. As the Posting Key is not brought into the data model in SPM, is any other way to create a filter to cater for this requirement?

Regards,

Gary Elliott

[Former Member · Accepted solution]

Hi Gary,

No. I doubt if it is possible to do in on BI side since as you said that information is not exracted. You will have to do the filtering on extractor side.

Best Regards,

Divyesh

[Former Member · Accepted solution]

Thanks Divyesh,

We had thought this would be the case. We will look at extending the extractor to include the posting key. This will give the users the option to filter on the type of document.

Many thanks,

Gary