Resolving Invalid Lines

When you ingest a sales file, any required fields that contain unrecognized data or blank data will result in an invalid sales line. Generally, these can be cleared by working through the Mapping Manager when opening the sales file and correctly mapping any unrecognized data with values already established in Curve.

1

Complete the Mapping Manager

If you have invalid lines, the first point of action is to fully complete the Mapping Manager and revalidate your sales file.

2

View the Remaining Invalid Lines

If a certain field is blank however, there is no data for Curve to display as a reference in the Mapping Manager. In this instance, even after you have completed your Mapping Manager, it may be that there are still invalid lines in your sales file.

To determine what is making the sales line invalid, go to the sales file's page and use the filters to filter for incomplete lines. The field that is causing the line to be invalid will be highlighted in red.

3

Update Your Template to Resolve the Cause of the Issue

After you have reviewed what is causing your sales line to be invalid, you can update your Template to guarantee the issue is resolved upon reingestion of your sales file. How to adjust your Template will depend on the cause of the issue. In the above example, we are not picking up any Territory data for our sales lines. Perhaps this was just a case of us forgetting to map the column in our sales file that specifies the territory information to our Territory field. Or perhaps no Territory information is given in the sales file, in which case we can set the Territory Default Field to World. You may also need to use Calculations to guide Curve to read certain data elsewhere under specific conditions. If the ISRC is missing for one given sales line, we can write a calculation that says when the ISRC is blank, use the Track Title as the ISRC, which can then be mapped as an Alias to the correct track. Another common example is a Total row at the bottom of your statement being picked up by Curve; you can tell Curve to ignore this row upon ingestion by setting a Skip Row calculation in your Template.

Once you have updated your Template, you can reingest your sales file for these changes to be reflected.

You can update the Target Period, Sale and Transaction Dates, as well as Exchange Rates of your Sales Files in bulk - whether these contain missing values or just values needing adjusting. Additionally you have the option to update the Exchange Rate based on the Transaction Date or simply on Today's Date. This way you can quickly revalidate a bunch sales files in just one go.

It is best practice to resolve all of your remaining sales lines by adjusting your Template. This does not just guarantee the issue is resolved for this particular sales, but also for all future sales files uploaded via this Template moving forward. As a matter of last resort, you do also have the ability to manually adjust sales lines. To do so, you can use the Edit Selected, Edit Filtered or Delete Selected buttons on your sales file page. Once you have manually resolved the sales lines, make sure to Revalidate your sales file to update the invalid status of these sales lines.