Showing posts with label Checklist. Show all posts
Showing posts with label Checklist. Show all posts

Sunday, October 19, 2014

Fixed Asset Period-End Procedures Checklist

Fixed Asset Period-End Procedures
1)      TO MANUALLY ADD A FIXED ASSET FROM PAYABLE TRANSACTION:
Cards – Fixed Assets – General
·        Put in the Asset ID (look at the last asset in the sub-ledger category then add 1)
·        Click “Purchase”
o   If there is not a “Purchase” button there are no assets to add (see #2 below)
·        Select line item in Fixed Asset Purchasing Transaction
·        Enter description, class ID
·        Click on the Go To icon in the top right hand corner
·        Go to Book
·        Select Book ID

2)      TO MANUALLY ADD A FIXED ASSET FROM THE CLEARING ACCOUNT:
Cards – Fixed Assets – General
·        Put in the Asset ID (look at the last asset in the sub-ledger category then add 1)
·        Enter description, class ID, Acquisition date, Acquisition Cost, Physical Loc ID, Location ID
·        Click on the Go To icon in the top right hand corner
·        Go to Book
·        Select Book ID 


3)      TO RUN DEPRECIATION ON ALL ASSETS (make sure AP is closed before depreciating assets):
This process will depreciate all assets for one month and should be run after A/P is closed for the month closing.
Tools – Routines – Fixed Assets – Depreciate
·        Select the “Depreciate All Assets” box to calculate depreciation for all assets
·        Enter the date through which depreciation is calculated in the “Depreciation Target Date”
o   i.e. – if you are closing January 2009 this date should be 01/31/2009
·        Insert the book(s) to be depreciated into the “Selected Books”.
·        Click “Depreciate” to begin the depreciation process
  
4)      RUN PRE-RECONCILIATION TO GL REPORT:
This process is to make sure your depreciation and ledger posting looks correct.  Check depreciation against last month for reason-ability. 
Reports – Fixed Assets – Activity – Fixed Assets to General Ledger Recon
·        Select Report Format
·        Select Modify
·        Print report

5)      General Ledger Posting
Tools – Routine – Fixed Assets – GL Posting
·        Enter:
o   Beginning & Ending Periods (both s/b the year and month closing – ex. 2008-012)
o   Transaction date (last day of the month closing ex. 12/31/08)
o   Comment (this will show up on the GL batch comment)
o   Continue

6)      Run the FA to GL recon again.
o   There shouldn't be anything on this report after the GL posting process

7)      Run inventory Report
Reports – Fixed Assets – Inventory
·        FA Inventory Report
o   Modify
o   Ranges
o   Class ID
·        Computer Equip to Software
o   Placed in Service Date
·        1/1/1995 to date of recon (ex. 7/31/09)

8)      Run Depreciation Ledger by Location
Reports – Fixed Assets – Depreciation – Depreciation Ledger by Location
·        Run for each class ID

Thursday, September 25, 2014

Management Reporter Installation Checklist

I have noticed numerous SOLID blog posts, which walk through the installation steps for Management Reporter!  The Dynamics Community does not disappoint - the level of sharing and collaboration frankly astounds me.   These blog posts include screen shots, and detailed instructions. 

Management Reporter installation woes still seem to be the source of many posts on the community forums.  The reason, the DEVIL is in the DETAILS.

What follows is a checklist I use when installing Management Reporter.  Prior to putting this checklist together, I routinely encountered issues when installing and configuring Management Reporter.   Without further adieu:

Make sure install user is Domain and Machine Administrator
Add Server Role - Web Server
Add Server Role - Application Server
Enable .Net 3.5.1 ASP.Net
Enable IIS 6 Metabase Compatibility Feature for IIS 7
Enable WCF HTTP Activation
Disable User Account Control
Reboot Machine (can try iisreset if not practical)
Run installation from a folder with short path-name
Run installation as administrator
Do NOT select NT AUTHORITY accounts - use an Active Directory Account created for this purpose.
Ensure the user you have running the application pool has "log on as batch job" rights in the local security policy of the machine.
Remember to Register Management Reporter - default installation is Evaluation Copy, no reminder to register, until the trial period expires!


Tuesday, September 16, 2014

The Value of Checklists - Dynamics GP 2013 Upgrade Checklist

As a general rule I advocate for the use of checklists when doing anything important.  It doesn't matter how many times a pilot flies, they still get in the plane and run through the "preflight" checklist prior to taking off, because let's face it, planes can and do fall out of the sky when something goes wrong.

Every year, our team goes through the Year-End Checklist prepared by the Microsoft team, adds our in spin on things, and then publishes it to our clients.

The checklist below is a constantly evolving Dynamics GP Upgrade Checklist. It is by no means exhaustive, and is a high-level document, which references technical information without providing significant detail.  Feel free to comment or ask questions.


Dynamics GP 2013 Upgrade

Preparation
Upgrades to GP 2013 Require a Zero Dollar Product Order
Designate a Client IT resource
Distribute Installation and Upgrade instructions to Client IT resource
Create/Validate Admin account for CustomerSource access for Client IT
Obtain Dynamics GP Install Media – Client IT Download to Install Folder
Obtain Dynamics GP Keys – Client IT Download to Install Folder
Obtain SQL Server Media – Client Obtain (validate licensing)
Obtain Management Reporter Media – Client Download to Install Folder
Obtain Management Reporter Key
Client IT - Create Domain/Machine Admin Credentials Install User
Client IT - Run File Maintenance / Check Links on data
Determine 3rd Party Applications installed
Contact 3rd Party support to determine version compatibility
Obtain 3rd Party Product Keys
Review necessary documentation – installation and upgrade instructions for any 3rd Party products
Determine GP Modules Installed  and in use
Identify Reports used to validate upgrade

Installation Prerequisites
Validate Sever Configuration
Add Server Role - Web Server
Add Server Role - Application Server
Enable .Net 3.5.1 ASP.Net
Enable IIS 6 Metabase Compatibility Feature for IIS 7
Enable WCF HTTP Activation
Install SQL Server 2008 r2
Optional – if someone else installed SQL and used Window Only Authentication 
Reconfigure SQL to accept Windows and SQL Authentication
Enable SQL SA User Account
Set SQL SA User Account Password – make sure meets requirements
Distribute SA Password to designated client IT resource
Install SQL Server Reporting Services
Validate SSRS Install
Install Management Reporter
Install Dynamics GP
Install Required 3rd Party Products

Backup Tasks
Backup Databases
Backup Working Workstation Folder for current version
Back Up Application Customizations
Custom Forms
Custom Reports

Optional - if moving Dynamics GP to New Environment
Move Database backups to new machine
Restore Files List Only (Determine DB Configurations)
Create Target Databases using DB Configurations
Restore Databases
Set SQL Compatibility Level (i.e. move from SQL 2005 to 2008)
Configure Security
Run Scripts to Capture Logins from Old Server
Run Script to Create Logins on New Server
Run sp_changeowner DYNSA on GP Databases
Run Grant.sql script on GP Databases
Backup the Databases – make sure you can restart from this point if Upgrade goes sideways
Run DynUtils
Upgrade System Database
Upgrade Company Databases
Enter Registration Keys
Add New Users
Create New Users
Testing -  Log in as user
Share Network Folder (hold shared components)
Set Security Correctly (Read and Execute Permissions)
Create Workstation install package
Install Workstations
Test Workstations
Run reports to compare to validation reports