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

    • 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 ...

    • 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 ...

    • 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 ...

    • Budget Details - Account Line Items Article

      This report displays both the Assumptions sub-tab and Budget Summary data from the Account Details tab according to the Search criteria.  Accounts Details tab is found in Budgeting Dashboard, Basic Budget Entry, Custom Budget Entry, Custom ...