Symptom
In the production order variance report, you can see the following information of a product and its components: Type, No., Description, Qty, Avg. Cost, Total, and Variance. Yet, you need more details for comprehensive analysis.
Reproducing the issue
Prerequisites:
- You are using SAP Business One version 9.3 PL02 or later.
- The Use Perpetual Inventory option is selected in Administration → System Initialization → Company Details → Basic Initialization tab.
Scenario:
- Create a production order together with some Issues for Production and Receipts from Production.
- Reopen the created production order. In the Summary tab, select the yellow link arrow next to the Total Variance field.
Solution
System behavior prior to SAP Business One 10.0 FP 2405 and SAP Business One 10.0 FP 2405, version for SAP HANA:
The Variance Report opens. You can see the following information of the selected product and its components: Type, No., Description, Qty, Avg. Cost, Total, and Variance.
System behavior after upgrade to SAP Business One 10.0 FP 2405 and SAP Business One 10.0 FP 2405, version for SAP HANA:
The Variance Report is extended to include a two-level view. The enhanced report allows you to drill down to see additional data for each component row, and includes new fields such as Issue Type, Source Journal Entry No., Source Document, and Target Document. You can expand any row in the default view to see the second-level lines, or you can expand all rows at once using the Expand All button.
