Hi all,
We have implemented the standard E-Invoicing feature in Dynamics 365 Finance & Operations for Saudi Arabia and Egypt. The setup was working as expected, and we were able to successfully submit our sales invoices using the standard submission process.
However, without any changes made to the configuration or customizations, the submission process has suddenly stopped working in our UAT environment.
We are now encountering the following error when attempting to submit invoices:
[Error] Sql command failed: Inner System.Data.SqlClient.SqlException
The target table 'dbo.BUSINESSDOCUMENTEXECUTIONREQUEST' of the DML statement cannot have any enabled triggers
if the statement contains an OUTPUT clause without INTO clause. Try again or contact with the system administrator.
Context: [CountryISOCode: SA, DocumentType: Customer invoice, LegalEntityID: e355, SubmissionType: blank]
This issue occurs at the point of submission, and the record is not being submitted at all.
It’s worth noting that the same feature is already deployed and working fine in the Production environment for one of the entities. The issue appears to be isolated to UAT, which makes it even more confusing since there have been no recent deployments or changes made to UAT either.
Has anyone encountered this error recently or can shed light on what might be causing this behavior?
Appreciate any support or insights on how to resolve this.
Thank you!
