Hello:
Currently invoices paid by PAP (pre-authorized payment straight from the bank account) for utilities, taxes, etc. are being entered into a spread sheet and then expense details are loaded into GP via Integration Manager direct to the General Ledger. We have two main challenges in this regard:
1. We are looking for a way to upload this information from Excel into Purchasing (and not just the General Ledger) so that these invoice details show up in Accounts Payable detailed reports. In effect, we are looking for an automated way to enter all of the various invoices for utilities, taxes, etc. Will Integration Manager work for this? The volume approaches over a thousand invoices a month as there are multiple accounts for multiple properties.
2. We would then need to have a way to show these invoices as paid in Accounts Payable even though we are paying via PAP and not by cheque or EFT. Do we need to do a "dummy" cheque run in A/P or are there other options?
Currently we are on GP 2013, but we will be upgrading to 2015 R2 in the next few months.
I welcome any feedback you may be able to provide.
Thanks.
Patrick
*This post is locked for comments
I have the same question (0)
