Business necessity:

Every company aspires to keep accurate records of all of its direct and indirect costs so that it may plan and operate more effectively.

One item that the business typically wants the customer to track is the cash discount in order to reflect it in the client’s P/L. For the Cash discount resulting from Payment terms to be seen in the Customer P&L, it is desirable for customer to be a COPA characteristic.

This blog helps readers comprehend how to automatically obtain the customer number as a COPA characteristic when applying the cash discount during the processing of the F-28, lockbox, or electronic bank statement.

With this approach, the original invoice document—which might be from a FI Invoice (DR) or Billing Invoice (RV) document—can inherit the COPA features for payment terms cash discount.

CO account assignmts/customer fields as document splitting chars, according to SAP Note 1652002 CO account assignments/customer fields are mentioned as one of the splittings in THIS. Add the PAOBJNR as one of the criteria for CO under IM activity in the new GL accounting. Business Transactions->Document Splitting->Define Document Splitting Characteristics for Controlling in Financial Accounting->General Ledger Accounting->Business Transactions

Characteristics of CO Split

When a document is posted, the system takes the Profitability Segment into account as one of the dividing criteria once the aforementioned settings have been defined.

When a customer invoice is posted using the aforementioned settings, the Prof. Segment of the revenue G/L line item divides the customer line item depending on one of the Split characteristics in CO, and database FAGL SPLINFO is changed.

However, there are other factors that can assist you in meeting the criterion in all circumstances. In this article, we’ll discuss two distinct scenarios for posting customer invoices: a direct FI invoice using the DR document type and a billing customer invoice using the RV document type.

Another need is that the appropriate Business Transactions for the document splitting of the RV, DR, and DZ document types be assigned.

Assignment of Document Split Business Transaction to Doc.

Additionally, updating the Cash discount GL account in OKB9 with the profit segment enabled is not necessary.

When a document is posted, the table FAGL SPLIT FIELD, which is related with CO splitting characteristics, determines which scenarios and accounts these qualities are given.

Table FAGL SPLIT FIELD

Let’s look at the system behaviour in two scenarios where two different forms of customer invoice posting have their CO assignments copied to the payment document: –

Invoice from FI Customer, “DR Type,” as an example.

Update to the BSEG table for Rev. Line Items with Prof Segments Attached:

CO document

After filing an invoice with two separate prof. segments for a customer recon GL code, the FAGL SPLINFO table is updated.

Update for the Invoice document under ACDOCA:

Using F-28 to post incoming payment documents for invoice 1800000022:

Because of two different Prof.Segment characteristics inherited from the source document invoice, the Cash Discount expenditure line item got split into two different lines of 20 USD and 10 USD totaling to 30 USD, as we can clearly see. The source invoice document and the payment document’s line items will both have the identical CO assignments.

Update to the ACDOCA Table:

The payment document inherits the same COPA features from the source document, which is the invoice against the cash discount account.

Accordingly, Scenario 1 of Direct FI invoice posting was successful with the above-mentioned fix from SAP Note 1652002.

Scenario 2: Transfer of a customer billing invoice of the “RV type” to the financial institution

You won’t see the Prof Segment field active in entry view for RV document due to the BSEG update with blank Prof.Segment against Rev line item, which is SAP usual behaviour.

The BSEG PAOBJNR submitted is summarised due to summarization settings made in OBCY under Application VBRK for Billing Document.

Please see SAP Note 2631941

Remove the aforementioned entry from the table, post the billing document, and assess the behaviour of the BSEG.

After change, OBCY

Posting a new billing document:

Table update for BSEG:

Let’s examine the FAGL SPINFO table.

As we can see, the FAGL SPLINFO table shows that the Customer line item has been divided into several line items, each of which has a Professor Segment number assigned to it. These line items will inherit the CO assignment when the Payment Document postings for the Cash discount Line item take place.

Posting of Payment Documents F-28

The updating of these COPA attributes in the GL line items for Cash Discounts Expenses provides a thorough view of the line-item display report with a Customer code associated to it, which aids business in internal reporting and planning based on various Customers and their market segments.

Conclusion:

The aforementioned blog post enables us to fulfil the most typical business requirement of charging off Cash Discounts to Customer Code at the time of F-28 as SAP Standard out-of-the-box functionality in Account based COPA with the least amount of Configuration Change and without the need for any enhancement. The COPA properties of the billing/invoice source document will ultimately be transferred to the payment document.

We value your thoughtful comments in the section below. Thanks for reading!