Template Version 1.1 Updated: 10/16/2008
Validation Session
Finance Team
Accounts Payable December 8-9, 2008
Validation Session Validation Session
Finance Team Finance Team
Accounts Payable Accounts Payable December 8 December 8-
- 9, 2008
9, 2008
LaGov LaGov Template Version 1.1 Updated: 10/16/2008 Project - - PowerPoint PPT Presentation
Validation Session Validation Session Validation Session Finance Team Finance Team Finance Team Accounts Payable Accounts Payable Accounts Payable December 8- -9, 2008 9, 2008 December 8 December 8-9, 2008 LaGov LaGov Template
Template Version 1.1 Updated: 10/16/2008
Validation Session
Finance Team
Accounts Payable December 8-9, 2008
Validation Session Validation Session
Finance Team Finance Team
Accounts Payable Accounts Payable December 8 December 8-
9, 2008
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
2
Project Phases Project Phases
Five Key Phases
Project Preparation Business Blueprint Realization Go Live and Support Final Preparation
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
3
Rationale for the Project
Consolidation of Administrative Processing and Reporting Address DOTD Systems Risk Improve IT Maintenance and Flexibility Enable New Initiatives Improve Data Warehouse/Business Intelligence 1 1 2 2 3 3 4 4 5 5 The business drivers for the Louisiana ERP Project are summarized in the five key areas listed below
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
4
Validation Session Agenda Validation Session Agenda
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
5
Purpose of Validation Sessions Purpose of Validation Sessions
workshop participants regarding the TO-BE process design:
differing
points
the TO-BE process design Note: Validation sessions are an affirmation of work session decisions, and assume the SAP functionality knowledge covered in TO-BE session. Note: Validation sessions are an affirmation of work session decisions, and assume the SAP functionality knowledge covered in TO-BE session.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
6
Workshop Session Recap Workshop Session Recap
Business Process Work Session Date Goals Work Session Code
Master Data Maintenance 08/18/08 09/30/08-10/02/08 Account Code Structure – Vendors FI-AP-001 LOG-MM-006 Vendor Invoice through Payment 09/17/08 – 09/18/08 09/23/08 Accounts Payable Processing Vendor invoice data entry through payment FI-AP-002 Vendor Check Management 09/30/08 – 10/01/08 Vendor Check Management FI-AP-003 1099 Reporting 10/22/08 1099 Processing FI-AP-004 Non Payable Vendor Invoice Management 10/21/08 Non – Payable Invoicing FI-AP-005 Procurement Card Expense Allocation 10/30/08 12/04/08 Purchasing Card Processing FI-AP-006 LOG-MM-025
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
7
Purpose of Today Purpose of Today’ ’s Validation Session s Validation Session
systems that will be replaced with SAP Purchasing and Accounts Payable
data maintenance including creating, updating, blocking/unblocking and marking vendor master records for deletion from SAP AP
design including: business partner strategy, field use and account numbering schema
for vendor invoice data entry and approvals supporting PO related and Non PO related invoices
for vendor payments
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
8
Purpose of Today Purpose of Today’ ’s Validation Session (continued) s Validation Session (continued)
design for Imprest Account replenishment
design for vendor check management
design for 1099 & 1098 reporting
design for Non payable invoicing through vendor clearing
design for procurement card expense allocation
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
9
SAP Accounts Payable SAP Accounts Payable
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
10
Accounts Payable Process Overview Accounts Payable Process Overview
Invoicing and Payments
Accounts Payable
Check Management 1099 - Invoicing and Reporting Purchasing Card Management
Financial Accounting
Non- payable Invoices Vendor Master Data
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
11
SAP Accounts Payable SAP Accounts Payable –
– Design Considerations
Design Considerations
SAP – AP functionality?
systems that will not be replaced by SAP – AP but could interface into SAP – AP?
systems that will not be replaced by SAP nor interface into SAP – AP?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
12
SAP Accounts Payable SAP Accounts Payable – – Key Decisions Key Decisions
Replaced by
Legacy AP
– PCRD (Procurement Card) – ADDS (Accounts Payable) – FMSP (Financial Management Systems) – PMFS (Project Management Financial System) – CFMS (Contract Financials Management System) – AFS (Advantage Financial System) – TMS (Travel Management System) – IMS (System used to pay refunds to One-time Payees)
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
13
SAP Accounts Payable SAP Accounts Payable – – Key Decisions Key Decisions
Interfaced with
– None
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
14
SAP Accounts Payable SAP Accounts Payable – – Key Decisions Key Decisions
– ESTI (DOTD) – LASES (Support Enforcement) – LAMI (TANF, Food Stamps, FITAP) – BRIS (Blind Rehab) – TIPS (Child Welfare) – DDS (Disability Determination System) – CAPS (Child Care) – JAS – STEP – IMS
Update FI-GL
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
15
SAP Accounts Payable SAP Accounts Payable –
–Changes & Challenges Changes & Challenges
different legacy systems
conversions and interface testing
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
16
SAP Accounts Payable SAP Accounts Payable –
– Open Issues Open Issues
an unknown future date?
SAP FI-GL for expense information?
systems at DSS effect their cash balance or ‘cash edit’ check for payments that come from SAP?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
17
SAP Accounts Payable SAP Accounts Payable – – Benefits & Improvements
Benefits & Improvements
maintenance and values
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
18
SAP Accounts Payable SAP Accounts Payable
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
19
Vendor Master Data Maintenance Process
Design Considerations Design Considerations
centralized or decentralized?
creating or modifying records?
and marking vendor records for deletion?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
20
Vendor Master Data Maintenance Process
Key Decisions Key Decisions
to route end-user requests to create, modify, block/unblock master records as well as mark master records for deletion.
be routed to the central management group.
for review, approval and update of SAP system.
be performed by using the match-code functionality. The match-code tool enables you to narrow down your search of records and display a list of possible entries for the field.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
21
Vendor Master Data Maintenance Process
Key Decisions Key Decisions
teams will be utilized to route such request.
and related master data reports for protection of security-sensitive information.
(create, change, block/unblock, mark for deletion) access to all records.
for vendor data maintenance processing
review/approval process (within an agency and cross agency) for blocking, unblocking and marking records for deletion
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
22
Vendor Master Data Maintenance Process
Key Decisions Key Decisions
performed only when there is confirmation of an address change or an addition and/or changes to pertinent contact information. Note: There are fields that typically are not changed which include but is not limited to payment terms and reconciliation account.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
23
Vendor Master Data Vendor Master Data – – Create Create
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
24
Vendor Master Data Vendor Master Data – – Change Change
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
25
Vendor Master Data Vendor Master Data – – Block Block
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
26
Vendor Master Data Vendor Master Data – – Unblock Unblock
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
27
Vendor Master Data Vendor Master Data – – Mark for Deletion Mark for Deletion
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
28
Vendor Master Data Maintenance Process
Changes & Challenges Changes & Challenges
DOTD master data processing.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
29
Vendor Master Data Maintenance Process
Open Issues Open Issues
additional duties warranted by the addition of DOTD?
and responsibilities have on OSRAP?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
30
Vendor Master Data Maintenance Process
Benefits & Improvements Benefits & Improvements
quality control.
need while maintaining data integrity of the system.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
31
SAP Accounts payable SAP Accounts payable
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
32
SAP Vendor Master SAP Vendor Master Data Views Data Views
necessary to conduct business with a vendor. For example, address information, payment terms, acceptable payment methods, etc
business functions or data views
– General view Data that supports all transactions – Purchasing view Data that supports Purchasing related transactions – Company Code view Data that supports Accounting related transactions – Grantor view Data that supports Grants related transactions
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
33
SAP Vendor Master SAP Vendor Master Data Views Data Views
Data View Used By
General Data: Name, Address Phone, Fax, Tax ID
Default address used if no specific business partner is defined in transaction
Purchasing Data: BP’s Address Inco Terms, Payment Terms
Purchasing related transactions
Accounting Data: Address, Banking info, Payment methods, Reconciliation Account, 1099 info
Accounting related transactions
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
34
Types of Vendors in SAP : Types of Vendors in SAP : Business Partners Business Partners
play in the Procurement Process.
Vendor
Goods Supplier Ordering Recipient Invoice Presented By Payee
different roles in the transaction. These partner roles are defined in the vendor master data.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
35
Vendor Master Record Integration Vendor Master Record Integration – – GL GL
summarized vendor liability in the balance sheet
updated in parallel by the posting of an AP document (invoice, credit memo, payment) – Line item details are kept in the subsidiary ledger – Summary information is kept in the reconciliation account
Enter vendor invoice Enter vendor invoice
"Parallel" Reconciliation Account G/L Accounting Vendor A Subsidiary Ledger
ECC System
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
36
Vendor Account Groups Vendor Account Groups
Maintenance:
– Which fields are available on the master record (Field Status) – Whether the account number is assigned externally (by the user)
– Number interval allowed for the account number of the vendor – Whether the vendor is one time vendor Vendor Account group determines... Vendor Account group determines...
Field status Vendor Number (internal/external) One-Time Vendor
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
37
Vendor Master Vendor Master – – General Data General Data
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
38
Vendor Master Vendor Master – – Company Code Data Company Code Data
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
39
Vendor Master Vendor Master – – Purchase Org Data Purchase Org Data
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
40
Vendor Master Data Vendor Master Data – – Screen Layout Screen Layout
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
41
Vendor Master Data Design
Design Considerations Design Considerations
suppressed on the vendor master record?
address (partners) be handled in SAP?
for each vendor group?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
42
Vendor Master Data Design
Key Decisions Key Decisions
groups
have not been confirmed by MM Team (TBD)
master records.
vendor master records:
due date will be set at “0”.
Document Date on the invoice.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
43
Vendor Master Data Design
Key Decisions Key Decisions
to classify maintenance notes:
– Purchasing notes – Accounting notes
– Vendor/Customer integration
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
44
Vendor Master Data Design
Key Decisions Key Decisions Area Account Group Number Range
Purchasing V9-Central Purchasing Vendor (1099) 31000-31999 Purchasing VN-Central Purchasing Vendor (Non 1099) 31000-31999 Purchasing OA-Purchase Order Address Vendor 41000-41999 Purchasing PL-Plant Vendor 61000-61999 Human Resource TP-HR Payroll Third Party Vendors (current vendor group) 300000-390000 (current number range) Human Resource GV-HR Payroll Garnishment Vendors (current vendor group) 100000-190000 (current number range) Human Resource EV-HR Payroll Employee Vendors TBD Accounts Payable P9-Invoicing Vendor (1099) 51000-51999 Accounts Payable PI-Invoicing Vendor (Non 1099) 51000-51999 Accounts Payable OT-One Time Vendor AAAAA-ZZZZZ
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
45
Vendor Master Data Design
Changes & Challenges Changes & Challenges
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
46
Vendor Master Data Design
Open Issues Open Issues
the current HR live implementation?
differences (variance from amount billed by vendor and amount expected to be billed by vendor)
– To our advantage (gain) – To our disadvantage (loss)
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
47
Vendor Master Data Design
Benefits & Improvements Benefits & Improvements
standard platform for Vendor master data
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
48
SAP Accounts Payable SAP Accounts Payable
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
49
Vendor Master Data Conversions
Design Considerations Design Considerations
is this important?
into SAP? Why is this important?
invoices? Only vendors that we have done business with within the last 2 years?
live?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
50
Vendor Master Data Conversions
Key Key Decisions
Decisions
possible) in legacy system.
where further cleansing and standardization routines will be performed via load program.
staged data to remove duplicates and make other corrections prior to actual data load into SAP.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
51
Vendor Master Data Conversions
Changes & Challenges Changes & Challenges
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
52
Vendor Master Data Conversions
Open Issues Open Issues
legacy system?
employee vendors?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
53
Invoicing and Payments Invoicing and Payments
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
54
Review of SAP Vendor Invoicing Review of SAP Vendor Invoicing
invoices and Non PO related invoices
directly into the FI-AP module
a PO (from the LOG-MM module) and post to FI-AP module via standard Logistics integration
requirements
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
55
Non PO Related Invoicing: Design Considerations
at one controlling agency?
related invoice data entry?
related invoice data entry?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
56
Non PO Invoice Process Non PO Invoice Process
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
57
SAP Accounts Payable SAP Accounts Payable -
Invoice Data Entry
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
58
Non PO Related Invoicing: Non PO Related Invoicing: Key Decisions Key Decisions
– Utility payments – Legal services – Some consulting services – Subscriptions
using SAP AP. Typically AP invoicing is done by Agency either centralized at an Accounting division or decentralized at a field office.
assigned 10 digit number range, for example 2000000000-2999999999.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
59
user security role or tolerance group setting. This configuration task will be defined so that all end users with the security access to invoice related data entry transactions will have the ability to enter any invoice regardless of dollar amount.
– Amount posted per Document (total) - $99999999999 – Amount posted per open item account (line item) - $9999999999 – Cash discount % processed – left blank so any payment term can be used – Permitted payment differences – left blank so any difference can be processed
recurring entry are:
– Subscription – Lease payments
– Vendor down payments – Use tax calculation and payment remittance – Foreign currency translation
Non PO Related Invoicing: Key Decisions Key Decisions
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
60
Non PO Related Invoicing: Changes & Challenges Changes & Challenges
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
61
Non PO Related Invoicing: Open Issues Open Issues
for non PO related invoice data entry?
and credits?
central ‘field office’ invoice data entry?
payment blocks on invoices?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
62
PO Related Invoicing: PO Related Invoicing: Design Considerations Design Considerations
at one controlling agency?
data entry?
related invoice data entry?
tolerance errors?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
63
– Commodity related purchases – Asset related purchases – Any purchase that requires a bid – Purchases on contract
SAP AP. Typically AP invoicing is done by Agency either centralized at an Accounting division or decentralized at a field office.
invoice verification tolerance settings will trigger a workflow to the appropriate personnel for resolution.
review outside of system driving tolerance checks. For example, cash availability or business approvals.
number range (XXXXXXXXXX-XXXXXXXXXX)
related data entry screen
PO Related Invoicing: PO Related Invoicing: Key Decisions Key Decisions
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
64
PO Related Invoicing: PO Related Invoicing: Key Decisions Key Decisions
Invoice Verification Tolerance Settings Invoice verification tolerance settings are configuration settings that control if an invoice should be free from payment if the vendor billed amount varies from the expected amount based on the PO and Goods Receipt. Because the PO and Goods Receipt are ‘drivers’ for the invoice verification process, the MM team’s input is needed in
– From the FI-AP point of view the tolerance setting for Price variance (tolerance key PP) should be set to 5% – Use and configuration settings for the other tolerance keys will be confirmed after the MM team have had the chance to conduct their Blueprint Workshops
tolerance settings by vendor. Therefore this functionality will not be used. All vendors will be subject to the same tolerance settings.
tolerance errors: Parking or Posting with an automatic Payment block assigned to the invoice
– Parked documents do not update the general ledger and are suspended in the system – Posted documents update the general ledger but will have a special system assigned block indicator that will prevent vendor payment – Manually reduce the invoice so that there is no discrepancy – Each Agency must decide which procedure will be used
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
65
PO Related Invoicing: PO Related Invoicing: Key Decisions Key Decisions
used for DOTD gas contracts only.
– SAP Security will be designed to limit the transaction to the appropriate DOTD business areas)
– Invoicing Plans – Vendor Down Payments – Calculation and remittance of use tax – Vendor specific Invoice Verification Tolerance Settings
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
66
PO Related Invoicing: PO Related Invoicing: Changes & Challenges Changes & Challenges
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
67
PO Related Invoicing: Open Issues : Open Issues
verification discrepancies or accounting/budget availability check errors?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
68
Invoicing: Benefits & Improvements Invoicing: Benefits & Improvements
vendor open item management.
during the invoicing and payment processing.
Departments have equal access to the same information.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
69
Invoicing and Payments Invoicing and Payments
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
70
Payments: Design Considerations Payments: Design Considerations
vendors?
payment disbursement confirmation?
for payment application?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
71
Vendor Payments in SAP Vendor Payments in SAP
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
72
Automatic Payment Program (F Automatic Payment Program (F-
110)
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
73
Payments: Key Decisions Payments: Key Decisions
– Checks – ACH (CTX format) – Wire Transfers
the current schedule that is in place currently:
– Checks cut on Tuesday & Friday – ACH remitted everyday
producing the payment output (checks or electronic files)
any checks that require additional information prior to mailing to vendor
made from SAP
from SAP
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
74
Payments: Changes & Challenges Payments: Changes & Challenges
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
75
Payments: Open Issues Payments: Open Issues
PRIOR to vendor payment?
tracking website?
automatic payment block clearing transaction by Agency?
payment and cashed check interfaces
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
76
Payments: Open Issues Payments: Open Issues
checks on demand, outside of the OSRAP regulated schedule
single or consolidated checks during invoicing?
payment block on invoices were the payment document/check have been reversed?
from payments in SAP? Maintained by OSRAP using the standard Vendor change (mass) transaction to add/remove block indicator?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
77
Payments: Benefits & Improvements Payments: Benefits & Improvements
Agencies.
during the payment processing.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
78
Invoicing and Payments Invoicing and Payments
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
79
Imprest Account: Design Considerations Imprest Account: Design Considerations
Imprest Accounts Imprest accounts are Agency managed bank accounts that are used to pay employee travel reimbursements, travel advances, one-time vendors and other payments as outlined in the Division of Administration and State Treasury Manual (section 10.14.1.1) Agencies have the responsibility of producing checks (outside of the normal OSRAP managed payment process) and balancing the bank account(s)
a legacy system?
for expense transactions?
procedure in SAP?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
80
Imprest Account: Key Decisions Imprest Account: Key Decisions
AP; expensing will be done using the Cash Management (CM) cash journal
account/checks
transaction that posts payments outside of the traditional check run (transaction F110)
will be used to monitor/control/approve payments that are cleared using this transaction
numbering schema and be responsible for their own check reconciliation or management
Be design cannot be determined until the AP team has discussed the integration point requirements of the CM Team
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
81
Manual Payments with Printout (F Manual Payments with Printout (F-
58)
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
82
Invoicing and Payments Invoicing and Payments
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
83
Check Management: Design Considerations Check Management: Design Considerations
vendor payments?
daily check management?
– Positive payment file processing – Stop payments – Check Void – Cash check files processing
handled in SAP?
they be handled using standard ECC reports or in BI?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
84
Check Register Check Register
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
85
Check Management: Key Decisions Check Management: Key Decisions
SAP AP House bank/bank account configuration.
SAP so that it will be easier to reconcile/identify outstanding checks from Legacy system and outstanding checks from SAP.
interfaces used for check management.
and issuing stop payments will continue in SAP.
easily identified and re-issued if necessary. There is a transaction in SAP that will void the check without reversing the initiating invoice (expense).
management.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
86
Check Management: Changes & Challenges Check Management: Changes & Challenges
system
live (legacy system checks and SAP)
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
87
Check Management: Check Management: Benefits & Improvements Benefits & Improvements
forecasting and reporting processes
information
development)
management
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
88
Check Management: Open Issues Check Management: Open Issues
accommodate business requirements for immediate check disbursement.
checks?
the positive payment and cashed check interfaces?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
89
Invoicing and Payments Invoicing and Payments
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
90
Vendor Invoice Data Entry Requirements: Vendor Invoice Data Entry Requirements: 1099 Invoices 1099 Invoices
system defaults the 1099 coding to the vendor line item on the invoice
that require specific invoice line items be code ‘1099 reportable’ but other line items are not?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
91
1099 1099 – – Design Considerations Design Considerations
be incorporated in the vendor master design to support 1099 vendor payment reporting?
are needed to support 1099 vendor payment reporting?
transmitted to the IRS?
the initial filing has been submitted to the IRS?
Agency?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
92
1099 1099 – – Key Decisions Key Decisions
Vendor Master
withholding tax code fields are required data entry. Exemption information will be optional data entry.
some type of 1099 data screening to be sure that we are entering vendor records in the SAP system correctly
Invoicing Procedures
reportable accounting object. During the invoicing process, the data entry personnel must determine (using the data defaulted by the PO or manually entered) if the expense line item is 1099 reportable.
vendor or using an 1099 vendor with a non 1099 reportable accounting object) will result in a warning for some agencies and a hard stop for others.
configured in SAP
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
93
1099 Filing
transmit the 1099 reportable payments to CONVEY 1099 software
(include forms) will remain in place using the CONVEY software
process
place for end users submitting changes to 1099 filing 1099 Reporting
variances for vendor invoices
1099 1099 – – Key Decisions Key Decisions
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
94
1099 1099 – – Benefits & Improvements Benefits & Improvements
because the SAP process is very similar to the current business practice
workflow trigger for 1099 discrepancy invoices, the data integrity will be improved on a real-time basis
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
95
1099 1099 – – Changes & Challenges Changes & Challenges
implement a workflow for 1099 invoicing discrepancies
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
96
1099 1099 – – Open Issues Open Issues
reportable?
identified? Using GL accounts or using some type of substitution rule enhancement?
1099 reporting?
responsible for remitting payment to the IRS?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
97
1098 1098 – – Design Considerations Design Considerations
1098 Filing
interest of $600 or more received during a calendar year in the course of our trade or business. This interest income can be received from individuals (including sole proprietors) and a business.
mortgage, thus a separate form is filed for each mortgage.
website
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
98
(RE), invoiced in Accounts Receivable (AR) and paid in the AR module
mortgage payments will be coded so that 1098 reporting can be extracted from SAP
– How will the 1098 relevant contracts be ‘coded’ for 1098 reporting? – Are there any special customer master design requirements that need to be in place to support 1098 reporting? – Will we need a custom extract program to extract to the 1098 reporting data and send to CONVEY? – Do we need any custom file formatting or file form configuration in CONVEY to support 1098 reporting?
confirm the business process design for 1098 reporting
1098 1098 – – Open Issues Open Issues
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
99
Invoicing and Payments Invoicing and Payments
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
100
Non Non-
Payable: Design Considerations
type of goods and/or services are purchased?
Reconciliation Account?
Group for the Non-Payable Vendors?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
101
Non Non-
Payable: Key Decisions
Department of Transportation and Development currently use the Non-Payable business function.
Workflow.
amount.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
102
Non Non-
Payable: Vendor Invoice
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
103
Non Non-
Payable: Vendor Payment Processing
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
104
Non Non-
Payable: Changes and Challenges
Manual Pay transactions at agency-level.
invoicing.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
105
Non Non-
Payable: Benefits & Improvements
the open Accounts Payable
and vendor open item management
time during the invoicing and payment processing
Departments have equal access to the same information
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
106
Accounts Payable Accounts Payable
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
107
Purchasing Card Functionality in SAP Purchasing Card Functionality in SAP
Purchasing card functionality is built with the SRM (Supplier Relationship Management) solution
purchase card transactions
purchase card business process:
– Custom development using a direct feed (interface) from card issue bank to SAP GL – Approving done in stand alone software provided by bank / interface to SAP G/L – Third party bolt-on software (XiBuy)
107
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
108
(interface) from card issue bank to SAP GL
provided by bank / interface to SAP G/L
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
109
What should be the To What should be the To-
Be Solution for SAP?
sessions for P-Card processing and AP team will incorporate their requirements, key decisions as part of design considerations for State-wide Purchasing Card solutions.
decisions that will be determined later.
109
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
110
Purchasing Card Reporting Purchasing Card Reporting
reporting from an online system secured at their website
– Authorization reports – Transaction activity reports – Dispute reports – Unusual spending reports
reporting)
Purchasing Card auditing?
110
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
111
Accounts Payable Accounts Payable
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
112
Reporting: Design Considerations Reporting: Design Considerations
cleared invoices?
reporting?
requirements for vendor account management?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
113
Reporting: Key Decisions Reporting: Key Decisions
reports will be available in SAP
reporting functionality (ABAP code, Queries) will provide custom reports based on specific business needs.
– Printing and mailing, faxing, etc – Viewing online – Downloading and saving to external file
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
114
Reporting: Open items Reporting: Open items
requirements for vendor account management?
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
115
Technical Objects Technical Objects
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
116
FRICE FRICE-
W Objects
– Electronic vendor registration form – Vendor check and invoice remittance advice
– Minority vendor query – Vendor by commodity code query – Vendor payment report – BI check register and payment document data by Agency – Purchases made to One-Time Vendors
– LEAD Small Disadvantage Business (SBD) vendor file interface (LED agency) – Positive payment file – Cashed check file – ACH payment file – 1099 reporting data extract to CONVEY system
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
117
FRICE FRICE-
W Objects (continued)
– AFS – LaPAC – AGPS – ADDS – FMSP – PMFS – CFMS – AFS
– AFS – LaPAC – AGPS – ADDS – FMSP – PMFS – CFMS – AFS
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
118
FRICE FRICE-
W Objects (continued)
– Custom field to identify a 1099 withholding tax code on One-Time Vendor – Custom field to identify a minority vendor – Custom field to identify commodity on vendor master – Custom field that specifies Treasury non-compliance on the vendor master record – Validation check that confirms all vendors with ACH or EFT payment methods have bank master details defined in the master record – Cash edit check – Vendor non-compliance list check – Custom field and user exit – User exit validation – Custom field on vendor invoice and credits (logistical and AP invoice) – Extract program for 1099 data – Warning validation 1099 expense coding – Custom field One-Time vendor indicating tax code
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
119
FRICE FRICE-
W Objects (continued)
– Electronic notification to review/approve a vendor master record – Parked documents due to logistical invoice simulation error – Parked documents due to asset accounting simulation error – Parked document, general approval (parked as complete status)
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
120
Legacy Conversion Strategy Legacy Conversion Strategy
– Strategy will be discussed during Realization Phase.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
121
Overall Organizational Impact Overall Organizational Impact
including service levels for data maintenance process.
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
122
Next Steps Next Steps -
General
– PDDs for Accounting Payable Master Data, Invoicing & Payments, Check Management, 1099, Non Payable Invoices and P-Card Reporting
– System Configuration – Unit and Confirmation Testing – Document Business Process Procedures (BPP’s) – Define and Develop FRICE objects – Integration Testing – User Acceptance Testing
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
123
Next Steps Next Steps – – Process Specific Process Specific
be replaced, master data conversion, etc.,
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
124
Contact Information Contact Information
mary.walker@la.gov 225-219-6857
anees.pasha@la.gov 225-219-6856
marietta.holliday@la.gov 225-219-6792
1/21/2009 PMO-FI-AP Validation Session Slide Deck - v1.0
125
Questions? Questions?