Finance | Project Operations, Human Resources, ...

paying multiple payables through upload

(0) Share

Report

Posted on by Community Member Microsoft Employee

My company has multiple locations, who receive and auto create invoices by vendor which is then paid by my accounting department.

We have about 10 -15,000 invoices to pay and currently my staff has to go one by one and check off payments.

Is there a faster way to do this? can it be done through a download / upload to select multiple invoices that match at one time?

Please help, my people are going nuts.

Thank you.

Categories:

Microsoft Dynamics GP

All responses (4)

Answers (0)

rcolemant 15 on at

Like (0)

Report

RE: paying multiple payables through upload

@tireman , @Tireguy - Did you find a resolution for this question?

Thanks

Renee
TireMan 5 on at

Like (0)

Report

RE: paying multiple payables through upload

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.
Carlos Henao @ GP365 15 on at

Like (0)

Report

RE: paying multiple payables through upload

I agree with Gerald... this sounds very much like something that can happen automatically through the "Build Payments Batch" window. I have seen some users go directly to other windows, like "Edit Cheque Batch", or "Edit Cheques", but when we are talking mass set of invoices, this is definitely the way to go.

Cheers!
Suggested answer

Gerald Buenafe BTP 280 on at

Like (0)

Report

RE: paying multiple payables through upload

hello,

Do you use the Build Checks Process? So if the invoices are already posted in the system, you could use the Build Check process and it will automatically get the open invoices that needs to get paid?

Are you using GP to print checks, EFT?

Gerald