Skip to Content
author's profile photo Former Member
Former Member

How toexport Payment proposal to Excel?

Hi,

Usually I create Payment proposal (via F110) with more than hundred (sometimes two hundred or more) vendors and some of them have more than one bank account. (By the way, we process remittance every day, except weekends). We have Excel file with the list of these vendors. We have to check if those vendors are in the Payment proposal and then choose the proper account by using reallocate function. Anyways, this process is quite boring and you can make mistakes (not to notice one or more of vendors in the list of several hundred of them, etc.) and it takes quite a lot of time. So one day I was thinking that maybe we could export Payment proposal to Excel and then make the whole process much easier (because we have the list of vendors with more than one bank account as Excel file and it would be easy to create a macro or even to use easier way to find identical units (for example, vendor number) in both Excel files). I know that it is possible by using some other programs (but you have to buy them). I tried to get more information about this, unfortunately did not find anything usefull.

My question: how can we export Payment proposal to Excel?

Thank you in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2012 at 02:05 PM

    Hi,

    You can export payment proposal to excel like below:

    F110 > Edit > Proposal > Display Proposal

    Then, in the output, click on export > Local File > Spreadsheet

    Best Regards.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Hi Tåke Tåke,

      You can export payment proposal to excel like below:

      F110 > Edit > Proposal > Display Proposal


      Then, in the output, click on : Change Layout > View > Preferred view > Microsoft Excel > Enter > Template select > Save.


      Could you please test this solution and give a feedback ?


      Best Regards.

  • Posted on Nov 14, 2012 at 07:50 PM

    Hi,

    you can export proposal log entering %PC in transaction code field. Select spreadsheet and save.

    I recommend you enter SE16 - table: REGUP, set Indicator: Only Proposal Run. Type your F110 identification for fields display.

    regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.