Income has been incorrectly attributed to the wrong Work. What is the required correction procedure?
While not a frequent occurrence, sales misattribution can occur when an Identifier is incorrectly stored against the wrong Work.
To start, you need to create an Income report to verify whether the correct Identifier was mapped to the Catalogue item upon income ingestion, as well as which sales files might be affected by this misallocation. You'll be comparing the original ingested Catalogue data with Curve’s mapped values.
For more information on Reports, please refer to How to Create Reports for your Income & Calculations, along with Glossary of Report Filters and Fields
1. Correcting Catalogue Data
To ensure this issue is fixed for future uploads, you need to confirm that the correct Identifiers are stored against your Curve entry. Essentially, you'd be reviewing the Society Identifiers and ISWC/Tunecode stored against that Work.
Next, you will need to delete the Identifier from the incorrect product it was originally associated with, and assign it to the correct Catalogue item in Curve.
2. Reassigning Income Using Income DB
The next step is to reassign income to the correct Work in Curve. You can utilize the Income DB page for this process.
Filtering Income Lines
Via the Income DB page, you'd need to search for all lines that have been attached to the wrong Work. Please note that the "Works" field refers to your stored Catalogue, while the "Works Title" field refers to the title contained in the imported income files.
Bulk Editing
Then, instead of clicking on "Edit Selected" (which only applies to the selected lines on the current page, requiring you to repeat the process for every page), it is quicker to select "Edit Filtered." This action will select and apply the edit to all lines currently displayed under the filter you applied.
Caution: Please ensure you are filtering only the income you wish to adjust. If you have loaded all the lines in your database and click "Edit Filtered," you will inadvertently update all income lines in your database.
3. Updating Statements (If Necessary)
If revenue relating to the misattributed Catalogue items has already been processed in Statements, you have two main options to update the Contract’s current Balance:
- Reprocess Statements: You can reprocess these specific Statements, as well as any following Statements, so the Contract’s current Balance gets updated accordingly.
- Adjustments: If you prefer not to reprocess these Statements, you can instead upload Adjustment files or create Adjustment Transactions to reconcile the balances.