Linha Microsiga Protheus - Inglês

Páginas filhas
  • General Consolidation (CTBA220 - SIGACTB)

The consolidation gathers data of a company's branches or of several companies for another company.

A few precautions must be taken before executing consolidation, such as:

Configure parameter MV_CONSOLD with number of the company and the branch that will receive consolidated data (company/destination branch). Correct configuration of this parameter assures that only companies informed receive consolidation data.


Example:

Suppose that companies/branches 02/01 and 03/01 are consolidators (destination companies); this parameter must be filled with 0201/0301.


Tip:

While performing this operation, recommendation is that nobody is using files of Management Accounting environment (including integration entries). This is just a recommendation but can avoid possible inconsistencies in the accounting balances.


Entry Point - CT200SEL

It enables sending content of (Array) with data of companies and files to be grouped.

Execution point: At the moment of environment preparation for consolidation process, data of companies and files to be grouped are loaded.

Expected return: Logical return to validate which Companies/Branches and files are to be grouped.


Example of Entry Point:


User Function CT220Sel( aEmp )

Local cMVSchedu := Getnewpar( 'MV_XSCHEDU' , '' )

Local axEmp2        =  

Local nJ                            = 0.

Local nI                             = 0.

Local lRet              := .T.

If lRet

// only when variable is not empty

 If ! Empty (cMVSchedu) .and. ( ValType( aEmp ) == 'A' .And. len( aEmp ) > 0 )

     while ! Empty( cMVSchedu )

                 cResult := Substr( cMVSchedu , 1 , 4 )

                 aAdd(axEmp2 , cResult )

                 cMVSchedu := Substr( cResult , 2)

     End

 Â  // zero the array of companies only to inform those of parameter

     FOR nI = 1 to len(aEmp)

                 aEmp[nI][1] := .F.

 Â  NEXT

     //  set as true items of the company

     FOR nI = 1 to len(aEmp)

                 FOR nI = 1 to len(aEmp)

                             If ( aEmp[nJ][1] == axEmp2[nI][1] )

                                         aEmp[nJ][2] := .T.

                             Endif

                 NEXT

     NEXT                       

 Endif    

Endif

Return .T.


Procedures

  1. In the maintenance window of General Consolidation routine, a warning screen is displayed for users to close the system, since files associated with the routine must not be in use by other workstations.
  2. Click Yes.

A screen is displayed with files and companies/branches available for consolidation.

  1. Select files and companies/branches by clicking the corresponding row.
  2. Click Parameters.

Specific parameters of the routine are displayed.

  1. Fill them considering the following information:
  • Clear Consolidation?

Choose "Yes" when you consolidate a period or a company already consolidated. Choose "No" in case of transfer to an empty consolidator company (without data) or when consolidating a company or origin branch by processing.

If you choose "No" for the question "Clear Consolidation?" and there are entries in the same period, the warning "There are entries for the consolidator company. Do you want to continue?" is displayed.

Continue processing only if you are consolidating one company/branch at a time, making sure that data of the company/branch of origin have not been consolidated yet. In this case, choose "Yes" for question "Clear Consolidation?", and a new consolidation of all companies/branches is required.

  • From Date/To Date?

It identifies period of the entries to be consolidated.

  • Delete?

This question has effect only when question "Clear Consolidation?" is filled with "Yes."

Period: Only transactions of the period indicated in the consolidator company are deleted.

All: All transactions are deleted, regardless of date interval.

  • Process Currency?

All Currencies - Entries in all registered currencies are transferred.

Specific Currency - Only entries in currency indicated in parameter Which Currency are transferred.

  • Which Currency?

It defines currency of entries to be transferred (data filter in the origin company).

  • Balance Type?

It defines balance type of entries to be transferred (data filter in origin company).

  1. Check parameterization and confirm it.

The system goes back to screen of consolidation between companies/branches.

  1. Confirm it again.

From this moment, consolidation companies and files is started.


See Also

Refer to topics:

  • Configured consolidation
  • Concepts
  • Consolidation script