Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Lewis Rosenberg]

Hello NAVUG Friends,

We are trying to void some ACH payments.  It looks we have somehow duplicated these payments and are now getting an error:   The Currency does not exist.  Identification fields and value: Code=”

This is from the Check Ledger Entries for 5/17/2017.

I tried to void one particular “Check No.” for a value of $34,313.07.  This check no. actually appears twice in the Check Ledger Entries each time with the same value of $34,313.07.  When I ran the debugger, I can see that the error occurs in Codeunit 367 (CheckManagement) because the CheckAmountLCY is $68,626.14 (double!) and the BalanceAmountLCY is -$34,313.07.  NAV wants the difference between these two values to be zero, otherwise it looks to the bank table 270 to get a currency code.   I think it then tries to post a currency conversion rounding entry.  Since the currency code is blank we get the error when trying to acquire a currency code from the Bank Account table.

           _{IF CheckAmountLCY + BalanceAmountLCY <> 0 THEN BEGIN  // rounding error from currency  conversion
                           Currency.GET(BankAcc.”Currency Code”);}

Any ideas on what we can do to fix this?

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————

[Kyle Hardin]

I had to solve this for a customer a month ago. I ended up doing a journal that made reversing entries – duplicating what a successful Void would do as far as the General Ledger and Bank Ledger was concerned. But I had to write a small bit of code to mark the Bank and Check Ledger Entries as Voided.

——————————
Kyle Hardin
NAV Developer
ArcherPoint Inc.
Lawrenceville GA
——————————
——————————————-

[Crystal Tollison]

Lewis,
Can you ‘un-apply’ the payment? I would do that step first. You may be able to Void the payment after doing that step. Let me know what happens!

——————————
Crystal Tollison
Consultant
ArcherPoint Inc.
Lawrenceville GA
——————————
——————————————-

[Lewis Rosenberg]

Our partner helped – We were able to un-apply the payments but we still could not void the check ledger entries.  We had to manually delete the duplicate check ledger entries with the help off our partner leaving only the original entries behind to be voided.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-