Explanation of Executive Summary Statistics

The statistics in the Executive Summary file (SAES) are updated by two programs:

• Generate Executive Summary Statistics (SA30) updates the Booking statistics (reported on lines 01 through 16), the Outstanding Back Orders (B/O), Purchase Orders (P/O) and Inventory balances (reported on lines 31, 32 and 33) and the Company Total Balances (reported on lines 34 through 41).

• Schedule Invoices & Credits (IN43) updates the Invoice/Sales related statistics (reported on lines 17 through 30).

These statistics are reported by the Executive Summary Report (SA35) and the Executive Summary Display (SA49).

Note: All updates are done per the Order/Invoice's Warehouse assignment. For example, an Order is entered in Sales Office 01 but shipped out of Warehouse 04. On the day that the Order is entered, the Bookings will be reported under Warehouse 04. On the day that the Order is Invoiced, the Sales will be reported under Warehouse 04.

Booking Section:

The Booking Section (lines 01-16) reports statistics for new Orders Booked, Cancelled Orders, Mistake Orders and the Net of those categories.

• When a new Order is entered, it updates the Orders Booked statistics for the total Order value.

• If you recall an Order and increase or decrease the selling price or discount, the impact of that change (+ or -) is reported on line 4 - Booked Dollars.

• If you recall an Order and increase the order quantity, the impact of that change is reported under line 4 - Booked Dollars.

When an entire Order or an Order detail line is deleted or the Order quantity is reduced, the following message automatically displays: "Is this a customer cancellation due to inventory availability? Yes/No".

• If you click Yes, then this is considered a cancellation and is reported on Lines 06-08.

• If you click No, then this is considered a mistake and is reported on Lines 09-11.

01 - Orders Booked - this statistic is incremented by one for the following types of transactions with Product sales:

• New Order (including Orders that are fully back ordered, future orders and pre-bill orders) entered through Enter Orders & Quotes (OE30).

• For Quotes when they are turned into an order.

• Direct Bills processed through Enter Inv/Direct Bills/Credits (IN41).

• New Retail Invoices entered through Enter Cash Counter Invoices (RS41)

• Orders imported and automatically generated for E-Commerce in Cart Conveyor (EC33), e-Sales in Build WinSol Order Import Files (ES52) and EDI Processing in Create Sales Orders (EI25).

• Orders for Customers flagged for Summary Invoicing will increment this counter but the Order number assigned when the Summary Invoice is generated by Summary Invoice Generation (SI90) will NOT increment this counter.

• Service Invoices generated by Invoice Listing and Creation (SE42) and Contract Invoices generated by Transfer/Update List (CT42).

• Although an Order number is assigned when Interest Invoices are generated by Interest Charge Audit Trail (AR82), this counter is NOT incremented for those transactions.

• Store/Warehouse transfers, Floor Charges, Direct Bills with no Product detail lines (i.e. Freight charges only) and Credit Notes do NOT increment this counter.

• If an Order is cancelled as a Mistake or Cancellation before it has passed through Generate Executive Summary Stats (SA30), then this statistic is decremented.

• If a Direct Bill is entered in IN41 and then cancelled, the result is no net impact on this statistic.

02 - Number of Order Lines Booked - the total number of Product Detail Lines processed on the following types of transactions increment this statistic by an increment of one:

• New Orders (including Orders that are fully back ordered, future orders and pre-bill orders) entered through OE30.

• Direct Bills processed through IN41.

• New Retail Invoices entered in RS41.

• Orders imported and automatically generated for E-Commerce in EC33, e-Sales in ES52, and EDI Processing in EI25.

• Orders for Customers flagged for Summary Invoicing will increment this counter but the Summary Invoice generated by SI90 does not increment this counter because it does not contain Product Detail records.

• Service Invoices generated by SE42 and Contract Invoices generated by CT42.

• Interest Invoices generated by AR82 are NOT included because they do not contain Product Detail records.

• Store/Warehouse transfers, Floor Charges, Direct Bills with no Product detail lines (i.e. Freight charges only) and Credit Notes will NOT increment the counter.

03 - Average No of Lines Per Order - is calculated as the 'Number of Order Lines Booked' divided by the number of 'Orders Booked' (Line 02 divided by Line 01).

04 - Booked Dollars - the total dollar value of Product Detail Lines on the following types of transactions update this statistic:

• New Orders (including Orders that are fully back ordered, future orders and pre-bill orders) entered through OE30.

• For Quotes when they are turned into an order.

• Direct Bills processed through IN41.

• New Retail Invoices entered in RS41.

• Orders imported and automatically generated for E-Commerce in EC33, e-Sales in ES52, and EDI Processing in EI25.

• Orders for Customers flagged for Summary Invoicing will update this total but the Summary Invoice generated by SI90 does not update the total because it does not contain Product Detail records.

• Service Invoices generated by SE42 and Contract Invoices generated by CT42.

• Interest Invoices generated by AR82 are NOT included because they do not contain Product Detail records.

• If an Order is recalled and the selling price or discount is changed or the Order quantity is increased, the impact of that change is included in this total.

• Store/Warehouse transfers, Floor Charges, Direct Bills with no Product detail lines (i.e. Freight charges only) and Credit Notes will NOT update this total.

• If an Order is cancelled as a Mistake before the original Order passes through SA30, then this statistic is decremented.

05 - Average Booked Order Including B/O's - is calculated as 'Booked Dollars' divided by the number of 'Orders Booked' (Line 04 divided by Line 01).

06 - Orders Cancelled - this statistic is incremented if any Order that has already passed through SA30 is recalled and deleted and the Operator responds Yes to the following message: "Is this a customer cancellation due to inventory availability? Yes/No". If the Order has not passed through SA30 yet, then the cancellation is backed out of 01-Orders Booked statistic and is not reported under 06-Orders Cancelled.

07 - Number of Cancelled Order Lines - this is the total number of all Product Detail lines deleted when an entire Order is deleted or an individual Product Detail line is deleted and the Operator responds Yes to the following message: "Is this a customer cancellation due to inventory availability? Yes/No".

08 - Cancelled Dollars - the total dollar value of all deleted Product Detail lines when an entire Order or individual Order Detail line is deleted or the Order quantity is reduced and the Operator responds Yes to the following message: "Is this a customer cancellation due to inventory availability? Yes/No". This is applicable before or after the Order has passed through SA30; the cancellation is reported under Cancelled Dollars.

09 - Mistake Orders - this statistic is incremented if any Order that has already passed through SA30 is recalled and deleted and the Operator responds No to the following message: "Is this a customer cancellation due to inventory availability? Yes/No". If the Order has not passed through SA30 yet, then the cancellation is backed out of 01-Orders Booked, and is not reported under 09-Mistake Orders.

10 - Number of Mistake Order Lines - this is the total number of all Product lines deleted when an entire Order is deleted and the operator responds No to the following message: "Is this a customer cancellation due to inventory availability? Yes/No". This is applicable if the Order has already passed through SA30 and is then deleted as a Mistake.

11 - Mistake Dollars - the total dollar value of all deleted Product Detail lines when an entire Order or an individual Order Detail line is deleted or the Order quantity is reduced and the Operator responds No to the following message: "Is this a customer cancellation due to inventory availability? Yes/No". This is applicable if the Order has already passed through SA30 and was then deleted as a Mistake. If the Order has not passed through SA30 yet, then the cancellation is backed out of the 04-Booked Dollars statistic, and is not reported under 11-Mistake Dollars.

12 - Net Orders Booked - is calculated as the net of 'Orders Booked' less 'Orders Cancelled' less 'Mistake Orders' (Line 01 less Line 06 less Line 09).

13 - Net Number of Order Lines Booked - is calculated as the net of 'Number of Order Lines Booked' less 'Number of Cancelled Order Lines' less 'Number of Mistake Order Lines' (Line 02 less Line 07 less Line 10).

14 - Net average Number of Lines per Order - is calculated as the 'Net Number of Order Lines Booked' divided by 'Net Orders Booked' (Line 13 divided by Line 12).

15 - Net Booked Dollars - is calculated as the net of 'Booked Dollars' less 'Cancelled Dollars' less 'Mistake Dollars' (Line 04 less Line 08 less Line 11).

16 - Average Net Dollars Booked - is calculated as the 'Net Booked Dollars' divided by 'Net Orders Booked' (Line 15 divided by Line 12).

Invoicing Section:

The Invoicing Section (Lines 17 - 30) report statistics related to Invoices and Credit Notes.

17 - Number of Invoices - this statistic is incremented by one for the following types of transactions:

• Each new Order/back order that is Invoiced in IN41.
• Each new Direct Bill entered in IN41 (even if Supplementary Charge only).
• Each Pre-Bill Invoice entered in OE30.
• Each new Retail Invoice entered in RS41.
• Each Interest Invoice generated by AR82.
• Each Accrual Invoice for Summary Invoicing and each Summary Invoice generated by SI90.
• Each Contract Invoice generated by CT42 and each Service Invoice generated by SE42.
• Store/Warehouse Transfers, Credit Notes and Floor Charges do not increment this counter.
• If an Invoice is created and then recalled and cancelled, the Invoice number is still 'used' but it is not included in this counter.

18 - Number of Invoiced Lines - the total number of Product Detail Lines processed on the following types of transactions:

• Orders/back orders Invoiced in IN41.
• Direct Bills entered in IN41.
• Pre-Bill Invoices entered in OE30.
• Retail Invoices entered in RS41.
• For Customers flagged for Summary Invoicing, Product Detail Lines are included for the Accrual Invoice but the Summary Invoice generated by SI90 is not included because it does not contain Product Detail records.
• Product Detail Lines related to Contract Invoices generated by CT42 and Service Invoices generated by SE42.
• Interest Invoices generated by AR82 are not included because they do not contain Product Detail records.
• Store/Warehouse Transfers, Credit Notes and Floor Charges do not increment this counter.

19 - Average No. of Lines per Invoice - is calculated as the 'Number of Invoiced Lines' divided by the 'Number of Invoices' (Line 18 divided by Line 17).

20 - Invoiced Sales - the total dollar value of Product Detail Lines processed on the following types of transactions INCLUDING Credit Notes (does not include Supplementary Charges and Taxes):

• Sales for Product Detail Lines for new Orders and back orders that are Invoiced in IN41.
• Pre-Bill Invoices entered in OE30.
• New Direct Bills and Credit Notes entered in IN41.
• New Retail Invoices entered in RS41.
• Sales for Customers flagged for Summary Invoicing are included for the Accrual Invoice, but the Summary Invoice generated by SI90 is not included because it does not contain Product Detail records.
• Product sales related to Contract Invoices generated by CT42 and Service Invoices generated by SE42.
• Sales/Warehouse transfers and Floor Charges do not increment this total.
• Interest Invoices generated by AR82 are not included because they do not contain Product Detail records.

21 - Average Sales per Invoice - is calculated as the 'Invoiced Sales' divided by the 'Number of Invoices' (Line 20 divided by Line 17).

22 - Number of Lines Invoiced (New Orders) - this counter is incremented if the Order detail line is for a Stock Product (as defined in IM13). The original Order is being Invoiced for the first time (i.e. not Invoicing a Back order), Qty Shipped to Date is zero and there is a Quantity to Ship. Lines partially shipped will increment this counter. This includes:

• Orders/back orders Invoiced in IN41.
• Direct Bills entered in IN41.
• Pre-Bill Invoices entered in OE30.
• Retail Invoices entered in RS41.
• For Customers flagged for Summary Invoicing, Product Detail Lines are included for the Accrual Invoice but the Summary Invoice generated by SI90 is not included because it does not contain Product Detail Records.
• Product Detail Lines related to Contract Invoices generated by CT42 and Service Invoices generated by SE42.
• Interest Invoices generated by AR82 are not included because they do not contain Product Detail records.
• Store/Warehouse Transfers, Credit Notes and Floor Charges do not increment this counter.
• This counter is incremented by '1' for each Assembled Set detail line, if shipped from prepack or components. For Models it is incremented by '1' for the model and each component detail line.

23 - Number of Lines B/O'd (New Orders) - is calculated as the sum of all fully back ordered lines for Stock Products on new Invoices (i.e. Orders that are being Invoiced for the first time and Qty to Ship=0).

24 - Fill Rate for Stock Products - is calculated as the 'Number of Lines Invoiced (New Orders)' divided by the sum of the 'Number of Lines Invoiced (New Orders)' plus the 'Number of Lines B/O'd (New Orders)' (Line 22 divided by (Line 22 + Line 23). Note: only Stock Products are included; non-Stock Products are not included.

25 - Number of Stock Transfers - the number of Invoices for all shipments (original and back order) to a Company-Owned Store or Warehouse. These are Invoices where the Customer's 'Class of Trade' is set to STO or WHS (which in turn means the 'TAT Code' is set to TRN or WHS). Transfer Credit Notes also increment this counter.

26 - Number of Lines New Stock Transfers - the sum of all Product Detail lines on all Stock Transfer Invoices (for original and back order shipments) and Credit Notes (the 'TAT Code' is set to TRN or WHS).

27 - Net Value of Stock Transfers - the dollar value of all Product Detail lines on all Stock Transfer Invoices (for original and back order shipments) and Credit Notes (the 'TAT Code' is set to TRN or WHS). This is calculated as the Ship Quantity multiplied by the Average Cost.

28 - Number of Credit Notes - the number of Credit Notes entered in IN41. Credits for Stock Transfers and Floor Charges are not included in this counter.

29 - Value of Credit Notes - the total dollar value of Product Detail Lines processed on all Credit Notes entered in IN41. Supplementary Charges and Taxes are not included in this value. Note: This is memo information only; the value of the Credit Notes is already included in 'Line 20-Invoiced Sales'.

30 - Gross Profit - the Gross Profit % is calculated as Net Sales (Line 20) minus Cost of Sales (stored in the SAES file but not presented on the report) divided by Net Sales (Line 20). Supplementary Charges and Taxes are not included.

31 - Outstanding B/O Balance - the total dollar value and number of lines of outstanding Back Orders. The statistics reported are as of the last running of SA30; there is no 'Current/Next' Month implication. The dollar value is the extension of B/O Qty multiplied by the Price less Discount from the Open Order file. Transfers are valued at Replacement Cost. The following categories are reported:

• Stock Items - back order lines for Products with a Stock flag of 'S' in Maintain Inventory Master (IM13/Stock).
• Non-Stock Items - back order lines for Products with a Stock flag of 'N' in IM13.
• Transfers - back order lines with a TAT code of 'TRN' or 'WHS'.
• Special Products - back order lines where the high-order characters of the Product code match the Special Product Mask defined in Company Control Initialization (CC00/Inventory Control).

32 - Outstanding P/O Balance - the value of all outstanding Purchase Orders (POs).

• The value reported is taken from the last run of SA30; there is no 'Current/Next' Month implication.

• Foreign currency Purchase Orders are converted to domestic equivalent by applying the associated Purchasing Exchange Rate from Maintain Currency Table (CC22).

• The total reported on the Print Outstanding P/O Report (PO80) does not do an exchange conversion; if there are outstanding foreign currency Purchase Orders then this total will not balance to PO80.

• In-Transit Purchase Orders are not included.

33 - Inventory Balance - the current value of Inventory from the Inventory General Ledger accounts defined in CC00/Invoicing/General Ledger.

• The statistic reported is taken from the last run of SA30. There is no 'Current/Next' Month implication; the value reported is 'up to the minute'.

• SA30 reads the CC00/Invoicing/General Ledger table for the Inventory control accounts, builds a list of accounts by Warehouse and then goes to the General Ledger and accumulates the Inventory balance.

• If two Warehouses specify the same Inventory control account in CC00, then the Inventory Balance will report in the Warehouse with the first occurrence and the other(s) will be zero. For example, you have an Inventory Account for Warehouse 01 defined as 11-1000 and Warehouse 02 defined as 11-1000 (the same as Warehouse 01). The Inventory Balance will report on Line 33 for Warehouse 01 and Line 33 for Warehouse 02 will be zero.

• This explains why the Inventory Balance reports as zero on Line 33 for a Warehouse but has a value on the Print Inventory Evaluation (IC81) report, which accumulates the extended value of each Product as Quantity on Hand multiplied by Average Cost.

• This total will likely not balance to IC81 unless the Evaluation is regularly reconciled to the GL control account(s).

Company Totals Only:

34 - A/R Balance - the current balance from the Accounts Receivable General Ledger account(s) defined in Maintain Bank Codes (AR02).

• The statistic reported is taken from the last run of SA30. There is no 'Current/Next' Month implication; the value reported is 'up to the minute'.

• SA30 reads the A/R Bank record for the Accounts Receivable control account and then goes to the General Ledger and calculates the Accounts Receivable balance. This happens for all Banks defined in AR02. The balance is calculated as 'Opening Balance' plus all transaction details that have a source code of IN (Sales Invoices) and AR (Cash Receipts). If there are postings from any other sources, like Journal Entries (JN), Accrual Setups (JA) or Accrual Reversals (JX), they will be skipped. Note: the GL total reported by A/R Diagnostics (AR70) works the same way.

• If you Invoice Customers in a foreign currency, then Invoices to those Customers will Debit the Accounts Receivable control account specified in their Bank Record (AR02) in foreign dollars.

• The value reported on Line 34 is one grand total of all Accounts Receivable control accounts, which could be a mix of currencies.

35 - A/P Balance - the current balance from the Accounts Payable General Ledger account(s) defined in Maintain Bank Codes (AP01).

• The statistic reported is taken from the last run of SA30. There is no 'Current/Next' Month implication; the value reported is 'up to the minute'.

• SA30 reads the A/P Bank record for the Accounts Payable control account and then goes to the General Ledger and calculates the Accounts Payable balance. This happens for all Banks defined in AP01. The balance is calculated as 'Opening Balance' plus all transaction details that have a source code of AP (AP Invoices), CC (Computer Checks) and MC (Manual Checks). If there are postings from any other sources, like Journal Entries (JN), Accrual Setups (JA) or Accrual Reversals (JX), they will be skipped.

• A/P Diagnostic (AP70) does include all transaction sources; if there are Journal Entries to the Accounts Payable control account, then the value reported on Line 35 will not balance to the value reported by AP70-GL.

• Since it is expected that the Accounts Payable control accounts are kept in domestic dollars, the value reported on Line 35 should not be a mix of currencies.

36 - Cash Received Value - the sum of all Debit postings to the Bank control account(s) defined in AR02.

• The statistic is for the Period that matches the Month of the system run date. For example, if the system date is August 15 and that date is in Period 8, then the statistics are for Period 08. There is no 'Current/Next' month implication.

• SA30 reads the A/R Bank record for the Bank control account and then goes to the General Ledger and accumulates the total of all Debit amount transactions in the GL Collector File for the period being reported.

• This value is not strictly the sum of all transactions with a source code of AR (i.e. from the Cash Receipts Journal). Debit amount Journal Entries to the Bank G/L account or Cancelled A/P Checks are also included.

• The value reported on Line 36 is one grand total for all Bank control accounts, which could be a mix of currencies.

37 - Cash Disbursements - the sum of all Credit postings to the Bank control account(s) defined in AP01.

• The statistic is for the Period that matches the Month of the system run date. For example, if the system date is August 15 and that date is in Period 8, then the statistics are for Period 08. There is no 'Current/Next' month implication.

• SA30 reads the A/P Bank record for the Bank control account and then goes to the General Ledger and accumulates the total of all Credit amount transactions for the period (Current or Next) in the GL Collector file.

• This value is not strictly the sum of all transactions with a source code of CC or MC (i.e. from Computer or Manual Check Registers). Credit amount Journal Entries or NSF checks posted in AR30 are also included.

• The value reported on Line 37 is one grand total for all Bank control accounts, which could be a mix of currencies.

38 - Number of Floor Charges - the number of Floor Charges entered in IN41. Note: this line only prints when Floor Charges are entered in IN41.

39 - Value of Floor Charges - the dollar value of all Floor Charges issued in IN41. Note: this line only prints when Floor Charges are entered in IN41.

40 - Gross Profit Floor Charges - the Gross Profit for Floor Charges calculated based on the 'Gross Profits' entered (Line 30). Note: this line only prints when Floor Charges are entered in IN41.

41 - Net Sales Value - is calculated as the total of the 'Invoiced Sales' (Line 20) and the 'Value of Floor Charges' (Line 39).

FYI: Sales statistics (Lines 17-30) are updated by IN43, which is usually run at the end of each day. Order Booking statistics (Lines 1-16) and Company statistics (Lines 31-41) are updated by SA30, which can be run on demand at any time during the day.