SAP Knowledge Base Article - Public

2870283 - Invoice AAA Should Not Be Included in Monthly Invoice BBB

Symptom

The closing date of the customer invoice AAA(AAA represents the ID of the invoice) is not in the invoicing period of the monthly invoice BBB(BBB represents the ID of the monthly invoice). So you do not think the invoice AAA should be included in the monthly invoice BBB.

For example, the closing date of the customer invoice AAA is 30.04.2019. The invoicing period of monthly invoice BBB is 01.06.2019 / 30.06.2019. But the invoice AAA is included in the monthly invoice BBB.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Receivables work center.
  2. Go to Invoice Summary Documents view.
  3. Search BBB.
  4. Open Invoice ID BBB.
  5. You can see the Invoicing Period is 01.06.2019 / 30.06.2019.
  6. View Document List tab.
  7. You can see the customer invoice AAA.
  8. Click on AAA.
  9. Click on View All.
  10. You can see the closing date is 30.04.2019.

Cause

The closing date in an underlying document has to be determined automatically by the system, based on the closing date pattern assigned to the payer. However, the date proposed can be modified by the user. It can be changed to any date in the month. For the determination of the payment due date in customer invoice, the invoice date was considered as the baseline date. However, for Japan the baseline date for payments is be the closing date maintained in the account master data for the particular closing date pattern. The invoices are summarized based on this baseline date/closing date. The idea is payer invoice should summarizes all the invoices for an account with the same due dates which is calculated from the payment term. Hence the Payment baseline date which is over written by closing date is used for fetching base transaction documents(invoice, credit memo).

Resolution

You can view the base line date of the customer invoice by following the steps below.

  1. Go to Receivables work center.
  2. Go to Customer Accounts view.
  3. Search CCC(CCC represents the account ID of the invoice AAA).
  4. Select Account ID CCC and click on View.
  5. Select Invoice AAA and click on Item Details.
  6. You can see the Base Line Date is 15.06.2019.

Since base line date 15.06.2019 belongs to invoicing period 01.06.2019 / 30.06.2019, the invoice AAA is included in the monthly invoice BBB.

Keywords

Closing Date, Invoice, Monthly Invoice, Invoicing Period , KBA , AP-DUE-GLO-ISJ , Japan Invoice Summary , Problem

Product

SAP Business ByDesign all versions