cancel
Showing results for 
Search instead for 
Did you mean: 

How toexport Payment proposal to Excel?

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Marssel700
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

Thank you for answer.

Unfortunately I cannot find this function. I tried to check if it is possible to do this before I wrote here (because we are able to export FBL1N tables to Excel, so I thought that it is possible to export Payment proposal also).

We are using SAP R3. Does it make any differece? Could it be the problem that I am trying to export Payment proposal after the Payment Run is already done? I can try tommorow after creating the Payment proposal also..

Former Member
0 Kudos
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.