ERP Software Logo

Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

T3 Information Systems

10 Budget Solutions in Microsoft Dynamics GP


    Email | Print

    Pull real-time metadata from Microsoft Dynamics GP or SL with OneStop Reporting (OSR). OSR is a robust financial report writer that uses Microsoft Excel as a platform allowing you to take advantage of all Microsoft Excel functionality.  Report Designer builds reports which are Excel Templates. End User enters budget in Excel Template. Full Circle Budget (FCB) is an Excel Add-in that saves your budgets directly to Microsoft Dynamics from Excel without having to perform an extra step to import.

    FCB-GP-OSR-image

    10 Budget Solutions in Microsoft Dynamics GP (SL) using OSR and FCB:

    · Calculation Integrity
    OSR uses Microsoft Excel functionality. Calculations are saved in Excel templates and cannot be modified by end-user.

    · Difficulty Using Baseline Data or Known Data
    OSR’s metadata provides a live and seamless integration with Microsoft Dynamics GP (SL) allowing you to include historical data in budget template.

    · Security
    OSR Admin module provides security at any account segment level. Thus an end-user will only have access to their centers/departments when they run the budget template. Similarly, certain accounts can be excluded such as Salary accounts.

    · Issues with Budget Level Granularity
    Using a combination of OSR and FCB, budget templates can be designed with line item detail. Comment lines also are available for end-user to explain budget detail.

    · Endless Linking
    No linking is required since OSR’s metadata provides a live and seamless integration with Microsoft Dynamics GP (SL).

    · Lack of Analytical Capability
    Since Microsoft Excel is the platform for OSR, a designer has the ability to use all excel functions combined with historical comparisons when building a budget template.

    · Version Control
    No need to worry about multiple versions of the budget template saved on user’s computers since the Budget Template is an Excel Template that is read-only.

    · Mass or Global Updates
    Should the designer decide to modify the budget template, the next time the end-user runs the budget template all changes will be reflected.

    · Importing Budget to Microsoft Dynamics
    When the end user completes their budget entry and saves, FCB uploads budget to Microsoft Dynamics GP (SL). The key to making this work is that the account number, budget ID and period are stored somewhere in the excel template.

    · Reporting on the Final Product
    Use OSR Report Designer to build a real time Budget Summary report.

     

    Would you like to receive more information on Microsoft Dynamics GP and SL, OneStop Reporting or Full Circle Budget as solutions for your accounting system? Email us at [email protected] and T3 Information Systems will present the best options for your company. Check out additional product information on OneStop Reporting and on Full Circle Budget on our website.

     

    Contact T3 Information Systems [email protected] to discuss pricing for your specific needs and learn more about Microsoft Dynamics GP for your business.

     

    By: Mary Schmidt, T3 Information Systems, www.t3infosystems.com Washington, DC Microsoft Dynamics GP Partner

    One Response to “10 Budget Solutions in Microsoft Dynamics GP”

    1. Excellent article. I am dealing with a few of these issues as well.
      .

    Ask This Expert a Question / Leave a Comment

     

     
     
    Live chat by BoldChat
    Show Buttons
    Hide Buttons