SAP Knowledge Base Article - Public

2521410 - Tax Amount is zero in Monitoring Invoices Report

Symptom

You see that Tax Amount in the Monitoring Invoices report is 0 for few invoices.

Environment

SAP Business ByDesign

Reproducing the Issue

Monitoring Invoices report :

  1. Go to Supplier Invoicing work center
  2. Select Lists under Reports view
  3. Open the Monitoring Invoices report
  4. Enter the  Invoice ID
  5. The Tax Amount is 0.

Also

  1. Go to Supplier Invoicing work center
  2. Select Invoices and Credit Memos view
  3. Search for the  Invoice XYZ (XYZ refers to custom duty invoice ID)
  4. Navigate to items tab
  5. Select item and go to basic data sub tab
  6. Item type is Import VAT Debit Item or Customs Duty Debit Item

Cause

For the  Item types Import VAT Debit Item or Customs Duty Debit Item, Currently the tax amount present in the report is calculated with following formula at the backend is :

Gross Amount - Net Amount = Tax Amount.

Since the Gross Amount and Net Amount in this invoice items is same, the tax amount in the report is being calculated as 0.

To see the tax amount in the invoice, kindly follow the below steps :

  1. Go to Supplier Invoicing work center
  2. Select Invoices and Credit Memos view
  3. Search for the Custom Duty Invoice XYZ (XYZ refers to custom duty invoice ID)
  4. Navigate to General tab
  5. Here the tax amount is not 0.

Resolution

Kindly follow the below details to get the tax amount onto the report as present in the Custom Duty Invoice.

Create a Custom data source on the Supplier Invoice Item including the Tax Amount attribute (Tax Amount field is PSM Released). Join the standard data source (Monitoring Invoices) with the newly created custom data source. Once this is done, the tax amount will be updated for the custom duty invoices like other invoices.

Keywords

tax amount in report, custom duty tax report, custom duty amount in report, tax amount in report, Invoice Report does not show tax amount , KBA , custom duty tax report , custom duty amount in report , tax amount in report , AP-SIP , Supplier Invoice Processing , How To

Product

SAP Business ByDesign all versions