Transcript Document

Copyright © 2012. Infor. All Rights Reserved. www.infor.com
1
Infor LN Finance Overview
and Concepts
Dan Aldridge, Senior Consultant, Infor
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
2
Course Methodology
Lecture and
Discussion
40%
Business
Concepts
Application
of Concepts
Hands-on
Practice
50%
Demonstrations
Practical Exercises
Measure
Results
10%
3
Review Questions
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
3
Student Guide Icons
Guided Task
Complete the steps with your instructor. Ask for
assistance or ask any questions while completing the task.
Instructor Demonstration
Watch your instructor complete the steps, listening to the
explanation. Generally, only one person can complete the
activity.
Independent Task
Does not provide detailed step-by-step instructions to follow.
Complete the steps independently. Ask your instructor to
assist you with any questions or problems.
4
Refer to the Student Guide
With your instructor, review the detailed information
in the Student Guide.
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
4
Course Objectives
Upon completion of this course, you will have a general
understanding of the processes and functionality of Infor LN
Financials, and can recognize the concept of the financial
integrations with Operations Management packages.
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
5
Agenda
•
•
•
•
•
•
•
•
•
•
Lesson 0
Lesson 1
Lesson 2
Lesson 3
Lesson 4
Lesson 5
Lesson 6
Lesson 7
Lesson 8
Lesson 9
Getting Started
Common Financials Data
General Ledger
Accounts Payable
Central Invoicing & Accounts Receivable
Cash Management
Fixed Assets Management
Controlling
Financial Statements
Financial Integrations
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
6
Lesson 1–0
Common Financials Data
7
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
7
Building a Company in LN
8
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
8
Enterprise Structure Model
Departments
Warehouses
Bus. Partners
Projects
9
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
9
Multi-Company
• Several separate production companies are controlled in separate
financial companies
Factory A
Finance 1
Finance 2
Factory C
Factory B
10
Finance 3
Group
Company
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
10
Defining organization - Enterprise Units
Finance Company 100
Finance Company 200
EU 1
Plant 1
11
EU 2
Logistic company 100
Plant 2
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
11
Enterprise Units
200
Financial
company
Enterprise
Unit
(Location 1)
WH
SO
PO
Logistical
100 company
12
300
Financial
company
Enterprise
Unit 2
(Location 2)
WH
= Warehouse
PP
= Production plant
PO
= Purchase office
SO
= Sales office
SO
PP WH
PP
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
12
Currency Systems
Single
External
Dependent
CAD
13
Independent
CAD
Reference
Local/
Reporting
* New in FP5: Standard
CAD
EUR
USD
USD
EUR
BRL
USD
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
13
Structure Common Data
Tables:
Calendars
Item Base Data
Sub-entities
Logistic / Financial/ Taxes
EMM
General Data
Company
Addresses
14
Common
Data
Employee
B.P.
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
14
Business Partner
• All supplier and/or all customer roles must be defined for a business partner
Buy
From
Supplier
Roles
Ship
From
Ship
To
Business
Partner
Invoice
Invoice
From
From
Pay
Pay
To
To
15
Sold
To
Invoice
Invoice
To
To
Customer
Roles
Pay
Pay
By
By
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
15
Business Partner
Characteristics
Number
Group #’s
Contacts
Business Partner
Banks
16
Addresses
Currency
Financial Business
Partner Group
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
16
Financial Business Partner Group
for Customers
for Suppliers
Purpose
 To group similar customers or supplier
 To assign ledger accounts and dimension codes for semi
automatic entries; based on pre-defined events generating
transactions for those groupings
 Multiple control accounts per business partner
 Note. Every business partner must be linked to a FBPG via the
17 business partner roles
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
17
Tax Codes
Ledger Accounts
Country
Netherlands
Purchase Tax
Tax Codes
High VAT
Low VAT
Sales Tax
19 %
Infor LN Financials
6%
Canada
Shifted Tax
Sales LA
Purchase Tax
Sales Tax
HST
5%
GST
2%
Shifted Tax
Sales LA
PST
18
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
18
Modeling Tax Scenarios Exceptions
Tax Defaulting Library
Applications
Destination Sales Tax
Tax Exception Library
Standard Tax Library
 Customer can define tax scenario for specific situation
 Applications call tax dll. There, first checked if for that situation a
tax scenario is modeled. If yes, data from there is taken, otherwise,
the standard ERP tax function is used
19
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
19
Independent Task: Common Financials Data
•
•
•
•
•
•
20
Check the enterprise model
Create a new currency rate
Add a terms of payment
Business partner group
Add a customer
Insert a new tax percentage
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
20
Infor LN Financials
Operations Management
Packages:
•Order Management
•Warehouse Mgt.
•Manufacturing
•Service
•Project
•Freight
• People
Financial Statements
Controlling
CPR
Budgeting
Cost Accounting
General Ledger
BP
Accounts Payable
DIM 1
DIM 2
DIM 3
DIM 4
DIM 5
Accounts Receivable
Cash Management
Fixed Assets Mgt
21
•Central Invoicing
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
21
Lesson 2–0
General Ledger
Financial Concepts & Overview
Infor LN
22
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
22
Infor LN Financials
Operations Management
Packages:
•Order Management
•Warehouse Mgt.
•Manufacturing
•Service
•Project
•Freight
• People
Accounts Payable
Financial Statements
Controlling
Budgeting
Cost Accounting
General Ledger
DIM 1
DIM 2
DIM 3
DIM 4
DIM 5
Accounts Receivable
Cash Management
Fixed Assets Mgt
23
•Central Invoicing
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
23
Multiple Business Unit Financials
Financial Group
Enterprise x
Enterprise 2
Enterprise 1
Sales
Region
24
Production
Bus
Unit
Project
General Ledger
level
…
Product
Line
…
Dimensions
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
24
Chart of Accounts
Example
P
Production Costs
P1
P2
Machine Costs
Depreciation
Costs
25
C1
Maintenance
Costs
Wage Costs
C2
Direct Wage
Costs
C3
Indirect Wage
Costs
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
C4
25
Chart of Accounts
• Chart of Account Types:
•
•
•
•
Sales
New
Existing
Repair
Other
26
•
•
•
•
•
•
•
•
•
•
Balance Sheet
Income Statement
Inter-company
Text
12 Alpha/numeric characters
Parent/Child Relationships
99 levels of subtotals
Integration account
Quantities
Currency base
Matching
Blocking
Statutory versus Complementary
Daily and BP balances
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
26
Parent – Child Relations
Ledger
Accounts
C1
C1
C2
C2
Dimensions
P1
C3
DIM 1
C3
P1
DIM 2
P
P2
C4
DIM 3
DIM 4
C5
P3
C = Child
P = Parent
27
C4
P2
P
C5
DIM 5
C6
C6
C7
C7
P3
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
27
Enter Transactions
Transaction Entry Date
Batch number
Date
10/01/2006
Fiscal year
Fiscal Period
Reporting Period
Tax Period
2006
04
01
02
416
Transaction Type
GLD
API
CBD
28
Journal Voucher
Invoices (pur / sls)
Credit notes (pur / sls)
Opening balance
Cash
Purchase / Sales Corrections
Journals (Detailed)
Purchase Invoices (order)
Bank Transactions (Detailed)
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
28
Transaction Processing Summary
• Maintain Transaction (New: Transaction Entry)
• Enter Batch Header*
• Enter Transaction Type*
• Enter Line Details
• Print Non-Finalized (optional)
• Finalize Transaction
• Finalization Administrator
Same for G/L,
ACP, ACR & CMG
*All transactions are created with a Transaction Type and processed in a Batch
29
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
29
Financial Document Numbers
Transaction
Type
API
GLD
Series
Code
20040001
10
Last-Used
Number
000001
• Transaction Type = user-defined; 3 alphanumeric characters
• Series Code = categorizes all transactions of a given type; up to 4 alphanumeric characters
• Last-Used Number = system generated sequential #; balance of characters where sum of
series # + first free # is 8 characters
30
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
30
Transaction Processing
Finalization Run #
UPDATE
Batch 1
-------Batch 2
--------Batch 3
--------Batch 4
--------Batch 5
31
STATUS
STATUS
‘Non-finalised’
Inquiries &
Reports
‘Finalised’
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
31
Drill Down
P
Production costs
P1
P1
Labour costs
Machine costs
Depreciation
costs
C1
Service costs
C2
Direct Labour
costs
C3
Indirect Labour
costs
C4
C10
Production Department
Tables
32
C11
Assembly Department
C12
C13
Chairs
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
32
Transaction Schedules
To distribute costs to ledger accounts, based on either
amounts or percentages, from a predefined schedule.
 Enter transaction schedule
15%
35%
25%
20%
33
 decide if amount or percentages
 currency
 Enter transaction schedule details
5%
 actual amounts or percentages by ledger
accounts & dimensions
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
33
Automatic Transactions
To generate automatic transactions for additional costs based
on a combination of transaction type, ledger account and
sequence number.
• Example: when salary expenses are recorded on
Transaction Type xx, automatically generate an entry for
18% benefit expenses to predefined accounts
34
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
34
Reverse Entries
35
Non-Finalized
Transactions
Finalized
Transactions
Journal
zzzzz D
zzzzz Cr
zzzzz D
Journal
zzzzz -D
Journal
Journal
zzzzz
-Cr
zzzzz
D
Journal
zzzzz D
zzzzz
zzzzz
D-D
zzzzz
Cr
zzzzz Cr
zzzzzD Cr
zzzzz
zzzzz D
zzzzz D
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
35
Recurring Transactions
To process entries that are prepared and/or reversed
automatically over multiple periods. Can be changed!
• Journals, Sales, Purchase
• Recurring Instructions
• Generate recurring entries
36 Today
Period 1
Period 2
Period N
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
36
GL Account Matching
• Match debit and credit postings on the same ledger account with each other
Debit
Credit
Employee advances
Employee advances
$500
$500
 Useful for intermediate accounts
 Suspense accounts
 Personnel advances
37
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
37
GL Account Matching
Statement of Expenses
Cash-Receipt Note
Date: 5-1-2001
Amount: $30 Diner
Amount: $20 Cash ENTER
Employee: Johnson
Date: 1-1-2001
Amount: $50 Cash
Employee: Johnson
(D) Advance Payments Employees
(CR) Cash
50
50
(D) Cash
(D) Diner Expense
(CR) Advance Payments Employees
20
30
50
GL Account Matching
(D) Advance Payments Employees $50
(CR) Advance Payments Employees $50
38
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
38
Periods
To aggregate transactions over time in fiscal, reporting or tax
periods within Infor LN Financials
 Period Status
 Close Periods
Closed
Open
39
Finally Closed
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
39
Independent Task: General Ledger
•
•
•
•
•
•
•
•
40
Create a ledger account
Create dimensions
Check transaction types
Add a journal voucher
Finalize transactions
Analyze ledger history
Close a period
Case: General Ledger
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
40
Lesson 3–0
Accounts Payable
Financial Concepts & Overview
Infor LN
41
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
41
Infor LN Financials
Relations Accounts Payable
Operations Management
Packages:
•Order Management
•Warehouse Mgt.
•Manufacturing
•Service
•Project
•Freight
• People
Financial Statements
Controlling
Budgeting
Cost Accounting
General Ledger
Accounts Payable
DIM 1
DIM 2
DIM 3
DIM 4
DIM 5
Accounts Receivable
Cash Management
Fixed Assets Mgt
42
•Central Invoicing
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
42
ACP Processes
 Receive and Authorize Invoices
 Fast and friendly invoice entry based on order or
packing slip data
 Matching and Approving
 Matching based on order or packing slip data
 Automatic matching
 Invoice approval by batch
 Pay from receipts (Self-Billing)
 Payment Schedules
 Problem Invoices and Business Partners
