IMPORT ASSET DISPOSALS PROCESSING

To process newly uploaded records or records that previously failed validations, complete the following steps:

  1. Click the drop-down and select Validate Input File after completing the screen. This uploads input file records and starts the validation process for both input files and records scripted directly into the import tables. You must click the Validate Input File button before the Preview, Print, or Import Asset Disposals buttons/options can access disposal records. The result of data validations that occur when you select the Validate Input File option will print an error report that you can use to modify records that fail validations. If there are no errors, the error report will print with that result.

  2. After you click the Validate Input File button, it is recommended that you use Preview or Print to review an edit report that includes records that passed validations and match the screen parameters. You can only print the edit report before you select the Import Asset Disposals menu option to create new asset disposal records. Printing the report is not required. If an import edit report is desired, you must print the report prior to selecting the Import Asset Disposals option because the report will not be available once the import has occurred. If you select the Import Asset Disposals option either after printing the edit report or without printing first, the valid records will be processed into the Fixed Assets Disposal Edit (FA_DISP_EDIT) table.

The Validate Input File menu option button deletes previously imported records if you select the Delete Imported Records option in the Process Table Options group box.

If the Allow Partial Processing check box is clear when the Validate Input File option is selected and table import records contain one or more errors that preclude processing, the Preview and Print functions produce no records on the edit report, and the process imports no records. This check box only applies when processing table records. When importing from a file, there will not be any records processed into disposal edit records when there is one or more errors that prevent at least one record from being processed.

To make the edit report available, complete the following steps:

  1. Select the Allow Partial Processing check box if desired for processing table records.

  2. Click drop-down and select the Validate Input File menu option.

  3. Click the Preview or Print buttons when the input file or table contains at least one record eligible for processing per the Process Table Options you select, assuming you selected the Allow Partial Processing check box for table records. Or if processing records from a file or if the Allow Partial Processing check box is not selected, click the Preview or Print buttons to review or to have a permanent copy of all of the processed records that are ready to be imported and turned into disposal edit records.

If the edit report contains one or more records, the Import Asset Disposals menu option imports the records on the report into FA_DISP_EDIT in addition to creating disposal edit records viewable on the Manage Disposal Transactions screen. If you select the Delete Imported Records option in the Process Table Option group box and the (FA_IMP_DISP) table holds import records that were previously used to create disposal edit records, the initial import records are deleted from the FA_IMP_DISP table.