Symptom
In period XXX(XXX represents the period number), you cleared all open items of account ABC(ABC represents the ID of account). You generated payer invoice of account ABC with status 'Fully Cleared'.
In period XXX+1, You changed the invoice summary role of account ABC from Invoice Summary Payer to Invoice Summary Recipient. You created new customer invoices for account ABC (as Invoice Summary Recipient). You executed invoice summary run, but system continued to generate payer invoice of account ABC.
Environment
SAP Business ByDesign
Reproducing the Issue
-
Go to Receivables work center.
- Go to Invoice Summary Runs view.
- Click on New.
- Closing Date From/To as period XXX+1. No value is added under Payer selection. Input the rest required parameters. Click on Save.
- Click on Schedule.
- Click on Save and Close.
- Select the generated Log and click on View Log Details.
- You find Payer Invoice of account ABC.
Cause
Ideally, a summary invoice is generated with a reference from previous summary invoice (and would update next invoice ID of the previous summary invoice). While fetching previous summary invoice, the latest previous summary invoice (for the account with role payer previously) would also be picked (the current logic would check if the next invoice ID in summary invoice for a payer is blank and would pick that as the latest previous summary invoice). Although ABC is no more the payer now, system would still generate a payer invoice for this account.
Resolution
The role change scenario is not supported in current release. You may use the following two work arounds for now. Before using the work around, please ensure that all the due amounts of the previous monthly invoices for the acount needs to be cleared before the role changes from Payer to Recipient.
Work Around 1: Populating the payer from and to while scheduling the run.
-
Go to Receivables work center.
-
Go to Invoice Summary Runs view.
- Click on New.
- Under Payer Selection, click on Add Row to populating the payer. For example, I - Including, 3 - Between, From AAA(AAA represents the ID of payer) To ZZZ(ZZZ represents the ID of payer).
- Input the rest required parameters. Click on Save.
- Click on Schedule.
- Click on Save and Close.
Work Around 2: While changing the invoice summary role from Payer to Recipient, remove the closing date pattern assigned the payer first and then change the role.
- Go to Receivables work center.
- Go to Customers view.
- Search ABC.
- Select Customer ID ABC and click on Edit->Financial Data.
- View tab Invoice Summary Data.
- Remove the value of Closing Date Pattern.
- Change Invoice Summary Role from Invoice Summary Payer to Invoice Summary Recipient.
- Click on Save
Keywords
Invoice Summary Role, Payer Invoice , KBA , AP-DUE-GLO-ISJ , Japan Invoice Summary , Problem