Open Forum

Expand all | Collapse all

Vendor Remittances

  • 1.  Vendor Remittances

    Posted Mar 14, 2018 07:36 PM
    I am using NAV 2013 R2 and am wondering if anyone has any knowledge of setting up vendor remittances using pre-built tools in the system?

    Currently, I am processing payment manually through our bank and manually sending payment remittances through MS Outlook.

    Any information would be greatly appreciated!


    ------------------------------
    Richard Luu
    Accounts Payable Manager
    GU Energy Labs
    Berkeley CA
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Vendor Remittances

    TOP CONTRIBUTOR
    Posted Mar 14, 2018 08:02 PM
    Richard,

    NAV can be set up to use ACH payments. The below blog post goes over the key things that need to be configured
    Using Microsoft Dynamics NAV for Electronic Payment (ACH) Transactions

    NAV 2017 can be configured to then email the remittance advice, but this functionality will be a customization for NAV 2013 R2.

    ------------------------------
    Ian Ray
    Cypress Grove
    Arcata CA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Vendor Remittances

    Posted Mar 15, 2018 07:14 AM
    Hi, Richard,
    is the 2017 functionality for emailing remittance advices available in NAV 2016 as well as 2017?


    ------------------------------
    Kelly Borchelt
    Pegasus Optimization Managers, LLC
    College Station TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Vendor Remittances

    TOP CONTRIBUTOR
    Posted Mar 15, 2018 12:20 PM
    Kelly,

    This was introduced in NAV 2017, afaik. It would be a minor customization to add emailing, but it is not there by default.


    ------------------------------
    Ian Ray
    Cypress Grove
    Arcata CA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Vendor Remittances

    TOP CONTRIBUTOR
    Posted Mar 15, 2018 08:21 PM
    Hi Kelly,

    NAV 2016 does indeed have the e-mail output method for the export electronic payments report (effectively the remittance advice), along with the Word report for the export report (REP #11383):


    However it is important to note that in all versions that have this feature, the remittance e-mailing happens before the export, which can be an issue if the bank rejects the file or you void the batch because of an issue, etc.



    ------------------------------
    Ramin Marghi , CPA, CGA
    CPA, CGA | ERP Consultant
    Catapult ERP
    VANCOUVER BC
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Vendor Remittances

    TOP CONTRIBUTOR
    Posted Mar 16, 2018 12:44 PM
    Ramin,

    Thank you for the correction that emailing remittance advice is indeed available in NAV 2016.

    ------------------------------
    Ian Ray
    Cypress Grove
    Arcata CA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Vendor Remittances

    Posted 4 days ago
    Hi Ramin!

    I realize this is an old thread, and not sure if you will get this.  I'm in NAV2017, and I've setup what I think i need to in order for the Remittances to get emailed.  However, on the Vendor Card - Document Layouts - I do not have a remittance usage selection in my 2017 environment?  I do in my 2018, but not 2017?  I do have however in the payment journal process, all you mentioned above to send the report output via EMAIL?  Does this work some other way circumventing not having the "usage" at the vendor master record level?

    Any input you have, would be greatly appreciated.



    ------------------------------
    Thomas Marks
    Family Brands
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: Vendor Remittances

    TOP CONTRIBUTOR
    Posted 4 days ago
    Thomas,
    Microsoft made some changes to the ACH process in NAV 2017 and they improved the ACH process in NAV 2018.
    There are a limited number of reports available in Document Layouts for NAV 2017.  This is greatly enhanced in NAV 2018.
    In NAV 2017, the Remittance Advice is created when you export the lines in the Payment Journal.  It is important that you print the Remittance Advice as a PDF so you can produce the report a second time.  Once you export the Payment Journal and process the payment, you cannot recreate the Remittance Advice in NAV 2017 the way you can in NAV 2018.
    However, there is another report in NAV 2017 that closely replicates the Vendor Advice.  It is the Vendor Payment Receipt which is found in the Documents Menu under Payables.  One note about the standard Vendor Payment Receipt report, it prints your internal Payment Document number not the Vendor's External Document number.  If you want to use this report for your Vendor, you will probably want to have the report modified to account for the information the Vendor would need to reconcile their payment.

    ------------------------------
    Robb Delprado
    Senior Trainer and Consultant
    New View Strategies
    robb@newviewstrategies.com
    860.558.8032
    Houston, TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


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