Filter supplier invoices

[EtienneJacquet]

Hello,

Using the applications "Import Supplier Invoices" and "Supplier Invoices List", it seems to be only possible to filter at company code level. Do you know if there is any way to filter on more detail level?

The objective is to answer the need to manage AP Invoices on a regional scope and not to mix all invoices of the entitiy.

Kind regards,

Etienne

[Sandeep_Kumar · Accepted solution]

Hi,

You can click on "Adapt Filters" in Supplier invoices list app and it provides a lot of other filerting options like fiscal year, currency etc.

Best,

Sandeep

[EtienneJacquet · Accepted solution]

Hello Sandeep,

Thank you for this answer. We reviewed the different filter but out of timing and currency, we don't see any possibility to filter by other organizational structure level than company.

Kind regards,

Etienne

[former_member94298 · Accepted solution]

If you follow Sandeep's instructions, you can us 'region' or 'country key' on the supplier as additional filters. What organisational levels are you seeking to use?

[EtienneJacquet · Accepted solution]

It is not based directly on the supplier but for example for the same supplier making business in different region, based on plant, purchasing organization.

[former_member95896]

Etienne,

Depending on what you want to see, you might be able to try Manage Supplier Line items to see more item detail for invoices, Display Line Item in General Ledger for RE document type will show you accounting detail for invoices including the offsetting account (supplier and how it was posted). Lastly, if those don't meet your needs you could combine some CDS table data and utilize the custom analytical query functionality.

Hope that helps,

Ryan