D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

AP Payment Journal

  • 1.  AP Payment Journal

    SILVER CONTRIBUTOR
    Posted May 25, 2020 12:31 PM
    Hello All,

    We just upgraded our D365 to Version 10.0.9 and we having vendor payment problems. Vendor has large credit balance but it pulls in payments. The credit pulls in when we run payments but it should not pull in any payment when we have a large credit out there. Can someone help me understand why this is so or what we doing wrong? Please Advise. Thank you


    ------------------------------
    Kobe Peasah
    National Vision, Inc
    Duluth GA
    ------------------------------
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: AP Payment Journal

    GOLD CONTRIBUTOR
    Posted May 25, 2020 06:36 PM
    What are you looking to achieve stop a user from creating the payments or not show up in your vendor payment proposal?

    When you create vendor payments you can select which vendor payments to process. The payment proposal is a query used to select invoices for payment. You can edit the list of invoices to pay before creating or generating the vendor payments.

    Or you can create journal controls to control journal posting to manage the payment runs for the vendor with unsettled invoices.

    If this doesn't help please assist with more information, screenshots or examples.

    ------------------------------
    Shilpi Thakur
    Freelance AX/D365 Microsoft Consultant
    Dynact Consulting Ltd
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: AP Payment Journal

    SILVER CONTRIBUTOR
    Posted May 26, 2020 06:40 AM
    Hi Kobe,

    If both the credit and 'owed' amounts show up as eligible for the payment process, it sounds like those transactions are still considered open - meaning that they haven't been settled against each other.  You may want to look at the vendor transactions and ensure that the credits you've entered are settled against the payments they should be applied to.  Once the transactions are settled, only the open items that really haven't been paid (if any) will show up for payment.

    ------------------------------
    Ben Morgan
    M3 Engineering & Technology Corp
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: AP Payment Journal

    Posted May 26, 2020 10:04 AM
    Hi Kobe,
    If the payment lines are being created using the Payment Proposal functionality, there is a "Delete negative payments" (aka vendor credits) in the Advanced parameters section. Once the user selects that, it'll remember for next runs. Once you receive the refund, then you can create a payment line for that vendor and use the Settle transactions option on the journal to find it on the open transactions list.
    Hope this helps.
    Thanks,
    Mariana
    Delete negative payments option


    ------------------------------
    Mariana Ardito Couto
    Liquor Stores Limited Partnership
    Edmonton AB
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 5.  RE: AP Payment Journal

    SILVER CONTRIBUTOR
    Posted May 26, 2020 10:28 AM
    Mariana,

    Are you saying, we should select that from NO to YES? And also can you help me navigate to this "Advanced Parameters". Thanks for you help!!

    Kobe

    ------------------------------
    Kobe Peasah
    National Vision, Inc
    Duluth GA
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 6.  RE: AP Payment Journal

    Posted May 26, 2020 10:39 AM
    Hi Kobe,
    Yes, you should switch the flag from No to YES. You can get to it by selecting the Payment proposal option in the Vendor payment form


    On the resulting pop up form, the Advanced parameters option will be in the bottom

    Happy to help, hope this works for your team.

    ------------------------------
    Mariana Ardito Couto
    Liquor Stores Limited Partnership
    Edmonton AB
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 7.  RE: AP Payment Journal

    SILVER CONTRIBUTOR
    Posted May 26, 2020 10:47 AM
    Hello Mariana,

    So by doing this all open invoices that are due will be applied against the large credit without payment going out to the vendor right? Thanks, please advise.

    ------------------------------
    Kobe Peasah
    National Vision, Inc
    Duluth GA
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 8.  RE: AP Payment Journal

    Posted May 26, 2020 11:14 AM
    Hi Kobe,
    No, this will avoid the credit from showing up on the payment proposal.
    To apply invoices against the credit, there are a couple different options, among them:

    1- Before generating a payment journal, go to the Open vendor invoices form, change the Include credit notes toggle to yes, sort/ filter by the vendor, and select Settle transactions. Once all invoices are settled against the credit, you can generate a payment for the remaining amounts, as needed.

    2 - Before generating a payment journal, go to the All vendors form, find the vendor, and select Settle transactions in the Invoice tab.
    3 - if you want invoices for all vendors to always automatically settle against open credits, there is a Auto settlement parameter in the Accounts Payable parameters>  Settlement page. However, we have not found a way to control which vendors or amounts those should be used for, which in our company was a big concern from the Finance team.

    Thanks

    ------------------------------
    Mariana Ardito Couto
    Liquor Stores Limited Partnership
    Edmonton AB
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role