Introduction to
and Infor SunSystems
By Triforce Global Solutions
Dec 2023
Copyright © 2013. Infor. All Rights Reserved. [Link]
Agenda
1. Triforce Introduction
2. Infor SunSystems Overview and Demo
• Ledger Accounting Module
• Infor Q&A (VISION-XL)
3. Questions and Answers
Copyright © 2013. Infor. All Rights Reserved. [Link]
Triforce Asia Networks
Thailand Japan
Myanmar
Singapore
Philippines
Local & Regional team
Clients in Asia Countries
We’re specialized in:
• Finance Operations Management & Process Automation
• Financial Planning & Analysis , Consolidation
• Budgeting & Cost Control & Expense Management
Copyright © 2013. Infor. All Rights Reserved. [Link]
Triforce Company Profile
Asia Pacific
Fastest Growing Infor’s Certified Partner , 13 years in Services
Over 100 Years Combined Experiences
In SunSystems Implementation
Over 220 SunSystems Customer
Commitments
Thailand , Singapore , Philippines , Japan , Indochina (L/M/V/C) )
Motto
Engineered for Financial Excellence
Methodology
Committed in “Long-Term
Relationship” & Focus on Proven project methodology ensuring project success
Clients’ Benefits in timely, efficient and cost effective manner.
Continuous INFOR’s Partner of the Year
Copyright © 2013. Infor. All Rights Reserved. [Link]
infor TODAY
90,000 25M users 10+ years >17,000
Global experience Employees
customers in the cloud
3rd largest 100,000 1,700 Support
Private tech
company
global Infor CRM
users
Engineers
200+ 99.9% $3B Revenue >5,000
Countries
and territories
historical
uptime
Developers
[Link]
Copyright © 2013. Infor. All Rights Reserved. [Link]
Industries used Infor SunSystems ...
1. FSI – Financial Services Indutries … Banking , Insurance , Investment , Asset Mgmt ,
Securities ( Brokerage ) , Insurance Broker ,
2. Energy and Power
3. Constructions
4. Professional Services , ( ie: Big 4 , SI )
5. Trading , Retails , Distribution
6. Hospitality
7. Mining
8. Property Management
9. Advertisement , Media
10. Manufacturing
11. NGO
And many more ……
* More than 10,000 companies World Wide use SunSystems
Copyright © 2013. Infor. All Rights Reserved. [Link]
Infor SunSystems
Industry Logos
AEROSPACE AUTOMOTIVE HOSPITALITY SERVICES TECHNOLOGY NOT FOR PROFIT
Copyright © 2013. Infor. All Rights Reserved. [Link]
Some Infor SunSystems Clients
Ramaland Development Co.,Ltd
Copyright © 2013. Infor. All Rights Reserved. [Link]
How well do you know SunSystems ?
700+ Life & Non-Life
600+ Oil and Gas site
Insurance companies
Worldwide
Worldwide
36 Years+ IFRS 10,000+
In Financial Experience Certified & Complied Organization WW
with Sarbane-Oxley
ACT Other Sunsystems All 5 of the UK’s Big 5
Users Includes : Accountancy Firms
Strategic ISO 9001 Christian Dior, Polo
Ralph Lauren, Nike,
First Financial Software
Infor Financial Paul Smiths
Product Vendor
Copyright © 2013. Infor. All Rights Reserved. [Link]
SunSystems Modules Integration
Infor dEPM
Financial Consolidation Budgeting & Planning, Forecast Strategy Management EAM WMS POS LOCAL PAYROLL
Recurring Invoice Requisition
SS Financial SS Q&A (VISION)
SS Order Management
Ledger Accounting PM Q&A XL
Sales Management
Asset Register PM Q&A Executive
Purchase Management
Corporate
Allocations PM Q&A Alert
Inventory Control
Foundation
Multi-Currency Filter Designer Forms Designer Formula Designer Report Writer Navigation
Manager Copyright © 2013. Infor. All Rights Reserved. [Link]
Office of the CFO solution footprint
Mobility Reporting BI Dashboards Social
Financials General & other Ledgers Projects Fixed Assets
XM
Accounts Payable Accounts Receivable Cash Flow Mgmt Expense Mgmt
Supply Chain Order Mgmt Procurement Sales Management Inventory Management
Human Capital HR Management Talent Management Service Delivery Workforce Management
Risk Continuous Monitoring Audit Compliance Regulatory Compliance Risk & Scoring
Enterprise Assets Work Order Management Reliability Management Sustainability Predictive Management
Performance Financial Reporting, KPI Budgeting Planning Consolidations Strategy Management
[Link] – Cloud Based Localizations – Tax, Reporting, Accounting, Bank Messages
Business Analytics – Analytics – Dashboards – Operational Reports – In-Context BI
Technology
ION – Integration – Workflow – Alerts – Business Vault
Business Cloud – Hybrid – Upgrade/S - PaaS
Copyright © 2013. Infor. All Rights Reserved. [Link]
VALUE FROM TRIFORCE
ONE SYSTEM WITH FULL INTEGRATION
Front End
SunSystems SS
TRANS. DESK
Other 3rd Systems
SS CONNECT HR , payroll
BU1 BU2 BU3
INDIA TH PH
SS Order Management SS Financial
Ledger Accounting
Inventory Sales AP/AR/GL
CA and Fixed Asset
Requester Purchase Requisition
Purchase Order
Budget Q&A Reporting
Financial &
Tax
Budgetary Control Management
Reports
Approver Reports
IFRS Reports
Copyright © 2013. Infor. All Rights Reserved. [Link]
Introduction to
Infor SunSystems
Copyright © 2013. Infor. All Rights Reserved. [Link] 17
Infor SunSystems Product Journey
Customers changing expectations met with product evolving needs, enhancing
product from DOS, Windows, Web-based to on Cloud application….
1980s 1990s 2000s Infor10 Web Infor SunSystems Version 6.4
Cloud Certified Architect
Copyright © 2013. Infor. All Rights Reserved. [Link]
Infor SunSystems Integration
Financial
Order Management Ledger Accounting
(GL/AP/AR) +
Sales Management budget control
Fixed Asset Register
Inventory Control
Corporate
Purchasing Management Allocations Infor Q&A (VISION)
(PR/PO) (BI or Reporting Tool)
Foundation
Multi-Currency Filter Designer Forms Designer Formula Designer Report Writer Navigation Manager
Copyright © 2013. Infor. All Rights Reserved. [Link]
Infor SunSystems Look & Feel (Web-Based)
myuserid
xxxxxxxxxx
Copyright © 2013. Infor. All Rights Reserved. [Link]
Infor SunSystems Look & Feel (Web-Based)
Copyright © 2013. Infor. All Rights Reserved. [Link]
Infor SunSystems Look & Feel (Windows Based)
myuserid
xxxxxxxxxx
Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright © 2013. Infor. All Rights Reserved. [Link]
Infor SunSystems Characteristics
• Multi-Companies feature: unlimited companies can be set-up
• Multi-Currencies feature: up to five currencies per transaction
• An Integrated Ledger or unified leger or combined ledger, SunSystems holds
revenue, costs, customers, suppliers, bank accounts, cash, investments, assets,
accruals etc. which provides Powerful in Real-Time Analytics with Single Point
of Access
• Very Flexible Analysis Structure Power can be changed over life of system
Copyright © 2013. Infor. All Rights Reserved. [Link]
Infor SunSystems Characteristics
• Ten Budget Ledger Files (Ledger for A-K) per Business Unit – for international
compliance
• Open system – Easy to Integrate with other applications
• Wilde range of Modules and Companion Products
• Screens can be Personalized by different users
• Flexible architecture suited to centralized deployment for on-premise, private cloud or
multi-tenant
• Infor Q&A is a Powerful and Flexible Business Intelligence Tool add-in Microsoft Excel
Copyright © 2013. Infor. All Rights Reserved. [Link]
Multi-Companies
Unlimited companies can be set-up as “business unit” or BU
Holding Company
Consolidated
Reports
Subsidiary Company-1 Subsidiary Company-2 Subsidiary Company-3 Subsidiary Company- 4
(BU-1) (BU-2) (BU-3) (BU-4)
Copyright © 2013. Infor. All Rights Reserved. [Link]
A Sample Multi-Companies Financial Report
Copyright © 2013. Infor. All Rights Reserved. [Link]
Multi-Currencies
Foreign currency per transaction against base currency and reporting currency
with daily exchange rate or period exchange rate
Value 1 Value 3
Value 2 Reporting Currency
Base Currency (SGD)
Transaction Currency (THB)
1 USD = 30.16 THB 1 USD = 1.40 SGD
1 EUR = 33.62 THB 1 EUR = 1.55 SGD
1 YEN = 0.29 THB 1 THB = 0.44 SGD
Foreign Currency Transaction Reports Company Group Reports
Copyright © 2013. Infor. All Rights Reserved. [Link]
Infor SunSystems is an Integrated Ledger
Infor SunSystems Financials maintains all of your accounting
details within a single, integrated ledger. You do not require
to separate General Ledger, Accounts Receivables Ledger,
Chart of Accounts Types
Accounts Payables Ledger, Client Ledger, Project ledger as a
Balance Sheet subledger.
The single source of financial data means that reports and
Profit & Loss
inquiries always reflect an accurate position.
Debtors
Integrated Ledgers
Creditors • Real time posting – Payable, Receivables and
General Ledger
Clients
• Get financial reports even without actual posting
Memo • No reconciliation
• Immediate availability for reporting
• No Period Closing
• Combined reporting across Payables/ Receivables
and GL
Is used to record non-financial data that should
not be included in the trial balance. • Powerful in real-time analytics and Business
Intelligence
Copyright © 2013. Infor. All Rights Reserved. [Link]
Flexible and Powerful Analysis Structure
Infor SunSystems’ reputation for flexibility comes from the way the dimensions are generated and used.
Each one is created and maintained independently of each other and of the customer, supplier, profit
aand loss or balance sheet account setup.
The two are linked together through a particular transaction process. In addition, the dimensions don’t
need to be defined from day one of installation – they can be added as the system grows
Value Static Analysis (A-Code) Transaction Analysis (T-Code)
(THB.) Account Code Description
IFRS ACC. [Link]. BRANCH PRODUCT
10,000.00 Revenue from Service 4602-01-01 EX8500-01-2 HOF PRD-1
4-10100
2,000.00 Revenue from Service 4602-01-01 EX8500-01-2 BN1 PRD-1
4-10100
4602-01-01 EX8500-01-2 BN2 PRD-2
3,000.00 4-10100 Revenue from Service
15,000.00 TOTAL
Copyright © 2013. Infor. All Rights Reserved. [Link]
Flexible and Powerful Analysis Structure
Chart of Accounts Creditor Debtor Transaction Fixed Asset PR/PO
A1 T1 F1 P1
S1 A1
A2 T2 F2 P2
S2 A2
A3 T3 F3 P3
S3 A3
A B
C | | | | | |
A10 T10 F10 P10
S10 A10
1
2
3
4 Up to 10 analysis types for each analysis structure
Up to 15 characters for each analysis code
Copyright © 2013. Infor. All Rights Reserved. [Link]
Account Code in SunSystems Product/service
Cost center
project
Traditional account code : 4-10100-100-C141-1101
SunSystems account code: 4-10100
Description: Revenue from Services
Account Analysis
Transaction Analysis
Account Type: P&L
Product/ Service: 100
IFRS A/C : 4602-01-01
Cost Center: C141
Conso A/C : EX8500-01-2
Project: 1101
Salesperson: MTT
Copyright © 2013. Infor. All Rights Reserved. [Link]
Flexible and Powerful Analysis Structure
Data is meaningful
Structured to support independent coding
More responsive to business change
Data to report and analyze stored right at the source
Available immediately
Capture all detail you need
Copyright © 2013. Infor. All Rights Reserved. [Link]
Multi-Set of Books
• 10 Budget Ledgers with the same structure of Main Ledger (Ledger A)
• Flexible Budget Code Structure
• Budget Control & Alert
• Spreadsheet Import/Export
Actuals Budget
Commit Local
GAAP
... IFRS
ment
Budget Statutory
B C D E K
Copyright © 2013. Infor. All Rights Reserved. [Link]
Handle Multiple Reporting Standard Easily
What if you needed a ledger for budgets? What if you need a
ledger for commitment tracking? What if you need a ledger to
support IFRS reporting?
⚫ You can have up to 10 ledgers per
Business Unit – for different
commitments, IFRS, GAAP, Budget, etc.
Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.
Advance Budgeting Mechanism
Budget check can be set
Budget Ledger
up to 5 levels
• Account Code
Expense Account
• Analysis Code (T-Code)
• Category 1 ( e.g. Department)
• Category 2 ( e.g. Project) T 1 – Department
• Category 3 ...
• Category 4 ...
T 2 – Project
User-definable budget
• E.g. budget for Training &
Workshop
Copyright © 2013. Infor. All Rights Reserved. [Link]
Open Interface
SunSystems Text file
Client or
XML file
Transfer Front -End System
Desk
Bank Paylink
SunSystems Web Payroll System
Database Service
BI Tools
ION
Server Other 3rd party System
Third Party
Development
Copyright © 2013. Infor. All Rights Reserved. [Link]
Open Interface
Transfer : Integration Tools
Desk (TRD)
Copyright © 2013. Infor. All Rights Reserved. [Link]
Open Interface : Transfer Desk
Import & Export Tools - Transfer Desk
Copyright © 2013. Infor. All Rights Reserved. [Link]
Optional for Posting a Journal
• Permanent Post or hard posting to the financial ledger and it can not be changed
• Provisional transactions are posted to the ledger as temporary, or draft postings.
You can amend these transactions and report on them and must be made
permanent at a later stage
• Holding transaction in the journal for
• Unauthorized Person
• Delay for Hard Posting
• Cancelling an Unposted Journal or Journal Has Some Mistake
Copyright © 2013. Infor. All Rights Reserved. [Link]
Use a blank pre-printed cheque form to print a cheque
Copyright © 2013. Infor. All Rights Reserved. [Link]
Form Designer
• Provide you with the
ability to customize
the system to reflect
your data flows and
terminology
• You can add your own
selection of data items
and controls to a form,
and specify your own
help text to assist
users.
Copyright © 2013. Infor. All Rights Reserved. [Link]
Report Designer
• Support for design of
business documents
• End-user design
• Widely-used technology,
more user-friendly
• Library of over 200 sample
reports
Copyright © 2013. Infor. All Rights Reserved. [Link]
Reporting Tools
a) SSRS
SunSystems Reporting Services
b) Q&A Reporting
Sample of SSRS Report
Copyright © 2013. Infor. All Rights Reserved. [Link]
Sample : SSRS Report Purchase Requisition
Copyright © 2013. Infor. All Rights Reserved. [Link]
Infor Query and Analysis
(Infor Q&A) as a Reporting Tool
Copyright © 2013. Infor. All Rights Reserved. [Link] 46
Infor Q&A
Infor Q&A formerly known as “VISION”, allows account staff to easily
create and update reports in a real time directly from Infor
SunSystems and gives managers unique insight into every facet of
business by providing multiple dimensions of financial and operational
information with the tool to create standard reports and ability to drill
down.
Infor Q&A also allows you to send data into SunSystems straight from
Microsoft Excel with full validation.
Copyright © 2013. Infor. All Rights Reserved. [Link]
Infor SunSystems & Q&A Reporting tool
Financial
Order Management Ledger Accounting
(GL/AP/AR) +
Sales Management budget control
Fixed Asset Register
Inventory Control
Corporate
Purchasing Management Allocations Infor Q&A (VISION)
(PR/PO) (BI or Reporting Tool)
Foundation
Multi-Currency Filter Designer Forms Designer Formula Designer Report Writer Navigation Manager
Copyright © 2013. Infor. All Rights Reserved. [Link]
Infor Q&A
Copyright © 2013. Infor. All Rights Reserved. [Link]
Infor Q&A
Copyright © 2013. Infor. All Rights Reserved. [Link]
Infor Q&A
Copyright © 2013. Infor. All Rights Reserved. [Link]
Sample Report –Balance Sheet
Copyright © 2013. Infor. All Rights Reserved. [Link]
Sample Report –Profit and Loss
Copyright © 2013. Infor. All Rights Reserved. [Link]
Sample Report –Trial Balance
Copyright © 2013. Infor. All Rights Reserved. [Link]
Sample Report –Chart of Accounts
Copyright © 2013. Infor. All Rights Reserved. [Link]
Sample Report –Account Balances
Copyright © 2013. Infor. All Rights Reserved. [Link]
Sample Report –Aged Creditor
Copyright © 2013. Infor. All Rights Reserved. [Link]
Drill-Down Functionality
Copyright © 2013. Infor. All Rights Reserved. [Link]
Consolidating Enterprise
Company A Company B
HQ
Company C Company D
Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.
A Sample Multi-Companies Financial Report
Copyright © 2013. Infor. All Rights Reserved. [Link]
Send Data to SunSystems
PM Q&A converts the data in the Microsoft Excel file to an import file compatible
to Infor SunSystems.
SunSystems
Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright © 2013. Infor. All Rights Reserved. [Link]
International Expertise…
Copyright © 2013. Infor. All Rights Reserved. [Link]
THANK YOU
Copyright © 2013. Infor. All Rights Reserved. [Link]
SunSystems – FA , Asset Register
Fully Integrated with Ledger
Full Management of Fixed Asset
• Automate Depreciation Calculation
• Set up Asset Budget for reporting/ analysis purpose
• Allocate Depreciation
• Asset Analysis Code
• Asset Inquiry & Reports
• Reporting Tools
Copyright © 2013. Infor. All Rights Reserved. [Link]
Fixed Asset Structure
ASSET CODE LOCATION
+
ASSET GROUP
PROJECT
OWNER
Etc.
Copyright © 2013. Infor. All Rights Reserved. [Link]
FA : Depreciation Allocation
Admin Dept 50%
Sales Dept 10%
ASSET
Marketing Dept 10%
DEPRECIATION
Production Dept 10%
Account Dept 10%
etc. 10%
Copyright © 2013. Infor. All Rights Reserved. [Link]
FA : Asset Class
Copyright © 2013. Infor. All Rights Reserved. [Link]
FA : Asset Quantity
Copyright © 2013. Infor. All Rights Reserved. [Link]
FA : Partial Disposal
Copyright © 2013. Infor. All Rights Reserved. [Link]
SunSystems : Corporate Allocation
Fully Integrated to Ledger Module
Powerful tool allowing to manipulate existing transactional data.
• Spread across period, analysis code, ledger and accounts
• Split, Increased, or Reduced.
Data apportionment
• Cost Center, product, etc.
• Inter-company posting
• Budget Spreads (uplifts of reductions)
• Fixed Asset Revaluation
Copyright © 2013. Infor. All Rights Reserved. [Link]
CA : Multi-level Allocation
20%
Dept C
40%
40%
Expenses
Dept B
100%
60%
40%
Dept A
Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.
CA : Inter-Company Allocation
Company A Company B
Company A
Expenses
40%
Expenses
100%
Inter -Company B Inter -Company A
60% 60%
Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.
Purchase Requisitioning
74 Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.
Requisitioning can be identified per department or Country
75 Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.
Requisition Entry > Tab Line Details
76 Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.
Requisition Entry > Budget Checking
77 Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.
My Requisition
78 Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.
Requisition Work Queue
79 Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.
Requisition Form
80 Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.
Work flow
81 Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.
POE: Purchase Order Entry form
82 Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.
POE: Purchase Order Entry Sample
83 Copyright © 2013. Infor. All Rights Reserved. [Link]
Copyright ©2014 Infor. All rights reserved. This presentation is provided for informational purposes only and does not constitute a commitment in any way. The information, products and services described herein are subject to change at any time without notice.
THANK YOU
Copyright © 2013. Infor. All Rights Reserved. [Link]