1851805 - Variable 'VAT / Sales Tax Percent' in Report 'Accounts Receivable - Line Items' Shows as 0.000000

SAP Knowledge Base Article - Public

1851805 - Variable 'VAT / Sales Tax Percent' in Report 'Accounts Receivable - Line Items' Shows as 0.000000

Symptom

In the report Accounts Receivable - Line Items you are selecting an account with account movements and vat-relevant customer invoices. However, in the column VAT / Sales Tax Percent the value 0.000000 is shown for all relevant positions. Moreover, other related variables e.g.: VAT / Sales Tax Rate Type, VAT / Sales Tax Rate Type, VAT / Sales Tax Country, VAT / Sales Tax Due Category - are shown as Not assigned

 

Reproducing the Issue

  1. Go to the Receivables work center.
  2. Navigate to view Reports / List.
  3. Choose the report Accounts Receivable - Line Items.
  4. As Customer select an account with vat-relevant invoices and press Go.
  5. Drag the variable VAT / Sales Tax Percent into the report / rows.

Cause

This is a system definition. For this Accounts Receivable -Line Items report, attributes of the offsetting items (credit) are only shown in certain cases.
The mentioned tax relevant categories are filled, for example, in case of VAT-relevant down payments for customer accounts.

For an illustration, please refer to the below screenshot taken from the report Accounts Receivable - Line Items in the case of applied down payments. 

 Capture Case Document.PNG

Keywords

KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions