Getting issue while uploading JV in SAP for more than 8 line item

Sagar s 0 Reputation points
2026-06-16T09:50:36.1266667+00:00

Hi,

I am using Microsoft 365 earlier it was excel 2019, if i am having more than 8 line item e.g 20 line item journal entry then while uploading JV from excel only 8 light item get upload and 8th row get overwrite till 20th line item result jv do not get park. In earlier version of excel there were no issues uploading entries from Excel to SAP.

SAP GUI is also updated please suggest what to do get rid of this issue.

Microsoft 365 and Office | Excel | Other | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Kai-H 20,755 Reputation points Microsoft External Staff Moderator
    2026-06-17T08:52:01.84+00:00

    Hi, Sagar s

    This does not look like a normal Excel row limit issue, because SAP’s own journal voucher upload from Excel supports multiple line items when the correct SAP Excel add-in/template is used. The symptom where row 8 keeps getting overwritten usually points to the SAP upload template, SAP GUI scripting/table control, or the Excel file format being read differently after moving from Excel 2019 to Microsoft 365.

    Here are some suggestions you can try:

    First, download a fresh JV upload template directly from SAP again instead of reusing the old Excel 2019 file. SAP templates/add-ins can depend on the installed Excel version, and the latest Excel Add-In should be installed for Excel-based journal voucher upload.

    Also try saving the file as.xlsm if it uses macros, or as.xls if your SAP upload program is older. If the upload is based on SAP GUI scripting or OLE, it is recommended that the script be checked for “visible row” handling. SAP table screens often show only a fixed number of visible rows, so the script must scroll or insert a new row after the visible rows are filled, otherwise the last visible row can be overwritten.

    If possible, test the same JV by saving the Excel data as CSV/TXT and upload that format, or ask your SAP/ABAP team whether the upload program supports CSV/TXT input. I should also mention Excel uploads that require saving as TXT or CSV before upload in some scenarios.

    Lastly, ask your SAP team to check whether the upload program uses ALSM_EXCEL_TO_INTERNAL_TABLE or OLE-based Excel reading. It is recommended that such programs be reviewed after Office upgrades, because OLE timing or XLSX handling can behave differently on newer Office versions.

    Thank you for your patience in reading, I hope this information has been helpful to you. 

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment."    

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

    Was this answer helpful?

  2. AI answer

    2026-06-16T09:50:52.7033333+00:00

    The described behavior (only 8 lines uploading and the 8th line being overwritten for subsequent lines) is specific to the SAP upload process and is not covered in the provided Microsoft documentation. There is no information in the context about Excel–SAP integration limits, templates, or known issues that match this scenario.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.