Product Line: | Microsiga Protheus |
Industry: | Services |
Module: | Fixed Assets (SIGAATF) |
Function: | Assets (ATFA012) |
To update the already existing fixed asset forms of an environment with management accounting data of type 10 - Accounting/Managerial Depreciation, you can use a routine for accounting classification import, the functionality of which follows rules through CSV formatted text files.
This functionality is available on the Assets registration browser menu, in option Import Classification.
Procedures
Important
The CSV file to be imported has a default layout, considering only the addition of classifications of type 10 - Accounting/Managerial Depreciation with a specific structure, following the rule below:
Configuration of text file fields
1; N3_FILIAL;N3_CBASE;N3_ITEM;N3_TIPO;N3_HISTOR;N3_CCONTAB;N3_VORIG1;N3_TXDEPR1;N3_VRDACM1;N3_AQUISIC;N3_TPDEPR;N3_TPSALDO
Example:
0;SN3 1;N3_FILIAL;N3_CBASE;N3_ITEM;N3_TIPO;N3_HISTOR;N3_CCONTAB;N3_VORIG1;N3_TXDEPR1;N3_VRDACM1;N3_AQUISIC;N3_TPDEPR;N3_TPSALDO 1;010101;010121;001;10;TESTE IMP ALT;10102;10000;10;;01012021;1;3
Attention
Hence, we must respect the following parameter settings:
Important
Note:
If the file contains other classification data not of type 10 – Accounting/Managerial Depreciation, they are disregarded.
If the asset form corresponding to the accounting classification is not found, or if the asset form does not have item 01 - Tax Depreciation, the classification data are disregarded.
The import process is subject to the regular validations of the editing process for fixed asset forms. If the validations are not met, the accounting classification data are disregarded.
If the same import file contains data both valid and rejected, the valid data are activated, whereas the invalid data are recorded in a processing log file.
Tables: