In some cases, you may want to clean up customer data and process it before you apply it to the database. To do that, you can customize report 8621 to fix issues, such as:
-
Convert dates and decimals to the format required by the regional settings on a user's computer.
-
Remove leading/trailing spaces or special characters.
After you modify the batch job, use the following procedure to process the data.
To clean up and process data before applying data
Open the configuration package for the company.
On the Tables FastTab, choose Functions, and then choose Process Data.
To apply the mapping that you have set up, on the Tables FastTab, choose Functions group, and then choose Apply Data.
 Tip |
|---|
For more information about how to work with fields and columns, see Work with Data. For more information about how to find specific pages, see Search. |