The following sections provide information about the Import Asset Disposals Error Report. For more information about screen and toolbar button selections to produce this report, see Import Asset Disposals Processing.
|
Label |
Source |
|
Import Fixed Assets Disposal Error Report |
Header Line |
|
Row Number |
Input File or Table – Read the Line Number of the File or Table that has the error |
|
Asset Number |
Input File 3rd field/Table FA_IMP_DISP.ASSET_ID |
|
Item Number |
Input File 4th field/Table FA_IMP_DISP.ITEM_NO |
|
Field Name |
FAPDISP.Input Preprocessor |
|
Field Value |
Input File/Table <Table>.<Field> |
|
Error Message |
FAPDISP.Input File Hard Validations, and FAPDISP.Input File Soft Validations excel worksheets associated with this enhancement. Truncate at 60 characters. |
The report sorts data according to the following fields:
ASSET_ID
ITEM_NO
The following sections provide information about the Import Assets Disposals Edit Report. For more information about screen and toolbar button selections to produce this report, see the Import Asset Disposals Processing
|
Label |
Source |
|
Import Fixed Assets Disposal Edit Report |
Header Line |
|
Asset Number |
Input File 3rd field/Table FA_IMP_DISP.ASSET_ID |
|
Item Number |
Input File 4th field/Table FA_IMP_DISP.ITEM_NO |
|
Select Status |
Input File 13th field/Table FA_IMP_DISP.S_DISP_STATUS_CD |
|
Gain/Loss Account |
Input File 8th field/Table FA_IMP_DISP.GNLS_ACCT_ID |
|
Gain/Loss Org |
Input File 9th field/Table FA_IMP_DISP.GNLS_ORG_ID |
|
Depreciation Adjustment |
Input File 14th field/Table FA_IMP_DISP.B1_DEPR_ADJ_AMT |
|
Disposal Price |
Input File 5th field/Table FA_IMP_DISP.DISP_PRICE_AMT |
|
Totals |
All data come from the Input File/Table. Totals for Depr Adjust and Disposal Price. |
The table sorts data according to the following fields:
ASSET_ID
ITEM_NO
The system performs the following actions when you use toolbar buttons as described below.
|
Action Title |
Action Process |
|
Import Asset Disposals Edit Report after you click Preview Default Report or Print Default Report |
If records passed validations during print/process, the user can preview or print the Edit Report of records that have passed validations and can be imported into FA_DISP_EDIT as disposal edit records per screen parameters. No report will be generated if the user has selected the Delete Imported Records option and clicks Validate Input File. |
|
Import Asset Disposals Error Report after you click Validate Input File |
An error report will be created as a result of the print/process. A Header Row error will immediately stop the validation process and the error report will only describe the Header Row issue(s). Note that a header row error indicates that an import attempt was made on asset data that was existing in a fiscal year/accounting period that is different from the Fixed Assets posting settings in the current database. Attempts to modify the import data to match the fiscal year/account period to the posting settings in the current database should not be attempted without a full understanding of how this will affect depreciation computations for the affected assets in the current system. If the Header Row is okay, the Upload will continue and an error report will follow, with validation failures that prevent processing detailed first, followed by validation failures that are warnings but, by themselves, will not stop the processing or ultimate import of disposal edit records. |
|
Import records into FA_DISP_EDIT after you click Validate Input File, and then Print Default Report |
The records that qualified for the Edit Report are now processed into FA_DISP_EDIT and are visible in Manage Disposal Transactions. For Table records, the Status is changed to I, indicating that this record has been used to create a disposal edit record for an asset, and that this record is available to delete if the user selects the delete records via the Process Table Option Delete Imported Records. |