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 :
- Go to Supplier Invoicing work center
- Select Lists under Reports view
- Open the Monitoring Invoices report
- Enter the Invoice ID
- The Tax Amount is 0.
Also
- Go to Supplier Invoicing work center
- Select Invoices and Credit Memos view
- Search for the Invoice XYZ (XYZ refers to custom duty invoice ID)
- Navigate to items tab
- Select item and go to basic data sub tab
- 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 :
- Go to Supplier Invoicing work center
- Select Invoices and Credit Memos view
- Search for the Custom Duty Invoice XYZ (XYZ refers to custom duty invoice ID)
- Navigate to General tab
- 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