Open Forum

Expand all | Collapse all

BC Payment Journal Error

  • 1.  BC Payment Journal Error

    GOLD CONTRIBUTOR
    Posted Sep 12, 2019 08:56 AM
    We just went live with Dynamics BC on Monday and are receiving an error when attempting to export the ACH file for a payment journal - The Bank Account does not exist. Identification fields and values: No.=''

    I have verified all our setups from our bank to the vendors banks are the same as what was in our previous system which worked with no issues.

    Has anyone encountered this error and what did you do to fix it?


    ------------------------------
    Liz McQuiston
    Corporate Controller
    Superior Walls of America
    New Holland PA
    Running NAV 2016, currently upgrading to BC on Prem
    ******************************
    BCUG/NAVUG Board of Advisors
    Delaware Valley Chapter Leader
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: BC Payment Journal Error

    TOP CONTRIBUTOR
    Posted Sep 12, 2019 09:50 AM
    @Liz McQuiston There is a Preferred Bank Account field on the Vendor Payments FastTab that needs to be filled in. This was not required on older versions. This may be the issue.

    V Pay


    ------------------------------
    Cynthia Priebe MCP, DCP
    Senior Analyst and Project Manager
    Liberty Grove Software

    I would love to see you at Summit 2019!
    GET67 - Small Changes with Big Impact: Core Application Setup and Configuration
    ADM60 - Mods: Just Because Everyone Does Them Doesn't Mean You Should
    FIN58 - (with Andrea Riviezzo) My AP Person Just Left, Now What?
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: BC Payment Journal Error

    GOLD CONTRIBUTOR
    Posted Sep 12, 2019 10:05 AM
    Thank you @Cynthia Priebe I did see that and fill it in, still getting the error.​

    ------------------------------
    Liz McQuiston
    Corporate Controller
    Superior Walls of America
    New Holland PA
    Running NAV 2016, currently upgrading to BC on Prem
    ******************************
    BCUG/NAVUG Board of Advisors
    Delaware Valley Chapter Leader
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: BC Payment Journal Error

    Posted Sep 13, 2019 10:32 AM
    You need to make sure that on the Vendor Bank Account table that the country code is setup.

    ------------------------------
    Linda Brown
    Senior Consultant
    BDO Canada
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: BC Payment Journal Error

    GOLD CONTRIBUTOR
    Posted Sep 13, 2019 11:23 AM
    Thank you @Linda Brown that too is set up already.​

    ------------------------------
    Liz McQuiston
    Corporate Controller
    Superior Walls of America
    New Holland PA
    Running NAV 2016, currently upgrading to BC on Prem
    ******************************
    BCUG/NAVUG Board of Advisors
    Delaware Valley Chapter Leader
    ------------------------------

    Conference-BCNAVUG_200x200


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