Objective
Aiming to improve the usability of the fixed assets records, the order of the fields of table SN1 - Asset File in the data dictionary (SX3) was changed, with impact on the registration interfaces:
· Assets Registration (ATFA010)
· Purchases Classification (ATFA240)
The other functionalities that use the asset visualization option derived from the Asset Registration option (ATFA010) or that are based on the order of the fields in the data dictionary (SX3) will also be impacted by the change in the order of the fields.
Reasons
With the evolution of the controls of the Fixed Assets module due to the needs of several countries, made since 2008 (Portugal, Angola, Colombia, Peru, Ecuador, and Venezuela) as well as due to the process of adaptation of the module to the international accounting standards (IAS), it became necessary to use it more effectively for the registration of groups of assets.
Currently, for Brazil, the registration of groups of assets has a simple typing facilitator functionality, in which the user enters the accounting data common to a given group of assets (ledger accounts, cost centers, accounting items, and value classes, in addition to the depreciation rate/useful life by currency).
Because of its potential for classification and standardization of fixed asset records, the asset group registration is being promoted to an essential module configuration registration, and the first functionality that will use it with this status will be the configuration of asset masks.
This functionality allows you to configure a mask for the property code depending on the defined group, as well as which fields will be considered mandatory depending on the selected group.
For this reason, the group of goods becomes the first enterable field in the record, so that, from the information of the group, the mask can be triggered depending on the group, and the validations of the mandatory fields become available depending on it.
Impacts on the operation
Changing the order of the asset group field and other key fields in the registration to make typing easier does not have any impact on asset processes or on integrations that use the functionality of the automatic routine (MsExecAuto ()), and the only impact will be visual unless the mask configuration feature for the asset codes is used.
New field order in the assets registration (SN1)
With the registration restructuring, the fields now take on the following order:
Order | Field | Description |
---|---|---|
01 | N1_FILIAL | Branch |
02 | N1_GRUPO | Group |
03 | N1_PATRIM | Classific. |
04 | N1_CBASE | Asset Code |
05 | N1_ITEM | Item |
06 | N1_DESCRIC | Synt. Descr. |
07 | N1_AQUISIC | Acquisition Dt. |
08 | N1_BITMAP | Asset Picture |
09 | N1_QUANTD | Quantity |
10 | N1_BAIXA | Posting Dt. |
11 | N1_CHAPA | Registrat. No. |
12 | N1_APOLICE | Number Policy |
13 | N1_CODSEG | Ins.Comp.Cd. |
14 | N1_DTVENC | Policy Due Dt. |
15 | N1_CSEGURO | Insur.Comp. |
16 | N1_TIPOSEG | Insur.Tp. |
17 | N1_FORNEC | Supplier Code |
18 | N1_LOJA | Suppl. Store |
19 | N1_LOCAL | Address |
20 | N1_NSERIE | Inv. Series |
21 | N1_NFISCAL | Invoice |
22 | N1_PROJETO | Project Cd. |
23 | N1_CHASSIS | Chassis No. |
24 | N1_PLACA | Lic. Plate No. |
25 | N1_STATUS | Asset Status |
26 | N1_CODCIAP | CIAP Code |
27 | N1_ICMSAPR | Item ICMS |
28 | N1_DTBLOQ | Blockage Dt. |
29 | N1_CODBEM | MNT Asset |
30 | N1_BASESUP | Base Code |
31 | N1_ITEMSUP | Sup Item |
32 | N1_CALCPIS | Calc. PIS |
33 | N1_CODBAR | Bar Code |
34 | N1_CONSAB | Deprec. Mtd. |
35 | N1_PENHORA | Seizure Stat. |
36 | N1_MESCPIS | Pis Cl. Months |
37 | N1_DTCLASS | Classif. Dt |
38 | N1_DIACTB | Journal Cd. |
39 | N1_NODIA | Journal Seq. |
40 | N1_TAXAPAD | Std.Rt.Cd. |
41 | N1_CIAP | Generate CIAP? |
42 | N1_CODCUSD | Custod.Cd. |
43 | N1_TPCUSTD | Custod.Tp. |
44 | N1_TPBEM | Asset Type |
45 | N1_TPOUTR | Tp. Other |
46 | N1_CODRGI | RGI Code |
47 | N1_NOMCART | Cart.Name |
48 | N1_AREA | Area |
49 | N1_REDE | Prop.Netw. |
50 | N1_LOGIMOV | Prop.Street |
51 | N1_NRIMOV | Prop.No. |
52 | N1_COMIMOV | Prop.Comp. |
53 | N1_BAIIMOV | Prop. B |
54 | N1_MUNIMOV | Prop. City |
55 | N1_SIGLAUF | Prop. State |
56 | N1_CEPIMOV | Prop. Postal Code |
57 | N1_QUALIFI | Qualification |
58 | N1_DLOCAL | Location Desc. |
59 | N1_NATBEM | Asset Nature |
60 | N1_TPDEPR | Deprec Type |
Important: The user fields will be sequenced from the last available order for the standard system fields.
Condition for execution:
At each new run of the Fixed Assets environment updater (UPDATF), the following fields will be checked, and if they are out of order, a complete reordering of the table will be performed:
Order | Field | Description |
---|---|---|
01 | N1_FILIAL | Branch |
02 | N1_GRUPO | Group |
03 | N1_PATRIM | Classific. |
04 | N1_CBASE | Asset Code |
05 | N1_ITEM | Item |
06 | N1_DESCRIC | Synt. Descr. |
07 | N1_AQUISIC | Acquisition Dt. |