Count Invoice Line Items in 2LIS_06_INV

[Former Member]

Hello Expertz,

I need the number of invoice lines processed whitin a given selection criteria and also the number of invoice lines with and without Purchase Order.

I'm using the Extractor 2LIS_06_INV and also cube 0PUR_C01.

Can i have ideas on how to do this?

Thanks in advance,

N.M.

• Points assigned

[Former Member · Accepted solution]

Hi Nuno,

You can create a key figure in your cube with numeric type and use it as a counter, then code an update routine where you can check if the invoce beeing processed meets the selection criteria and add 1 to your counter.

For the purchase order .....I dont have system with me and not familiar with the extractor but isn't the purchase order informed there? If yes you can create another key figure and code the update to check if the purchase order field in the transfer structure is informed.

Hope this helps,

Regards,

Carlos.

[Former Member · Accepted solution]

Hi,

Still regarding this question, i have now a issue..!! It was supposing that i just needed MM(Purchasing) Invoices, that are stored in RBKP/RSEG tables, but now Func. teams told me that we need all Vendor Invoices, not only the ones that are in these tables!

How can i get this Invoices details? What is the criteria?

Thanks,

N.M.

[Former Member · Accepted solution]

Hi,

Any Suggestion on 2nd question?

N.M.

*points assigned

[Former Member · Accepted solution]

Did you check the Datasources availbale in the Business Content? Maybe I'm wrong, but it looks to me like you're trying to do this "from scratch"...

Luis

[Former Member]

create a key figure with exception aggregation on characteristic invoivc line item. In update rule set KF as constant = 1

there is a white paper too, if you want to calculate in the query. send me ur email ID. I can email you

good luck.

[bill_coombs]

Hi Nuno,

Along the same lines as the last post, we use the business content that flows to cube 0FIAP_C03 (FIAP: Line Item) . This is the Vendor line infomation from the invoice and has the PO number in it. The extractor we are using is 0FI_AP_4.

Hope that helps...

[Former Member]

HI Bill,

Thanks for the help.

But using this extractor do you have the invoice line items? Because i need those.

Can you detail the model you're using? Do you use it merged with some Purchasing data (2LIS_02* or 2LIS_06*)?

Thak you,

N.M.

[bill_coombs]

We had to develop a custom extract to get the "G/L (non-vendor) lines", but we did this to get the accounting related to the invoice.

However for our reporting requirements for Accts Payable, they typically look at the vendor line to represent the entire invoice, for instance number of invoices entered, number of invoices paid, etc. Since the 0FI_AP_4 extractor has PO number in it, you could create a restricted key figure that is PO not equal to blank to get a "purchase order value". Note that in our AP process one invoice= one PO, you may have something different in your AP process -

Bill

[Former Member]

Hi Bill,

Thanks for the help.

Can you please send me your data model on this? dekadence@portugalmail.com

In fact, i don´t have de PO number in 0FI_AP_4 and i can have more than one PO per Invoice...

What do you think on getting this with 0FI_GL_4?

Best Regards,

N.M.

P.S. Points Assigned

[Former Member]

Hi all,

Any Hint on this?

Kind Regards,

N.M.