Open Forum

Expand all | Collapse all

Error message when Reversing Bank Account Ledger Entries

  • 1.  Error message when Reversing Bank Account Ledger Entries

    Posted Jan 31, 2019 04:12 PM
    Before I start my question here are some comments.

    Version: NAV 2013 R2
    Vertical: LINKFRESH
    US Dynamics NAV 7.1 (7.1.38455.0), LINKFRESH 2013 (4.73)

    Company Details (General Ledger Setup)
    • Check G/L Account Usage: TRUE
    • LCY Code: M.N.
    • Unrealized Tax: TRUE
    • Prepayment Unrealized TaX: TRUE
    • VAT in Use: TRUE
    • Additional Reporting Currency" USD
    • Tax Exchange Rate Adjustment: Adjust-Additional Currency Amount
    Here are the details.
    User post a payment to a Vendor on local currency (Pesos) with a bank on the same currency. After posted user realized it was the wrong bank.

    I was able to Unapply Entries on the payment. Here the detail on the entry

    As you can see payment status is Open.

    Then I tried to do a Reverse Transaction.

    When I click on Reverse I get the following error message

    I navigate to Tax Entry 7698.

    I see Unrealized Tax Entry No. is linked to the original invoice.

    I also realized Entry No. 7698 has data on "Additional-Currency Base" and "Additional-Currency Amount". Is this correct? At this point, I am thinking that I should not have "Tax Exchange Rate Adjustment: Adjust-Additional Currency Amount" set up this way on the GL Setup.

    I am open to any ideas or suggestions.

    Finally, I know there is a Tax Settlement process that we have never set up.

    Thank you in advance

    Juan F Martinez
    Wholesum Family Farms Inc.
    Nogales AZ

  • 2.  RE: Error message when Reversing Bank Account Ledger Entries

    Posted Feb 19, 2019 03:43 PM
    Just wondering why do you not try to 'void the payment' for the bank account. I'm assuming this was posted through as a check ledger entry from the payment journal. Rather than reversing the payment entry, void the payment to reinstate the invoice for payment.  Not sure you want run into problems but I would definitely give this a try.

    Kim Dallefeld
    Dallefeld Consulting, LLC
    Member of Dynamics Consulting Group
    Ft. Worth, TX
    2019 NAVUG Board of Advisors
    Past NAVUG Board Chairman
    NAVUG Programming Committee

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