This documentation aims to clarify the phasing-out of parameter MV_AT60FIL in version 12 and to show you a workaround using the configurator inside the standard process to reach the same objective, which is to display branches only of the company logged-in when company management is used in routine Asset Transfers (ATFA060).
We did not implement parameter MV_AT60FIL in Protheus version 12 because we changed the screen interface to MVC and replaced the XMO default query to the Framework SMO_01 default query. We also have internal directives to not use two default queries for the same field in the area of the parameter.
This parameter only applies to version 11.80 of module Fixed Assets in routine asset transfers; therefore, consider the documentation about parameter MV_AT60FIL found in TDN for this version only. IMPORTANT!
Considering a company management layout (EEUUFFFF) as an example, we can copy the existing default query, for example, from XM0 to XM0_01, and create the following filter:
SM0->M0_CODIGO = cEmpAnt .And. SUBS(SM0->M0_CODFIL,1,2) = Subs( cFilAnt,1,2)
See below the technical specification of this example, to add default query XM0_01 via configurator:
XB_ALIAS | XB_TIPO | XB_SEQ | XB_COLUNA | XB_DESCRI | XB_DESCSPA | XB_DESCENG | XB_CONTEM |
XM0_01 | 1 | 1 | DB | Branches | Sucursales | Branches | SM0 |
XM0_01 | 2 | 1 | 1 | Code | Code | Code |
|
XM0_01 | 4 | 1 | 1 | Code | Code | Code | M0_CODFIL |
XM0_01 | 4 | 1 | 2 | Branch | Sucursal | Branch | M0_FILIAL |
XM0_01 | 4 | 1 | 3 | City | City | City | M0_CIDENT |
XM0_01 | 5 | 1 |
|
|
|
| SM0->M0_CODFIL |
XM0_01 | 6 | 1 |
|
|
|
| SM0->M0_CODIGO = cEmpAnt .And. SUBS(SM0->M0_CODFIL,1,2) = Subs(cFilAnt,1,2) |
Via configurator after adding this default query for XM0_01, edit the default query for fields:
Field | Title | Default Query |
FN9_FILDES | Dest. Branch | XM0_01 |
FNR_FILDES | Dest. Branch | XM0_01 |
With this procedure, we have the same behavior found in version 11.80 by using the parameter.