This routine is a report that prints the entities: Cost Center, Accounting Item, Value Class or Additional Entities, tied to a configuration of records linked to a management view; thus, it can have as balances the transactions of those entities the accounts of which were used, hence making it easier to query transactions of certain desirable entities.
On the menu, access Reports>Trial Balances>Managerial Entity or search for CTBR165 on the search bar.
Home Screen:
Print screen:
Other Actions / Related Features
Feature | Description |
Param | Report Settings |
OK | Finalization |
Schedule | R3 function, to schedule a report |
Cancel | exit report |
Size, destination and format settings | |
Filter | Crate filters specific to the report |
Options | Methods to print the page, save, restore or delete data |
Customize | Customize report according to the user |
Main Fields and Parameters
Field | Description |
Start Date * | Start date of period |
End Date * | End date of period |
Config. Code Records * | Configured record settings |
Entity * | Entity chosen for printing |
From code | Code from the entity of which the printing starts |
To code | to the code of final entity for printing |
Manag. Ent. From | Enter code of Managerial Entity from which to print report |
Manag. Ent. To | To the last entity to be printed on report |
Print Manag. Ent. | Detailed, Summarized or both entities |
Balances set to Zero | If you want the report to show balances set to zero |
Currency * | Currency chosen for report printing |
Initial Page | The page from which to start the report |
Print to seg | Up to which segment of accounting mask to consider |
Filter segment No. | Account segment for filter |
Content Segmt Start | Initial range for account searches |
Content Segmt End | Final range starting from the above ask |
Content Found in | To search non-sequential accounts. Example: AA?333?100 |
Print Trans Column | Whether to print entity transaction columns |
Skip page | Whether to skip page by record or do everything in same page until sheet is full |
Skip Synth Line | Whether to skip when printing synthetic lines |
Print Value 0.00 | Formatting with 0.00 |
Print Code | Whether code is reduced or regular (complete) |
Divide by | Divide value in report by Hundred, Million or does not apply |
Position Prev. P/F | Position Previous to Profits and Losses |
Profits and Losses Date | Date of profits and losses |
Ignore Bal.Prev.Prof/L * | Ignore balance previous to profits and losses |
Revenues/Exp Group | Accounts of revenues and expenses group, generally those of Levels 3 and 4 |
Filter Cost Center | If you wish to filter Cost Centers |
Initial C.Center | Start of typed Cost Center |
Final C.Center | End in desired Cost Center |
Filter Item | Filter Accounting Item |
Initial Item | Start of report on desired item |
Final Item | End of report on item |
Filter Val Class | If you wish to filter Value Class |
Initial Value Class | Start of desired value class report |
Final Value Class | End of desired value class report |
Balance Type * | Balance Types |
Parameters with * are required in this report and of utmost importance for its printing.IMPORTANT!
On the Configurator (SIGACFG) access Environments>Registers>Menu (CFGX013). Enter menu option of Management Accounting and fill out information as explained below:
Menu | Management Accounting |
Submenu | Reports>Trial Balances |
Routine Name | Managerial Entity |
Program | CTBR165 |
Module | SIGACTB |
Table | CTM, CT3, CT4, CTI, CTN, CTH, CTH, CTT, CTD, CT1 |
To use report, update the menu with the latest available on the portal or add routine CTBR165 through configurator. For environments with releases previous to version 12.1.25, the user must update the MENU via configurator. Reference Link: http://tdn.totvs.com/x/QqApEIMPORTANT!