Share
Report
13Hi Experts!
I have a client who is using Excel Add-in to upload approximately 20,000 lines per day.
After showing progress percentage, data connector shows Updating workbook..... and then process cannot be done while BC received 20,000 lines.
Is this MS bug? If so, when does MS issue patch and where?
Also, how many lines (maximum) is suggested using Excel Add-in?
I do not want to propose to the client using configuration package as an alternative solution because configuration package is used for data migration by MS partner like us and the feature is system admin module where usually ordinary end user is not allowed to access.
Below is the information of source data and target table
Target Table: General Journal Line (81)
Total number of line: approximately 20,000 - 25,000 per day.
Below is the columns in the file (total 12 column)
Journal Template Name
Journal Batch Name
Line No
Posting Date
Document No
Account Type
Account No
Description
Amount ($)
Shortcut Dimension Code 1
Shortcut Dimension Code 2
External Document Number
Total number of cell: 240,000 - 300,000
Each cell does not contain color, formula, grid lines etc.
Account type=G/L account only (nothing customer, vendor, bank etc).
All responses (
Answers (