43
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
43
Purchase Invoices
Optional
function
Maintain received
purchase invoices
Purchase
Invoice
Approve received
purchase invoices
Copy
Automatic depends on
parameters ACP:
•Automatic matching
•Tolerances
Matching with an
purchase order
Open entries
Register invoices
Link with a
Ledger Account
Approve purchase
invoices
Finalise transaction
44
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
44
Self Billed Invoice
Purchase
Order
No. 123
Invoice Date: 12-01-2004
Chairs
Tables
USD 50000
USD 10000
Total
USD 60000
Register Invoice
Automatic Match
Approved for Payment
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
45
Hold Reasons (Blocking Codes)
Hold reasons can be linked to purchase invoices explaining why
the company does not want to pay the supplier’s invoice.
Hold Reason:
‘Goods damaged’
Assigned Approver:
Purchase manager
Purchase
invoice
 Blocked for automatic payments
46
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
46
Procurement Card Payments
Manually
Electronically
Manually
Electronically
Purchase Requisition
Holiday Inn hotel
Lufthansa
EUR 850
EUR 1,400
•Manually
•Automatically
Holiday Inn hotel
Lufthansa
EUR 850
EUR 1,400
EUR 2,250
Match
Open entry AP
Visa company
47
2,250
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
47
Supplier Statement of Account
Invoice
Invoice-From
Statement Account
Supplier Statement Account
Dear supplier,
Our finance department does have the following invoices outstanding.
Please check with your administration if this is correct.
Invoice
P01-001
P01-087
P01-180
Date
12-01-01
18-01-01
27-02-01
Best Regards,
Standard.COM company.
48
Amount
EUR 100
EUR 125
EUR 85
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
48
Independent Task: Accounts Payable
•
•
•
•
•
49
Register a cost invoice
Automatic purchase matching
Check received orders
Match a purchase order and invoice
View the Accounts Payable Management
Dashboard
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
49
Lesson 4–0
Central Invoicing & Accounts Receivable
Financial Concepts & Overview
Infor LN
50
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
50
Infor LN Financials
Relations Accounts Receivable
Operations Management
Packages:
•Order Management
•Warehouse Mgt.
•Manufacturing
•Service
•Project
•Freight
• People
Accounts Payable
Financial Statements
Controlling
Budgeting
Cost Accounting
General Ledger
DIM 1
DIM 2
DIM 3
DIM 4
DIM 5
Accounts Receivable
Cash Management
Fixed Assets Mgt
51
•Central Invoicing
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
51
Accounts Receivable Control
Central Invoicing
Accounts Receivable
Without an invoice
Manual
Sales
Service
Project
Interest
Freight
Finalisation in
General ledger
Open entries
Aging Analysis
52
Reminders
Customer
statements
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
52
Central Invoicing
Procedure
Lines to be invoiced
Sales
Order
Service
Order
Project
Manual
Billing Request Template
Interest
Freight
Billing Request Additions
Billing Request
Select invoice lines
Invoice
53
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
53
Central Invoicing
Example
Billing Request Template 01
Sales
SI Orders
ARI-20040010 Yes
To customer
Manual
Sales AA
Invoices
No
Service Orders
No
10 Laptops 10.000 euro
More
than
one Sales Order Yes
Order
SNS-140000
More than one BP
Yes
Sales
Sales
Sales
Order
Order
Order
v
Manual
Invoice
v
Sales
Service
Order
Order
v
Confirmation of Order Data
Sales Order
Yes Manual
Sales
Yes Service Order Yes
Billing Request Template 02
Sales Orders
Yes
Manual
Sales
Invoices
No
SI
ARI-20040011
To customer
BB
Service
Orders
Yes
More
than one
Sales
Order Yes
10 Laptops
10.000
euro
Order
SNS-140000
More
than
one Service Ord.
5 PCs
4500 euro Order
Yes More than one BP
SNS-140036
Yes
54
Billing Request
Use template
BP
Sales Order
Compose
01
Sold-to
….. To zzzzz
….. To zzzzz
Sales
Orders
BP AA
Sales
Sales
Order
Orders
BP BB
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
54
Sales Invoice Characteristics
The following information defined in the Invoice-To business partner setup is of key
importance to the way the Accounts Receivable module behaves and works:
Language - Documents can be sent in the language of the customer.
Group - Financial Business Partner Group of the Invoice-To business partner determines
which ledger accounts are used for transactions.
Credit Limit - A preset maximum limit for the total value of outstanding amounts for the
customer is established in the Invoice-To business partner setup.
Terms of Payment - The length of time the customer is allowed before payment becomes
overdue is established in the business partner setup.
55
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
55
Aging Analysis Codes
Aging analysis codes allow for the generation of reports and
statements that summarize customers accounts based on
the number of days or month that the invoices are overdue.
30 days
56
No action required yet.
60 days
Send a reminder letter.
90 days
Instruct the legal representatives to intervene.
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
56
Statement of Account
Customers
Invoice
To
Statement Account
Customer Statement Account
Dear customer,
Our finance department does have the following invoices outstanding.
Please check with your administration if this is correct.
Invoice
S01-001
S01-087
S01-180
Date
12-01-01
18-01-01
27-02-01
Best Regards,
Standard.COM company.
57
Amount
EUR 100
EUR 125
EUR 85
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
57
Reminders
Options:
Business
Partner
Invoices
Text number of
the last reminder
(A)
(B)
(C)
(D)
1000
S05 99000008
1
2
1
3
2
1000
S05 99000012
2
3
1
3
2
1000
S05 99000027
1
2
1
3
2
A) - “Standard” Reminder Letter Processing

B) - “Same Letter for All Statements
 1
C) - “Group all Letters Under Highest
58

D) - “Restrict Highest Letter No.”
 2
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
58
Factoring
A form of accounts receivable financing that consists of the
sale of a company’s accounts receivable to a third party
(factor), in order to obtain funding.
1. Order
Standard.COM
company
8. Balance
payment
5. Pay advance
4. Send invoice copy
2. Agree customer limit
59
3. Deliver goods and invoice
with notice to pay to factor
Factoring company
Customer
6. Follow up
7. Payment
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
59
Independent Task: Central Invoicing &
Accounts Receivable
• Create billing request template
• Create a manual sales invoice (direct processing
and no direct processing )
• Create an aging analysis code
• Check the customer invoice aging analysis
• Create a customer statement layout
• Print a customer statement
60
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
60
Lesson 5–0
Cash Management
Financial Concepts & Overview
Infor LN
61
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
61
Infor LN Financials
Relations Cash Management
Operations Management
Packages:
•Order Management
•Warehouse Mgt.
•Manufacturing
•Service
•Project
•Freight
• People
Accounts Payable
Financial Statements
Controlling
Budgeting
Cost Accounting
General Ledger
DIM 1
DIM 2
DIM 3
DIM 4
DIM 5
Accounts Receivable
Cash Management
Fixed Assets Mgt
62
•Central Invoicing
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
62
Payment Methods
Type of Payment/Receipts
Payment steps
Payment postings
Supplier payments
Customer receipts
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
63
Supplier Payment Process
Select invoices for
payment
Payment advice
Documents
Trade Note
process
Automatic payment
process
Documents
File
Change Trade Note
step
Electronic
bank statement
Automatic
matching
64
Open entries
Manual
bank statement
Reconcile
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
64
Automatic Payments
Select invoices for
payment
Documents
File
Maintain payment
advise
Assign Banks
Process payments
Electronic
Audit Paymentsbank statement
Create Payment Orders
Remittance Letter
Automatic
Open entries
65
Post Payments matching
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
65
Cash Forecast
Sales Invoices
Supplier Invoices
Purchase Orders
Project Orders
Sales Orders
Sales Quotes
66
Cash
Forecast
Budgets
Standing Orders
• Update business partner status
• Modify cash dates
• Update cash forecast
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
66
Independent Task: Cash Management
•
•
•
•
67
Add payment authorization
Create an automatic payment
Customer receipts
Reconcile a payment
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
67
Lesson 6–0
Fixed Assets Management
Financial Concepts & Overview
Infor LN
68
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
68
Asset Management
 Investment
 Depreciation
