Applies to Product - Dynamics 365 Supply Chain Management
What’s happening?
Customers are experiencing difficulties when attempting to paste release quantities or material lines from an Excel sheet into the system. The pasted values do not match the displayed values in the system, leading to persistent errors that block partial releases and require manual entry.
Reason:
This may be related to a design limitation within the system, where discrepancies occur between the values copied from Excel and those displayed in the system. Additionally, it has been noted that if a saved view filters for "Transfer status equals Shipped," new transfer orders may initialize as "Shipped" and become uneditable.
Resolution:
- Ensure that the data in the Excel sheet is formatted correctly and matches the expected input format in the system.
- Use the Trim() function in the material ID field to remove any leading or trailing spaces that may cause discrepancies.
- Refer to the documentation provided in the following link for further guidance on using the Excel add-in: Excel Add-in Documentation.
- If the issue persists, consider capturing a trace to investigate the system code execution order and schedule a follow-up meeting to discuss further troubleshooting steps.