Is extensibility possible to upload more than 999 line items by using Upload Customer Open Items app

[AjitNDBS]

Our client has embarked journey of business transformation into S/4 HANA Public Cloud system. So the client has preselected scope item – J59 (Accounts Receivables) to upload customer open items (AR items) by using standard App - Upload Customer Open Item

Here the business team would be planning to use this app to upload customer open items on monthly basis hence they are intended to upload more than 2000 entries in single file.

Project Phase:- Explore

Issue Description: -

While testing the app - Upload Customer Open Item in starter system, the app is giving error message  if the upload file contains more than 2000 records

As per SAP help document , it is mentioned that each time you can upload no more than 2,000 entries in a file. If we have more than 2,000 entries in a file, split them up and upload them separately. As the maximum number of entries in an invoice during posting is limited to 999, avoid entering more entries than that number.

In current SAP ECC system of client, there is custom transaction code created which splits the file logically if items are more than 999 items. Hence the business team does not require it splits the file manually. so the business team is looking forward for similar solution where the app can able to split the files if entries more than 2000 (999 items) as it will require hugh manual efforts from business side to split the records into multiple files.

Regards,

Ajit

[OwenLiu]

Added Finance tag, please remove other tags.

[HenrikeGrötecke]

forwarded to experts

[OwenLiu]

We helped you to accept the answer, since there were no updates after 7 days. You can unaccept it anytime if you have further questions.

[Victor5 · Accepted solution]

Hello Ajit, Thanks for your interest on the Upload Customer Open Items App.

You mentioned two limitations:

1. For one invoice, you can enter max 999 line items
2. You can enter max 2000 lines in the excel file for uploading. (which means in extrem case, if each invoice has 999 line items, then you can input only 2 such invoices in the excel file)

As to the first limitation, We are working on a standard solution, then you will be able to upload a invoice with more than 999 line items and post this invoice. Such solution planned be released in next major cloud release (2502)

As to the second limitation, we limit 2000 line items due to performance consideration. What is your expected line items in your case?

Best Regards,

Victor