You have performed an Inventory Adjustment for a product and have updated the reason for deviation in the field Deviation Reason. However, in Confirmation Journal report the system displays Deviation Reason value as Not Assigned.
Reproducing the Issue
- Go to Physical Inventory work center.
- Navigate to the Reports: List view.
- Select the Confirmation Journal report link.
- Enter the relevant product information to view the confirmation ID for the Inventory Adjustment performed.
You can see that under the colum Deviation Reason system displays the value as Not Assigned.
The Deviation Reason field available in Confirmation Journal report is mapped to the difference posting confirmations in logistics tasks (Inbound, Outbound and Internal) and not to count task and inventory adjustment related confirmations. This is the reason why you are not able to see the deviation reason you have maintained in inventory adjustments or count task documents.
As a work around you can build a custom data source by the joining the Confirmation Journal data source and Physical Inventory Count business object. This custom data source will be able to display Deviation Reason maintained for count task confirmations and inventory adjsutments. The Physical Inventory Count business object is released to partners for further modifictions.
KBA , SRD-FIN-FA , Fixed Assets , How To