FI document Excel upload best practice?

[Former Member]

Hello,

What's the current best practice for financial document upload from Excel? (uploading data from excel to run FB01/FB50)

Especially I'm looking for a comprehensive and easy-to-implement solution for error handling. The simulation/testrun in foreground should find out all master data and combination mistakes and give detail feedback for the user. Additionally the production run should be straight forward, also with status/error handling (read, user should not be asked to go to SM35).

Is there any how-to docs released by SAP?

Thanks!

Aki

[Former Member]

Hello,

What's the current best practice for financial document upload from Excel? (uploading data from excel to run FB01/FB50)

Especially I'm looking for a comprehensive and easy-to-implement solution for error handling. The simulation/testrun in foreground should find out all master data and combination mistakes and give detail feedback for the user. Additionally the production run should be straight forward, also with status/error handling (read, user should not be asked to go to SM35).

Is there any how-to docs released by SAP?

Thanks!

Aki

[Former Member]

Not any?

[Former Member]

Hi Aki

www.mkpg.ch developed an Excel add-in called xls2Sap. With this add-in you can post from Excel directly into SAP, without an upload file, without leaving Excel. Occuring errors are written into a seperate log-tab in the Excel sheet. Furthermore the user can choose to store he posting document in SAP. It seems that our solution fullfills your requirements. Let me know, if you have any other questions.

There are some videos on www.mkpg.ch showing some of the possibilities. However the are in Swiss German

Kind regards,