Finance | Project Operations, Human Resources, ...

Answered

Netting Execution Stuck – Can’t Proceed with Customer/Vendor Balance Netting

(2) Share

Report

Posted on by AK-04061727-0

I'm facing an issue with Customer and Vendor Balance Netting in Dynamics 365 Finance.

Every time I try to post or even delete a netting pair for a specific customer and vendor, I get the error:

"Customer and vendor balance netting cannot be executed. There is another netting execution running on the selected vendor or customer."

✅ Here's what I already tried:

I checked Netting history → it's empty.

No active or failed Batch jobs related to Netting.

I tried to delete the netting pair, but I get:

"Netting pair cannot be deleted while dependent netting execution exists."

WhatsApp Image 2025-03-28 at 01.14.35_d0460439.jpg

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Holly Huffman 6,538 Super User 2025 Season 2 on at

Like (0)

Report
Hi there! Good morning, evening, or afternoon - depending on where you are :) Hope you are well today!

The issue you're encountering with Customer and Vendor Balance Netting in Dynamics 365 Finance is likely due to a lingering or incomplete netting execution process that hasn't been properly cleared. Here are steps to troubleshoot and resolve the problem:

Possible Causes

Stuck Netting Execution:

A previous netting execution might not have completed successfully, leaving the system in a state where it believes the process is still running.

Dependent Netting Execution:

The error message suggests that there is a dependent netting execution tied to the netting pair, even though the history appears empty.

Batch Job Issues:

While you mentioned no active or failed batch jobs, there could be hidden or orphaned batch processes causing the issue.

Data Integrity:

There might be inconsistencies in the database related to the netting pair or execution records.

Steps to Resolve

Check Batch Job History:

Go to System Administration > Batch Jobs and review the history for any completed or failed jobs related to netting. If you find any, clear or delete them.

Clear Netting Execution Records:

Use SQL queries to check for lingering netting execution records in the database. For example:
SELECT * FROM NettingExecutionTable WHERE Status = 'Running';

If you find any stuck records, update their status to 'Completed' or delete them (ensure you have a backup before making changes).

Reset Netting Pair:

Temporarily deactivate the netting pair in the Netting Agreement setup, then reactivate it. This can sometimes clear dependent executions.

Recreate Netting Pair:

If the issue persists, delete the netting pair (after resolving dependent executions) and recreate it.

Hope this helps :)

Was this reply helpful? Yes No
Verified answer

Jonas "Jones" Melgaard 4,986 Most Valuable Professional on at

Like (2)

Report

It's most likely due to a crash happening while netting calculation was running.

I don't recall a way to reset it from the user interface, but you can have a developer or Microsoft support clear the lock by going into the execution table for netting (CustVendNettingExecution) and set the status to Error.

Was this reply helpful? Yes No
Vahid Ghafarpour 12,166 Super User 2025 Season 2 on at

Like (1)

Report

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No

Join the conversation

Community site session details

Netting Execution Stuck – Can’t Proceed with Customer/Vendor Balance Netting

✅ Here's what I already tried:

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Netting Execution Stuck – Can’t Proceed with Customer/Vendor Balance Netting

✅ Here's what I already tried:

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates