CA Clarity Tuesday Tip by Shawn Moore, Sr. Principal Support Engineer for 6/07/2011
Today's tip is a simplified set of steps to financially enable Clarity. If you haven't enable Clarity for Financials, you should only try the following on a test/dev system that can be restored. See currency selection note below. Next week, we'll look at the dataflow from timesheets to the ppa_wip table to see how our data moves from one location to another.
Financial Setup (Enabling Clarity for Financial)
================================================
0. Prerequisites: These should be decided prior to following the steps to financially enable Clarity.
a. Determine if the Clarity installation is to support a single currency or multi-currencies.
** If the application is set for Single-Currency option – and the need exists to change the installation to support Multi-currency – take a full back up of database and system files before and after the changes are made in case it becomes necessary to restored the system.
b. Determine the name of the Entity.
It is highly recommended that “The Corporation” be the Entity Name and “CORP” be the Entity Code
for the initial defaults.
c. Determine the default currency for the Entity.
d. Determine the Fiscal Year Type for the Entity.
The options are listed below and can be viewed by navigating to the following location if an Entity already exists.
Administration Tools >> Financial Module >> Setup >> Entity >> (Select on Entity) >>
view the Fiscal Period Type values.
- 13 Periods Per Year
- Annually
- Monthly
- Quarterly
- Weekly
e. Determine the Start Date and Finish Date for each period in the Fiscal Year.
Ok, here are the actual steps to enable Clarity for Financials. Note: these are a sample set of steps and are provided for "experimentation" and learning purposes only. Depending upon your organization's needs, you may need to configure this differently. For implementation help and recommendations on how to get the most out of Clarity financials, please consult our services group.
1. Department OBS
--------------------
Admin Tool -> OBS, click New, enter Name, ID, Levels =1
** level are defined in prj_obs_levels
Add associated Objects
Click Units, click New
Enter Name and ID
2. Location OBS
------------------
Admin Tool -> OBS, click New, enter Name, ID, Levels
Add associated Objects
Click Units, click New
Enter Name and ID
3. Entities, Fiscal Time Periods and Plan defaults
-----------------------------------------------------
a. Entity: Admin Tool -> Finance ->Setup
-- Click New to create an entity, enter values for required field Organization Breakdown Structures, select the Location OBS and Department OBS from 1 & 2 above
b. Fiscal Time Periods (this will be in your entity properties)
Click New, select Period Type and enter required fields
Filter for the Fiscal Time Periods you created
Activate them
c. Plan Defaults
Select Plan Default values (for use in cost plan creation later)
Create all the various classes, definitions, assignments, etc. under finance -> setup
----------------------------------------------------------------------------------------
4. Create Resource Classes (used in the project and cost plan later)
a. Click Resource Classes
b. Click New and enter required fields
c. Make sure it is active
5. Create Company Classes (under Finance-> Setup)
6. Create Work in Process Classes
7. Create Investment Classes
8. Create Transaction Classes (needed for each transaction, may not be used as much, but more that other classes, like investment class)
9. Create Batch Cycle Definitions
10. Create Batch Cycle Assignments
a. Click on the Batch Cycle created above and add yourself
11. Create Batch Cycle Output
a. Create Output Code and specify output path
b. Output path can be your local machine
12. Admin Tool ->Objects->Project -> Attributes
--------------------------------------------------
Click and set “Financial Status” = Hold (in earlier versions this defaulted to open in the attribute definition)
“Open” – Financial Transactions are created. Timesheet entries are sent to Invalid Transactions.
“Hold” – Financial Transactions not created yet
(setting the attribute default to Hold - this may be the default)
13. Define Matrix (not used a lot, but DST uses this for taxes) - under Finance -> Define Matrix
--------------------------------------------------
Admin Tool -> Define Matrix
(Optional For Cost Codes, Administrative charges, Taxes)
14. Create Rate Matrix (Manage Matrix)
--------------------------------------------------
Admin Tool -> Manage Matrix
Click New, enter Matrix Name and Matrix Type = Cost/Rate
Assign Columns, select columns, like Charge Code, Resource Class, etc
Edit Matrix Rows ->New and enter below values:
For example: From Date = 1/1/2011
To Date = 12/31/2012
Rate = 50
Standard Cost = 30
Actual Cost = 80
15. Associate departments to locations
------------------------------------------
Admin Tool -> Finance -> Setup -> Locations -> choose location -> Departments -> Add --> choose a location
Verify by looking at:
Click Home->Departments->Locations tab and add the locations to departments
** If you don't do this, then step 16 will not show any locations/departments.
16. Home ->External Billing ->Companies (this is an optional step, only needed for External Billing)
--------------------------------------------------
Create one or more companies and set it Active
Financial tab ->General
Select values created above
Financial Location
Financial – Department
17. Home->Resource (create a new resource)
--------------------------------------------------
Click New and create data for a resource and set the resource type to "Labor"
* set up for time tracking properties as well, so you can export transactions to financials.
Click Financial Tab and select values for required fields to financial enabled (all the required fields)
Click Financially Active Checkbox
Financial Location
Financial – Department
Transaction Class
Resource Class
Do the same for
a) Resource and Resource Type = Equipment
b) Resource and Resource Type = Material
c) Resource and Resource Type = Expense
d) Role and Resource Type = Labor
18. Home -> Projects
---------------------------------
a. Create a new project, set Progress = Started (under schedule), Status = Approved (under general properties)
b. Project ->Main ->Properties ->Financial, Financial Status = Open, Type = Standard, select, Company, Department and Location, select Labor Transactions Rates and Batch Cycle
(set type to Internal if External Billing is not used)
c. Team ->Staff ->add the resource created in Step 17
d. Task, create new task, select Charge Code, Save
Click Assign to select the resource to the task
Now you can create a timesheet for the resource from Step 17. Next week we'll look at the data flow from the timesheet to the finacial tables.
note: If you do not have any input type codes then you should also create some from within the Administration Tool, which are needed for transactions. A default can be specified at the resource level, especially if you timesheets do not have the input type field on the timesheet view. (Input type codes can be chargeable or not. If using external billing the input type code should be set to to chargeable.)
Enjoy!
-shawn