By using this feature , you can run custom X++ scripts without going through LCS you can correct minor data inconsistencies without causing any downtime.
must not be used for following scenario or any other purpose
- Data collection
- Schema changes
- Data migration or other long-running processes
- Correction of data that can be corrected through other means, such as regular business processes, data consistency tools, or other self-service tools
Here are the steps
- create a deployable package same as you create normal package
- must contain exactly only one runnable X++ class
- In your finance and operations app, go to System administration > Periodic tasks > Database > Custom scripts.
- Select Upload.
- Select the deployable package that you created as described earlier
- The script must now be approved by a user other than the user who uploaded it. The approver must follow these steps:
- Go to System administration > Periodic > Data base > Custom scripts.
- Select the script to approve, and then select Details.
- On the Action Pane, on the Process workflow tab, in the Start group, select Approve or Reject. If you select Approve, the script is marked as approved and is unlocked for testing. If you select Reject, the script is locked. In both cases, the event is logged, and a copy of the script is kept in the system.
- Then you need to test the process
- On the Action Pane, on the Process workflow tab, in the Test group, select Run test
- Accept the test result if satisfied and run the process.