999 Line Item limit in uploading financial files (invoices, journal entries, etc.)

[former_member95896]

Has anyone else run into the 999 item limitation when uploading journal entries or supplier invoices? We bump up against this limitation often when we're uploading month end adjustments for inventory by store, or in processing some of our produce supplier invoices.  We've asked SAP to work on a fix so we do not have to break up these files manually (as it will be a large problem for us once we pass 500 stores), but are curious how many other organizations are encountering it. 

[Amith_Nair · Accepted solution]

Hi

As per the roadmap for 1811 cloud edition, you can upload and post a general journal entry that contains 999 or even more line items in the General Ledger. To do this, you need to add a field and give a specified value in the upload file. If you want to post a general journal entry that contains 999 or even more line items in the General Ledger, perform the general steps as follows: Add a field column in the header section of the template file. The field technical name and value: BSTAT (Journal Entry Attribute) = U (Posting in General Ledger Only)​ Fill in the information of the general journal entry that includes the head and line items. Upload the general journal entry. Post the general journal entry. However, The app doesn't support uploading 999 line items in any one of the following cases: Post taxes Open item management is set for a G/L account Post cross-company journal entries when open item management is set for clearing accounts Submit for approval from the Verify General Journal Entries app Upload for reversals. To reverse an accrual and deferral journal entry with over 999 line items, use the Manage General Journal Entries app, display the general journal entry, and create one as reversal. Please refer to the below link that mention the same. https://help.sap.com/doc/0c51b70bf38f447fa045443622289b87/1/en-US/3399d9f358fb449ca86305773ad237b7.h...

Thanks! Amith Nair

[former_member95896 · Accepted solution]

amiths.nair2 Thanks for the update Amith, we were testing it in Q in 1808 and have been using it in in production since it's release.

I still however have questions about when the functionality will be added to do large journal entries across company codes and also with the journal entry workflow which we're looking to start using with our business in the coming months. Being unable to use the 999 je line item functionality with the journal entry workflow in particular will present issues for us (as the workflow is basically the new park and post which we're moving towards for audit purposes).

[Cora_Phelan]

In release 1905 the following is delivered:

The feature of posting with over 999 line items is supported for Journal Entry - Post (Synchronized) and Journal Entry - Post (Asynchronized) API​

Rules:

If the document line item number is less than or equal 999, no compress will happen. The details are stored in both of Entry View and Ledger View. ​

If the document line item number is higher than 999 and the items include open item, cross company item or tax item, the items will be compressed in Entry View. This is done by deleting the contents from the account assignment except for the function area. But the details are still stored in the Ledger View.​

If the document line item number is higher than 999 and the items exclude open item, cross company item and tax item, the items are only stored in the Ledger View without compress.​

In case the document line item number is still higher than 999 after compress, the posting will fail.

[rb2020]

It did, quite a revolution, we thought there was no upload for supplier invoices. We still don't see anything for uploading customer invoices, but as you said, fingers crossed for a road map item.

[rb2020]

Hi Ryan - sorry this is a little unrelated - but I did not know you could upload supplier invoices? Where do you do that? Can you also upload sales invoice documents?

[former_member95896]

Hi Robert,

There are a few ways you can upload supplier invoices depending on your needs:

Import Supplier Invoices application which has a template you can put supplier invoice info into and post it (https://help.sap.com/viewer/6b39bd1d0e5e4099a5b65d835c29c696/1805.500/en-US/7a000500308242f181aa50e5f3aacdba.html?q=upload%20supplier%20invoices)

The Upload Supplier Invoices application which is more in the purchasing space and has workflow capability attached to it (https://help.sap.com/viewer/0e602d466b99490187fcbb30d1dc897c/1805.500/en-US/210c1c5845359344e10000000a4450e5.html?q=upload%20supplier%20invoices)

Extensibility thru the white listed Create Supplier Invoices API (this is how we initially brought our supplier information into the system because the applications above didn't exist).

I'm not as well versed in the sales space in S/4HANA Cloud, but I know there is capability to upload data thru a file template in for items like debit memo requests. It would surprise me if an upload for sales invoice documents isn't in SAP's road map or already delivered. You also might be able to leverage an API to pull this info into S/4HC as well

Hope that helps!

[Nadja_Medeiros]

Hi Ryan , this limitation still persistent due to the currently architecture , we still have BSEG as part of it . There is no current automatic solution for it and it is a common question between our customers .

[Nadja_Medeiros]

Hi ‎@Paul BORDAGE , thanks for sharing this information , this workarounds are available for a while and they are all in a good usage in On Prem , nevertheless we still dot have any official workaround in Cloud , as stated by P&I so far. But we are following up on this topic internally and hopefully we will have some progress on the topic.

[former_member132042]

Hi ‎@ryan.muller & ‎@Nadja Medeiros, here is a link which provide more information & OSS Note about this topic:

https://wiki.scn.sap.com/wiki/display/ERPFI/System+limitation+of+999+line+items+per+FI+document

I am checking if a workaround exist, will keep you posed if something may help.

[Nadja_Medeiros]

Hi Ryan, as the topic is of high interest i will follow up internally , currently there are some solution available in the On Prem world, some BADI s , and summarizations , that i dont know if they are available in Cloud. Please give me some time and i will come back to you with more information on this topic and try to understand we are we the current architecture on BSEG.

[former_member95896]

Thanks for your response Nadja. I know this issue has been out there for a while, but it really becomes problematic for a business like the one I'm in that is growing at the rate of 200+ cost and profit centers a year related to our stores. It would be great if SAP used the S/4HANA Cloud product to modernize their architecture to advance past historic limitations like this.