on 11-14-2012 1:30 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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..
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.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.