Entering the Posting Documents in the InfoCube 

In purchase documents the header data contains details on the vendor, and the item data contains details on the goods or services purchased. Documents from Financial Accounting are structured differently: The item lines contain details on both the vendor and the purchased goods or services.

In order to be able to evaluate the documents from Financial Accounting from a procurement perspective, they must first be modified: The vendor must be assigned uniquely to each product or service that he has purchased.

In the example, an invoice and the resulting posting document in Financial Accounting are shown. The individual items of the posting document for goods and services contain net amounts. These must be aggregated in the InfoCube. In order to enable more detailed evaluations, the gross amount that is posted against the vendor, is included in the InfoCube.

Only the information required to describe the situation is shown. Address data, date etc. have not been included.

 

Invoice Document

Header data:

                  Vendor 1

Items:

Quantity	Unit of measure	Article	Unit price	Price basis	Total price
3	Unit	Material A	10.00 €	1	30.00 €
5	Unit	Material B	100.00 €	1	500.00 €

 

Totals:

Net total                                                                                                                530.00 €

Input tax                                                                                                                   84.80 €     

Gross total                                                                                                            614.80 € 

 

Provided that both materials are posted to the same account, the following posting record arises for the liabilities:

A&B Materials         530.00 €

Input tax                    84.80 €           to vendor 4711         614.80 €

 

The following FI document results:

Header data:

                  Document number

Items:

Dr./Cr.	Account	Amount	Vendor
Debit	A&B Materials	530.00 €
Debit	Input tax	84.80 €
Credit	Liabilities	-614.80	Vendor 4711

 

In the FI document, therefore, one item contains an amount equal to the sum of the amounts of the other items.

The amounts must be updated in different key figures. This problem is independent of the account side (debit/credit) because these amounts are preceded by a sign.

Make sure that gross and net amounts are not added together in the queries.