I have set up batch attributes on some products and I put values in the attributes. Everything is working good. I need to change the values sometimes. Is it possible to see the historical values?
For historical values, the answer is no. There is no mechanism or screen available in Dynamics 365 F&SCM for viewing historical batch attributes available out of the standard D365 system. The values are lost unless you have a custom auditing or logging component tied to track the changes into these tables.
You can leverage the Inventory batch attributes v2 (PdsItemBatchAttributeValueV2Entity) with Change tracking enabled and host the data inside a historical table or a file storage (Azure blob) and keep the historical copy of the batch attribute values.
Configuration wise, you can use features Monitoring or Telemetry features tied to the InventBatchAttribute table. Alternatively, you can use tools like Fastpath to capture the audit logs using the CRUD model. Database logging would be an option that i would recommend to keep as a last option and consider options like Monitoring and Telemetry and Fastpath audit trail tools.
The other option is to extend the system with change tracking (eg. event handlers or PowerBI reporting using Azure Synapse link with Fabric) and capture the data onto a historical table for future references.
Hope this helps. Happy to answer questions, if any.
1 people found this reply helpful.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
344
Share
Report
All responses (
Answers (