Fixed Assets
Investment 125,000
Adjustments 10,000
Revaluation 15,000
69
Depreciation 50,000
Disposal
100.000
 Disposal
 Adjustment
 Revaluation
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
69
Asset Structure
Group
Category
Category
Asset
70
Asset
Asset
Asset
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
70
Independent Task: Asset Management
•
•
•
•
71
Create an asset
Capitalize an asset
Depreciate an asset
Dispose an asset
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
71
Lesson 7–0
Controlling
Financial Concepts & Overview
Infor LN
72
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
72
Controlling
Controlling is the coordination tasks of budgeting, auditing,
and providing information to improve business procedures
in organizations.
Production department
Warehouse department
Account
Budget
Rate
Actual
Facility department
FAC
QM
FIN
1 mio 300.000
100.000
1.1 mio
Account
Buildings Depr.Budget
Machines
Actual
Cost
500.000
25.000
350.000
SLS
Inventory
Salary
costs
Salary
PUR
1 mio 300.000
1.1 mio
Account
Buildings
Budget
Actual
Allocation
17.000
100.000
50.000
600.000
costs
Energy
500.000
Inventory
Salary
mio
50.000
1.1350.000
mio 45.000
Buildings
Deprec.
Allocated
costs 1 35.000
2.5 mio
………
20.000 45.000
costs
Sales costs 40.000
17.000
50.000
600.000
costs
Energy
11.000
60.000
10.000
costs
Salary
costs
PLA
PROD
2.4
mio
………
Revenues
………
TOTAL
COSTS
260.000
2.5 mio
………
20.000 45.000
costs costs
Sales costs 70.000
………
72.000
Energy
WRH
2.4
mio
………
26
Machine
hours
10.000
Revenues
………
………
Inerest costs
………
Allocated costs
73
Operations:
• Painting (3h)
• Assembling (2h)
Case
MEM
Disk
171.000Copyright © 2012. Infor. All Rights Reserved. www.infor.com
73
Infor LN Financials
Relations Controlling
Operations Management
Packages:
•Order Management
•Warehouse Mgt.
•Manufacturing
•Service
CPR
•Project
•Freight
• People
Financial Statements
Controlling
Budgeting
Cost Accounting
General Ledger
BP
Accounts Payable
DIM 1
DIM 2
DIM 3
DIM 4
DIM 5
Accounts Receivable
Cash Management
Fixed Assets Mgt
74
•Central Invoicing
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
74
Concept - Planning Cycle
Sales
Plan
Manufacturing
Plan
Resource
Plan
Production
Plan
Cost allocation
Evaluation
actual data
Financial
budget
Cost price
75
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
75
Static Budget
• Defined in a horizontal way:
Dimension Types
Examples:
(1)
Dimension
A.
Ledger Account
B.
Ledger Account
C.
Ledger Account
Dimension
D.
Ledger Account
Dimension
E.
76
Dimension
(2)
Dimension
(3)
Dimension
(4)
Dimension
(5)
Dimension
Dimension
Dimension
Dimension
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
76
Flexible Budget
• Defined in a vertical way:
Dimension
Ledger Account
77
Reference Unit
Reference Unit
(cost driver)
(cost driver)
Ledger Account
Ledger Account
Ledger Account
Ledger Account
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
77
Flexible Budget
10,000 machine hours
Production
office
Facility
cost center
Wages
€ 200,000
Temporary labor
€ 110,000
Allocate From (debit)
2,000 man hours
Interest
€ 10,000
Service
office
Allocate To (credit)
€ 320,000
Allocate From (debit)
Rate:
€ 24 per hour
€ 240.000
Rate:
€ 40 per hour
€ 80.000
€0
Dimension
Primary ledger account
Secondary ledger account
78
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
78
Independent Task: Controlling
• Create a static budget
• Enter a cost budget
79
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
79
Lesson 8–0
Financial Statements
Financial Concepts & Overview
Infor LN
80
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
80
Infor LN Financials
Relations Financial Statements
Operations Management
Packages:
•Order Management
•Warehouse Mgt.
•Manufacturing
•Service
•Project
•Freight
• People
CPM /
Reportwriter
Accounts Payable
Financial Statements
Controlling
Budgeting
Cost Accounting
General Ledger
DIM 1
DIM 2
DIM 3
DIM 4
DIM 5
Accounts Receivable
Cash Management
Fixed Assets Mgt
81
•Central Invoicing
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
81
Financial Statements
Ledger Account
Financial Statement
Account
Offices
Acc. Depreciation Offices
Automobiles
Acc. Depr. Automobiles
Fixed Assets
Bank Loan
Accounts Payable
Liabilities
Total Assets
82
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
82
Financial Statements Architecture
Financial
Statement
definition
Infor LN LN
Financials
GLD and FBS
information
ODBC
Export sessions
FST
FST
Interim
FST
Interim
Tables
reporting
Tables
tables
Infor LN
Infor CPM
83
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
83
Lesson 9–0
Financial Integrations
Financial Concepts & Overview
Infor LN
84
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
84
Financial Integrations. Why?
invoice
supplier
10
pcs
5
pcs
8
pcs
adjustments
adjustments
1
pcs
invoice
customer
85
Financial integration / Reconciliation
Physical world of
goods movements
Financial world of
periods, ledgers and
debit/credit balances
SFC Production
INTERIM TRANSIT
Issue
Subcontracting
SFC WIP
INTERIM VARIANCE
Purchase Price Variance
Operation Costs
Operation Costs
WIP Transfer Issue
WIP Transfer Issue Invoiced
INTERIM SFC WIP
Cost of Goods Sold
Cost of Goods Sold
WIP Transfer Receipt
INVOICE ACCRUAL
SFC WIP
Turnover
Completion
SFC WIP
Revenue Analysis
INTERIM TURNOVER
WIP Transfer Receipt Invoiced
Surcharge Cover
Item Surcharge Receipt
INTERIM VARIANCE
INTERIM TRANSIT
Add. Calculation Office Variance
Efficiency Variance
Price Variance
Receipt
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
85
Concept Financial Integrations
Operations
Management
Reconciliation data
drill down
drill down
Financials
logging
posting data
drill down
logging
drill down
86
posting
Financial
integrations
drill down
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
86
Integration Mapping Scheme
•
Example, goods receipt
IDT = 10061074 – Warehouse Receipt/Receipt
D) 70100 – Inventory Amsterdam € 10,000
€ 5,000
D) 70200 – Inventory Berlin
€ 15,000
C) 28001 – Interim Transit
87
Detailed mapping
Default mapping
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
87
Integration Elements
 Example, warehouse receipt
