Views:

Applies to Product - Dynamics 365 Supply Chain Management 

What’s happening?
The customer encounters an error when attempting to activate pending costs for items, specifically receiving a message indicating that the transactions on a voucher do not balance, resulting in the posting being canceled.


Reason:
The error may occur due to several reasons, including: 

  • If there are unactivated pending cost records, they need to be either activated or deleted before the overall activation can succeed.
  • Accidental posting of journals (e.g., item transfer journals) for future dates can also block activation.
  • Withholding tax applied to the transaction being greater than the amount of the open transaction.
  • Settlement status changes after undoing a settlement for a customer/vendor payment or due to settlement data corruption where settled amounts exceed the transaction amount.
  • Data corruption in the database affecting the transaction records.
Resolution:
To address the item cost activation error, follow these steps:
  1. Check Released Product Configuration:
    1. Navigate to Released Products > Manage cost > Item Price and verify if there are any pending costs that need to be activated or deleted.
    2. Ensure Item model group is selected as Standard (Standard Cost)
  2. Costing Version Setup:
    1. Ensure the “Block Activation” flag in the Costing version setup page is set to “No” to allow activation of pending cost records.
    2. Ensure “Costing type” is “Standard Cost” and not “Planned Cost”.
  3. If error message is encountered while activating the item price of a large number of items, then check if the activation of an individual item works or throws the same error message.
  4. Review Journals:
    1. Check for any journals posted with future dates that might be interfering with the activation process.
  5. Verify Withholding Tax:
    1. Check if there is any withholding tax applied to the transaction.
    2. Ensure that the amount of withholding tax is less than the amount of the open transaction. If unsure, try processing the transaction in another journal without withholding tax.
  6. Check Settlement Status:
    1. Undo all settlements for the voucher mentioned in the error message and attempt the process again.
    2. Use scripts to check the settlement status and correct any discrepancies.