Skip navigation
Ariba Exchange
1 2 3 Previous Next

Procurement

41 Posts
0

Financial Reports

 

Run this report...
To see this data...
Financial Analysis ReportLists invoice spend by supplier. Analyze spend by supplier to find suppliers who sell to different business units within your company at different prices, and aggregate total spend into one contract. This report displays financial transaction data for reference document line amount, invoiced amount, and received amount for suppliers, transaction dates, supplier IDs, supplier locations, event types, transaction document numbers, transaction document line numbers, transaction document line unit prices, transaction document line quantities, reference document currencies, reference document numbers, reference document line numbers, reference document split line numbers, reference document line quantities, commodity IDs, account IDs, department IDs, and reference document line amounts in detail view. Drill down or filter data further by transaction date. By default, the report only displays transactions that were carried out in the past 6 months.

Best Practice Tip


Review your
metrics and use
them to guide
your decisions.


With your metrics in
place, you can tell which
strategies are working
and which aren't. If you
make a change, you use
the metrics to tell you
whether the change
improved things or not.

Picture3.png

 

Payment Analysis

 

Run this report...
To see this data...
Lost Payment Discount by SupplierLists invoice payments and lost discounts for suppliers. Gain visibility into your top vendors where your company has missed most of the available payment discounts. Link the discount lost to the respective vendor's invoicing performance to diagnose the potential causes of such losses by analyzing total invoice amount, invoice exception count and early payment discount lost with that supplier within this single report. This report displays invoice spend, invoice payment paid amount, invoice exception invoice count, and discount lost for suppliers in aggregate view. Drill down or filter data further
by supplier and calendar accounting date.
Payment Discount Earned vs. LostLists maximum possible discount and actual earned discount for invoice payments. Track whether vendor early payment discounts have been effectively captured during payment process by analyzing the maximum payment discounts available and the actual discount amount captured. Report also provides details on whether the discounts are earned within terms specified or outside terms. This report displays invoice payment maximum discount and earned discount for discount terms in aggregate view. Drill down or filter data further by discount term, calendar payment date, and supplier. By default,
this report excludes data for the No Discount Available and To Be Paid discount terms.
Payment ForecastLists on hold, pending, and scheduled payments by amount, available discount, and invoice count. Track future payments and discounts by analyzing the to pay amount an the maximum payment discount available (by terms), especially with the ability to forecast pending payments and discounts for invoices that have not yet been approved. This report displays invoice payment amount, maximum discount, and invoice count for payment status by payment created quarter in aggregate view. Drill down or filter data further by payment status, created date, discount terms, net terms, payable status, calendar payment date, and supplier. By default, this report excludes payments with Paid status.
Payment PerformanceLists payment amounts per net term by payment date. Monitor overall vendor payment performance over time by analyzing payments that are made within net terms and payments that are outside net terms. Further drill down by supplier to identify opportunities to improve vendor relations by paying vendors on time. This report displays invoice payment amounts for payment terms by calendar payment date in aggregate view. Drill down or filter data further by payment date, terms, payable status, status, and supplier.

 

P Card Reports

 

Run this report...
To see this data...
P Card Best Practice Tips
Charges Load ReportPurchase card charge loads, grouped by loaded date, purchase card number, and reconcile approvable. This report displays a detail view of purchase card charge load base amounts with loaded date, PCard number, reconcile approvable ID, supplier name, approvable type, charge status, transaction date, PCard holder, and charge ID.
                    1. Secure senior management support while involving key players.
                    2. Establish checks and balances.
                    3. Establish consistent policies across the organization.
                    4. Mandate training for cardholders and card managers before a card is issued.
                    5. Establish protective controls up front.
                    6. Use technology to streamline back-end auditing.
                    7. Audit beyond the traditional.
                    8. Foster positive relationships with cardholders.
                    9. Conduct periodic peer reviews before official audits occur.
                    10. Network to gain new ideas.
                    *Based upon JPMorgan PCard Survey
                    PCard Charge Reconciliation ReportApprovable purchase card charge amounts, grouped by PCO # and reconcile
                    approvable status. This report displays a detail view of purchase card charge amount and tax amounts with PCO #, reconcile approvable status, reconcile approvable ID, reconcile approvable ID line number, PCard number, transaction date, loaded date, and description. Drill down or filter data further by approvable type and reconcile approvable ID; by default, the report only displays PCard charges of type Procure.

                     

                    Procurement Content Reports

                     

                     

                    Run this report...
                    To see this data...
                    Best Proactice Tip for e-Catalog Success
                    Catalog AggregationA summary of catalog content by supplier and commodity. This report displays an aggregate view of catalog item count for suppliers and top-level commodity categories.
                    • A successful catalog technical lead will need to have the skills required to understand content requirements, educate suppliers on these requirements, cleanse and manipulate large amounts of catalog data, and troubleshoot technical errors that may occur during the enablement.

                     

                    • Depending on your industry, services can be one of the largest spend categories and is often overlooked.

                     

                    • According to Aberdeen, Best-in-class organizations do at least 74 percent of their buying through an eCatalog.

                     

                    • The time from catalog upload to availability in production is less than three days at a best-in-class organization.
                    Checkout SummaryA summary of checkout requisition data for catalog items. This report displays a detail view of requisition quantity, unit price, and spend by supplier, top-level commodity category, and manufacturer, with unit of measure, cost center or department, description, requisition line number, and requester. Drill down or filter data further by business unit ID.
                    Catalog vs. Non-Catalog ItemsA comparison of catalog and non-catalog checked out commodities at the requisition line level. This report displays a detail view of requisition spend and line count by line type and top-level commodity category with unit of measure, cost center or department, requisition line number, requisition ID, and requisition date. Drill down or filter data further by business unit ID, supplier, and manufacturer
                    Top Items Purchased by PunchOut vs. ContainedA comparison of how many requisition lines are for punched out versus contained items, with details of those requisition lines. This report displays a detail view of requisition line counts for punched out and contained items and top level commodity categories with unit of measure, cost center or department, description, requisition ID, and requisition date. Drill down or filter data further by business unit ID, supplier, and manufacturer.
                    Total Number of Items PurchasedAn overview of the number of requisition lines for each commodity, with details of those requisition lines. This report displays a detail view of requisition line counts by top level commodity category with unit of measure, cost center or department, description, requester, requisition ID, requisition line number, and requisition date. Drill down or filter data further by business unit ID, supplier, and manufacturer.

                     

                    Purchase Order Reports

                     

                    Run this report...
                    To see this data...
                    Catalog vs. Non-Catalog Ordered ItemsA comparison of catalog and non-catalog commodities in purchase orders. This report displays a detail view of purchase order spend and line counts by line type and top-level commodity category with unit of measure, cost center or department, description, PO line number, PO status, PO ID, user, and ordered date. Drill down or filter data further by
                    business unit ID, supplier, and manufacturer.
                    Order Details by Commodity and SupplierPurchase orders, grouped by commodity, supplier, and purchasing business unit. Identifies what items your company is ordering, from which suppliers, and which parts of the company are placing the orders. This report displays a detail view of PO unit price, quantity, and spend by top-level (L1) commodity category, supplier, and business unit ID, with unit of measure, department or cost center, description, PO line number, PO status, ordered date, and PO ID.
                    Order Summary by CommodityPurchase orders, grouped by commodity and supplier. Provides a basic view of what commodities your company is ordering and from which suppliers. This report displays a detail view of PO spend by top-level (L1) commodity categories and suppliers, with ordered date, description, PO status, and PO ID. Drill down or filter data further by business unit ID.
                    Order Summary by Contract and CommodityPurchase orders, grouped by contract and commodity. Provides a basic view of the contracts your company is purchasing against and what items are being ordered. This report displays a detail view of PO spend by contract ID and top-level (L1)
                    commodity category, with ordered date, description, PO status, PO ID, and supplier.
                    Order Summary by Contract and Department or Cost CenterPurchase orders, grouped by contract and department or cost center. Provides a basic view of the contracts your company is purchasing against and which parts of your company are placing the orders. This report displays a detail view of PO spend by contract and department or cost center, with ordered date, PO status, PO ID, and supplier. Drill down or filter data further by business unit ID.
                    Order Summary by Department or Cost CenterPurchase orders, grouped by department or cost center, commodity, and supplier. Provides a basic view of which parts of your company are placing orders, what items they are purchasing, and from which suppliers. This report displays a detail view of PO spend by department or cost center, top-level (L1) commodity category, and supplier, with ordered date, PO status, and PO ID. Drill down or filter data further by business unit ID.
                    Order Summary by SupplierPurchase orders, grouped by supplier, department or cost center, and commodity. Provides a basic view of which suppliers your company is purchasing from, which parts of your company are placing the orders, and what items they are purchasing. This report displays a detail view of PO spend by supplier, department or cost center, and top-level
                    (L1) commodity category, with ordered date, PO status, and PO ID. Drill down or filter data further by business unit ID.
                    Orders by Commodity and DepartmentPurchase orders grouped by commodity and department or cost center. Provides a detailed view of what items your company is purchasing and which parts of the company are placing the orders. This report displays a detail view of PO quantity, unit price, and spend by top-level (L1) commodity category and department or cost center, with unit of measure, supplier, description, PO line number, ordered date, PO status, and PO ID. Drill down or filter data further by business unit ID.
                    Orders OverviewPurchase orders, grouped by supplier. Provides a high-level overview of the purchase orders placed with each supplier. This report displays an aggregate view of PO count, spend, and average spend by supplier. Drill down or filter data further by purchasing company business unit ID.
                    PCard Order DetailsPurchase orders, grouped by PCard number and holder. Identifies which PCards are responsible for purchase orders and who holds those cards. This report displays a detail view of PO spend by PCard number and holder, with PCard expiration date, PO ID, PO status, ordered date, supplier, PO line number, and department or cost center.
                    Purchase Order ActivityPurchase orders, grouped by line type. Provides a high-level view of catalog vs. noncatalog purchase order spend; drill down and filter data further to identify where the non-catalog purchase order spend is coming from. This report displays an aggregate view of PO spend, counts, and line counts by line type (catalog vs. non-catalog). Drill down or filter data further by business unit ID and ordered date. Use the detail view to examine PO ID, ordered date, requester, ERP supplier, account ID, account, department or cost center ID, department or cost center, accounting company GL business unit, and
                    business unit ID.
                    Purchase Price Variance by CommodityCommodities and price variance data, to help you understand the impact of price variance on your company’s spend. This report displays an aggregate view of PO spend, price variance cost and percentage, and PO count for top-level commodity
                    categories. Drill down or filter data further by commodity, ordered date, supplier, company, account, company code, part name, unit of measure, contract, IsPunchOut Item, and line type.
                    Requisition Total by SupplierPurchase orders, grouped by supplier. Provides a high-level view of purchase order spend with each supplier. This report displays an aggregate view of PO spend and line counts by supplier. Drill down or filter data further by business unit ID.
                    Spend Concentration Analysis by CommodityAn overview of how many purchase order lines account for spend on each part in commodity categories. This report displays an aggregate view of PO total line count and average spend per part by top-level commodity category. Drill down or filter data further by supplier, company code, part name, contract, IsPunchOut Item, and line type.
                    Spend Penetration by CommodityAn overview of commodity spend by quarter. This report displays an aggregate view of PO spend by top-level commodity category for the past eight quarters. Drill down or filter data further by ordered date, supplier, company code, account, part name, unit of measure, contract, IsPunchOut Item, and line type.
                    Top Items Ordered by PunchOut vs. ContainedA comparison of how many purchase order lines are for PunchOut versus contained items, with details of those purchase order lines. This report displays a detail view of purchase order line counts for punched out and contained items and top level commodity categories with unit of measure, cost center or department, description, PO line number, PO status, ordered date, and PO ID. Drill down or filter data further by business unit ID, supplier, and manufacturer.
                    Total Number of Items OrderedAn overview of the number of purchase order lines for each commodity, with details of those purchase order lines. This report displays a detail view of purchase order line counts by top level commodity category with unit of measure, cost center or department, description, PO line number, PO status, ordered date, and user. Drill down or filter data further by business unit ID, supplier, and manufacturer.

                     

                    Requisition Reports

                     

                    Run this report...
                    To see this data...
                    Commodity DetailsRequisitions, grouped by commodity. Provides a detailed view of what items your company is requisitioning. This report displays a detail view of requisition quantity, unit price, and spend by top-level (L1) commodity category, with unit of measure and requisition ID.
                    Department or Cost Center DetailsRequisitions, grouped by business unit, department or cost center, and commodity. Provides a detailed view of which parts of your company are generating requisitions and what items they are requisitioning. This report displays a detail view of requisition quantity, unit price, and spend by business unit ID, department or cost center, and top-level (L1) commodity, with unit of measure and department or cost center.
                    Requisition DetailA list of requisitions with both header and line item information. Provides a detailed view of all of your company’s requisitions. Filter on any of the non-total columns to narrow down the data the report displays. This report displays a detail view of requisition quantity, unit price, and spend with unit of measure, department or cost center, supplier, description, PO ID, requisition line number, requisition date, requisition status, requester, requisition title, and requisition ID.
                    Requisition SummaryA list of requisitions. Provides a basic view of all of your company’s requisitions. Filter on any of the non-total columns to narrow down the data the report displays. This report displays a detail view of requisition spend with requisition status, requisition date, requisition title, preparer, requester, and requisition ID.
                    Supplier DetailsRequisitions, grouped by supplier and commodity. Provides a detailed view of which suppliers your company is generating requisitions with and what items they are for. This report displays a detail view of requisition quantity, unit price, and spend by supplier and top-level (L1) commodity category, with unit of measure, description, and requisition ID.
                    Requisition Approval Cycle Time
                    Requesters with the Longest Approval TimeRequests, grouped by requester. Identifies the requesters whose requisitions take the longest to approve or deny requests. This report displays a detail view of request approval time, count, number of approvers, and approver approval time by requester, with request ID, type, status, and submitted date. Drill down or filter data further by approved/denied date and status; by default, the report only displays requests with Approved or Denied status.
                    Requisition Approval Time by Originating DocumentApproval data for requests. Identifies which departments are taking the longest to approve or deny requests. This report displays an aggregate view of request approval time, approver approval time, number of approvers, request count, and average requisition amount. Drill down or filter data further by requesting management or users, status, and type. Use the detail view to examine request ID, type, status, and submitted date. By default, the report only display requests with Approved or Denied status.
                    Requisition Approval Time by Size of RequisitionApproval data for requests. Provides an overview of requisition approval efficiency and helps you determine whether the size of a requisition is related to its approval cycle time. This report displays an aggregate view of request approval time, number of approvers, approver approval time, and request count. Drill down or filter data further by approved/denied date, requesting management or users, status, and type. Use the detail view to examine request ID, type, status, and submitted date.
                    User Activity
                    Active Approvers by Month (XLS)The number of users approving requests in each month. You can export this report with the associated Excel template. This report displays an aggregate view of the number of users by submitted/approved month. Drill down or filter data further by activity type, document type, and user. Use the detail view to examine users, submitted/approved date, document type, and activity type. By default, the report only displays data for the Approved activity type.
                    Active Requisitioners by MonthThe number of users submitting requisitions in each month. You can export this report with the associated Excel template. This report displays an aggregate view of the number of submitters by submitted/approved month. Drill down or filter data further by activity type, document type, and user. Use the detail view to examine users, submitted/approved date, document type, and activity type. By default, the report only displays data for the Submitted activity type and the Requisition document type.

                     

                    Picture3.png

                    Link to part 1 of this post below.

                    Ariba Procurement Reporting Part 1

                    ___________________________________________________________________

                     

                    This has been another Knowledge Nugget post brought to you by Beverly Dunn.

                    For more information or details please feel free to contact me!

                    882 Views 0 Comments Permalink
                    0

                    OOTB — Out of the box or prepackaged reports are available within your Ariba Procurement application. The description of each prepackaged report includes a list of the data elements used in the report. These default analytical, parameterized, and compound reports are delivered with Reporting and Analysis as a basis for your own customization or adaptation for your particular company’s needs. The reports are grouped into folders by area, for example, Purchase Order Reports. Within the Purchase Order Reports folder are reports relating to purchase order activity.

                     

                    The reports that are available to you, and the fields that are available in those reports, depend upon your company’s Ariba Spend Management solution configuration. Today, I will cover report options in the default configuration. The best way to become familiar with the reports is to work with them. In addition to the standard data fields associated with each of the supplied facts, many of the reports contain user-defined fields based on these data fields. In some reports, the data has been constrained to illustrate a type of analytical report. For example, sometimes unclassified data has been excluded from the pivot table view for easier recognition of other trends. So, while these are out of the box or OOTB, there is an element of customization to fit your particular reporting needs.

                     

                    Reports are useful to gauge adoption, usage, and results. These tips, tricks, suggestions and best practices are designed to help you get the most from your Ariba solutions, achieve organizational success and elevate your procurement program to best-in-class.

                     

                    Types of OOTB Reports Availale
                                      • Approval Reports
                                      • Budget Analysis Reports
                                      • Buyer Settlement Reports
                                      • Contract Reports
                                      • Financial Analysis Reports
                                      • Payment Analysis
                                      • PCard Reports
                                      • Procurement Content Reports
                                      • Purchase Order Reports
                                      • Requisition Reports

                                       

                                      Approval Reports


                                      Run this report...
                                      To see this data...
                                      Approval HistoryA detailed history of all approvals (including denials) from all completed approvables, such as requisitions, invoices, travel authorizations, and so forth. This report displays approval completed (approval history) approvable counts by approvable ID, approvable title, approvable type, approvable status, action date, approved by user, approver, reason, and state in detail view, filtered by submit date. Drill down or filter further by approvable status, approvable type, and approved by user.
                                      Pending ApprovalA detailed report of all approvals that are in process. This report displays pending approvable counts by approvable ID, title approvable type, approver, signed date, and reason in detail view, filtered by submit date. Drill down or filter further by approvable status and approvable type.

                                       

                                      Budget Analysis Reports

                                       

                                      Run this report...To see this data...
                                      Budget AnalysisBudgeted and transaction amounts, and remaining available funds, for all budget items. This report displays budget amount, transaction amount, and funds available amount by budget code, document number, transaction date, transaction type, action, transaction line number, transaction split line number, and asset, filtered by calendar transaction date in detail view. Drill down or filter data further by accounting company, purchasing company, department, fiscal year, account ID, period, budget start date, and budget end date.

                                       

                                      Buyer Settlement Reports

                                       

                                      Run this report...
                                      To see this data...
                                      Commodity AnalysisA comprehensive analysis of spend by commodity. Begin with the big picture, and identify spend amounts, number of suppliers, number of items, commodities, etc. Identify areas of savings opportunities and drill into the details to review detailed item-level information to aid in your savings opportunity identification and sourcing strategic decisions. This report displays invoice spend for top-level commodity categories by invoice quarter in aggregate view. Drill down or filter data further by supplier, company, company code, invoice date, contract, line type, part name, region, and unit of measure.
                                      Invoice Accrual ReportInvoice spend for each supplier. The report displays a detail view of invoice spend in US dollars and the original currency for suppliers, invoice IDs, account IDs, and department or cost center IDs with invoice number, accounting date, ERP supplier, and original currency code. Drill down or filter data further by business unit ID and reconciliation status; by default, invoices with Paying and Paid reconciliation status are excluded.
                                      Invoice Summary ReportInvoice amounts and counts for each supplier, grouped by status. The report displays an aggregate view of amount invoiced, amount accepted, amount disputed, and invoice count for business unit IDs, suppliers, invoice status, and reconciliation status.
                                      Invoice Summary Report by ContractInvoice amounts and counts for each contract and supplier. The report displays a detail view of amount invoiced, amount accepted, amount disputed, and invoice count for contract IDs and suppliers with business unit ID, invoice ID, invoice status, invoice date, and reconciliation status.
                                      Order Liability ReportPurchase orders that have not yet been fully invoiced for each supplier and purchasing business unit. The report displays a detail view of PO spend, total amount left to invoice, and total amount left to reconcile for suppliers and business unit IDs with PO ID, ordered date, requester, ERP supplier, account ID, and department or cost center ID.
                                      Purchase Price Variance by CommodityCommodity price variances. Commodity managers can use it to drill deeper by commodity and part into their supply base to analyze minimum, maximum and unit prices and quantities per part to identify savings opportunities. This report displays invoice spend, count, and price variance cost for top-level commodity categories in aggregate view. Drill down or filter data further by account, supplier, commodity, company code, invoice date, contract, line type, part name, region, and unit of measure.
                                      Spend Concentration Analysis by CommodityCommodity spend at the part level, including the total number of parts purchased and average spend per part. Commodities with large spend on a small number of parts often enable greater sourcing savings. Drill into deeper levels of commodities with large number of parts as one of the inputs in your sourcing opportunity analysis. This report displays invoice line count and average invoice spend per part for top-level commodity categories in aggregate view. Drill down or filter data further by account, supplier, company code, contract, line type, part name, and region.

                                       

                                      (click image below for full size)

                                      Picture1.png

                                      Important To Know

                                      All analytical reporting in any Ariba solution is based upon fact tables

                                      • Fact tables contain all of the information a user wants to report on
                                      • What fact tables are available depends on the solutions

                                      Fact tables are made up of

                                      • Dimensions - Information about a business
                                      • Measurements - Numerical data that contains measureable information about the fact

                                      Reports in Ariba are based upon Microsoft Excel pivot tables

                                      • After a report has been created it can be further modified by "pivoting" on any dimensional information

                                      Reports are built around the numerical measurements with dimensions providing the associated business information

                                       

                                      Contract Reports


                                      Run this report...
                                      To see this data...
                                      Contract Days LeftContracts that have not yet expired, grouped by number of days left until expiration. This report displays a detail view of contracts by duration (in months) with contract ID, parent contract, status, supplier, contact, effective date, expiry, and days left.
                                      Contract By Amount LeftContracts that have remaining amounts that can be purchased against them, grouped by the percentage of amount remaining. This report displays a detail view of contract cumulated amount ordered, maximum commitment, and remaining amount percentage with contract ID, parent contract, status, contact, effective date, expiration date, and expiry. Drill down or filter data further by supplier and contract release type; by default, the report only displays contracts of type Release.
                                      Contract By Invoiceable Amount LeftContracts that have remaining invoiceable amounts that can be invoiced against them, grouped by the percentage of invoiceable amount remaining. This report displays a detail view of contract cumulated amount reconciled, cumulated amount invoiced, maximum commitment, and remaining reconcilable amount percentage with contract ID, parent contract, status, supplier, contact, effective date, expiration date, and expiry. Drill down or filter data further by supplier and contract release type; by default, the report only displays contracts of type Release.
                                      Contract By Reconcilable Amount LeftContracts that have remaining amounts that can be reconciled against them, grouped by the percentage of reconcilable amount remaining. This report displays a detail view of contract remaining reconcilable amount percentage, cumulated amount reconciled, cumulated amount invoiced, and maximum commitment with contract ID, parent contract, status, supplier, contact, effective date, expiration date, and expiry. Drill down or filter data further by supplier and contract release type; by default, the report only displays contracts of type No Release.
                                      You can't manage what you don't measure. It is an old management adage that is accurate today. Unless you measure something you don't know if it is getting
                                      better or worse. You can't manage for improvement if you don't measure to see what is getting better
                                      and what isn't.
                                      Picture6.png
                                      Contract Line By Amount LeftContract line items that still have remaining amounts that can be purchased against them, grouped by the percentage of amount remaining. This report displays a detail view of contract line item amount ordered left percentage, amount ordered, amount ordered left, quantity ordered, quantity ordered left maximum amount, and maximum quantity with contract ID, supplier, supplier part number, and description. Drill down or filter data further by contract release type; by default, the report only displays contracts of type Release.
                                      Contract Line By Quantity LeftContract line items that still have remaining quantities that can be purchased against them, grouped by the percentage of quantity remaining. This report displays a detail view of contract line item remaining quantity ordered percentage, amount ordered, remaining amount ordered, quantity ordered, remaining quantity ordered, maximum amount, and maximum quantity with contract ID, supplier, supplier part number, and description. Drill down or filter data further by contract release type; by default, the report only displays contracts of type Release.
                                      Contract Line By Receivable Amount LeftContract line items that still have remaining amounts that can be received against them, grouped by the percentage of amount receivable remaining. This report displays a detail view of contract line item remaining amount receivable percentage, amount received, remaining amount receivable, quantity received, remaining quantity receivable, maximum amount, and maximum quantity with contract ID, supplier, supplier part name, and description. Drill down or filter data further by contract release type; by default, the report only displays contracts of type No Release.
                                      Contract Line By Receivable Quantity LeftContract line items that still have remaining quantities that can be received against them, grouped by the percentage of quantity receivable remaining. This report displays a detail view of contract line item remaining quantity receivable percentage, amount received, remaining amount receivable, quantity received, remaining quantity receivable, maximum amount, and maximum quantity with contract ID, supplier, supplier part number, and description. Drill down or filter data further by contract release type; by default, the report only displays contracts of type No Release.
                                      Contract Line By Reconcilable Amount LeftContract line items that still have remaining amounts that can be reconciled against them, grouped by the percentage of amount reconcilable remaining. This report displays a detail view of each contract line item’s contract, remaining amount reconciled percentage, amount reconciled, remaining amount reconcilable, quantity reconciled, remaining quantity reconcilable, maximum amount, and maximum quantity with supplier, supplier part number, and description.
                                      Contract Line By Reconcilable Quantiity LeftContract line items that still have remaining quantities that can be reconciled against them, grouped by the percentage of quantity reconcilable remaining. This report displays a detail view of each contract line item’s contract, remaining quantity reconcileable percentage, amount reconciled, remaining amount reconcilable, quantity reconciled, remaining quantity reconcilable, maximum amount, and maximum quantity with supplier, supplier part number, and description.

                                       

                                      Picture5.png

                                      Best Practice Tip:

                                      Review your metrics and use them to guide your decisions

                                      With your metrics in place, you can tell which strategies are working and which aren't. If you make a change, you use the metrics to tell you whether the change improved things or not.

                                       

                                       

                                       

                                       

                                       

                                       

                                       

                                       

                                       

                                       

                                       

                                       

                                       

                                       

                                       

                                       

                                       

                                      Link to part 2 of this post below

                                      Ariba Procurement Reporting Part 2

                                      _________________________________________________________________

                                       

                                      This has been another Knowledge Nugget post brought to you by Beverly Dunn.

                                      For more information or details please feel free to contact me!

                                      935 Views 0 Comments Permalink Tags: best_practices, procurement, ariba, eprocurement, knowledge, knowledge_nuggets, customer_success, reporting, reports, procurement_reporting
                                      0

                                      There are many approaches to increasing savings throughout the source to settle process.  Tomorrow Heinz Schaeffer from AXA is going to share what steps they took to create a holistic commerce platform that has enabled nearly $6B in cash management opportunities on a webinar you can sign up for here.

                                       

                                      Is ther one particular thing that you've done that has been a huge "ah ha" item?

                                      1,039 Views 0 Comments Permalink Tags: procurement, p2p, financial, success, webinar, emea, savings, global, commerce, heinz, axa, schaeffer, holistic
                                      0

                                      eProcurement Transformation — Getting Buy In from Your Organization

                                       

                                      Change management continues to be one of the single hardest challenges that organizations face daily. As I have heard and read it takes 21 days to learn a habit. So how can you ensure your users get in the “habit” of following your procurement processes? Good question to begin with….do you have an established process for purchasing?

                                       

                                      For increased adoption and a good user experience, it is imperative that your end users understand the organizational goals and initiatives and in return what that can mean to the company bottom line (and them!) Ariba Customer Success can help you develop a Success Plan that puts your organizational goals into a framework to track and report against. From there, you can begin to identify areas for increased usage and adoption, spend/contract leakage, and drive more through your P2P/Buyer application.

                                       

                                      Best Practice Suggestions:

                                      • Develop a process and program for how purchasing will take place among your business units/departments.
                                      • Publish, teach and train end users on how to follow the process. Executive Sponsorship of process is imperative.
                                      • Design and implement an internal newsletter calling out procurement success by individual, department, and or team. This allows end users to see how their efforts aid the organization.
                                      • Incentivize end users through individual or inter-departmental awards. Competition can make mundane tasks fun and exciting and ultimately enforce your published policies.

                                       

                                      Best Practice P2P Tip of the Day from IOMA:

                                      In today's world, AP and purchasing can no longer work in "silos." That is, the two departments need to collaborate because they are the two components of the all-important procure-to-pay (P2P) process. And there are significant cost savings that can be found if AP and purchasing work together.

                                       

                                      One area that can benefit from this collaboration is noncompliant (maverick) spending, both indirect and direct. Noncompliant indirect spending includes things like office supplies, computers and consulting services. Direct (contract) noncompliant spending includes non-PO purchases, invoices coming in with no associated PO, or POs opened with non-approved vendors.

                                       

                                      Best-in-class companies manage the P2P process so that fewer purchases are made outside their purchasing process. When someone tries to use a non-PO-type vendor, it should be visible within the system and a determination can be made if the purchase is appropriate. For example, the vendor master file control process can be tweaked so that purchasing gets alerted when non-PO-type vendors are being set up.

                                       

                                      A little analysis can uncover noncompliant spending and the lost savings can be calculated. This lost savings can be interpolated based on your total spending to come up with a total potential savings.

                                       

                                      For more information go to: www.iofmonline.org

                                       

                                      Best Practices for P Card Success

                                      The best way to ensure success of your purchasing card (p-card) program is to have a formal and detailed policy and procedures manual for cardholders and administrators. This will also help with control of the program because it spells out what is—and is not—allowable in terms of p-card usage.

                                       

                                      At a minimum, the manual should include:

                                      • an explanation of why p-cards should be used (benefits);
                                      • how cardholders can obtain a card and activate it;
                                      • a cardholder agreement that spells out responsibilities and liabilities;
                                      • the types of purchases that should go through the p-card;
                                      • any specific vendors that should be paid via the p-card;
                                      • any limits on the use of the p-card (types of transactions, size of purchases, monthly limits, etc.);
                                      • receipt requirements, reconciliation procedures, and record retention policy; and
                                      • what cardholders should do if their cards are lost or stolen;

                                      The policy should be updated whenever a change is made or, at a minimum, once every year.

                                       

                                      Adoption Best Practice Tip

                                      Boost their skills.


                                      Send staff to training to make them feel more a part of the  organization—they’ll give back by working faster and more efficiently. Also, cross-train every employees so that  anyone can step in for anyone else who is missing. One way to do this is through a job-sharing  program.


                                      Probably the most valuable aspect of motivating your staff is simply having employees who are more satisfied with their work. And more satisfied employees means more productive employees.

                                       

                                      Discuss training opportunities with your Customer Success Manager—Ariba University courses, Customer Success Lunch & Learns, User Groups, etc.

                                       

                                      AP Automation and Productivity

                                      Automating your invoice processing operation increases efficiency because it reduces the “touch points” an invoice has to go through on its way to payment. For example, you no longer have to route invoices by hand—electronic versions are routed using Ariba automated workflow and passed thorough to the accounting system for payment.

                                       

                                      With electronic invoicing, AP doesn’t even see the invoices coming in—they are automatically received, matched to POs, and then paid. For non-PO invoices, the electronic bills are automatically routed to approvers. All AP sees are the exceptions (and any invoices that do not come through the e-invoicing process).

                                       

                                      A recent survey conducted by the Institute of Management and Administration (IOMA) found these productivity improvements when going from a low level to a high level of AP automation:

                                      • average number of PO payments per month per AP staff member: from 930 to 3,647;
                                      • average number of non-PO payments per month per AP staff member: from 934 to 2,263; and
                                      • average number of T&E expense report payments per month per AP staff member: from 450 to 1,335.

                                       

                                                                                                                       

                                       

                                      This has been another Knowledge Nugget post brought to you by Beverly Dunn.

                                      For more information or details please feel free to contact me!

                                      978 Views 0 Comments Permalink Tags: best_practices, adoption, contract_management, procurement, purchasing, p2p, ariba, eprocurement, productivity, success, ariba_knowledge_nuggets, customer_success, buy, po, process, usage, ap_automation, pcards, _plan, p_cards
                                      0

                                      To view a replay of the webinar featuring Kay Ree Lee from RockTenn  or get a copy of the whitepaper, Best Practices in eCatalog Management or other resources by clicking here.  Below are some of the answers from Kay Ree who is the Director, Purchasing System and Administration at RockTenn.

                                       

                                      Q: I am interested in how RockTenn decided to implement e-catalogs, with centralized procurement, rather than outsourcing to an organization such as an Integrator

                                       

                                      A: When we decided to implement an e-procurement system, catalog and supplier management were additional workstreams that naturally complemented the system implementation. As a result, the implementation of e-catalogs was managed by the same individual that managed the system implementation. The e-catalog implementation was relatively straight forward and did not require additional resources.

                                       

                                      Q: What was the overall time of implementation across all RockTenn sites?

                                       

                                      A: RockTenn took about 11 months to implement across all sites.

                                       

                                      Q: how did RockTenn work with smaller companies that found it financial difficult to support this new Ariba e-procurement?

                                       

                                      A: The charges to suppliers who transact over the Ariba Supplier Network (ASN) is minimal. Most of our suppliers do not even meet the threshold that require them to pay a fee to transact with RockTenn over the ASN. So their cost is zero. For the smaller suppliers who have found it difficult to transact with RockTenn, we worked closely with Ariba to share the value of transacting over the Ariba Supplier Network through a qualitative and quantitative presentation that shares benefits of the program.

                                       

                                      Q: Also, how many suppliers did RockTenn have before the implementation and after? (i.e. how many non-catalog suppliers are there?)

                                       

                                      A: We really do not look at the number of suppliers before and after unless it is for a sourcing event. During the implementation of Ariba, we realized that a supplier may accept catalog and non-catalog requisitions and it did not really benefit us to view them separately.

                                      744 Views 0 Comments Permalink Tags: best_practices, catalog, procurement, purchasing, sap, p2p, eprocurement, enablement, erp, oracle, ecatalog, rocktenn, rock_tenn
                                      0

                                      To view a replay of the webinar featuring Kay Ree Lee from RockTenn  or get a copy of the whitepaper, Best Practices in eCatalog Management or other resources by clicking here.

                                      Q: Do you have any benchmarks or statistics around cost associated with a buyer placed PO vs a catalog PO? This kind of stats are needed to promote catalog

                                       

                                      A: According to a 2008 Aberdeen study, the order costs before an eProcurement system with catalogs enabled is $51.  After a system is put in place the cost drops to $26.  Cycle time drops from 11.6 to 3.4 days and percent of maverick spend drops from 33% to 20%.

                                       

                                      Q:How many organizations are represented in the number quoted "average org. has 224 catalogs"? Seems high.

                                       

                                      A: This is from a study from Aberdeen from Oct 2007 and looked at 622 enterprises.  Even at 224 catalogs, which granted depending on your industry and company size may seem large, the amount of spend controlled through catalogs and eprocurement is very low.  The key point to remember here is to increase the number of catalogs enabled to achieve a high degree of spend controlled.  Some would say at least over 65%.

                                       

                                      Q: Of the 74% Best in Class Companies who have catalogs is this related to transactions or spend?

                                       

                                      A: According to Aberdeen, 74% of top performing organizations use eCatalogs complementing their eprocurement systems.  So this is the % of the survey population not spend or transactions.

                                       

                                      Q: Targeted for eCatalogs: Suppliers who receive150 orders or more annually.  Do you mean 150 orders or lines in orders?

                                       

                                      A: 150 lines in orders.  Using a catalog will reduce the time required to find manually and fill out the required information for each item ordered.

                                      595 Views 0 Comments Permalink Tags: best_practices, catalog, adoption, procurement, indirect_spend, purchasing, sap, p2p, eprocurement, erp, oracle, ecatalog, rocktenn, rock_tenn
                                      0

                                      Q: For products like business cards that require additional information about the individual placing the order.  What type of catalogue works best?

                                       

                                      A: For very simple value added products like business cards, a CIF catalog can sometimes be used, however for more complex print and other services such as temp labor, marketing services, consulting and facilities, a CDF catalog is used as part of a Services Procurement Solution. Learn more by clicking here.

                                       

                                      Q: Do you use catalogs for services or do you use a services procurement solution?

                                      ­

                                       

                                      A: Catalogs (SKU based) can be used for reorders for value added products such as print.  Best Practices show that catalogs for many services should be used as part of a services procurement solution.  A good example of this would be the Ariba Temp Labor Catalog.  This catalog includes over 1,000 industry job descriptions along with 14 categories.  It improves communication with suppliers and saves implementation time.

                                       

                                      Q: ­What is the average and max. level for catalog buying (versus free text) that can be reached for IT, professional services  Marketing & Sales?­

                                       

                                      A: Trying to purchase off catalog (free text) severely limits the benefits of your eprocurement system.  Using Ariba Services Procurement any type of service can be purchased with no dollar limitation including IT, PS and Marketing and Sales.  A Services Procurement Solution delivers the following benefits that you miss with free text purchasing:

                                      • Spend visibility
                                      • Online collaboration with suppliers to deliver competitive proposals and maximum value
                                      • Contract/Rate card compliance
                                      • Approval control
                                      • Preferred supplier compliance

                                      Q: ­How do you set up service type catalogs with variable pricing and basket purchases?

                                      ­

                                       

                                      A: Variable pricing or rate cards in services such as contingent labor, consulting, print, marketing services, facilities, and others can be easily accomplished with Ariba Services Procurement.  http://www.ariba.com/solutions/procurement/servicesprocurement.cfm   This uses the same platform and interface as Ariba Procurement for goods.

                                      683 Views 0 Comments Permalink Tags: best_practices, catalog, procurement, services, labor, consulting, contingent, print, indirect_spend, purchasing, sap, marketing, p2p, contingent_labor, vms, services_procurement, temp_labor, eprocurement, sow, erp, oracle, ecatalog
                                      0

                                      Check out the webinar Q&A.  More Q&A tomorrow.  You can view the replay by clicking here.

                                       

                                      Q: Is there an optimal (best practice) ratio between the number of catalogs and the items therein that enables user adoption while still driving product standardization and pooling?

                                       

                                      A: Ideally product standardization would happen up front during the strategic sourcing project.  However, if you do have multiple suppliers for the same items, you can drive end users to purchase the “preferred” item by using tools in procurement applications such as relevance ranking and icons indicating a preferred item.

                                       

                                      Q: Do you have some examples of which supplier are already level 2 ready?


                                      A: Some some Level 2 compliant suppliers include: Ebsco Information, Cellular Accessories for Less, Markmaster, and SHI.

                                       

                                      Q: Do you recommend that the supplier manages data input for CIF or an internal user?

                                       

                                      A: It is recommended that the supplier manages the data input for the CIF.  Normally a supplier is able to provide some type of data export that is easier than having the buying organization create CIFs in house.  For some suppliers where perhaps only a handful of items are purchased (less than 10 for example), it may make sense for the buying organization to create this catalogs internally.

                                       

                                      Q: I have several customers using cif catalogs as well as PunchOut.  cif catalogs have been challenging because many customers want customized column headers plus customized data in some of the column content.  Some may be within the same organization.  Why?

                                       

                                      A: Some purchasing organizations are decentralized and required different data elements for accounting, receiving, etc.  Most likely that is why you are seeing varying requirements from within the same organization.

                                       

                                      Q: How do you monitor pricing on punch-out catalogs? i.e. to verify if contract pricing is used?

                                       

                                      A: This is done by doing a spot audit of the PunchOut site against the contracting pricing on a regular (quarterly suggested) basis.

                                       

                                      Q: What measures can an organization take to ensure punchout catalog items are verified against contract. How do you see delta reporting of items added, revised or removed.

                                       

                                      A: This is one drawback to PunchOut catalogs.  There is no delta report created as there is with CIF when a new version is uploaded.  The best method is to maintain a list of contracted items and prices and verify manually on a regular basis.

                                       

                                      Q: Can punch out be specific to our organization?

                                      A: Yes, almost all PunchOut sites are set up to be specific to each individual buying organization

                                       

                                      Q: Can i tell the supplier to standarize a punchout catalog the way I want it to show for my users?

                                       

                                      A: Most suppliers have a standard look and feel to their PunchOut site across all customers.  You can ask the supplier to customize it for your organization, but it depends on the ability of the supplier to dedicate the resourcing for that effort.  PunchOut sites are customer specific though, so from a technical standpoint, yes this is possible.

                                       

                                      Q: what would you recommend to suppliers who want to connect through punchout to Ariba procurement systems... so they can be prepared to take on buyers using Ariba?

                                       

                                      A: The best route to take would be for the supplier to get their PunchOut site certified by Ariba as part of the Ariba Ready program.  This will then let new buyers know that the supplier is PunchOut capable and ready to integrate.  More information can be found at:  http://www.ariba.com/supplier/

                                      726 Views 0 Comments Permalink Tags: best_practices, catalog, adoption, procurement, indirect_spend, p2p, eprocurement, punchout, erp, procurement_content, ecatalog, rocktenn, rock_tenn
                                      0

                                      Last Thursday we had a terrific attendance to our webinar featuring Kay Ree Lee from RockTenn and Jarod Shrock, Sr. Catalog Enablement Mgr. at Ariba. We covered:


                                      • RockTenn’s experiences and lessons learned
                                      • How many and which catalogs should be online
                                      • How to keep pricing current
                                      • Compliance/control
                                      • Supplier tools
                                      • Security and service
                                      • Cleansing and content enrichment
                                      • Guidance to suppliers for best content creation

                                      If you missed the Webinar you can view the replay by clicking here.

                                      There were over 50 questions during the webinar and we will be posting answers here throughout the week. So stay tuned!

                                      484 Views 0 Comments Permalink Tags: best_practices, catalog, adoption, procurement, indirect_spend, eprocurement, enablement, content, erp, ecatalog, rocktenn, rock_tenn
                                      0

                                      Best Practices in eCatalog Management


                                      April 29, 2010 - 11:00 a.m. EDT
                                      60 minutes

                                      Catalog management can be a hassle for many organizations, and there are challenges regardless of the type of eProcurement system currently employed.  Join Ariba and packaging giant RockTenn for an upcoming educational webinar to learn how to optimize SAP, Oracle, or any eProcurement system through improved eCatalog management.  During this webinar, we’ll provide you with information on the following topics:    

                                       

                                      * RockTenn’s experiences and lessons learned   

                                      * How many and which catalogs should be online   

                                      * How to keep pricing current   

                                      * Compliance/control   

                                      * Supplier tools   

                                      * Security and service   

                                      * Cleansing and content enrichment   

                                      * Guidance to suppliers for best content creation

                                       

                                      Register

                                      626 Views 0 Comments Permalink Tags: best_practices, catalog, suppliers, procurement, purchasing, sap, eprocurement, enablement, erp, oracle, ecatalog
                                      0

                                      What is eProcurement?

                                      Posted by John Lark Apr 14, 2010

                                      After a webinar last week, I was asked this question, so I thought I'd put my response out to the rest of this community:

                                       

                                      Unfortunately the term eProcurement is much like the word “cat” – do you mean a cute 6 pound tabby, or a 500 lb lion.  When asked if you want a cat at your house, it’s pretty important to know what is meant, and the same goes for “eProcurement”.  eProcurement is a broad-reaching term that, in its most general sense, can be applied to any way of communicating electronically during the procurement process.  In its most rudimentary form, this can be the use of emails or embedded forms, while something slightly more advanced might be EDI.  To further complicate matters, different people define “procurement” as different things.  Some think about this as simply the ordering of products, while others may look at just the process from PO through approval.

                                       

                                      However, if we are to ask what is world-class eProcurement, the kind that delivers nearly 3x the savings of even average peers (much less compared to some of the lagging definitions above), then it is a completely different story.  World class eProcurement is one which has ties to all of the key processes affecting procurement, from sourcing to settle, visibility and process improvement, managing all areas of spend, and expertise to drive adoption and maximize compliance while allowing for the necessary growth and flexibility of today’s successful companies.  It is one which can be deployed so as to deliver savings rapidly, and which continues to improve through best practice integration.  It allows for easy, electronic interfacing and collaboration between key parties at each step of the process, with the necessary controls in place to ensure compliance, not just with processes, but with legal and regulatory requirements as well.  Finally, it is deployed in a fashion that allows essential consideration of the IT other resources needed to maintain currency, not just of code, but also of all the data (contracts, products, etc) that are needed for effective procurement.

                                       

                                      So, when someone says they do eProcurement, I always try to ask what they mean so I know if I’m dealing with a tabby cat or a lion.  What do you think?  What does you or your company consider eProcurement?

                                      1,114 Views 0 Comments Permalink Tags: adoption, best, ariba, eprocurement, proactices
                                      0
                                      You already have SAP, Oracle or another ERP eProcurement system,  but not everyone uses it and keeping it updated is a hassle.  Below are 5  important tips along with other resources for improving the adoption and  increasing the spend through your ERP eProcurement module.
                                      1. 1.Enable suppliers/catalogs that  represent at least 65%+  of your spend
                                      2. 2.Enable services categories such as  consulting, print, temp  labor, marketing and others.
                                      3. Ensure  catalogs are updated regularly, minimum  quarterly.
                                      4. 3.Make sure pricing is  accurate.
                                      5. 4.Provide  on-demand training for users who are not accustomed to the ERP  system.
                                      If you would like to learn more, join our webinar on April 29, 11AM ET: Best Practices in eCatalog ManagementRegister for this webinar and download other resources including Improving  User Adoption and Contract Compliance with Your Existing Procurement  Platform whitepaper.
                                      784 Views 0 Comments Permalink Tags: best_practices, catalog, adoption, procurement, purchasing, sap, contract_compliance, content, erp, oracle, procurement_content, apc, ecatalog
                                      0

                                      OK, we all get it, procurement is hard.  Sometimes I think that wrangling 100 cats would be easier, but there are times we have to step back from all the biting and scratching and look at where we're spending our time and energy.  This last week I saw some fascinating statistics around Services spend.

                                       

                                      So often we think only of temp labor, but did you know there are over 20 major categories of services spend?  Furthermore, I saw how much spend is typical for different industries and to say it's significant, well just look at the summary below:

                                       

                                      Airline - 37%; Auto & Transportation - 20%; Business Services (Consulting, Insurance, Media) - 75%; Consumer Products - 31%; Financial Services - 85%; Healthcare - 44%; High Tech Hardware - 50%; Industrial Manufacturing - 47%; Oil, Gas, Chemicals - 43%; Pharmaceuticals - 64%; Retail - 66%; Software - 69%; Telecom - 79%; Utilities - 71%

                                       

                                      So if you ask me, being sure that my eProcurement strategy has a clear services piece integrated to it may be just the "squeeky toy" needed for the next "cat wrangling" session.

                                       

                                      459 Views 0 Comments Permalink Tags: procurement, services, p2p, ariba, eprocurement, procure-to-pay, services_spend
                                      0
                                      So I was at a P2P conference last week, and learned that Schering-Plough was going to be one of the speakers (they started using Ariba nearly 7 years ago and continue using it today).  What I hadn't realized is what a great job they'd done with establishing their baselines, and metrics so that they could report on the savings they got each year.  What they said at the conference was that last year alone, the Ariba solutions saved them over $200M!  Now if I could only find a stock market with that kind of return!
                                      411 Views 0 Comments Permalink Tags: best_practices, procurement, p2p, ariba, benchmark, savings, metric, roi
                                      0

                                      Last week we had a timely discussion around procurement of marketing services including; Print, Consulting, Market Research, Creative Services, Direct Mail, Call Centers, Promotional Merchandise and others. The 10 commandments of marketing spend were outlined along with touching on some points from Target around Print and WellPoint around Consulting from previous webinars.

                                      View the Replay

                                       

                                      We will be covering Q&A from the webinar over the next week so stay tuned.

                                       

                                      Q: What is the ideal way for procurement to search for potential vendors for marketing?

                                       

                                      A: One great place to start is http://discovery.ariba.com/

                                      There you will be able to search by commodity, region and size for suppliers that meet your criteria.  You will also be able to request information and a proposal.

                                      592 Views 0 Comments Permalink Tags: best_practices, procurement, services, consulting, contingent, print, indirect_spend, purchasing, marketing, p2p, contingent_labor, services_procurement, discovery, sow, wellpoint, target
                                      1 2 3 Previous Next