Working with Formulae
Last update:CCH Accounts Production
Mixing CCH Accounts Production and Excel commands
Mixing CCH Accounts Production and Excel commands
CCH Accounts Production
Introduction to Formulae used in CCH Accounts Production
The CCH Accounts Production page/note formatter contains formulae to bring through data from CCH nominal codes, name ranges, Central and Statutory database references, and also supports some standard MS Excel functions. This section gives an introduction and looks at statutory database #references, nominal codes and range names within the =AP("...") formula.
CCH Accounts Production
Using Formulae within a Paragraph to link to dates, figures, words, pages and notes
This section gives examples of using formulae in paragraphs to link to figures in CCH Accounts Production using nominal codes, name ranges, statutory database references, linking to notes and pages and using formulae to automate words based on certain conditions.
CCH Accounts Production
Using ranges within RangeDef and RangeCode formulae
This document provides a detailed overview of utilizing Range Names and ranges of Nominal Codes in specific formulae within CCH Accounts Production. It covers the definition and application of Name Ranges and Nominal Ranges, including syntax for their usage in formulas like RangeDef and RangeCode. Key functionalities are described for generating financial reports, viewing nominal descriptions, and inserting balances for specified ranges. Additionally, it emphasizes the importance of not changing standard Name Ranges and provides examples for implementing ranges, splitting them, and using RangeDefCode for audit purposes.
CCH Accounts Production
Signature command
The document explains the use of the SIGNATURE command for displaying multiple signatories on Financial Statements. It details the syntax and parameters necessary for formatting names (Prefix, First Name, Last Name, Suffix), which can be overridden by a Name Override field. It highlights the flexibility of the SIGNATURE command compared to previous methods for displaying signatories, allowing for a unified output and customized formatting, and specifies its application for different types of reports (Directors Report and Balance Sheet).
CCH Accounts Production
RangeDef command
This document describes a set of commands used to list account descriptions and balances within a financial context. The three primary commands, RangeDef, RangeCode, and RangeDefCode, are utilized together to display accounts and their respective balances for the current and previous years. It outlines the syntax and parameters for each command variant, detailing how to specify account ranges, year codes, sorting orders, and balance conditions. The instructions emphasize consistency in parameters across commands to ensure accurate alignment of descriptions and balances. Additional notes on year totals and handling zero balances are also provided.
CCH Accounts Production
RangeDif and Dif commands
The document outlines the functionality of the RangeDif command used in variance analysis to compare financial data between two periods. It describes syntax options for named and complex account ranges, including parameters for specifying account ranges, year comparisons, and handling of zero balances. Additionally, it details the use of the Dif command for summing totals from the RangeDif command results. Key aspects include the parameters that dictate how balances are compared and presented, including handling of debit and credit balances. Related functionalities and formatting notes are also included.
CCH Accounts Production
Nz command
The document explains the Nz command, used to count non-zero accounts in a specified range for either the current or comparative year. It provides examples of the command's syntax for both nominal and named ranges, as well as parameters for including subaccounts and specifying debit or credit only counts. Additionally, it notes that account codes must be defined with a full range for accurate counting. The Nz command aids in managing the display of headings and subtotals within account reports.
CCH Accounts Production
FormatPrints and NotesPrint command
The document discusses the use of the FormatPrints and NotesPrint commands on the Contents page to manage the inclusion of pages in printing. It highlights two scenarios: forcing pages to be included or excluded manually, and handling unincorporated accounts without notes. The FormatPrints command allows checking if a page will print, while the NotesPrint command verifies the presence of account notes. Syntax for both commands is provided to demonstrate their application for automated updates to the Contents page.
CCH Accounts Production
Entering Quantities
The document provides a comprehensive guide on using quantity data in CCH Accounts Production. It explains how to set up and capture quantity data at both the master and client levels, as well as how to enter and edit quantities for new and existing transactions. Additionally, it highlights configurations for displaying quantity data in reports and demonstrates the use of specific formulae to retrieve quantity balances. The document also clarifies year-end behaviors concerning quantity data retention and offers troubleshooting insights for disabling quantity capture if needed.
CCH Accounts Production
ColumnFlex command
The document explains the ColumnFlex command, which allows columns in a document to adjust their widths dynamically to fit to the right margin of the page. It simplifies past methods of aligning columns when some are suppressed by automatically redistributing their widths to ensure proper alignment. The command includes specific minimum width requirements and operates differently in portrait versus landscape modes. Additionally, it can distribute widths proportionately across multiple columns. Introduced in version 2017.4, the ColumnFlex command enhances document formatting in various applications.
CCH Accounts Production
APGroup command
The APGroup command is designed to retrieve financial data for individual companies within a group or to aggregate data for all group companies. The syntax allows for parameters to specify company selection and execute various AP commands for data retrieval. Examples demonstrate its versatility in summarizing totals, listing account balances, and comparing periods. The command facilitates flexibility in processing group financials but has limitations in certain cases, such as not intelligently filtering combined credit and debit balances. The parameters also take into account historical participation of subsidiaries in the group.