Transcript CISTECH GLI Enhancement Module

INFOR XA GLI – THE CISTECH WAY !
Rod Fortson, Sr.
CISTECH
XA Sr. Consultant & Educator
February 5, 2008
Infor Confidential
Copyright © 2001-2007 Infor Global Solutions
Streamlining your XA GLI - Agenda
1. CISTECH GLI Enhancement - Product Introduction
2. The Benefits of using the CISTECH GLI Enhancement
Module
3. New GLI Business Objects - Unposted Transactions
4. New GLI Business Objects – Posted Transactions
5. Streamlining the GLI Process with CISTECH Tools
6. Q&A
2
Copyright © 2001-2007 Infor Global Solutions
1 - CISTECH GLI - Product Introduction
The XA GLI Files and new Cistech
“Posted GLI Detail” for XA R6 or XA
R7 Power Link
3
Copyright © 2001-2007 Infor Global Solutions
1. What the GLI Enhancement Includes
 A new Card File for all the GLI Objects – Unposted and
Posted GLI
 New Objects for the existing Infor XA GLI Files – Views,
subsets, and sorts to insure an easy and proper posting of
all GLI Transactions for COM, Inventory, and PC&C
 New Objects for Posted GLI Detail – Views, subsets and
sorts to review and support Journal detail, or summary
entries during Audit.
 Triggers Programs that update the CISTECH Posted GLI
Detail Files
 Registration of the Triggers in CAS to prevent ever losing
