extracting GLs data by vendor wise

Hi @areian 

Did you try the options in order report? you would see plenty of options for supplier analysis and also you can make use of the accounts payable lobby 

Hi Ali,

I recommend - as always :-) - the “ETL - way”.
Bring data every night from ORACLE to a MS SQL DWH (DataWareHouse) - DB and than do with your data what you want.
We created a complete purchase solution as follows:
-- FACT_PurchaseOrderInvoice            PIL
-- FACT_PurchaseOrderLines               POL
-- FACT_PurchaseOrderChargeLines  POC
-- FACT_PurchaseInvoiceLines            MAN
The “Alias” is also used as “FactSource”.
So you can see your data “combined” or “solo” from one “data layer”.
 

We used as a main dimension the Supplier and there the following “objects”:
 

So in the MS OLAP cube (which you can use with a lot of front end tools) you can e.g. see
the following attributes and hierarchies:
 

Here you can see some of the used measures:

Because MS cubes are a common standard you can decide which tool is the best for you.
Excel pivot, PowerBi, .. you name it.

If you want more information just contact me any time.

All the best

Michael