Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

FI document Excel upload best practice?

Former Member

‎2011 Oct 12 2:32 PM

0 Likes
1,912

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

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

Reply
2 REPLIES 2
Read only

Former Member

‎2011 Oct 14 12:05 PM

0 Likes
904

Not any?

Read only

Former Member

‎2011 Nov 28 12:53 PM

0 Likes
904

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,