detail when posting your COM, Inventory or PC&C GL
Transactions.
4
Copyright © 2001-2007 Infor Global Solutions
1.The CISTECH GLI Module – Product Overview
CISTECH Trigger Programs
Create
Entries
update
the GL
Posted
GLI Detail
Files when
“Create
GL Entries”. This
IM, you
COM,
or PC&C
insures the EXACT detail is
Process
captured and available to support your
entries Summary or Detail Journals!
TEMGEN
Posted GL
5
Copyright © 2001-2007 Infor Global Solutions
YAA7REP
GL LINES
1. CISTECH GLI Architecture
Inventory
COM
PC&C
Repetitive
Transactions
Detail
INVTXN
Emptied
IM
GLI File
OEITXN
Detail
COM
GLI
Emptied
IM, PCC &
COM Assign
GL Accts to Txns
PCCTXN
Detail
PCC GLI
Emptied
XA IM, COM,
PC&C Create
GL Entries
GL or IFM
Journal
Entries
CISTECH GLI Updates
Cistech IM
Posted GLI
6
Copyright © 2001-2007 Infor Global Solutions
Cistech PCC
Posted GLI
Cistech COM
Posted GLI
Cistech
GLI
2. Benefits of CISTECH GLI Enhancement Module?
How does the
CISTECH GLI
Enhancement Module
assist your Team ?
7
Copyright © 2001-2007 Infor Global Solutions
2. CISTECH GLI Module Benefits
Easy access with new Browser GLI Business Objects for
Unposted and Posted GLI Transactions
The ability to review your Unassigned, Assigned, and any Invalid
GLI Transactions in Browser
Review your GLI Transactions BEFORE they are booked
The ability to review GLI Detail that has been posted to your XA
General Ledger
Capturing the Exact Journal with the Posted GLI Detail
Pre-Packaged Views/Subsets/Sorts for managing your GLI Detail
eliminate ‘data mining’ during Month-end and Audits
Sarbanes and Audit support with Cistech GLI
The CISTECH GLI Module fills the voids for
Finance….
8
Copyright © 2001-2007 Infor Global Solutions
2. Benefits to Your Team – The Bottom Line
The CISTECH GLI Method makes it
easy for Finance to validate period
transactions quickly and effectively.
The tool enables cleanup of GL
transactions prior to booking,
reducing cleanup effort, inaccurate
financial statements, and costly
adjustments.
9
Copyright © 2001-2007 Infor Global Solutions
3. Reviewing Un-Posted GLI with standard XA
What are these Transactions –
and why didn’t some of my RP
Txns get GL Accounts
Assigned?
This is what Infor XA Financial Users deal with without the
Cistech GLI Enhancement Module !!
10
Copyright © 2001-2007 Infor Global Solutions
3. Review Unposted Txns – CISTECH GLI
The Infor
UnPosted XA
GLI Files
The CISTECH
XA Posted GLI
Files
Remember the Inventory GLI Transactions for our
RP’s – the Integrated Unposted GLI Files make it
easy to determine what they are and what needs to
be done to correct any problems !
11
Copyright © 2001-2007 Infor Global Solutions
We
needed
this a
long time
ago !
3. Review Unposted Txns – CISTECH GLI
All Un-Posted Inventory Transactions in one View
Focus on your problems with predefined Subsets
Our 6 Receipts without
Our
8RP
Receipts
with
– remember the Unposted
Transactions?
proper
GL
Accounts
!
their GL Accounts
Assigned!
12
Copyright © 2001-2007 Infor Global Solutions
3. Review Unposted Txns – CISTECH GLI
The CISTECH GLI Module includes most all of the
the “Unassigned for a Selected
Views/Subset and Sorts thatUse
your
Finance Team will
Period” Subset to insure you don’t
need to manage your Un-Posted
Posted Detail
for be
haveand
any transactions
that won’t
both XA AM/GL and XA IFM/GL
!! !
posted
Always check
for earlier
Periods –
remember
mistakes
happen !
13
Copyright © 2001-2007 Infor Global Solutions
Did someone
post Transactions
to a prior period
??
3. Review Unposted Txns – CISTECH GLI
Team Finance may now verify your Companies
Assigned and Un-Assigned Period Transactions
from COM, Inventory and PC&C to make sure
that ALL transactions are posted for a fiscal Period !
14
Copyright © 2001-2007 Infor Global Solutions
3. Review Unposted Txns – CISTECH GLI
When these entries are
posted – they will more
than likely be posted in
Summary. So a single GL
Entry forcan
$50,000
to
Team Finance
quickly
Inventory,
andhave
Un-Invoiced
see that they
6
Receipts will
be recorded
Transactions
for August
that !
don’t have Accounts
Assigned and have NOT
Remember – IMHIST doesn’t contain account
been posted !
numbers and that the GL detail in INVTXN will be
removed when the entry is posted !
HOW DO YOU PROVE
THAT ENTRY ?
15
Copyright © 2001-2007 Infor Global Solutions
3. Review Unposted Txns – CISTECH GLI
Txns with Accounts Assigned
After running the “Assign Accounts”
Process – Team Finance can quickly verify
that ALL Accounts (or Unit/Natures) were
correctly set for Inventory, COM, or PCC
Transactions.
16
Copyright © 2001-2007 Infor Global Solutions
3. Review Unposted Txns – CISTECH GLI
1340 Raw
Materials
50,000.00
220 Un-Invoiced
Receipts
-158,000.00
5700 PPV
108,000.00
6 Detail Transactions will be booked to the same account
numbers (Unit/Natures) as illustrated above !
17
Copyright © 2001-2007 Infor Global Solutions
4. Managing Posted Transactions with XA
18
Copyright © 2001-2007 Infor Global Solutions
4. Managing Posted Transactions with XA
If you
don’t
the Spool
File that
Since
we keep
summarized
entries
supports
Entry,
in IFM
becausethe
weSummary
didn’t want
a debit
there
is a entry
file UAQNCPP
has
and
credit
for every that
RP, you
the see
detail
in AM/GL
there
is not
can
the– impact
to the
IFM/GL
anything.
Wouldn’t
it be
great to
(or
AM) for our
August
Receipts
–
have
the
EXACT
DETAIL
for what
but
what
makes
that up?
you booked in either case?
19
Any impact of this magnitude to the P&L will most
likely be questioned during an audit – remember
that 6 detail entries made up that debit to the P&L !!
Copyright © 2001-2007 Infor Global Solutions
4. Manage Posted Transactions – CISTECH GLI
The Debit to InventoryThe Credit to RNI The Debit to the
Review
Posted
DetailJournal
for a specific
Remember
our $158,000
Entry to
P&L for the
Transaction
Type,oraAM/GL.
Specific GL Variance !!
Either IFM/GL
Account,
or IFM
and Nature
Proving
that entry
nowUnit
becomes
quite easy
during
– YOU
CAN NOW
with
TeamAudits
Finances
new Posted
Detail
SUPPORT
ANY that
SUMMARY
ENTRY
which
can support
entry with
the exact
BOOKED VIA
THENumbers
GL INTERFACES
!!
Account
!
20
Copyright © 2001-2007 Infor Global Solutions
4. Manage Posted Transactions – CISTECH GLI
As your IM, COM, and PC&C GLI Transactions are
Posted, and moved to the CISTECH Posted GLI Objects,
..the EXACT JOURNAL NUMBER is captured for the
Detail, even if you Summarized your Entries !!
21
Copyright © 2001-2007 Infor Global Solutions
4. Manage Posted Transactions – CISTECH GLI
22
Copyright © 2001-2007 Infor Global Solutions
4. Manage Posted Transactions – CISTECH GLI
 Remember the 108,000 Variance Entry to your P&L – capturing the
Posted Detail with Power Link makes proving that entry a breeze!
The CISTECH GLI Package
includes the most common, and
necessary Subsets and Views –
Plug and Play with GLI!
23
Copyright © 2001-2007 Infor Global Solutions
CISTECH
did all the
work for us
!
Cards for GLI Objects – Unposted and Posted
Minimal Maintenance – Unposted Detail
No Maintenance – Posted Detail
24
Copyright © 2001-2007 Infor Global Solutions
5. Review Streamlining the GLI Process!
B
Capturing of XA Transactions for
COM, PC&C, or Inventory to
Standard Infor XA GLI Files – the
Unposted transactions are now
viewable on your CISTECH GLI
Card before booked !
Assign GL Accounts, or IFM
Units/Natures to your COM/PC&C
or Inventory Transactions with
normal GLI “Assign Accounts”
Process.
Verify that all GL Account Numbers
or IFM Units/Natures have been
assigned to your Un-Posted GLI
Transactions using the CISTECH
GLI Un-Posted Objects
“Unassigned/Date” Subset.
B
25
Use new CISTECH GLI Historical
Posted Detail Objects to support
any detail, or Summary Journal
Entries booked to the IFM/GL, or
AM/GL, by the “Create GL Entries”
Process.
Correct any Unassigned
Transactions by correcting any
Rules/Priorities until all Fiscal
Period Transactions have valid
Account Numbers or IFM
Unit/Natures. Use CISTECH GLI
Views and Subsets for each new
Un-Posted CISTECH GLI objects.
Pre-existing Subsets exist to allow
you to locate the exact impact to
any GL Account, for any Period.
Additional benefits are described
further in the Section “Posted GLI
Detail” Subsets of the Manual.
Execute the Standard “Create GL
Entries” for COM, IM, and PC&C.
This will post your Journals and
update new CISTECH Posted GLI
Objects with exact detail
including the GL Accounts, or
IFM Units/Natures.
GLINTFCE/
INVTXNHIS
GLINTFCE/
OEITXNHIS
GLINTFCE/
PCCTXNHIS
Your New CISTECH GLI History Objects
Copyright © 2001-2007 Infor Global Solutions
CISTECH
GLI
The CISTECH GLI Method – Ask our Users !!
 Following are some companies who have implemented the
CISTECH GLI methodology:
AG Instore – Forest City, NC
Miltope – Montgomery AL
M-Tek – Ohio, TN, MS, and AL Plants
Nissan Tier 1 Provider
EEC – Enterprise AL
CEC – Dallas TX
Gestamp
Mercedes Tier 1 Provider
26
Copyright © 2001-2007 Infor Global Solutions
CISTECH GLI Implementation
 License Fee: $4,500 AM
$7,500 IFM

optional annual support fee of 20% includes updates
 Includes Technical and User Documentation
 Installation Assistance - $500-$1,000
 Education and Implementation Assistance, 1-2 days,
$1,500 - $3,000
 On-site or remote
 Product implementation plus process improvement
 Prerequisites: XA R6 or R7, Integrator
27
Copyright © 2001-2007 Infor Global Solutions
Team Questions
QUESTIONS ??
28
Copyright © 2001-2007 Infor Global Solutions
From all of us at CISTECH – Thanks !
Hundreds of Years of XA Experience working for
your Teams – Your XA Expert !
29
Copyright © 2001-2007 Infor Global Solutions