Sage 100 Dashboard

/ Sage 100 reconciliation

Sage 100

Checking...

Cloud Database

Checking...

ActionEDI

Checking...

PO Matching

Checking...

Today's Invoice Pipeline (810)

Shipment Pipeline (856)

7-Day Summary

Invoice Detail

Audit — Invoice

Dashboard Guide

This dashboard shows how invoices and shipments flow from your Sage 100 system through to ActionEDI and your trading partners. It updates automatically every 60 seconds.

Connection Status

Sage 100: Whether the connector can read data from your Sage 100 system.
Cloud Database: Whether tracking data is being stored successfully.
ActionEDI: Whether invoices and shipments can be sent to ActionEDI.
PO Matching: Whether the connector can look up Purchase Orders in ActionEDI to match against invoices.

Invoice Pipeline

Shows how invoices flow from Sage 100 to ActionEDI for the selected date:

In Sage: Total invoices found in Sage 100 for this date.
PO Matched: Invoices where the Purchase Order was found in ActionEDI.
Sent to ActionEDI: Invoices successfully delivered to ActionEDI for EDI transmission.
Non-EDI: Invoices whose Purchase Order is not available in ActionEDI (not transmitted via EDI). These are expected for some freight or non-EDI orders — not a connector failure.
Failed: Invoices that could not be processed due to a connector or validation error. Check the Invoice Details table for specifics.
Awaiting: Invoices still being processed or awaiting approval.

Shipment Pipeline

Shows Advance Ship Notices (856) for the selected shipment date (aligned with invoice business dates on the 810 pipeline):

Shipments: ASN records with this shipment date.
Sent to ActionEDI: Those ASNs marked sent from the connector.
Platform Verified: Shipments confirmed in ActionEDI (platform_verification_state).
Verification Failed: Shipments where platform verification returned an error for this shipment date.

Invoice Details Table

Lists every invoice for the selected date with its current status. Common error messages:

Purchase Order not found: The PO number from the Sage invoice was not found in ActionEDI. The PO may not have been transmitted via EDI yet.
Connection timeout: ActionEDI did not respond in time. The connector will retry automatically.
Sage connection lost: The connector could not read from Sage 100. Check that the Sage server is running.

Technical Details (Expandable)

For the ActionEDI support team: heartbeat logs, error category breakdowns, and connectivity history. Not needed for day-to-day monitoring.