topic Re: FI document Excel upload best practice? in Application Development and Automation Discussions

FI document Excel upload best practice?

Former Member — Wed, 12 Oct 2011 13:32:10 GMT

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

Re: FI document Excel upload best practice?

Former Member — Fri, 14 Oct 2011 11:05:21 GMT

Not any?

Re: FI document Excel upload best practice?

Former Member — Mon, 28 Nov 2011 12:53:44 GMT

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,