Invoice Reduction and or Invoice Retention with Document

Splitting Active

Purpose

This wiki shows how document splitting should be configured for invoice reduction.

Overview

From the Release Information: SAP ECC 6.0, EHP 4, New General Ledger Accounting, the following is

stated

FI_GL_CI_2: Invoice Reduction (Changed)

From SAP ECC 6.0, Enhancement Package 4, Business Function New General Ledger Accounting 2, you can

split invoice reduction items from Materials Management (MM) across the relevant profit centers. An assigned

purchase order with two invoice reduction items on different profit centers is written correctly to new General

Ledger Accounting when the corresponding incoming invoice is posted. In other words, the invoice reduction

item is split across the relevant profit centers.

From the Release information SAP ECC 6.0, EHP 4, Procurement and Logistics Execution, the following

is stated

As of SAP ECC 6.0, Enhancement Pack 4 (SAP_APPL 604), Business function MM, Integration of Materials

Management and Financial Accounting (LOG_MMFI_P2P), you can retain parts of the invoice amount until a

defined due date, in order to ensure the fulfillment of the contract when materials are delivered or services

performed. You can define retentions percentage of the purchase order value in purchasing. The system

copies the retention data that you define at header or item level in the purchase orders in logistics invoice

verification, as default values. When you process the incoming invoice, you can change retention data and

define the due date.

Step 1 - Activation of business functions in transaction SFW5

Step 2 - Create new transaction variant for business transaction 0300

Create new transaction variant for business transaction 0300

To create new transaction variant for business transaction 0300 go to transaction SPRO -> SAP Reference

IMG-> Financial Accounting (New) -> General Ledger Accounting (New) -> Business Transactions ->

Document Splitting -> Extended Document Splitting ->Define business transaction variants (transaction code:

GSP_VD)

Create a new business transaction within business transaction 0300 (Z003 in this example).

 

Step 3 - Maintain a new splitting rule

The menu path for the configuration of the document splitting rule is as follows:

SPRO -> SAP Reference IMG -> Financial Accounting (New) -> Business Transactions -> Document Splitting

-> Extended Document Splitting -> Define Document Splitting Rule

Copy the rule of standard business operation 0300 "Vendor invoice" to the created variant Z003. Highlight

method (in this case ZXHEN00012) Transaction 0300 Variant 0001 and click on button copy as . Specify

target enteries - Splitting Method ZXHEN00012, Business Transaction 0300, Transaction Variant  Z003. Press

return on keyboard and click on button copy all. Continue.

  

Step 4 - Customize For Each Logical Transaction within Rule

Execute Define Document Splitting Rule and double click on Method (ZXHEN00012), Transaction 0300,

Variant Z003

In Section Further subdivide document, select radio button For Each Logical Transaction.

From Note 1451948   The following is stated

When you post a reduced invoice and when you use the new retention function, in addition to the invoice, the

system posts separate FI documents or logical transactions in an LUW (logical unit of work) from Logistics

Invoice Verification to FI.

You may have to set the "Further Subdivision in Document" indicator for documents from Logistics Invoice

Verification to "After Each Logical Transaction". When you do so, the invoice reduction document or retention

document is handled separately from the invoice. This means you cannot derive the account assignments

from the invoice to this separate document as part of a rule-based document splitting.

Step 5 - Add the item category 03100 as the base item category for 03000

Select Item Categories to be edited. Choose Item Category 03000

 

Double click on Base item categories. Add item category 03100 as base item category

Step 6  - Add the item category 40200 as item category to be edited based on base item category 01000

 From note 1451948 the following is stated

In addition, you must ensure that a relevant splitting rule for difference lines (KTOSL 'DIF') is defined.  You can

post these with the item category 40200, for example.  The splitting rule could look as follows:

40200 Exchange Rate Differences

Splitting according to base items

    Base item categories

        01000 Balance Sheet Account

 

Step 7 - Assign Business Transaction/Transaction Variant Assigned to Document types involved in posting 

Assign business transaction/transaction variant to document types involved in posting invoice reduction via

menu path Transaction SPRO -> SAP Reference IMG -> Financial Accounting (New) -> General Ledger

Accounting (New) -> Business Transactions -> Document Splitting -> Classify Document Types for Document

Splitting

Execute Classify Document types for Document Splitting

In this example document type RE is the main document type. Note that all document types involved in the

posting should be assigned to the same business transaction/transaction variant.

See note 1712488 Creation of separate documents in an LUW (logical unit of work)

 

Document types RE and RK are the document types in test example for invoice reduction. Document types

RE and KA are document types in test example for invoice retention.

 

Step 7 - Assign account associated with transaction key EGX to item category 03100

From note 1451948 the following is stated

For the splitting rule to work correctly, the offsetting account for the security retentions (KTOSL 'EGX') must be

assigned to the item category 03100 in Customizing of document splitting (transaction GSP_LZ2), and the

overwrite indicator must be set.

The menu path for transaction GSP_LZ2 is as follows

SPRO -> SAP Reference IMG -> Financial Accounting (New) -> General Ledger Accounting (New) ->

Business Transactions -> Document Splitting -> Classify G/L Accounts for Document Splitting

 Execute Classify G/L Accounts for Document Splitting

The F1 help on the field Override states the following;

Document Splitting: Override Internal Item Categ. Derivation

Definition

This indicator is used to specify whether the internal derivation of the item category should be

overridden in document splitting by the derivation by accounts.

Use

Select entry X if you want to assign the vendor or customer items to more detailed item categories

(such as 2100 Customer: Special G/L Transaction / 3100 Vendor: Special G/L Transaction). These item

categories can be handled separately in rule definition in document splitting.

Related Content

Relates Documents

Related SAP Notes/KBAs

Sap Note 1451948: Change of document splitting logic for Logistics

Sap KBA 1712488: Creation of separate documents in an LUW (logical unit of work)

SAP Note 1085921 : Document Split

Sap Note 891144 : New GL/Document splitting: Risks w/ subsequent changes