Description |
*efinition:*
The GL Detail will serve as the consolidting table it will have to maintian the company id.
We need a rotuine that will pull all the transactions from the subsidiary companies tblGLDetail and roll them into the consolidating company tblGLDetail.
Add a new menu item called consolidations.
Add a selection for the date of consolidation (Date picker) (date picker should select the period ends from the fiscal year table.
!pastedImage_d66442_0.png!
There should be a period selector dropdown.
When you press the cosolidation button it should:
* Check to see if the fiscal periods are closed for the subsidiary companies
* Fail if the current or prior period is not closed in a subsidiary company
* Warn if there are no transactions in that subsidary company
Test data
Consolidaiton date: 12/31/2016
|Conpay id|Company type|12-31-2016 |unposted transactions on or before 12-31-2016|
|1|Parent|Closed|No|
|2|Subsidiary|open|yes|
|3|Subsidiary|Closed|no|
| | | | |
| | | | |
| | | | |
*Expected result :*
Warning - Company 2 fiscal year is not closed
Warning - company 2 has unposted transactions
*This will work per below:*
# Delete all transactions for subsidaiary companies in the consolidating company
# Insert all transactions from the subsidiary company into the consolidating company
## make sure to sync the IntAccountId - the StrAccountId is the most important for syncronization
# Rerun the recalc for tblGLSummary
This function will only be available from the Consolidating company only
|