Skip to main content
Suggested answer

Excel Data Import issue

editSubscribe (0) ShareShare
ReportReport
Posted on by 50
Hello All,
 
I am new to Business Central and learning it all by myself. I have recently managed to import an excel file in BC through Config Package. 
 
Post the import the data is half uploaded and the uploaded data is incomplete. The numbers of the account is showing where as the name is not showing
 
Even there is error for some records - 
The field Customergroup Code of table G/L Account contains a value (BOTH) that cannot be found in the related table (Dimension Value).
The field Department Code of table G/L Account contains a value (BOTH) that cannot be found in the related table (Dimension Value).
 
All our suggestion and help is appericated.
 
Thank you