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
A screen is displayed with files and companies/branches available for consolidation.
Specific parameters of the routine are displayed.
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.
It identifies period of the entries to be consolidated.
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.
All Currencies - Entries in all registered currencies are transferred.
Specific Currency - Only entries in currency indicated in parameter Which Currency are transferred.
It defines currency of entries to be transferred (data filter in the origin company).
It defines balance type of entries to be transferred (data filter in origin company).
The system goes back to screen of consolidation between companies/branches.
From this moment, consolidation companies and files is started.
See Also
Refer to topics: