How Do I Report on Account Segments? Article

How Do I Report on Account Segments? Article

ERP Accounts  include all segments of the account number.  Objects combine segments of the full account number.  Tags in Manage ERP Accounts can be used to group like segments together for reporting purposes on Define Row Formats.


For example, the full account number segments are: OrgUnit (???) + Natural Class (????) + Location (??). The Dynamics Budget structure combines the Natural Class and Location together to form the Object code (????-??). Therefore the Objects cannot be used to report on location.


Please see 1. in Manage ERP Accounts for a full explanation on how to use Tags to report on a segment code, such as the Location code.



Related Article:

Dynamic Budgets can do side by side comparisons of a single budget account to the sum of multiple accounts grouped by either the Object code or the ObjectRollup code as specified in Manage Objects.  Please see Report Level-GL Code, Object or Object Rollup

    • Related Articles

    • Form/Report Article

      The Form/Report functionality provides the ability to: 1) Display comparative data from prior year actuals and/or budgets on the Basic Budget Entry screen.  These Forms are setup in Define Basic Budgets Entry Forms. 2) Customize the data to be ...

    • Report Level-GL Code, Object, or Object Rollup Article

      How to Use Report Level of {Object} or {Object Rollup} in Custom Report or Custom Budget Entry Form definitions Dynamic Budgets can do side by side comparisons of a single budget account to the sum of multiple accounts grouped by either the Object ...

    • Object (Main Account) Article

      The Object is our term for the Main Account or Natural Account segment of the GL Account of the ERP Software (Revenue, Expense, Asset or Liability). The Object can be a single GL segment or can be the concatenation of a main account segment and one ...

    • Account Number (Budget Account Number) Article

      An Account Number refers to the full General Ledger Account Number  ("GL Accounts") which originates from Great Plains Accounting Software ("ERP").  Account Numbers cannot be created in Dynamic Budgets. This is by design and acts as a control such ...

    • Payroll Summary Report Article

         Tutorial Link Purpose: This report displays all of the payroll data which may include employee name, orgunit, annual salary, and benefits. The report can be sorted and subtotaled by any of the columns displayed.  There is no total row ...