Skip to Content
1
Former Member
Nov 14, 2012 at 01:30 PM

How toexport Payment proposal to Excel?

1551 Views

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.