What does each column in the Transaction Activity Report mean?

The Transaction Activity Report provides detailed information about the transaction volume and documents for all your customer relationships.

When you view this report for a quarterly invoice, the report displays the transaction volume and documents for all your customer relationships from the previous quarter. When you view the transaction activity report for an annual invoice, the report displays the transaction volume and documents for all your customer relationships from the past 12 months.

You can use the transaction activity report to reconcile your transaction volume for the transaction fees.

The first seven columns of the report (Buyer, Buyer ANID, Document Type, Document Number, Document Date, Document Amount, and Document Currency) provide general information about your customers and the documents you sent and received.

The rest of the columns show details about the transaction amounts:

• Choreography Reference: Each "transaction" will refer to a choreography number. If you receive a  purchase order (PO) that then is flipped onto a PO Invoice, both will have the same Choreography reference number. This indicates the system that both documents are part of the same business transaction, allowing us to charge you only over the remainder in case the PO is increased or the invoice is greater than the PO.
• Choreography Base Amount: The total value of the purchase order, non-PO invoice, or invoice you received from or sent to your customer. This value excludes any disputed amounts in purchase orders, invoices, and non-PO invoices.
  For example, if your customer has several purchase orders whose total value is $1,100,000 and one purchase order for $100,000 is disputed, the Qualifying Amount is $1,000,000 (the amount excluding the disputed amount). This is the amount over which we will calculate the actual fees. If there are two documents with the same choreography reference, one is a PO and the other one its corresponding PO Invoice, the amount you will see here is both amounts, because they both have an amount on that choreography, however, only one of them will have an Actual fee in column Q. See cell A4 as an example.
• Choreography Base Currency: If you have received purchase orders or created invoices in multiple currencies, SAP Ariba stores all amount values in USD internally using daily rates for conversion. For each month, the USD equivalent values are aggregated and converted to your preferred currency. This is reflected in the report.
• Relationship Type Ariba Network: Relationships can be either Standard or Critical. The only reason why you would have a critical relationship is if there was at least one Service Sheet transacted with the customer. Critical relationships are charged at the .35% instead of .155% in all documents (not only Service Entry Sheets). On the Ariba Network, suppliers will be upgraded to a critical relationship after submitting service entry sheets and service entry sheet responses. Service orders or service entry sheets are commonly used by suppliers that charge their buyers by line of services. Critical account users are allowed to transact purchase orders (product & service), PO invoices, service entry sheet responses & Non-PO invoices. It costs 0.35% of the Choreography Based Amount. It will be only charged after sending a Service Entry Sheet, and from that specific date that relationship (and only that relationship) will be charged at 0.35%.
• Actual Fee: This is the .155% of the choreography base amount, this column details exactly how much are we charging you for each choreography.
• Document Status: Depending on the document type, this column lets you know where your customer is in the invoice approval and payment process. The turnaround time for an invoice to move between statuses, such as from Sent to Approved, depends on your customer's internal processes. If the document is a Purchase Order, it will show the Order statuses and where the order stands in regard to your processing of the order.

For additional information you can also check our Ariba Network Portal for Suppliers where you would find information about Ariba, Billing and helpful articles explaining how to manage your Ariba Account.

SAP Ariba Supply Chain Collaboration
SAP Business Network