SAP Knowledge Base Article - Public

3021989 - How to get Tax Amount, Net Amount and Gross Amount in the Purchase Order Report?

Symptom

You have a business need to see the report or data source for purchase order which shows net value, gross value and tax amount for line items.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics work center
  2. Go to the Design Reports or Design Data Sources
  3. Search for a report which provides Gross Amount and Tax Amount
  4. No direct reports or data sources available

Cause

You can use the data source Purchase Order Items with Extended Tracking Details or Purchase Order Item Details to get the required fields in the purchase order reports.

Resolution

The Tax Amount field and Gross Amount field is stored with in Adapt mode and you need to enable it. To do so;

  1. You can go to Business Analytics work centerand select Design Data Sources view
  2. Search for Data Source Purchase Order Items with Extended Tracking Details or Purchase Order Item Details 
  3. Select Adapt button 
  4. You can see the TaxAmount field and Add field Name as Tax Amount
  5. Gross Amount is a calculated based on the List Unit Price. Select the field ListUnitPrice/Amount and name it as Gross Price or List Unit Price
  6. Now select Add button and selectc Close
  7. Now you can build a report based on this data source or you can use the existing report which is based on the above mentioned data sources

Keywords

purchase order report gross price; purchase order report tax amount; Report for tax amount; Net Amount report; PO tax amount report; PO Gross Amount report; , KBA , AP-POP-PO , Purchase Order , Problem

Product

SAP Business ByDesign 2011 ; SAP Business ByDesign 2102 ; SAP Business ByDesign 2105