Open Forum

Expand all | Collapse all

Create File To Upload To Bank

  • 1.  Create File To Upload To Bank

    Posted 15 days ago
    We are fairly new to NAV 2017. We rushed into NAV in the beginning and are now trying to go back and shore up the foundations of our NAV Accounting systems. One of the areas we want to build into our Invoice Payments is the ability to create a file of payables to be paid, that can be uploaded to our bank for payment. Can this be created within NAV 2017 or do you have to have 3rd party software to do this? We currently are using the NAV 2017 - Basic package.

    ------------------------------
    Brian St Clair
    Controller
    Columbia Pulp I, LLC
    Dayton, Wa
    ------------------------------


  • 2.  RE: Create File To Upload To Bank

    TOP CONTRIBUTOR
    Posted 14 days ago
    Hi Brian,
    You're probably looking for Positive Pay which is a function within NAV 2017. The link below will get you started, however, depending on your bank, they may request for specific requirements when exporting positive pay.

    Export Positive Pay Files - Dynamics NAV App
    Microsoft remove preview
    Export Positive Pay Files - Dynamics NAV App
    To make sure that your bank only clears validated checks and amounts, you can export a Positive Pay file that contains vendor information, check number, and payment amount, which you send to the bank for reference when you process payments. Dynamics NAV is preconfigured to support Positive Pay files for Bank of America and City Bank.
    View this on Microsoft >


    ------------------------------
    Kristoffer Ruyeras
    Tigunia
    Seattle, WA
    ------------------------------



  • 3.  RE: Create File To Upload To Bank

    TOP CONTRIBUTOR
    Posted 14 days ago
    Edited by Greg Enns 14 days ago
    It sounds to me like you're looking for ACH file exports. We use these to have our bank pay invoices for us. Essentially, in the NAV Payment Journal you export a txt file that you can then upload to your bank with all the info needed for the bank to wire the funds to the appropriate vendor bank accounts.
    Here's a pretty good step-by-step for getting started: https://www.archerpoint.com/blog/Posts/using-microsoft-dynamics-nav-electronic-payment-ach-transactions

    ------------------------------
    Greg Enns
    ERP Coordinator
    Technical Prospects
    Kaukauna WI
    ------------------------------



  • 4.  RE: Create File To Upload To Bank

    Posted 14 days ago
    I think the Archer Point blog is close, but that is for a previous version and not all of the fields shown there exist in 2017. While Positive Pay is a great new feature, it's not the ACH you are asking for, but do look into that. It does protect you from fraud. To look at the 2017 ACH setup, you might try these 2 links in the order they are shown.

    https://www.cloudfronts.com/setups-required-perform-automated-clearing-house-ach-payments-vendor-bank-accounts-microsoft-dynamics-nav/
    https://community.dynamics.com/nav/b/dynamicsnavcloudfronts/archive/2017/05/22/automated-clearing-house-ach-payments-to-vendor-bank-accounts-in-microsoft-dynamics-nav

    That should at least get you started. Good luck!

    ------------------------------
    Jim Brewer
    Silverware
    beaverton AZ
    ------------------------------