Linha Microsiga Protheus - Inglês

Páginas filhas
  • Field N3_TPSALDO -- 117882

Versões comparadas

Versão antiga 2

changes.mady.by.user Otto Alexandre Monteiro Altorfer

Gravado em

comparado com

Nova versão 3

changes.mady.by.user Otto Alexandre Monteiro Altorfer

Gravado em

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

Pagetitle
Field N3_TPSALDO
Field N3_TPSALDO

Technical Bulletin: Field N3_TPSALDO

...

e) You must run the compatibility tool with Referential Integrity deactivated*.

 

 

The following procedure must be performed by a professional qualified as Data Base Administrator (DBA) or equivalent!

 

Improper activation of the Referential Integrity may drastically change the relationship between tables on the database. Therefore, before using it, thoughtfully observe the following procedure:

 

                         i.     In Configurator (SIGACFG), check whether the company uses Referential Integrity by selecting option Integrity/Checking (APCFG60A).

                        ii.     If there is no active Referential Integrity, all companies and branches registered for the system are listed on a new window and none of them will be selected. In this case, AND ONLY IN THIS CASE, you do not need any other procedure of integrity activation or deactivation; just complete the checking and apply the compatibility program as usual, following the instructions.

                       iii.     If Referential Integrity is active in all companies and branches, a message is displayed in window Relationship Checking Between Tables. Confirm the message to complete the checking, or;

                       iv.     If Referential Integrity is active in one or more companies, though not to its full extent, all companies and branches registered for the system are listed in a new window, in which only those with integrity are selected. Write down which companies or branches have the integrity activated and save this note for later reference on reactivation (you may also contact our Framework Help Desk for a file with this information).

                        v. In the cases described in the items iii or iv, AND ONLY IN THESE CASES, you must deactivate such integrity by selecting option Integrity/Deactivate (APCFG60D).

                       vi.     Upon deactivation of the Referential Integrity, run the compatibility tool in accordance with the instructions.

                      vii.     Once you have applied the compatibility program, use option Integrity/Activate (APCFG60) to reactivate the Referential Integrity, IF AND ONLY IF it has been deactivated. To do so, have the information of companies and/or branches that had integrity activation at hand, select them once again, and confirm the activation.


IF YOU HAVE ANY QUESTIONS, contact the Framework Help Desk!



1. In Microsiga Protheus TOTVS Smart Client, enter U_UPDATF in field Initial Program.

...

Editing in file SX3 – Fields:

    • Table SN1 – Fixed Assets

Field

N3_TPSALDO

X3_WHEN

IIF(FindFunction("AF010ATPSAL"), AF010ATPSAL(), INCLUI)    

The size of fields that have groups may vary according to the environment in use.

...

  1. In Fixed Assets (SIGAATF) access Updates/Records/Assets (ATFA010).
  2. The system displays the Fixed Assets Update window.
  3. Click option Add.
  4. Place the cursor on field Balance Type and check whether you can edit the field. 
  5. Select and Confirm the option desired.
  6. Click option Edit.
  7. Place the cursor on field Balance Type of a line already added and check whether you cannot edit the field.
  8. Place the cursor on field Balance Type of a new line and check whether you can edit the field.


Technical Data

Tables

SN3 – Balances and Values