Business Object = Inventory Transaction
• Item
• Enterprise Unit
• Item Group
• Calculation Office
• Product Line
• Department Type
• Product Class
• Manufacturer
• Project
88
• Business Partner
• Country
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
88
Financial Integration Process
Operations Management
Order Mgt.
Warehouse
Mgt.
Manufacturing
Project
Service
Freight
Mgt.
People
Central
Invoicing
Integration tables
Integration logging
Reconciliation logging
Integration mapping
Integration posting
General Ledger
Non-finalized transaction
Finalized transaction
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
89
Reconciliation
Example invoice accrual 3
Operations
Management
Financials
Goods Received, Not
Invoiced
Purchase Order
500
500 Euro
500
Reconcile
90
Purchase Invoice
500 Euro
Accept (reconcile) the accrual
transaction !
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
90
Reconciliation Groups
The following reconciliation groups are created by Infor LN:
 Inventory
 Consignment inventory
 Invoice Accrual
 Consignment accrual
 Project provisional revenues
91
 WIP









Production order
Project (PCS)
Assembly order
Assembly line
Service order
Service call
Maintenance sales order
Maintenance work order
Project (TP)
 Interim






Costs
Revenues
Turnover
Contract
Variance
Transit
 End account
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
91
Independent Task: Financial Integrations
•
•
•
•
•
•
•
92
Find active mapping scheme
Find an integration mapping
Map and post integration transactions
Drill down from Ledger History
Find reconciliation elements
Analyze the inventory
Accept reconciliation data
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
92
For more information go to:
http://inforln.com
www.performaapps.com
Contact: Dan Aldridge, CEO Performa Apps – Infor Services Partner
703.251.4504 or [email protected]
Copyright © 2012. Infor. All Rights Reserved. www.infor.com
93