Views:

Applies to Product - Dynamics 365 Finance


What’s happening?
Customers encounter an error stating, "The transactions on voucher do not balance as per date" when attempting to post pending vendor invoices. Additionally, there are instances where project invoicing fails due to an unbalanced voucher during credit invoicing on an on-account transaction.
 

Reason:
The underlying cause of this appears to be related to incorrect amounts on invoice lines, particularly when there are discrepancies between the invoice amount and the purchase order amount. This can lead to the transactions not balancing as expected.
 

Resolution:
Follow these steps:

  1. Enable Vendor Invoice Recovery
    1. Navigate to Accounts Payable (AP) > AP parameters > Invoice tab.
    2. Enable the "Allow vendor invoice recovery" option to make the Recover vendor invoices page available.
  2. Recover Vendor Invoice:
    1. Go to AP > Periodic tasks > Recover vendor invoice.
    2. Select the impacted invoices and click “Recover” to recover vendor invoices that have been locked for editing. After recovery, invoices will be available for editing from the Vendor invoice page
  3. Delete Pending Vendor Invoice: 
Go to AP> Invoices> Pending vendor invoice, choose the impacted invoice, and click "Delete." The invoice should now be deletable.
  1. Reset Distribution:
    1. Go to Procurement and Sourcing> Purchase orders> All purchase orders and run the "Reset Distribution" task for the impacted purchase orders.
    2. Generate the invoice again to create a new purchase order invoice, which should be editable and deletable..