Sage Intelligence Combined Financials

When I run the Sage Intelligence for Combined Financials, it combines both companies, but for accounts that are the same numbers, it doubles them.  It adds a line for Company A, with the total of Company A and Company B, then adds a line for Company B with the same total.

Company A - Cash $5,000

Company B - Cash $1,000

Export shows:

Cash A - $6,000

Cash B - $6,000  

The Financials Have $12,000 cash instead of $6,000.

This happens with any similar account numbers, which are basically the same between the two companies.

Parents
  • 0

    You don't really tell us how your template is setup so it makes it somewhat difficult to address your issue. It appears that you are using the Consolidated Financial Report Designer. This requires that you add all companies to the database consolidation list in each of the subreports. It may be, as has already been noted, that you have a duplicate company code in one of these lists.

    If you determine that you don't have any duplicate company codes, then it is probably how you set up your template. Did you bring over the accounts for each company into the same column and then sort? If so, you have to add the company code in the function argument. If you leave it blank it will 'assume' that you want to use both companies for each row. That would result in the cash account calculating the sum of both companies.

Reply
  • 0

    You don't really tell us how your template is setup so it makes it somewhat difficult to address your issue. It appears that you are using the Consolidated Financial Report Designer. This requires that you add all companies to the database consolidation list in each of the subreports. It may be, as has already been noted, that you have a duplicate company code in one of these lists.

    If you determine that you don't have any duplicate company codes, then it is probably how you set up your template. Did you bring over the accounts for each company into the same column and then sort? If so, you have to add the company code in the function argument. If you leave it blank it will 'assume' that you want to use both companies for each row. That would result in the cash account calculating the sum of both companies.

Children
No Data