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
- Go to Receivables work center.
- Go to Invoice Summary Documents view.
- Search BBB.
- Open Invoice ID BBB.
- You can see the Invoicing Period is 01.06.2019 / 30.06.2019.
- View Document List tab.
- You can see the customer invoice AAA.
- Click on AAA.
- Click on View All.
- 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.
- Go to Receivables work center.
- Go to Customer Accounts view.
- Search CCC(CCC represents the account ID of the invoice AAA).
- Select Account ID CCC and click on View.
- Select Invoice AAA and click on Item Details.
- 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(01.06.2019 / 30.06.2019).
See Also
KBA 3247998 Invoice AAA is Not Considered in Invoice Summary Run
KBA 3339817 Invoice AAA is Not Considered in Invoice Summary Run
Keywords
Closing Date, Invoice, Monthly Invoice, Invoicing Period, Summary Invoice Document, Base Line Date , KBA , AP-DUE-GLO-ISJ , Japan Invoice Summary , Problem