cancel
Showing results for 
Search instead for 
Did you mean: 

Internal Error (-47) occured [Message 131-183]

zal_parchem2
Active Contributor
0 Kudos

Hello Everyone...

I am using the Administration > Data Import/Export > Data Import > Import from Excel function in SAP 2007 A SP 01 PL 05.

This update import is so simple: it has only BP Code and BP Name and I am doing only changes to the BP Name to what already exists on the SAP B1 System. So no new customers, no new numbers, and the only changes are some letters in the name that went from lower case to capitalization.

Saved the file to be loaded in TXT format and put ".txt" at end. Even made sure the BP Code was changed to "Text" in the Excel spreadsheet

Of course, cleared the "Import from Excel" window, selected the two fields in the drop down list ,and checked the box to "Update Existing Records"

However I get the above error (see Subject line) and have no idea what this means.

Can anyone give a helping hand???

Thanks in Advance - Zal

Accepted Solutions (0)

Answers (1)

Answers (1)

zal_parchem2
Active Contributor
0 Kudos

Unbelievable as it may seem, I just fixed my own problem!!!

The key was for me to highlight BOTH BP Code and BP Name columns in Excel and then use the "Cell Format" function to set them both to "Text" - I guess since BP Name was left formatted as "General" SAP B1 did not like that. LOL and of course -47 is soooooooo apparent...Mamma Mia, why did I not think of that before!!!

Hope this might help someone else in case they run across the same problem with error messages...

Maybe I should give myself points - &:-)

Take care all - Zal

Former Member

It is not about the cell format, you simply have to close the txt file (in my case it was opened with excel)

Matteo