Maximum number of items in FI reached Message no. F5727 Diagnosis The maximum number of items for an FI document ('999') has been exceeded

When our client does posting GI from SD more then 506 lines item we find above error.
And Sap gives suggestion for summarization FI document because when posting to FI line items of document more then 999 line items.

How to customize this FI summarization ?
Just using tcode OBCY to maintain table summarization.
Input "MKPF" in work area and BSEG - Matnr, BSEG - posnr2. This means fields matnr (material no) and postnr2 will be blank in table BSEG, this condition cause FI doc will be summarized.
For billing document just adds work area in OBCY value "VBRK".

I hope this information can help to solve this problem.


Comments

Post a Comment

Popular posts from this blog

Step by step Create SAP LIS Report

Steps in LIS EXTRACTION:
T.code - :MC18 – create field catalog
1. Characteristic Catalog
Application-01-Sales and Distribution, 02-Purchasing, 03-Inventory Controlling, etc..
Catalog category 1. Characteristic catalog, 2. Key figures catalog 3. Date catalog Select characteristic catalog and enter, click on characteristic select the source table and it will be display the relevant source field and select the source field, copy + close, copy.
Save, similarly create key figures catalog

T.code : MC21 – create infostructure
Example –
Inforstructure : S789
Application – 01
Choose characteristic select the catalog, select the fields, copy + close Choose key figures catalog select the key figures ,copy + close, save and generate

T.code – MC24 – create updating
Infostructure : S789
Update group : 01- Sales document, delivery, billing document ,enter Select the key figures click on rules for key figures give suggest rules, copy save and generate Click on updating (activate updating) Select the …
Read more

Step by Step SAP Splitting Document

Image
Sap Document Splitting in SAP ECC 6.0

For splitting document in General Ledger View you can following this step.
1. Adding new ledger. this step is optional if you only using one leading ledger (sap "0L").
>Financial Accounting (New) > Financial Accounting Global Setting (New) > Ledgers > Ledger
>  Define Ledgers for General Ledger Accounting

2. Financial Accounting (New) > Financial Accounting Global Setting (New) > Ledgers > Ledger
> Define and Activate Non-Leading Ledgers
Define this menu because we add new ledger (1L)

3. Financial Accounting (New) > Financial Accounting Global Setting (New) > Ledgers > Ledger  > Assign Scenarios and Customer Fields to Ledgers
This is the core for selecting field will be SUM in General Ledger document
We add scenario FIN_PCA, this scenario splitting document by profit center. What is FIN_PCA you can see at  Financial Accounting (New) > Financial Accounting Global Setting (New) > Ledgers > Fie…
Read more

New GL Manual Update FAGLFLEXA & FAGLFLEXT

Image
Recently we go live the system on sep 1st, due to missing customization PRCTR & KOSTL filed not updated in General ledger view ( FAGLFLEXA & T ) Tables.

We came to know Sep 9th and we did the customization and transported. That day onwards system updating PRCTR and KOSTL filed in those tables.

Could you please help me, how do we update PRCTR and KOSTL fields in New general ledger tables & also tell me what are the impacts, if direct table updation.

Solution :

Delete the line item whichever not having profi centre from FAGLFLEXA & FAGLFLEXT tables & run the GLGCU1 transaction code. GLGCU1 retriving data from BSEG tables and posted in above mentioned FLEX tables.

How to deleted please read
How to delete line item (row) of SAP table ?



Read more