In Dynamics 365 Finance and Operations, a validation key is available under Accounts Receivable parameters to prevent duplicate invoice number generation for Free Text Invoices (FTI).
However, no similar validation exists for Sales Orders, which occasionally results in duplicate Sales Invoice numbers being generated during invoice posting, especially during high-volume or parallel processing scenarios.
To ensure data integrity and maintain consistent invoice numbering across all AR processes, we request Microsoft to introduce a standard system validation for Sales Order invoices, similar to the existing FTI duplication check.
Requested Enhancement
- Add a duplicate invoice number validation control for Sales Order invoicing under AR or Sales parameters.
- Ensure that the system automatically prevents posting when the next invoice number is already used.
- Provide logging or messaging similar to the FTI feature for easy troubleshooting.
Business Impact
- Prevents financial posting inconsistencies.
- Eliminates manual corrections and credit/rebill scenarios.
- Ensures compliance with audit and statutory requirements.
- Improves reliability of the standard numbering sequence during peak processing.
Comments
As of now, we have identified same issue for 2 different customers since last one year. I am not sure how many other customers suffer due to this, but this needs immediate attention. There is no logic to provide validation only for FTI transactions. Sales Invoices, Cr notes also should be included in the validation point of view. ex-Invoice Invoice account Name Sales order Date Voucher Currency Invoice amount SIN/0449589 C40023 ABC SO-000616755 14-11-2025 SIV/449591 AED 105 SIN/0449589 C40050 TEST SO-000616678 14-11-2025 SIV/449590 AED 278
Category: Accounts Receivable