Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

paying multiple payables through upload

Posted on by 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:
  • rcolemant Profile Picture
    rcolemant 15 on at
    RE: paying multiple payables through upload

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

    Thanks

    Renee

  • TireMan Profile Picture
    TireMan 5 on at
    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.

  • 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 Profile Picture
    Gerald Buenafe BTP 280 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans