SAP Knowledge Base Article - Public

2885903 - Down Payment Request is not Shown in Accounts Payable - Open Items Report

Symptom

You have created a down payment request for a given supplier account. You see that the down payment request is being shown as Open Item in the supplier account monitor, however this down payment request is not shown when running the Accounts Payable - Open Items report.

Environment

SAP Business ByDesign.

Reproducing the Issue

Go to Payables work center.

  1. Go to Supplier Accounts view.
  2. Open the related supplier account monitor. You'll see the Down Payment Request is Open status.
  3. Go to Lists view of the Payables work center.
  4. Open the report Accounts Payables - Open Items.
  5. Give the relevant company, supplier ID and dates. 
  6. Run the report.

You notice that the Down payment Request is not returned in the reports list.

The same behavior can be noticed in the Accounts Payables - Line Items.

Cause

The Down Payment Request is still not posted (no Journal Entry assigned) and hence is only considered as a statistical item. In the Supplier Account Monitor, note that there is a checkbox flagged as Include Statistical Items, reason being that the down payment request is shown in the supplier account monitor.

Resolution

In order to make the Down Payment Request visible in the Accounts Payables - Open Items Report or Accounts Payables - Line Items Report please follow the below steps.

  1. Open Accounts Payables - Open Items Report or Accounts Payables - Line Items Report.
  2. Enter your selection criteria.
  3. Under Standard Selection option select the field "Statistic Relevance".
  4. Here you have to select "X" form the options.

 Now you notice Down Payments details appear on the report.

Please be aware to see the Down Payment Request Value you must add the column Debit Amount Line Item Currency.

Keywords

statistic items, Accounts Payables, Statistical Items, down payment request. Open Items, Line Item. Down Payment Request. , KBA , SRD-FIN-ACP , Payables , How To

Product

SAP Business ByDesign all versions