Microsoft Dynamics SL 2015 Project Features

Report
Project Multi-Company and
Project Multi-Currency
SL 2015
Darrell Meisner | Plumbline Solutions, Inc.
OBJECTIVE
• Understand the requirements for utilizing the
Multi-Company and Multi-Currency features of
the SL 2015 Project Series modules
Agenda
• Project Series
Multi-Company
– Requirements and Setup
– Demo
– Questions
• Project Series
Multi-Currency
– Requirements and Setup
– Demo
– Questions
Project Series Multi-Company
Summary
• Expands the Project modules to include familiar
multi-company capabilities found in other SL
modules
– Secure access by company
– Process multiple companies at once
– Print reports by company
Project Series Multi-Company
Dependencies
• Multi-Company (MC) module
– Registered and set up
• GL Setup
– Allow multiple companies in a single database
NOTE: This feature only applies to multiple companies within one
application database.
Project Series Multi-Company
Dependencies (continued)
• Access Rights Maintenance (95.270.00)
– Setup access to screens/processes/reports per
company
Example: A user with access to Project Maintenance (PA.PRJ.00) for
only company 0060 can only manage projects assigned to
company 0060.
Project Series Multi-Company
Features
• Maintenance, Input, and Inquiry screens
– Screen acts on all objects from any companies for
which the user is granted access to this screen
• Eliminates the need to log out of company A and then log
into company B
NOTE: This is different from the multi-company implementation in
other modules where users can only act on objects from the
logged in company.
Project Series Multi-Company
Features (continued)
• Processes
– Default is to process the logged in company
– Select ‘All’ allows processing for all companies for
which the user has been given access to this process
Project Series Multi-Company
Features (continued)
Project Series Multi-Company
Features (continued)
• Reports
– The ROI “Company Selection" tab is functional
Example: User logged into company 0070 opens the Project List Report
(PA.170.00) and clicks the “Company Selection” tab. They
select company ID 0070 and 0080 and preview the report.
Output contains data for projects from company 0070 and
0080.
Project Series Multi-Company
Features (continued)
Project Series Multi-Company
Demo
Project Series Multi-Company
Not Affected
• Some processes, due to their nature, are not
impacted by this feature
–
–
–
–
–
–
–
Financial Transaction Transfer (PA.TRN.00)
Close Period (PA.CLO.00)
Delete Project Detail (PA.PUR.00)
PMA Integrity Check (PA.BLD.00)
Billings Transaction Load (BI.BTL.00)
Automatic Payment Analysis (CN.APA.00)
Labor Commitment Load (TM.LCL.00)
Project Series Multi-Company
Not Affected (continued)
• Most configuration screens
– Allocation Method Setup (PA.MET.00)
– Billing Rules Maintenance (BI.RUL.00)
– etc.
• Allocation Processor Inter-company transactions
– Still placed in the GL batch for the source Project’s
company
Project Series Multi-Company
Not Affected (continued)
• Schema
Project Series Multi-Company
Questions?
"Things should be made as simple as possible, but
not any simpler.“ - Albert Einstein
Project Series Multi-Currency
Summary
• Projects and subcontracts can now be assigned
a foreign currency
– A.K.A. “Project Currency”, “Subcontract Currency”
– Budget/Transaction amounts are tracked in both
foreign currency and base currency
• Within Project, entry is always in the assigned
currency
Project Series Multi-Currency
Summary (continued)
– Entry, inquiry, and reports are in the assigned
currency
– During upgrade, entities are assigned the base
currency
– A “Convert Project Currency” Tool is available through
support
Project Series Multi-Currency
Summary (continued)
• Does not affect the existing Foreign Currency
Billing feature
– Project Currency and Project Billing Currency (or
Billing Currency) are separate and independent
Project Series Multi-Currency
Dependencies
• Currency Manager (CM)
– Must be registered and activated
– Add currencies and consider required rate types
– Configure rate tables
• Project to Base; Base to Project; Billing to Project;
“Other” currencies to Project as needed
Project Series Multi-Currency
Dependencies (continued)
• Project Controller Setup
– New option under the PC Options and Setup tab
• Activate Foreign Currency Project Management
must be turned on
Project Series Multi-Currency
Dependencies (continued)
Project Series Multi-Currency
Dependencies (continued)
• Schema
– Need to store the …
•
•
•
•
•
•
currency code
currency rate type
effective date
multiply / divide flag
currency rate
amounts
Project Series Multi-Currency
Dependencies (continued)
– Subcontract Currency fields
• Prefixed with “Cury”
– Project Currency
• Prefixed with “ProjCury”
– The “Cury” prefix was already used for originating
currencies from other modules as well as foreign
currency billing.
Project Series Multi-Currency
Schema
Table
PJPROJ – Project Master
Column Name
ProjCuryId
ProjCuryRateType
Type
CHARACTER (4)
CHARACTER (6)
ProjCuryBudEffDate
SMALLDATETIME Date used to retrieve the project currency budget
exchange rate.
CHARACTER (1) Indicates whether the project currency amount can be
multiplied or divided by the project currency exchange
rate to arrive at the base currency amount. Valid values
are: M - Multiply D – Divide.
FLOAT (8)
The exchange rate in effect for project currency budget
translation.
ProjCuryBudMultiDiv
ProjCuryBudRate
Comment
Identifies the project currency.
Identifies the default rate table for exchange rate lookups.
Project Series Multi-Currency
Schema
Table
PJTRAN – Project Transaction File
Column Name
ProjCury_amount
ProjCuryEffDate
ProjCuryId
ProjCuryMultiDiv
ProjCuryRate
ProjCuryRateType
Type
Comment
FLOAT (8)
The transaction amount in the project currency.
SMALLDATETIME Date used to retrieve the project currency exchange rate.
For summary postings, set to "1900-01-01 00:00:00".
CHARACTER (4) Identifies the project currency of the transaction.
CHARACTER (1) Indicates whether the project currency amount can be
multiplied or divided by the project currency exchange
rate to arrive at the base currency amount. Valid values
are: M - Multiply D – Divide. For summary postings, set to
"M".
FLOAT (8)
The exchange rate in effect for project currency
translation. For summary postings, set to 1.00.
CHARACTER (6) Rate type used for project currency translation. For
summary postings, set to blank.
Project Series Multi-Currency
Schema
Table
Column Name
PJPTDROL – Project Current Rollup ProjCury_act_amount
ProjCury_com_amount
ProjCury_eac_amount
ProjCury_fac_amount
ProjCury_rate
ProjCury_tot_bud_amt
PJPTDSUM – Project-Task Current ProjCury_act_amount
Summary
ProjCury_com_amount
ProjCury_eac_amount
ProjCury_fac_amount
Type
FLOAT (8)
FLOAT (8)
FLOAT (8)
FLOAT (8)
FLOAT (8)
FLOAT (8)
FLOAT (8)
Comment
Project currency actual amount
Project currency commitment amount
Project currency revised budget amount
Project currency forecast budget amount
not used at this time
Project currency original budget amount
Project currency actual amount
FLOAT (8)
FLOAT (8)
FLOAT (8)
Project currency commitment amount
Project currency revised budget amount
Project currency forecast budget amount
Project Series Multi-Currency
Features
• Projects and Subcontracts can now have a
currency assigned.
Project Series Multi-Currency
Features (continued)
Project Series Multi-Currency
Features (continued)
• Maintenance, Input, and Inquiry screens
– Application Toolbar currency buttons are now
activated on select screens
• Allows users to toggle the view between the
foreign currency and the base currency.
Project Series Multi-Currency
Features (continued)
Project Series Multi-Currency
Features (continued)
• Reports
– New formats that show data in the foreign currency
• These are versions of the existing base currency
reports
Project Series Multi-Currency
Features (continued)
Project Series Multi-Currency
Demo
Project Series Multi-Currency
Not Affected
• Foreign Currency Billing
– Works the same as always
– Can be turned on/off independent of Foreign
Currency Project Management
Project Series Multi-Currency
Not Affected (continued)
• Allocation Processor
– Still uses base currency amounts for standard
allocations
– Conversion for Foreign Currency Billing is still the
same
Note: Does handle conversion of allocated amount to the project
foreign currency
Project Series Multi-Currency
Not Affected (continued)
• Time Entry is still base currency only
• Expense multi-currency entry still functions the
same
• Employee Utilization has not changed
Project Series Multi-Currency
Questions?
“Before I came here I was confused about this
subject. Having listened to your lecture I am still
confused. But on a higher level.” - Enrico Fermi
Contact Info
Darrell Meisner
[email protected]
THANK YOU
Please fill out your evaluation

similar documents