Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Unapplied payment to vendor invoice issue

(0) ShareShare
ReportReport
Posted on by

Hi All

I've tried to unapply a payment to vendors invoices.  I'm able to unapply other payments to vendor invoices except for one.   The payment is in foreign currency (AUD), the reporting currency is in USD.  When I tried to unapply the payment I've the following error message:

 

"The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table.  Check where and how the CONSISTENT functions is used in the transaction to find the reason for the error.  Table can be marked as inconsistent during comprehensive tasks, such as posting.  This prevents data from being updated incorrectly."

I don't know what cause the problem and why it will affect the G/L Entry table.  I would thought unapply payment won't post anything to G/L account?!

Much appreciated if anyone could help on this, thanks!

*This post is locked for comments

  • Verified answer
    Tharanga Chandrasekara Profile Picture
    23,116 on at
    RE: Unapplied payment to vendor invoice issue

    Please check following link : http://tharangac-dynamicsnav.blogspot.com/2014/10/the-transaction-cannot-be-completed.html

  • Verified answer
    mmv Profile Picture
    11,469 on at
    RE: Unapplied payment to vendor invoice issue

    Hi,

    Unapply entry works this way:

    https://msdn.microsoft.com/en-us/library/hh893079(v=nav.71).aspx

    For the inconsistency, you may need to debug the code.  You may follow the below link:

    http://gotcal.com/index.php/2010/10/what-is-in-your-dynamics-nav-toolbelt-find-inconsistency-in-gl-entries-when-posting/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans