Background: Executive Information Summary
Use the Executive Information Summary (EIS) program to display statistics about sales, shipping, inventory, manufacturing, purchasing, accounts receivable, accounts payable, and general ledger transactions. See Road Map for work flow.
This topic answers these frequently asked questions:
What is Scope and How Can I Change it?
You can view statistics for a single branch, group of branches, or the entire enterprise. The program's Selection options determine what you see:
If you enter or select a single branch for the Branch or branch grp field, the program displays sales, shipping, inventory, manufacturing, and purchasing statistics only for that branch.
If you enter or select a branch group for the Branch or branch grp field, the program displays sales, shipping, inventory, manufacturing, and purchasing statistics for all branches in that group.
If you enter *E for the Branch or branch grp field, the program displays sales, shipping, inventory, manufacturing, and purchasing statistics for all branches in the enterprise.
If you enter or select a single organization in the Org or org group field, the program displays AP, AR and GL statistics only for that organization.
If you enter or select an organization group in the Org or org group field, the program displays AP, AR and GL statistics for all organizations in that group.
If you have more than one consolidation, you may want to create an organization group that includes all organizations with the Organization Groups Maintenance (TOGM) program. Then you can enter or select that organization group in the Org or org group field and display AP, AR and GL statistics for all organizations in your enterprise.
Why Do the Numbers Not Match When I Drill Down?
The system dynamically updates the Executive Information Summary program. If data on a drill down does not match a higher-level screen, the drill down most likely has been refreshed more recently than the higher-level screen.
What Programs Update these Statistics?
Many programs update statistics on the main Executive Information Summary screen. The tables lists some of the actions that update these totals.
Accounts Receivable
Category |
Action and Program |
Current balance |
Invoice a shipment or credit memo with AR Invoice Register (RR) Process a payment (PY) or a deposit (DP) with Cash Receipts Entry (RCE) Process a credit adjustment (CA), debit adjustment (DA), write off (WO) with Cash Receipts Entry (RCE) or AR Adjustments Entry (RB) Reverse a payment with AR Payment Reversal (RVC) |
MTD net invoices |
Invoice a shipment with AR Invoice Register (RR) |
MTD payments |
Process a payment (PY) with Cash Receipts Entry (RCE) Reverse a payment with AR Payment Reversal (RVC) |
MTD discounts |
Process a payment (PY) that qualifies for a terms discount with Cash Receipts Entry (RCE) Reverse a payment with AR Payment Reversal (RVC) |
MTD cost of goods |
Invoice a shipment or credit memo with AR Invoice Register (RR) |
Accounts Payable
Category |
Action and Program |
Current balance |
Enter an invoice or credit memo and run the register in AP Invoice Entry (NE) |
MTD net payables |
Enter an invoice and run the register in AP Invoice Entry (NE) |
MTD payments |
Select invoices for payment with Vendor Invoice Payments (NC), print checks with Check Print (NCP), and run AP Payment Register (NCR) |
MTD discounts taken |
Select invoices for payment with Vendor Invoice Payments (NC), print checks with Check Print (NCP), and run AP Payment Register (NCR) |
MTD disc available |
Enter an invoice and run the register in AP Invoice Entry (NE) |
Sales Orders
Category |
Action and Program |
| Orders not invoiced | Enter an order in Sales Order Maintenance
(OE) or a one-step order with One-Step Invoice Entry (RE)
Process an offline order with Quote-to-Order Transfer (EPIB) Enter an adjustment, credit or debit memo, or reversal with One-Step Invoice Entry (RE) Close an order with Sales Order Maintenance (OE) Invoice a shipment with AR Invoice Register (RR) |
| MTD orders (gross) | Enter an order in Sales Order Maintenance (OE) or a one-step order with One-Step Invoice Entry (RE) Process an EDI order with Quote-to-Order Transfer (EPIB) Enter an adjustment, credit or debit memo, or reversal with One-Step Invoice Entry (RE) Close an order with Sales Order Maintenance (OE) |
| MTD orders (net) | Enter an order in Sales Order Maintenance (OE) or a one-step order with One-Step Invoice Entry (RE) Process an EDI order with Quote-to-Order Transfer (EPIB) Enter an adjustment, credit or debit memo, or reversal with One-Step Invoice Entry (RE) Close an order with Sales Order Maintenance (OE) |
| MTD shipments | Invoice a shipment with AR Invoice Register (RR) |
| Orders on hold | Release from hold with Credit Hold Release (CHR) or Order Hold Release (OHR) |
Purchase Orders
Category |
Action and Program |
Open purchases |
Release a requisition with Requisition Maintenance (IRM) or enter a purchase order with PO Maintenance (VOE) Receive with Receiver Maintenance (IRC) and/or inspect and receive with Receiving and Inspection (IRI) |
MTD invty purchases |
Release a requisition with Requisition Maintenance (IRM) or enter a purchase order with PO Maintenance (VOE) |
MTD receipts |
Receive a purchase order or vendor contract with Receiver Maintenance (IRC) and/or inspect and receive with Receiving and Inspection (IRI) |
Supply chain reqs |
Run Material Requirements Planning to create requisitions for a vendor contracts Receive a vendor contract with Receiver Maintenance (IRC) and/or inspect and receive with Receiving and Inspection (IRI) |
MTD other purchases |
Release a requisition for a non-stock or capital item with Requisition Maintenance (IRM) or enter a purchase order with PO Maintenance (VOE) |
General Financial Information
Category |
Action and Program |
Inventory value |
Confirm a shipment with Sales Shipment Confirmation (OC), Secured Confirmation (SOC), or Bill of Lading Maintenance (BLM) Receive a purchase order, manufacturing order, workorderless item, transfer, RMA, or vendor contract with Receiver Maintenance (IRC) Pick components with Manufacturing Order Maintenance (MIM), Material Usage Maintenance (MUA), Picking Confirmation (MPK), Secured Picking (SMPK), Manufacturing Order Picking Selection (MSS), WIP Movement (WIPM), Labor Entry (LLE), Labor Import (LEI), or Receiver Maintenance (IRC) Enter an adjustment with Material Issues and Adjustments (IMI) Rollup costs with Standard Cost Rollup (MCR) |
MTD gross margin |
MTD shipments - MTD cost of goods sold |
Net cash forecast |
AR current balance - AP current balance |
How can Shipments Exceed Sales?
The sales statistics that display are for orders that have been entered in the current calendar month or fiscal period. Shipment statistics include shipments that have been invoiced during the same month/period. Some orders for these invoiced shipments were entered in the previous month/period. Some orders have not yet been shipped and invoiced.