After converting from Accpac Plus, the accounts and departments are visible in the Display and Maintain accounts. There are no departments at all in Maintain or Edit departments. In Accpac Plus you were able to add accounts and assign department codes without defining the departments in the Maitain Departments function. I can print Trial balances and Ledger reports in Adagio for any account/department range. I cannot print any departmental reports using the Adagio Financial Statements. Is this due to the departments not being defined in the old Accpac Plus data? In Accpac Plus you could print departmental financial statements even if you did not define departments.
Thanks any input.

Hi Carl,

In order to use the department drop-down field in the toolbar, you do require to have Department codes, not just accounts with departments. There are some other SmartSheet functions and Print Departmental / Statement Groups that take advantage of having departments coded.

Departments don't have to be codes for the Financial Reporter to generate values. The standard formula =GLAMT("Y","4000-100") will still report the YTD net changes for account 4000 and 'dept' 100, even though the department code 100 has not been created.

You can do SmartSheets that expand particular to particular department numbers, even though you don't have department codes defined, though the spreadsheet must be defined in a particular way.

.SmartSheet must be in cell A1
.Range must be in some cell in column A (say A11, for example)
Cell B11 contains the account range with the specific department, such as 4000:4999-100

When this SmartSheet is expanded, all accounts in the range and specifically for department 100 would be generated.

You can also key in the desired department number into a desired cell and have it flow to all your account ranges, requiring only a single change. If the cell in B11 had ="4000:4999-" & A3 (where cell A3 contains the department number 100, prefixed by an apostrophe to define the cell as text), the formula and any other account range would use cell A3 to determine the department.

So it is possible to do departmental statements without having actual department codes defined. But it requires doing minor manipulations to the spreadsheet in order to generate the desired departmental rows.

Thanks for the tips. Very helpful.
Carl