What is happening?
We will start with some context, provided by none other than the goat himself, Roelof Spijker:
When this happens, CloudBilling generates the following error:
Last report generated more results (11552) than current report (9541) for prefix 202211-664884876168-226780461708, manual intervention required to clean up excess
How can we (or the customer) fix it?
The excess items need to either be deleted or overridden. The latter happens when the total number of items in a new report exceeds the number of items in the report preceding the current one. So, sticking with the example above, this would happen if a new report has more than 11552 items. However, we cannot be certain that this will happen. The only way to be certain that the invoice will not contain excess items is by deleting them. To do this, you need to take the following steps:
- In the connector Activity result with the error message, select the entire prefix (6 numbers-12 numbers-12 numbers) and copy it.
- Go to Purchases and paste the prefix in the Purchase Reference field (don’t click any of the dropdown options!)
- I would recommend clicking 'search' at this point, to check the imported date of the most current purchases
- Next, in the ‘Imported Date To’ field (don't select the wrong one), select the date directly after the connector run with the error, at 00:00:00. After searching, the imported dates should precede those of current purchases
- Check a few of the purchase references. The last number should be higher than the second number mentioned in the connector error.
- Select all of these purchases and delete them
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article