Symptom
You want to show Net Amount field in G/L Accounts - Line Items report, but cannot find it available.
Reproducing the Issue
- Go to General Ledger work center.
- Go to Reports view and List subview.
- Search for report G/L Accounts – Line Items.
- Choose the selection criteria you want to use.
- Click on Go.
- Go to Settings option.
- Select Key Figures.
You cannot find Net Amount option in Available Key Figures.
Cause
This report does not show the Net Amount data. This is standard system behavior.
Resolution
If you need this data to be displayed in this report, you can create a custom Key Figure and add it to the G/L Accounts – Line Items items. You have further instructions on how to create a Key Figure in the Help Document: Create and Edit a Key Figure, which can be found via Help Center.
After that, in the report tab, click on Add Fields button, in the tab key figures select the options you wish, then click on Ok.
Keywords
KBA , general ledger , net amount , SRD-FIN-GL , General Ledger , How To