01. DATOS GENERALES
| Producto | TOTVS Backoffice | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Línea de producto: | Línea Protheus | |||||||||
| Segmento: | Backoffice | |||||||||
| Módulo: | SIGAFAT - Invoicing | |||||||||
| Función: |
| |||||||||
| País: | United States | |||||||||
| Ticket | 19687650 | |||||||||
| Pacote | 013780 | |||||||||
| Requisito/Story/Issue (informe el requisito vinculado): | DUSAL-71 |
02. SITUACIÓN/REQUISITO
The system is slow to load the city search window when accessing the city fields in the Customer or Supplier registration.
03. SOLUCIÓN
The standard query CC2SA1 was changed to be used in queries made by the customer registration routine and the standard query CC2SA2 was created to be used for queries made by the Supplier Registration routine.
Backup DataBase.
Apply the changes to the DataBase indicated in the 04. INFORMACIÓN ADICIONAL section.
- In the Financials module (SIGAFIN), go to Updates / File / Customer.
- Find an existing customer. Click the View button and click on the magnifying glass next to de City Code field (A1_COD_MUN).
- In the Financials module (SIGAFIN), go to Updates / File / Suppliers.
- Find an existing supplier. Click the View button and click on the magnifying glass next to de City Code field (A2_COD_MUN).
04. INFORMACIÓN ADICIONAL
DataBase Updates
To update the environment, apply the following changes.
Standard Query (SXB)
CC2SA1
Update Standard Query in file SXB - Standard Query:
Alias | Type | Sequence | Column | Description | Content |
|---|---|---|---|---|---|
| CC2SA1 | 1 | 01 | DB | Customers' Cities | CC2 |
| CC2SA1 | 2 | 01 | 01 | IBGE code+State | |
| CC2SA1 | 2 | 02 | 02 | City | |
| CC2SA1 | 2 | 03 | 03 | IBGE Code | |
| CC2SA1 | 4 | 01 | 01 | City | CC2_MUN |
| CC2SA1 | 4 | 01 | 02 | IBGE code | CC2_CODMUN |
| CC2SA1 | 4 | 01 | 03 | State | CC2_EST |
| CC2SA1 | 4 | 02 | 04 | City | CC2_MUN |
| CC2SA1 | 4 | 02 | 05 | IBGE Code | CC2_CODMUN |
| CC2SA1 | 4 | 02 | 06 | State | CC2_EST |
| CC2SA1 | 4 | 03 | 07 | IBGE Code | CC2_EST |
| CC2SA1 | 4 | 03 | 08 | City | CC2_MUN |
| CC2SA1 | 4 | 03 | 09 | State | CC2_EST |
| CC2SA1 | 5 | 01 | CC2->CC2_CODMUN | ||
| CC2SA1 | 6 | 01 | CC2->CC2_EST==M->A1_EST |
CC2SA2
Update Standard Query in file SXB - Standard Query:
Alias | Type | Sequence | Column | Description | Content |
|---|---|---|---|---|---|
| CC2SA2 | 1 | 01 | DB | Suppliers' Cities | CC2 |
| CC2SA2 | 2 | 01 | 01 | IBGE code+State | |
| CC2SA2 | 2 | 02 | 02 | City | |
| CC2SA2 | 2 | 03 | 03 | IBGE Code | |
| CC2SA2 | 4 | 01 | 01 | IBGE Code | CC2_CODMUN |
| CC2SA2 | 4 | 01 | 02 | State | CC2_EST |
| CC2SA2 | 4 | 01 | 03 | City | CC2_MUN |
| CC2SA2 | 4 | 02 | 04 | City | CC2_MUN |
| CC2SA2 | 4 | 02 | 05 | IBGE Code | CC2_CODMUN |
| CC2SA2 | 4 | 02 | 06 | State | CC2_EST |
| CC2SA2 | 4 | 03 | 07 | IBGE Code | CC2_CODMUN |
| CC2SA2 | 4 | 03 | 08 | City | CC2_MUN |
| CC2SA2 | 4 | 03 | 09 | State | CC2_EST |
| CC2SA2 | 5 | 01 | CC2->CC2_CODMUN | ||
| CC2SA2 | 6 | 01 | CC2->CC2_EST==M->A2_EST |
This solution applies to version 12.1.2210 or higher.
IMPORTANT!
05. ASUNTOS RELACIONADOS
Does not apply.
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas