Symptom
You execute the report Material Inventories - Line Items and found the Key Figure 'Amt Comp Curr' shows 0 value
Environment
Business ByDesign
Reproducing the Issue
- Navigate to Business Analytics Work Center
- Select Design Reports and search for report 'Material Inventories - Line Items'
- Open the report and enter the relevant fields like Company Code, Set of Books, G/L account, Journal Entry and so on
- Once its executed, you observe the key figure 'Amt Comp Curr' shows 0 amount
Cause
Eventhough the respective Journal Entry has the non zero values for the G/L account used in the report, same amount is available in both the debit and credit side which means the source document e.g. Goods and Activity Confirmation has in(+) and out(-) quantities, resulting in net value of zero for the G/L Account
Resolution
To accurately see the transactional values, the report needs to have 2 columns Journal Entry Item ID and Journal Entry. Then both positive and negative value of same amount can be seen to which the resultant value is zero.
Keywords
Design Report, Material Inventories - Line Items, Goods and Activity Confirmation , KBA , SRD-FIN-ANA , Analytics Content , Problem