Use Flexible Summarization to Reduce the Number of Line Items in FI Documents

  • by Hendrik-Jan van Hoeijen
  • October 17, 2012
Learn how to use the Business Add-In (BAdI) AC_DOCUMENT to solve the 999-line-item limit in an FI document in a flexible manner.
Key Concept

With the Business Add-In (BAdI) AC_DOCUMENT, you can differentiate summarization not only for reference transactions (article documents, billing documents), as is the case with standard summarization, but also for different reference procedures (goods receipt, goods issue), account keys, or even individual general ledger accounts.

When you use the SAP accounting interface to post documents from sales and distribution (SD), materials management (MM), or other applications, you can use transaction OBCY to activate FI document summarization for reference transactions, such as goods receipts or billing documents. These documents from SD or MM can be so big that without FI summarization, the subsequent FI document passes the 999-line-item limit, and you receive error message F5 727: Maximum number of items in FI reached.

You can solve this problem by spitting billing documents or goods receipts. However, from a business or procedural perspective, this is undesired. Such detailed information is also not always needed or desired in FI and means the warehouse clerk has to split the delivery note into two goods receipts.

Via summarization, the SAP system can total items in the FI document if they have the same account assignments and only differ in the value fields. The summarization can be achieved by deleting certain fields in the accounting interface, such as material number in all FI items. In SAP Notes 36353 and 545137, you find a detailed description of FI summarization.

I explain how to use flexible summarization for a goods receipt (reference procedure RMWE) so that you can still clear the Goods Received/Invoice Received (GR/IR) clearing account (WRX -account key) at the purchase order item level. However, in the stock general ledger account (BSX-account key) line, the article information is deleted in the accounting interface and, therefore, summarized in the FI document.

Hendrik-Jan van Hoeijen

Hendrik-Jan van Hoeijen is a senior FI/CO consultant with Prospect IT. He has more than 15 years of hands-on SAP knowledge, including many full implementation cycles as well as international template rollouts. Hendrik-Jan holds a master's degree in business economics (Erasmus University Rotterdam) and has substantial experience integrating finance, controlling, and logistics.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.