Calculations

Quantity acknowledged/ordered calculation

Quantity acknowledged/ordered is calculated by comparing the line item details in an acknowledgment to the associated purchase order.

BTI matches up the line numbers to calculate the quantity of each line item that is acknowledged to your trading partner, compared to the number of items ordered. Canceled or rejected items are marked with a strike through.

Quantity shipped/ordered calculation

Quantity shipped/ordered is calculated by comparing the line item details in a ship notice to the associated purchase order EDI documents.

BTI matches up the line numbers to calculate the quantity of each line item that is shipped to your trading partner, compared to the number of items ordered.

Quantity invoiced/ordered calculation

Quantity invoiced/ordered is calculated by comparing the Quantity of each line item in an invoice to the purchase order.

BTI matches up the line numbers in these documents to calculate the quantity of each line item that is invoiced to your trading partner, compared to the number of items ordered.

Daily metrics calculation

The per day metrics are based on documents that are processed through BTI for the current date.

For example, the average document count per day is the sum of all of the past week's documents (purchase orders, acknowledgments, shipments, invoices, payments, but not 997s) that contain the same date in their respective date fields, divided by seven.

If the order date and the order acknowledgment date for an order document are both July 16th, then the order document counts toward the daily document count. However, if an order was processed on July 16th but has an order date field of July 15th, the document is counted toward the daily count of July 16th, and not July 15th.

Note: Here, order date refers to the date on which BTI processed the order.

Average document count calculation

All the average document counts in the dashboard are for the past week (seven days, including today).You can adjust this period by clicking on the calendar icon and selecting the range you want.

The average document count is the sum of purchase orders, acknowledgments, shipments, invoices, payments, and other documents (but not functional acknowledgments) processed in the past week by BTI, divided by seven. If you select a longer time period, the averages are for the full length of time.

The average document count does not count all the documents going through B2Bi SaaS - it only takes BTI into account.

Draft comment: apdabh23@in.ibm.com
This is opposite to information mentioned in the Daily Metrics Calculation topic. Dev pointed it out as incorrect. Keeping it as comment in case it needs to be rewritten with changes, in the future.

Keep in mind that the day a document is counted for is based on the Interchange Date, such as an order date or invoice date. These values come from the contents of the EDI document, not when the document was processed.

When you specify a time period that is less than 24 hours, the averages are presented for the total documents during the time period, in full hours, divided by the number of hours. For example, if you select 9 to 12, all documents with times of 9:00 to 11:59 are counted, and the total is divided by 3. They are indicated as per hour.

Restriction: For time zones where the time is not an even integer offset from UTC, the dashboard calculations are set to the nearest UTC equivalent. So, in the example given, the calculations are actually 9:30 to 12:30 in local time.