Thank you guys but i don't think that works.
Let me give a better more detailed example.
See steps below.
Go to smart list
Then Purchasing
Then payable transactions
Then Vendor Invoices
Then select vendor by ID#
After running the list of about 10,000 open invoices show up.
Then Click Excel to down load
We then V Look up to the Vendor statement.
Out of 10,000.... 8,000 match.
Now we want to pay only the 8000 because we have to research the other 2000.
I have 25 retail stores that we need to contact each manager to see why the invoices that show on the vendor statement are nor inputted in their stores system.
Currently we go into "edit check batch / edit parables check batch"
then create batch ID
then payment method
then checkbook id
Click transactions
click on edit payable check batch
then click vendor name, so all transactions show on right side of screen
then go one by one to match from the spread sheet to the voucher number in GP.
then click the check box for every invoice to pay.
There has to be an easier way to do this so we don't have to one by one.
Is there a way to upload those 8,000 or pay those 8,000 invoices without doing them by clicking one ?
Thank you all for any help with this.