131
I believe this is a documented issue for Dynamics Nav, and there was a fix described in the link below. Very frustrating to run into this error today and realize I had to manually create a reversing entry throught a General Journal. Can BC team please fix this issue?

https://forum.mibuso.com/discussion/comment/295389#Comment_295389

Here are the steps we did to get an error message "You cannot reverse Vend. Ledger Entry No. (xxx) because the entry has an associated Realized Gain/Loss entry.":
1) Create Purchase invoice for vendor in foreign currency
2) Create and apply a payment to this invoice, also in foreign currency
3) Unapply the payment from this invoice
4) Attempt to "reverse transaction" on the payment
STATUS DETAILS
Completed
Ideas Administrator

This 'feature' is planned to go out with the 2023 Wave 2 release (Oct 2023)

Best regards,

Brian Nielsen, Business Central Team

Comments

S

Second all the comments. Perhaps if Microsoft tendered to this wild overgrown garden of ideas they would be able to better prioritise. This ideas system is failing them due to duplication and lack of good collaboration with their ecosystem.


Glad to see this is being considered - but you could easily argue that before they mess around with Analysis Mode on lists they should be addressing functional blockers like this.


It is a massive pain and doesn't make any sense - a regular user just views it as a lazy system that doesn't want to be bothered with doing the work to reverse the transaction and they aren't wrong.

Category: Financial Management

S

To tell users this is not in MS roadmap, it does not easily make sense.

When they fail to reverse and be required to post an adjustment, the erroneous entries are appearing in bank reconciliations and unnecessarily complicate the process.

From the end user point of view, and in my opinion, this is a bug which needs to be fixed. It is not an additional feature.

Category: Financial Management

S

This issue is a very old (since NAV 2009R2) and very vital part of Requirements, Microsoft must focus on this issue and give the solution for this issue. Then only it will make Business Central a perfect ERP system.

Category: Financial Management

S

Hi Microsoft Team, how many votes you need in order to fix this? ERP is to simplify individual activities and provide automates processes to help business.


This manual reverse method really time consuming as user have to double check all posted entries then repost again.


Category: Financial Management

S

I agree with Jose. This feels like an answer that is devoid of prioritisation by a team that has understanding of the business impact and potential for work-around. There is no explanation of why correcting entries can't be made to realized payments.

I cannot think of another ERP that has this restriction and it creates real issues when there is a minor data entry error that needs to be reversed out.

It seems rationale to draw the conclusion that 'they can't be bothered'.

The BC product team really need to draw up a charter of guiding principles if they want to service the small and medium market and then they can answer with rationale:

1) It's not on the roadmap because we have something better coming along and we don't want to waste time on a short term fix.

i.e. We are working on a proper holistic fix in re-engineering the entire system to dynamically generate posting entries in realtime from the business documents at a point in time queried, rather than creating separate posting entries that create huge amounts of unnecessary data and solved a problem when we had limited compute power, but much more storage.

2) It's not on the roadmap because it doesn't align with our vision and goal to service small and medium businesses and stay away from the functional domain serviced by other products in the portfolio.

i.e. Multi-national with global subsidiaries and staff over 100 should really look elsewhere and we will actively discourage you from the product even though we might have supported you in the past when we had an unfocused overlapping product portfolio driven by national geographies, rather than customer segments.

3) It's an idea that would actually cause more issues elsewhere in the product and that other people wouldn't necessarily support, so we will review and promote discussion.

4) We have a better workaround that is quick and solves your problem easily. Given the degree of difficulty in solving this we are not prioritising.

Category: Financial Management

S

Actually this needs to be fixed, it's not possible that you say "It's currently not on our roadmap"

It's a basic functionallity in every other ERP, when you need to reverse something and you click on the functions made to reverse an entry it should REVERSE THE ENTRY.

There's also the problem with Sales Orders or Purchase Orders already paid, you can't use the Reverse function because it already causes a VAT movement and the system can't make the reverse too.

This both problems should be looked at as they're part of the basic functionallity.

We had 2 Tickets submited to MS and the solution was: Reverse it manually.

Category: Financial Management