How to print: Complete the Submit Order Cancellation List Screen (POCL).
Quotes: The system includes quotes on this report whose cancel date is earlier than the date you ran the report. See Entering Pre-Order Quotes for an overview.
For more information: See the sample report in PDF format.
Contents:
• Order #: A unique number the system assigns to identify an order. These are the orders that are due to be canceled.
• Total $: The total dollar value of the order or quote that is due to be canceled. (Note: This report does not support multi-currency conversion. The order total appears in the currency on the order, regardless of whether you process orders in multiple currencies.)
• Customer Name: The number, last name, first name and middle initial of the customer who placed the order.
• Daytime phone #: The customer's daytime phone number. You can define a phone number format for each country; the system uses this format whenever you enter or change a customer's phone number. See Setting Up the Country Table (WCTY).
• Ship to: The ship to customer number that has the items with an overdue cancellation date.
• Line #: The order line number for the item with an overdue cancellation date.
• Cancel date: The date the item is eligible for cancellation, in company date format.
• Quantity: The quantity of the item on the order line that is eligible for cancellation.
• Item: The item number.
• SKU: The SKU code, if the item has SKUs.
• Description: The item description.
How to print: Select the By item field on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BOR_ITM. Backorder totals are provided at the base item level only, not the SKU level.
Backordered items on quotes: The system does not include items on backorder on quotes; see Entering Pre-Order Quotes for an overview.
For more information: See the sample report in PDF format.
Contents:
• Item number
• Item description
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)
• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)
• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)
• Final totals
Backorder Report by Item with SKU Details
How to print: Select the By item and Print SKU detail fields on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BOR_ITMS. Backorder totals are provided for each base item number and each SKU.
Backordered items on quotes: The system does not include items on backorder on quotes; see Entering Pre-Order Quotes for an overview.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents:
• Soldout control (a code indicating when the system should consider the item sold out)1
• Item number
• SKU
• Item description
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)
• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)
• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)
• Subtotals for the base item
• Final totals
How to print: Select the By whse/item field on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BORWHSITM.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents:
• Item number
• Item description
• Warehouse code
• Warehouse description
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)
• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)
• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)
• Subtotals for each warehouse
• Final totals across all warehouses
Backorder Report by Warehouse with SKU Details
How to print: Select the By whse/item and Print SKU detail fields on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BORWHSITMS. Backorder totals are provided for each SKU and each warehouse.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents:
• Soldout control (a code indicating when the system should consider the item sold out)2
• Item number
• SKU
• Item description
• Warehouse code
• Warehouse description
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)
• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)
• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)
• Subtotals for each base item
• Subtotals for each warehouse
• Final totals across all warehouses
How to print: Select the By vendor field on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BORVND.
Important: A backordered item is included on this report only if a primary vendor has been defined for the item.
For more information: See the sample report in PDF format.
Contents:
• Item number
• Item description
• Vendor number
• Vendor description
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)
• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)
• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)
• Subtotals for each vendor
• Final totals for all vendors
Backorder Report by Vendor with SKU Details
How to print: Select the By vendor and Print SKU detail fields on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BORVNDS. Backorder totals are provided for each SKU and each vendor.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents:
• Soldout control (a code indicating when the system should consider the item sold out)3
• Vendor number
• Vendor description
• Item number
• SKU
• Item description
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)
• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)
• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)
• Subtotals for each base item
• Subtotals for each vendor
• Final totals across all vendors
Backorder Report by Vendor w/PO
How to print: Select the By vendor w/PO field on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BORVNDPO.
For more information: See the sample report in PDF format.
Contents:
• Vendor number
• Vendor description
• Item number
• Item description
• Purchase order number
• Purchase order due date
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on order (cumulative total of all SKUs being ordered from your suppliers)
• Quantity on hand (cumulative total of all SKUs currently available across all warehouses)
• Quantity on reserve (cumulative total of all SKUs already reserved to existing orders)
• Subtotals for each vendor
• Final totals for all vendors
Backorder Report by Vendor/SKU/PO
How to print: Select the By vendor w/PO and Print SKU detail fields on the Print Backorder Report Selection Prompt Screen and select Accept. The system submits the program BORVNDPOS. Backorder totals are provided for each SKU and each vendor.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents:
• Soldout control (a code indicating when the system should consider the item sold out)4
• Vendor number
• Vendor description
• Item number
• SKU
• Item description
• Purchase order number
• Purchase order detail line number (on which the SKU was ordered)
• Purchase order due date
• Quantity on backorder (cumulative total of all backordered SKUs for the item)
• Quantity on purchase order (cumulative total of all SKUs being ordered from your suppliers)
• Subtotals for each SKU
• Subtotals for each base item
• Subtotals for each vendor
• Final totals for all vendors
How to print: This report prints if you accept the default (unselected) setting of the Print by division field through the Printing the Sales Journal (PDSJ) menu option. Sales transactions are listed in ascending order (lowest-to-highest) by date and in ascending order by invoice number order within each date.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Things to note about the spreadsheet version of the report:
• There may be a rounding discrepancy on the tax total for the last date included on the report, as well as the grand total of tax. This discrepancy should be no more than a few cents.
• Depending on the width of the data, there may be blank columns between some of the columns.
Sort order: The report sorts by:
1. currency, if the Multi Currency by Offer (E03) system control value is selected, with blank currency sorted first.
2. division, if you selected the Print by division flag when generating the report. See Sales Journal by Division.
3. invoice date. Within each date, the report lists invoices in ascending numeric order (lowest to highest).
Contents:
Page headings: Each page of the report includes the following headings:
• Invoice Dates: The range of dates you selected when generating the report.
• Currency: The currency code and description are included only if the Multi Currency by Offer (E03) system control value is selected. The currency indicated is blank if you run the report for shipments that occurred before you started using multi-currency by offer.
• Division: The division code and description are included only if you selected the Print by division flag when generating the report. See Sales Journal by Division for a discussion and report sample.
• Invoice Date: Totals are included for each invoice date.
There is a page break for each new currency, division, or invoice date.
For each invoice: The report lists:
• Invoice: The number identifying the invoice.
• Customer: The sold-to customer number.
• Order: The number identifying the order. The ship-to number is not listed.
Note: The following fields are from the Invoice Ship To records. If there is more than one Invoice Ship To, these fields represent the sums across all ship-tos. The amounts listed for credit invoices are followed by a minus sign.
• Merchandise
• Freight
• Additional Freight
• Tax: The amount of sales tax calculated on merchandise shipped. If the Tax Included in Price (E70) system control value is selected, this figure includes any value-added tax, and the word VAT is to the right.
About VAT: On orders subject to VAT, tax on merchandise does not accumulate in the Tax bucket; instead, a “hidden tax” is included in the order detail line and the customer pays a tax-inclusive price for each item. For such orders, the Merchandise total indicated is net of VAT. In other words, if the customer paid $10.00 for the merchandise, but a $1.50 hidden tax was included in the order detail line, the merchandise total would be $8.50.
The unit VAT charge is stored in the Second choice SKU item field in the Order Detail table, and the total VAT amount for an invoice is the total of the extended VAT amounts for each order detail line billed for that invoice.
• Handling
• Additional Charge
Note: The following fields indicate how the invoice was paid, and are from the Invoice Payment Method records. If there are multiple Invoice Payment Method records for the same pay category (for example, two credit cards), the field indicates the sum for that pay category.
• Total Cash
• Total Credit Card
Calculated fields:
• Gross Profit: Calculated as Merchandise amount - cost from invoice ship-to / merchandise amount * 100. Rounded up or down to the nearest hundredth or cent, so that the report lists a gross profit with two decimal positions.
Note:
• If the Multi Currency by Offer (E03) system control value is selected, the cost is converted to the local currency before calculating the gross profit, using the conversion rate from the Invoice Currency record. For example, if the cost in the order currency is 10.00 and the currency conversion rate is 1.50, then the system uses a cost of 15.00 (10.00 * 1.5) to calculate gross profit. However, if the Multi Currency by Offer (E03) system control value is selected but the report includes shipments billed before you selected the system control value, the Gross profit listed for the invoices is 100.00%.
• An invoice might have a Gross profit of 0.00 if it is for the shipment of a no-charge item, or if the cost and the merchandise total were equal.
See Determining Gross Profit for a discussion.
• Out-of-balance: the out-of-balance amount is included in a separate line immediately below the out-of-balance invoice. See Out-of-Balance Invoices for a discussion.
Totals: The report includes a total of each of the above-listed dollar values for:
• each date in the selected date range
• the division, if you selected the Print by division flag when generating the report. See Sales Journal by Division for a discussion and report sample.
• the currency, if the Multi Currency by Offer (E03) system control value is selected
• the entire selected date range
An out-of-balance total line is included for each of the above totals if any invoices in the selected date range were out-of-balance; see Out-of-Balance Invoices for a discussion.
• Gross profit totals: The Totals field for Gross profit represents the average gross profit percentage for all shipments on the specified invoice date, calculated by totaling the gross profit percentage for all shipments and dividing the result by the number of shipments, where:
• the shipment amounts include positive invoices only, not credits
• the number of shipments includes positive invoices only, not credits, and does not include invoices with a Gross profit of $0.00. An invoice might have a Gross profit of $0.00 if it is for the shipment of a no-charge item, or if the cost and the merchandise dollar total were equal.
See Determining Gross Profit for a discussion.
• VAT Total: the total amount of value-added tax, which is also included in the Tax total. This information appears only if the Tax Included in Price (E70) system control value is selected.
How to print: This version of the Sales Journal prints if you select the Print by division setting through the Printing the Sales Journal (PDSJ) menu option. Sales transactions on this report are sorted and subtotaled by sales division. Each division starts on a new page. A grand total of all invoices for the company as a whole is presented at the end of the report.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents: See the Standard Sales Journal for a description of the contents of this report.
How to print: Use the Printing the Sales Journal by Pay Type (PSJP) menu option.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents:
• Invoice date range
• Currency
• Invoice date (the date on which an invoice was created as a result of a shipment. This report shows all shipments for the specified report date range)
• Pay plan type
• Pay type code
• Invoice number
• Customer number
• Order number
Note: The following totals are from the Invoice Payment Method record(s).
• Merchandise
• Freight
• Additional freight
• Tax (the amount of sales tax calculated on merchandise shipped. If this figure includes any VAT, the word VAT appears to the right.5)
• Handling
• Additional charge
• Total invoice
• Amount collected
• Total credits (the total dollar amount of credits (refunds) for this pay type for items returned today. Credits appear as negative dollar amounts.)
• Total invoices
• Totals for pay type
• Totals for pay plan type
• Totals for (date)
• Grand total
Note: This report sorts by currency if the Multi Currency by Offer (E03) system control value is selected.
Sales Journal Summary by Period
How to print: Select the By period field at the Print Sales Journal Summary screen; see Printing the Sales Journal Summary (PSJM).
Information on this report is sorted by offer within accounting period. Sales totals are provided for each period. A grand total of sales for all periods is provided at the bottom of this report.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents: See the Sales Journal Summary by Entity/Offer.
Sales Journal Summary by Offer
How to print: Select the By offer field on the Print Sales Journal Summary screen; see Printing the Sales Journal Summary (PSJM).
Information on this report sorts by offer (in alphanumeric offer code sequence). A grand total of sales for all offers is provided at the bottom of this report.
For more information: See the sample report in PDF format.
Contents: See the Sales Journal Summary by Entity/Offer.
Sales Journal Summary by Descending Dollars
How to print: Select the By merch$ descending field on the Print Sales Journal Summary screen; see Printing the Sales Journal Summary (PSJM).
Information on this report is sorted by descending merchandise dollars (highest-to-lowest sales) for each offer during an accounting period. Sales totals are provided for each period. A grand total of sales for all periods is provided at the bottom of this report.
For more information: See the sample report in PDF format.
Contents: See the Sales Journal Summary by Entity/Offer.
Sales Journal Summary by Invoice Date
How to print: Select the By invoice date field on the Print Sales Journal Summary screen; see Printing the Sales Journal Summary (PSJM).
Information on this report is sorted by date and division for each offer during an accounting period. Sales totals are provided for each period. A grand total of sales for all periods is provided at the bottom of this report.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents: See the Sales Journal Summary by Entity/Offer.
Sales Journal Summary by Entity/Offer
How to print: Select the By entity/offer field on the Print Sales Journal Summary screen; see Printing the Sales Journal Summary (PSJM).
Information on this report is sorted by offer within each entity. Sales totals are provided for each entity. A grand total of sales for all entities is provided at the bottom of this report.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
• Start date and End date: the dates between which sales information is reported
• Offer: the code for the catalog, television or space advertisement from which you accept orders
Note: The following totals are from the Invoice Ship To record.
• Merchandise dollars: the sum of all merchandise amounts on the Invoice records for each offer. This is strictly the charge for the item and does not include charges for tax, freight, shipping, etc.
• Tax: the sum of the sales tax on the Invoice records for each offer.
• Freight: the sum of the freight on the Invoice records for each offer.
• Additional freight: the sum of the additional freight on the Invoice records for each offer.
• Charges: the sum of the extra charges on the Invoices for each offer. This may include service charges (for the source code or offer), additional shipper/item charges, guaranteed service charges, or additional charges/credits entered during Order Entry or Order Maintenance
• Handling: the sum of special handling charges on the Invoice for each offer. Special handling is some type of additional item handling, such as monogramming, hemming, altering, etc.
• Total: the sum of all Invoice Pay Method records for pay category Cash/Check for the offer
• Cost: the sum of the cost amounts in the Invoice records for each offer.
• Gross profit: the dollar amount of profit realized from the sales for each offer. This is calculated by:
Total Merchandise Amount - Total Cost for each offer
• Gross profit percent: the percentage of gross profit realized from the sales for each offer. This is calculated by:
(Total Gross Profit / Total Merchandise Amount) * 100
See Determining Gross Profit for a discussion.
• Deferred liability: total amount posted to deferred liability for this offer.
• Credit card: the sum of all Invoice Pay Method records for pay category Credit Card for the offer
• Invoice Date: The date that the invoice was created (This field only occurs when you print the Sales Journal Summary by Invoice Date)
• Division: This code represents the division of your business against which you are posting the transaction. (This field only occurs when you print the Sales Journal Summary by Invoice Date)
Sales Journal Summary by Order Type
How to print: Run a periodic process that includes the SLSSMOT periodic function (program name = PFSLSSUMOT).
Which date? If the Parameter field for the periodic function specifies a date in MMDDYY format, the report includes sales for that date. Otherwise, the report includes sales for the day before the report is generated (current date - 1). Typically, you would include the periodic function in your daily processing, to review sales for the previous day, but you can also use the Parameter to generate the report for any date.
The report can include data for only a single date.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents:
• Start date/End date: the date when the sales activity took place. The start and end dates are always the same. Can be specified in MMDDYY format in the Parameter for the periodic function; otherwise, the previous system date is used (current date - 1). See above for a discussion.
For each order type that had sales activity:
• OT: The code identifying the order type. The description of the order type is on the line below the summary totals for the type.
Note: Unless indicated otherwise, the following totals are from the Invoice Ship To records.
• TTL: The total number of shipments or returns for the order type on that date, based on the number of Invoice Ship To records.
Note: Each of the following totals are decreased by credit invoices, if any.
• Merch: the sum of all merchandise amounts on the invoice records for the order type. This total is based on item prices and does not include charges for tax, freight, shipping, etc.
• Tax: the sum of the sales tax on the invoice records for each order type.
• Freight: the sum of the freight on the invoice records for each order type.
• Add’l frt: the sum of the additional freight on the invoice records for each order type.
• Add’l chg: the sum of the extra charges on the invoices for each order type. This total may include service charges (for the source code or offer), additional shipper/item charges, guaranteed service charges, or additional charges/credits applied to the order and billed.
• Hnd: the sum of special handling charges on the invoices for each order type. Special handling might consist of monogramming, hemming, alternations, etc.
• Total: the sum of all Invoice Pay Method records for the order type.
• Cost: the sum of the cost amounts in the invoice records for each order type.
• G/P: the dollar amount of profit realized from the sales for each order type. This is calculated by:
Total Merchandise Amount - Total Cost for each order type
• G/P%: the percentage of gross profit realized from the sales for each order type. This is calculated by:
(Total Gross Profit / Total Merchandise Amount) * 100
See Determining Gross Profit for a discussion.
• Def liab: total amount posted to deferred liability for the order type.
• Credit card: the sum of all Invoice Pay Method records for pay category Credit Card for the order type.
How to print: Complete the Print Sales Journal Errors Screen through the Printing Sales Journal Errors (PSJE) menu option.
For more information: See the sample report in PDF format.
Contents:
• Date range: From and To dates selected at the Print Sales Journal Errors Screen
• Invoice date: the date the order shipment or credit billed
• Invoice: invoice number
• Customer: customer number
• Order: order number
Note: The following totals are from the Invoice Ship To record.
• Merchandise: the total merchandise value billed on the invoice
• Freight: the total freight charges billed on the invoice
• Add’l freight
• Tax
• Handling
• Add’l charge
• Total cash
• Total C/C
• Out of balance amount: the total Merchandise, Freight, Additional freight, Tax, Handling, and Additional charge for all Invoice Pay Method records that do not equal the corresponding totals for the Invoice Ship To record. If the Invoice Pay Method total is higher than the Invoice Ship To total, the out-of-balance amount is negative; otherwise, if the Invoice Pay Method total is lower than the Invoice Ship To total, the out-of-balance amount is negative.
For more information: See Out-of-Balance Invoices for a discussion.
Order Shipment Analysis Report
How to print: Use the Printing the Order Shipment Analysis (POSA) menu option.
For more information: See the sample report in PDF format.
Contents:
• Cmp: Company code.
• Ofr: Catalog (offer) code.
• Orders: Number of orders.
• Items ordered: Number of items ordered.
• Order value: Order value.
• Avg Ord Size: Average order size.
• Phone orders: Number of phone orders.
• Phone value: Value of phone orders.
• Avg Ord Size: Average size of phone orders.
• Mail orders: Number of mail orders.
• Mail value: Value of mail orders.
• Avg Ord Size: Average size of mail orders.
• Shpmnts: Number of shipments.
• Items Shipped: Number of items shipped.
• Shipment Value: Shipment value.
• Total
• Final Totals
How to print: Use the Printing the Open Prepaid Order List (POPP) menu option.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
• order number
• order status (whether the order is held)
• number of order recipients
• order date
• customer number
• customer name
• order balance
• prepaid balance: The amount of prepayment received from the customer.
• refund due, if any: If the prepaid balance is greater than the order balance, and if no refunds have been paid yet, this equals the prepaid balance minus the order balance. The amount of the refund also depends, however, on how you have defined the pay type; if the refund check minimum for the pay type is $2.00, then refunds of less than $2.00 will appear as zero.
• refund paid, if any: The calculation is similar to refunds due, except that this amount includes refunds that have already been processed.
• open prepaid balance: This is the amount of the customer's prepayment that is applied to the order balance.
• balance due, if any: If the order balance is greater than the prepaid balance, this equals the order balance minus the prepaid balance
• order type
• user ID of the person who entered the order
When the report runs as part of your daily process, it includes all add reason codes for that day.
How to print: Use the Print the Order Addition Report (PAAR) menu option. You can also add this report to your periodic processing.
For more information: See the sample report in PDF format.
Contents:
• date range (from and to dates for the period)
• add reason code
• operator (Rep) who added the item
• order number
• add reason code
• item or alias code
• SKU codes, if any
• description of the item
• unit price
• total number of order lines added by the operator for this add reason
• total number of order lines added by all operators for this add reason
• grand total number of order lines added for the period
Purpose: This report displays tax, GST, and PST totals by state for all debit invoices and credit invoices within a given date range.
How to print: Use the Printing the Sales Tax Report by State (PSTX) menu option.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents:
• From: The first date for invoices included on the report.
• To: The last date for invoices included on the report.
• State: A code for the state associated with the tax.
• Tax debit: The total tax associated with sales for the state. The system totals the Tax amount in the Invoice Ship To table for each debit invoice that falls within the specified date range and whose ship to customer resides in the specified state.
• Tax credit: The total tax associated with returns for the state. The system totals the Tax amount in the Invoice Ship To table for each credit invoice that falls within the specified date range and whose ship to customer resides in the specified state.
• GST debit: The total GST amount associated with sales for the state. The system totals the GST amount in the Invoice Ship To table for each debit invoice that falls within the specified date range and whose ship to customer resides in the specified state.
• GST credit: The total GST amount associated with returns for the state. The system totals the GST amount in the Invoice Ship To table for each credit invoice that falls within the specified date range and whose ship to customer resides in the specified state.
• PST credit: The total PST amount associated with returns for the state. The system totals the PST amount in the Invoice Ship To table for each credit invoice that falls within the specified date range and whose ship to customer resides in the specified state.
• PST debit: The total PST amount associated with sales for the state. The system totals the PST amount in the Invoice Ship To table for each debit invoice that falls within the specified date range and whose ship to customer resides in the specified state.
How to print: Use the Printing the State Tax Detail Report (PSTD) menu option.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents:
Report selections:
• State and description
• date range selected
• currency selected and description (if you use Multi Currency by Offer (E03))
Invoice and credit information: (this information is presented first for all invoices, both taxable and tax-exempt, then for all credits, which may also include both taxable and tax-exempt)
• invoice number
• invoice date
• customer number of the person who placed the order
How to print: Use the Printing the Order Demand/Sales Reports (PSSR) menu option.
Quotes: Quotes entered by the salesman number are included on this report. Q displays in the Order Status field for orders flagged as quotes. The Quantity Returned, Quantity Reserved, and Quantity Shipped totals are always 0 for quotes. See Entering Pre-Order Quotes for more information.
For more information: See the sample report in PDF format.
Contents:
• Orders from entered date range
• Salesman number
• Order number
• Order date
• Order status
• Merchandise total
• Tax total
• Freight total
• Gross margin
• Gross margin percent
The gross margin calculations on this report do include estimated freight for the item class. See Determining Gross Profit for a discussion.
• Quantity returned
• Quantity ordered
• Quantity reserved
• Quantity shipped
• Salesman totals
• Final totals
How to print: Use the Printing the Order Demand/Sales Reports (PSSR) menu option.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents:
• Orders from entered date range
• Source code
• Order number
• Order date
• Order status
• Merchandise total
• Tax total
• Freight total
• Gross margin percent. The gross margin calculation on this report does include estimated freight for the item class. See Determining Gross Profit for a discussion.
• Quantity returned
• Quantity ordered
• Quantity reserved
• Quantity shipped
• Source totals
• Final totals
Item Purchase and Sales Aging Report
How to print: Use the Item Purchase and Sales Aging Report (LIPS) menu option.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents:
• Warehouse
• Vendor number and description
• Item/SKU
• On hand quantity
• Month to date
• Year to date
• Reserved quantity
• Open purchase order quantity
• Weekly receipts aging buckets (updates when you receive the item)
• 0-7 days
• 8-14 days
• 15-21 days
• 22-28 days
• 28 and over days
• Last purchase order number
• Weekly sales aging buckets (updates when you confirm the item)
• 0-7 days
• 8-14 days
• 15-21 days
• 22-28 days
• 28 and over days
• Last receipt date
Purpose: Use this report to review the flow of orders from entry through shipment for a period of time. This report provides a high-level overview of the fulfillment process, identifies potential bottlenecks or problem areas, and delivers an audit trail of order activity.
This report is broken into separate areas of information:
• order control: beginning order totals and ending order totals
• shipment summary: shipped totals, exchanged totals, and credited/returned totals
• open order summary: open/held order totals, open/held backordered totals, open/held printed totals, and open/held reserved/unprinted totals
• general operational summaries: suspended batches totals, pending picks totals, pending RA receipts totals, pending RA credits totals, and pending refunds totals
• general merchandising summaries: backordered items totals, open PO totals, held PO totals, docked PO totals, open past due PO totals, held past due PO totals, docked past due PO totals, suspense receipt totals, pending putaway totals, and staging warehouse totals
• If the held and open totals are blank: You need to follow the process described under Print Order Control Report (POCT) to make sure the system records the total order activity.
• Drop ship items update the totals on this report as well as items that you ship from your warehouse.
• Non-inventory items: The setting of the Demand Update for Non-Inventoried Items (E59) system control value does not affect how the system calculates these totals; non-inventory items update each total regardless of this setting.
• Update demand for order maintenance: The setting of the Update Demand for Order Maintenance Transactions (C72) system control value does not affect how the system calculates these totals.
You can also review these totals in the Operations Control Summary menu option; see Reviewing Operations Control Summary (FLSH).
How to print:
• complete the Order Control Report Screen.
• submit the order summary periodic function (PFR0062).
• select Update current totals at the First Operations Control Summary Screen, Second Operations Control Summary Screen, or Display Operations Control Summary Screen in the Operations Control Summary (FLSH) menu option.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents:
• Date range: Dates included in the report. If you generated the report at the Order Control Report screen, these are the dates you entered; if you generated the report through the periodic function, both dates should represent the generation date; if you generated the report at one of the Operations Control Summary screens, both dates are the current date.
Order control: The number of orders, number of units, and total merchandise dollar value for open orders. The system breaks down these totals by gross demand, add on demand, cancelled orders, closed/soldout orders, and shipped orders.
• Beginning open order balance: The number of orders, number of units, and merchandise dollars for the beginning transaction date of this report.
• number of orders: The total number of open and held orders as of the beginning transaction date. The system uses the following calculation to determine the beginning number of orders; these fields are from the Order Control Summary table: open orders number + held orders number + orders cancelled number + orders soldout/closed number + orders shipped number - orders entered number = beginning number of orders.
• number of units: The total number of units on open and held orders as of the beginning transaction date. The system uses this calculation to determine the beginning number of units; these fields are from the Order Control Summary table: open backordered quantity + open printed quantity + open unprinted quantity + held backordered quantity + held printed quantity + held unprinted quantity + add on demand + quantity cancelled + quantity soldout + quantity shipped - quantity ordered = beginning number of units.
• merchandise dollars: The merchandise dollar total of open and held orders as of the beginning transaction date. The system uses this calculation to determine the beginning merchandise dollars; these fields are from the Order Control Summary table: open backordered dollars + open printed dollars + open unprinted dollars + held backordered dollars + held printed dollars + held unprinted dollars + add on demand dollars + orders cancelled dollars + orders soldout dollars + orders shipped dollars - orders entered dollars = beginning merchandise dollars.
• This is the Orders entered dollars from the Order Control Summary table for the beginning transaction date.
The beginning open order balance is then broken out by:
• Gross demand: The number of orders, number of units, and merchandise dollars for orders entered for the selected date range. These order totals reflect initial order entry only.
• number of orders: The total number of orders entered for the selected date range, from the Orders entered number in the Order Control Summary table.
• number of units: The total number of units on new orders, from the Quantity ordered in the Order Control Summary table.
• merchandise dollars: The merchandise dollar total on new orders, from the Orders entered dollars in the Order Control Summary table.
• Add on demand: Actual add-on demand; increased each time you add any items in order maintenance, including the replacement items in exchanges. However, these totals are decreased by orders or items canceled with a cancel reason whose Reduce demand flag is selected.
• number of orders: The total number of orders; increased each time you reopen a closed order by adding item(s) in order maintenance, including exchange (replacement) items and mis-ships; decreased each time you cancel an order using a cancel reason whose Reduce demand? flag is selected. This is the Orders reopened number from the Order Control Summary table.
• number of units: The total number of units; increased each time you add an item in order maintenance, including a mis-ship or exchange (replacement) item; decreased each time you cancel an item using a cancel reason whose Reduce demand? flag is selected. This is the Quantity increased from the Order Control Summary table.
• merchandise dollars: The merchandise dollar total; increased each time you add item(s) in order maintenance by the extended price of the added item(s), or enter exchange item(s) in order maintenance by the extended price of the replacement item(s); decreased each time you cancel an item using a cancel reason whose Reduce demand? flag is selected. This is the Orders increased dollars from the Order Control Summary table.
• Cancelled: The number of orders, number of units, and merchandise dollars for orders cancelled for the selected date range. These totals include orders, items, or merchandise dollars only if the Reduce demand? flag for the cancel reason is unselected.
• number of orders: The number of orders cancelled (orders in Cancelled status; all order lines have been cancelled). This is the Orders cancelled number from the Order Control Summary table.
• number of units: The number of units cancelled, from the Quantity cancelled in the Order Control Summary table.
• merchandise dollars: The merchandise dollar total of cancelled items, from the Orders cancelled dollars in the Order Control Summary table.
• Closed/soldout: The number of orders, number of units, and merchandise dollars for orders soldout for the selected date range. The system considers an order line sold out if you process soldout order lines in order entry, order maintenance, or the Processing Auto Soldout Cancellations (MASO) menu option, or you cancel order lines with a cancel reason whose Reduce demand? flag is selected. However, the system updates only soldout orders and does not update soldout units, soldout dollars, cancelled orders, cancelled units, or cancelled dollars for these order lines.
• number of orders: The total number of soldout orders, including orders for which all order lines are sold out, or at least one order line is sold out and all other order lines have been cancelled using any cancel reason code. This does not include order lines that are sold out if other order lines exist on the order that are not sold out or cancelled. This is the Orders soldout/closed number from the Order Control Summary table.
• number of units: The total number of sold out units, from the Quantity soldout in the Order Control Summary table.
• merchandise dollars: The merchandise dollar total of sold out items, from the Orders soldout dollars in the Order Control Summary table.
• Shipped: The number of orders, number of units, and merchandise dollars for orders shipped for the selected date and accounting period as of the time you refreshed the screen. These totals are not decreased by returns or exchanges.
• number of orders: The total number of shipped orders, from the Orders shipped number in the Order Control Summary table. The setting of the Order Control Summary Shipment Update Method (I55) system control value determines how the system updates the # Orders shipped field in the Order Control Summary table; if this system control value is not set to ORDERS, the will not provide an accurate day by day audit of order shipment activity.
• number of units: The total number of shipped units, including shipped units confirmed. Does not include units for returns processed in order entry. This is the Quantity shipped from the Order Control Summary table.
• merchandise dollars: The merchandise dollar total of shipped items, including shipments confirmed. Does not include dollars for returns processed in order entry. This is the Orders shipped dollars from the Order Control Summary table.
• Ending open order balance: The number of orders, units, and total merchandise dollar value for the ending transaction date of the date range you selected.
• number of orders: The number of open and held orders as of the ending transaction date. The system uses this calculation to determine the ending number of orders; these fields are from the Order Control Summary table: open orders number + held orders number = ending number of orders.
• number of units: The number of units on open and held orders as of the ending transaction date. The system uses this calculation to determine the ending number of units; these fields are from the Order Control Summary table: Open backordered quantity + Open printed quantity + Open unprinted quantity + Held backordered quantity + Held printed quantity + Held unprinted quantity = ending number of units.
• merchandise dollars: The merchandise dollar total on open and held orders as of the ending transaction date. The system uses this calculation to determine the ending merchandise dollars; these field are from the Order Control Summary table: open backordered dollars + open printed dollars + open unprinted dollars + held backordered dollars + held printed dollars + held unprinted dollars = ending merchandise dollars.
Shipment summary: The number of orders, number of units, and total merchandise dollar value for shipments. The system provides totals by shipped orders, exchanged orders, and credited/returned orders.
• Shipped: The number of orders, number of units, and merchandise dollars for orders shipped for the selected date range. These totals are not decreased by returns or exchanges.
• number of orders: The total number of shipped orders, including returns processed by negative quantities in order entry (these returns update the number of shipped orders and the Returns fields, but does not update shipped units or shipped dollars) and shipped orders confirmed. A single order with multiple pick slips (for example, for ship alone items) updates the total by 1. An order with multiple ship-tos updates the total by the number of ship-tos. For example, an order with 2 ship-to addresses updates the total by 2. This is the Orders shipped number from the Order Control Summary table.
• number of units: The total number of shipped units, including shipped units confirmed. This does not include units for returns processed in order entry. This is the Quantity shipped from the Order Control Summary table.
• merchandise dollars: The merchandise dollar total of shipped items, including shipments confirmed. Does not include dollars for returns processed in order entry. This is the Orders shipped dollars from the Order Control Summary table.
• Exchanged: The number of orders, number of units, and merchandise dollars for items returned in exchange transactions for the selected date range. These totals include quantities and merchandise dollar value of the items returned in exchange transactions, not units and merchandise dollar value of items ordered in exchange. You can enter an exchange in order maintenance or Work with Return Authorizations (these totals increase only when you process the credit).
• number of orders: The total number of exchange transactions processed, regardless of whether the exchanges are on the same order. For example, an order with 2 exchanged order lines processed separately updates this total by 2; however, if the same 2 exchanged order lines on a single order are processed in the same transaction, the total updates by 1. This is the Exchanges number from the Order Control Summary table.
• number of units: The total number of units returned in exchange transactions, from the Quantity exchanged in the Order Control Summary table.
• merchandise dollars: The merchandise dollar total of returned items in exchange transactions, from the Exchanged dollars in the Order Control Summary table.
• Credited/returned: The number of orders, number of units, and merchandise dollars for orders returned for the selected date range. You can enter a return in order entry (via negative quantity ordered), order maintenance, or Work with Return Authorizations (these totals increase only when you process the credit). These totals include simple returns only, as opposed to exchanges.
• number of orders: The total number of return transactions processed and credited, regardless of whether the returns are on the same order. For example, an order with 2 returned order lines processed separately updates this total by 2; however, if the same 2 returned order lines on a single order are processed in the same transaction, the total updates by 1. This is the Invoices credited number from the Order Control Summary table.
• number of units: The total number of returned units, from the Quantity credited in the Order Control Summary table.
• merchandise dollars: The merchandise dollar total of returned items, from the Invoices credited dollars in the Order Control Summary table.
Open order summary: The number of orders, number of units, and total merchandise dollar value for backordered orders, printed orders, and reserved/unprinted orders as of the ending date on the report. The system provides totals by open orders, held orders, and open and held orders.
• Open: Open order totals as of the ending date on the report, broken out by:
• open number of orders: The total number of open orders; this is the number of orders in an open status. From the Open orders number in the Order Control Summary table for the ending transaction date.
• open backordered number of units: The total number of units on backorder that are located on open orders. This is the Quantity backordered from the Order Control Summary table for the ending transaction date.
• open backordered merchandise dollars: The total merchandise dollars of units on backorder that are located on open orders. This is the Open backordered dollars the Order Control Summary table for the ending transaction date.
• open printed on pick slips number of units: The total number of printed units on open orders. The total number of open printed units is the Open printed quantity in the Order Control Summary table for the ending transaction date.
• open printed on pick slips merchandise dollar total: The total merchandise dollars of printed units on open orders, from the Open printed dollars in the Order Control Summary table for the ending transaction date.
• open reserved/unprinted number of units: The total number of reserved units on open orders, from the Open unprinted quantity in the Order Control Summary table for the ending transaction date.
• open reserved/unprinted merchandise dollar total: The total merchandise dollars of reserved units on open orders, from the Open unprinted dollars in the Order Control Summary table for the ending transaction date.
• Held: Held order totals as of the ending date on the report, broken out by:
• held number of orders: The total number of held orders; this is the number of orders in a held status, from the Held orders number in the Order Control Summary table for the ending transaction date.
• held backordered number of units: The total number of units on backorder that are located on held orders, from the Quantity held backordered in the Order Control Summary table for the ending transaction date.
• held backordered merchandise dollar total: the total merchandise dollars of units on backorder that are located on held orders, from the Held backordered dollars in the Order Control Summary table for the most recent transaction date.
• held printed on pick slips number of units: The total number of printed units on held orders. This is the Held printed quantity in the Order Control Summary table for the ending transaction date.
• held printed on pick slips merchandise dollar total: The total merchandise dollars of printed units on held orders. This is the Held printed dollars in the Order Control Summary table for the ending transaction date.
• held reserved/unprinted number of units: The total number of reserved units on held orders. This is the Held unprinted quantity in the Order Control Summary table for the ending transaction date.
• held reserved/unprinted merchandise dollar total: The total merchandise dollars of reserved units on held orders. This is the Held unprinted dollars in the Order Control Summary table for the ending transaction date.
General operational summaries: The number of orders, number of units, and total merchandise dollar value for suspended orders, pending pick slips, pending RA receipts, pending RA credits, and pending refunds. The total number of suspended batches also displays.
• Suspended batches number: The total number of order batches that are in a suspended status. This is the Batches suspended number in the Order Control Summary table.
• Suspended orders: Total number of suspended orders, suspended units, and total dollar value of suspended orders, regardless if the order is batched.
• number: The total number of suspended orders; this is the number of orders in a suspended status. This is the Orders suspended number in the Order Control Summary table for the ending transaction date.
• number of units: The total number of suspended units, including units on backorder or on a held order lines. This does not include soldout units. This is the Orders suspended quantity in the Order Control Summary table for the ending transaction date.
• merchandise dollars: The merchandise dollar total of suspended orders, including units on backorder or on held order lines. This does not include merchandise dollars for soldout units. This is the Orders suspended dollars in the Order Control Summary table for the ending transaction date.
• Pending picks: The number of pending pick slips, number of units on pending pick slips, and merchandise dollars for pending pick slips. Pending pick slips are pick slips that have not yet been billed or voided. The system increases the pending pick slip number, units, and dollars for drop ship orders if the drop ship output defined for the vendor is drop ship pick slip; if the drop ship output defined for the vendor is drop ship purchase order or collaborative shipping, the system only increases the total units and total dollars pending and does not increase the total number pending.
• number: The total number of pick slips pending. This is the Pending picks number in the Order Control Summary table for the ending transaction date.
• number of units: The total number of units on pending pick slips. This is the total of the Open printed quantity and the Held printed quantity in the Order Control Summary table for the ending transaction date.
• merchandise dollars: The merchandise dollar total of items on pending pick slips. This is the total of the Open printed dollars and the Held printed dollars in the Order Control Summary table for the ending transaction date.
• Pending RA receipts: The number of pending return authorization receipts, number of units on pending return authorization receipts, and merchandise dollars for pending return authorization receipts. Pending return authorization receipts are return authorizations that have been entered, but not yet received. You can only enter a pending RA receipt using non-streamlined return authorizations (the Use Streamlined Return Authorizations (F44) system control value is selected). These totals include quantities and merchandise dollar value of the items returned in return transactions and items returned in exchange transactions, not units and merchandise dollar value of items ordered in exchange.
• number: The total number of pending return authorization receipts, regardless of whether the returns are on the same order. For example, an order with 2 pending RA receipt order lines processed separately updates this total by 2; however, if the same 2 pending RA receipt order lines on a single order are processed in the same transaction, the total updates by 1. This is the Pending RA receipt number in the Order Control Summary table for the ending transaction date.
• number of units: The total number of units on pending return authorization receipts. This is the Pending RA receipt quantity in the Order Control Summary table for the ending transaction date.
• merchandise dollars: The merchandise dollar total of items on pending return authorization receipts. This is the Pending RA receipt dollars in the Order Control Summary table for the ending transaction date.
• Pending RA credits: The number of pending return authorization credits, number of units on pending return authorization credits, and merchandise dollars for pending return authorization credits. Pending return authorization credits are return authorizations that have been received, but not yet credited. You can only enter a pending RA credit using non-streamlined return authorizations (the Use Streamlined Return Authorizations (F44) system control value is selected). These totals include quantities and merchandise dollar value of the items returned in return transactions and items returned in exchange transactions, not units and merchandise dollar value of items ordered in exchange.
• number: The total number of pending return authorization credits, regardless of whether the returns are on the same order. For example, an order with 2 pending RA credit order lines processed separately updates this total by 2; however, if the same 2 pending RA credit order lines on a single order are processed in the same transaction, the total increases by 1. This is the Pending RA credit number in the Order Control Summary table for the ending transaction date.
• number of units: The total number of units on pending return authorization credits. This is the Pending RA credit quantity in the Order Control Summary table for the ending transaction date.
• merchandise dollars: The merchandise dollar total of items on pending return authorization credits. This is the Pending RA credit dollars in the Order Control Summary table for the ending transaction date.
• Pending refunds: The number of pending refunds, number of units on pending refunds, and merchandise dollars for pending refunds. Pending refunds are refunds in an open or held status that have not yet been processed; these totals do not include refunds that are in a pending cancelled, cancelled, pending write off, write off, or processed status.
• number: The total number of unprocessed refunds. This is the Refunds pending number in the Order Control Summary table for the ending transaction date.
• merchandise dollars: The merchandise dollar total of items on unprocessed refunds. This is the Refunds pending dollars in the Order Control Summary table for the ending transaction date.
General merchandising summaries: The number of orders, number of units, and total merchandise dollar value for backordered items, open POs, held POs, docked POs, open past due POs, held past due POs, docked past due POs, suspense receipts, pending putaway inventory, and staged warehouse inventory.
• Backordered items: The number of items on backorder, number of units on backorder, and merchandise dollars of backordered items.
• number: The total number of items on backorder. This is the Backorder items number in the Order Control Summary table for the ending transaction date.
• number of units: The total number of units on backorder, across items. The system adds the Open backordered quantity and the Held backordered quantity in the Order Control Summary table for the ending transaction date to determine the total number of units on backorder.
• merchandise dollars: The merchandise dollar total for items on backorder. The system adds the Open backordered dollars and the Held backordered dollars in the Order Control Summary table for the ending transaction date to determine the merchandise dollar total of backordered items.
• Open PO: The number of open purchase orders, number of units on open purchase orders, and merchandise dollars of items on open purchase orders. Open purchase orders are POs that are in an open (O) status; this does not include drop ship POs.
• number: The total number of open purchase orders from the PO Header table. This is the Open PO number in the Order Control Summary table for the ending transaction date.
• number of units: The total number of units on open purchase orders from the PO Detail table. This is the Open PO quantity in the Order Control Summary table for the ending transaction date.
• merchandise dollars: The merchandise dollar total for open purchase orders from the PO Detail table. This is the Open PO dollars in the Order Control Summary table for the ending transaction date.
• Held PO: The number of held purchase orders, number of units on held purchase orders, and merchandise dollars of items on held purchase orders. Held purchase orders are POs that are in a held (H) status; this does not include drop ship POs.
• number: The total number of held purchase orders from the PO Header table. This is the Held PO number in the Order Control Summary table for the ending transaction date.
• number of units: The total number of units on held purchase orders from the PO Detail table. This is the Held PO quantity in the Order Control Summary table for the ending transaction date.
• merchandise dollars: The merchandise dollar total for held purchase orders from the PO Detail table. This is the Held PO dollars in the Order Control Summary table for the ending transaction date.
• Docked PO: The number of docked purchase orders, number of units on docked purchase orders, and merchandise dollars of items on docked purchase orders. Docked purchase orders are POs that are in a docked (D) status. The PO line status can be open (O) or held (H) to be included in these totals. If you partially receive a docked PO, the system updates the PO status from docked (D) to open (O).
• number: The total number of docked purchase orders from the PO Header table. This is the Docked PO number in the Order Control Summary table for the ending transaction date.
• number of units: The total number of units on docked purchase orders, from the PO Detail table. This is the Docked PO quantity in the Order Control Summary table for the ending transaction date.
• merchandise dollars: The merchandise dollar total for docked purchase orders from the PO Detail table. This is the Docked PO dollars in the Order Control Summary table for the ending transaction date.
• Open past due PO: The number of open purchase orders that contain purchase order lines that are past due, number of units on open purchase orders that are past due, and merchandise dollars of items on open purchase orders that are past due. This does not include drop ship purchase orders. Open past due purchase order lines are PO lines that have not yet been received and are past the expected due date (the Due date defined for the PO line is less than the current date) and the PO header status is open (O). The PO line status can be open (O) or held (H) to be included in these totals.
• number: The total number of open POs that contain PO lines that are past due from the PO Header table. This is the Open past due PO number in the Order Control Summary table for the ending transaction date.
• number of units: The total number of units on open POs that are past due from the PO Detail table. This is the Open past due PO liens in the Order Control Summary table for the ending transaction date.
• merchandise dollars: The merchandise dollar total for items on open POs that are past due from the PO Detail table. This is the Open past due PO dollars in the Order Control Summary table for the ending transaction date.
• Held past due PO: The number of held purchase orders that contain purchase order lines that are past due, number of units on held purchase orders that are past due, and merchandise dollars of items on held purchase orders that are past due. This does not include drop ship purchase orders. Held past due purchase order lines are PO lines that have not yet been received and are past the expected due date (the Due date defined for the PO line is less than the current date) and the PO header status is held (H). The PO line status can be open (O) or held (H) to be included in these totals.
• number: The total number of held POs that contain PO lines that are past due from the PO Header table. This is the Held past due PO number in the Order Control Summary table for the ending transaction date.
• number of units: The total number of units on held POs that are past due from the PO Detail table. This is the Held past due PO lines in the Order Control Summary table for the ending transaction date.
• merchandise dollars: The merchandise dollar total for items on held POs that are past due from the PO Detail table. This is the Held past due PO dollars in the Order Control Summary table for the ending transaction date.
• Docked past due PO: The number of docked purchase orders that contain purchase order lines that are past due, number of units on docked purchase orders that are past due, and merchandise dollars of items on docked purchase orders that are past due. This does not include drop ship purchase orders. Docked past due purchase order lines are PO lines that have not yet been received and are past the expected due date (the Due date defined for the PO line is less than the current date) and the PO header status is docked (D). The PO line status can be open (O) or held (H) to be included in these totals.
• number: The total number of docked POs that contain PO lines that are past due from the PO Header table. This is the Docked past due PO number in the Order Control Summary table for the ending transaction date.
• number of units: The total number of units on docked POs that are past due from the PO Detail table. This is the Docked past due PO lines in the Order Control Summary table for the ending transaction date.
• merchandise dollars: The merchandise dollar total for items on docked POs that are past due from the PO Detail table. This is the Docked past due PO dollars in the Order Control Summary table for the ending transaction date.
• Suspense receipt: The number of PO lines received into suspense, number of units received into suspense, and merchandise dollars of items received into suspense.
• number: The total number of PO lines received into suspense from the PO Suspense table, including PO lines that only have a partial quantity received into suspense. This is the Suspense receipts number in the Order Control Summary table for the ending transaction date.
• number of units: The total number of units on PO lines received into suspense from the PO Suspense table. This is the Suspense receipts quantity in the Order Control Summary table for the ending transaction date.
• merchandise dollars: The merchandise dollar total for items received into suspense from the PO Suspense table. This is the Suspense receipts dollars in the Order Control Summary table for the ending transaction date.
• Pending putaway: The number of PO lines received into a pending putaway warehouse, number of units received into a pending putaway warehouse, and merchandise dollars of items received into a pending putaway warehouse. A pending putaway warehouse is a warehouse where you place inventory that is on its way to its final destination. You can define a warehouse as a pending putaway warehouse by assigning a warehouse location type of PP (pending putaway warehouse) to the warehouse in Working with Default Warehouse Locations (WWDL). The system increases these totals when you receive a PO line or a partial quantity on a PO line into a pending putaway warehouse.
• number: The total number of PO lines received into a pending putaway warehouse from the Pending Putaway Detail table, including PO lines that only have a partial quantity received into a pending putaway warehouse. This is the Pending putaway lines in the Order Control Summary table for the ending transaction date.
• number of units: The total number of units received into a pending putaway warehouse from the Pending Putaway Detail table. This is the Pending putaway quantity in the Order Control Summary table for the ending transaction date.
• merchandise dollars: The merchandise dollar total of items received into a pending putaway warehouse from the Pending Putaway Detail table. This is the Pending putaway dollars in the Order Control Summary table for the ending transaction date.
• Staging warehouse: The number of PO lines received into a staging warehouse, number of units received into a staging warehouse, and merchandise dollars of items received into a staging warehouse. A staging warehouse is a warehouse that designates an area within your actual warehouse where you keep stock that needs to be put away. You can define a warehouse as a staging warehouse by entering the warehouse code in the Default Staging Warehouse (E15) system control value. The system increases these totals when you receive a PO line or a partial quantity on a PO line into a staging warehouse.
• number: The total number of PO lines received into a staging warehouse, including PO lines that only have a partial quantity received into a staging warehouse. This is the Staging inventory number in the Order Control Summary table for the ending transaction date.
• number of units: The total number of units received into a staging warehouse. This is the Staging inventory quantity in the Order Control Summary table for the ending transaction date.
• merchandise dollars: The merchandise dollar total of items received into a staging warehouse. This is the Staging inventory dollars in the Order Control Summary table for the ending transaction date.
Held Order by Reason Code Report
Purpose: This report list held orders in your company.
How to print: Complete the Print Held Orders Report Screen. You can also generate this report by selecting Print Held Orders at the Manage Held Orders page in Modern View.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Contents: This report page breaks on currency code. Within currency code, the system sorts held orders in ascending order by ship via priority, user hold, pay type hold, SH hold, and order number sequence.
• Selection Criteria: The selection criteria you selected at the Print Held Orders Report Screen, if any.
• Reason Code: The reason code you selected. ALL displays if you did not select a reason code.
• Pay Type: The pay type you selected. ALL displays if you did not select a pay type.
• Via Priority: The ship via priority you selected. ALL displays if you did not select a ship via priority.
• Currency: The report is broken out by currency. Both the currency code and the description are listed.
• For each hold reason code and ship via priority for the same currency:
• Reason: The system hold reason on the order. From OHD OHR Sys hold reason in the Order Header table. Blank for user hold reasons, which are grouped together and listed first, with the user hold reason code indicated in the left-most column for each order on user hold.
Note: The Awaiting Credit Card Auth (CW) hold reason is not included on the report.
• Ship Via Priority: The ship via priority for the ship via on the Order Header. From VIA Priority in the Ship Via table.
The following column headings apply to the data below the Reason and Ship Via Priority.
• User Hold: The user hold, if any. From OHD OHR Usr hold reason in the Order Header table.
• Payment Type Hold: The pay type hold, if any. From OHR Hold Reason in the Order Payment Method table.
• Ship To Hold: The ship to hold, if any. From OST OHR Hold Reason in the Order Ship To table.
• Order Number: The order number. From the Order # in the Order Header table.
• Payment Type Code: The pay type code; MLT displays if more than one pay type was used on the order. From PAY Pay type in the Order Payment Method table.
• Ship Via Code: The ship via code for the Order Ship To. From Ship via in the Order Ship To table.
• Customer Number: The sold-to customer number. From Customer # in the Order Header table.
• Name: The company name for the sold to customer. If a company name is not defined, this is the last name and first name of the sold-to customer. From NAM Company name in the Customer Sold To table or from NAM Last Name and NAM First Name in the Customer Sold To table.
• Telephone/Email: The sold-to customer’s day time phone number, followed by the first 29 positions of the sold to customer’s primary email address. From CS# Phone in the Customer Sold To Phone # table and CEM Email Address in the Customer Sold To Email table.
• Order Total: The total order value. From OST Add’l charges + OST Freight + OST Handling + OST Add’l freight + OST Tax + OST GST + OST PST + OST Merch in the Order Ship To table. Note: This total displays in the order currency, regardless of the setting of the Multi Currency by Offer (E03) system control value.
• Order Date: The date the order was placed. From the OHD Order Date in the Order Header table.
• Authorization Date: The most recent date when the credit card on the order was authorized. From the Auth Date in the Authorization History table.
• Total dollars on hold: The total order value for the system hold reason, or for all orders on user holds with the same currency. From OST Add’l charges + OST Freight + OST Handling + OST Add’l freight + OST Tax + OST GST + OST PST + OST Merch in the Order Ship To table for all orders with the specified system hold reason.
• Grand total [Currency code]: The total order value for the currency code. From OST Add’l charges + OST Freight + OST Handling + OST Add’l freight + OST Tax + OST GST + OST PST + OST Merch in the Order Ship To table for all orders on the report that use the same currency.
How to print: Enter DBST in the Fast path field at the top of a menu, select Printing the Daily Business Status Report (DBST) from a menu, or run the Daily Business Status Report periodic function (program name ACR0178).
For more information: See the sample report in PDF format.
Contents: Each field below indicates if the value is based on the Processing date you defined at the Daily Business Status Screen or the date you generated the report (job date). If the field indicates the value can be from either: the value is based on the Processing date if one exists; otherwise the job date is used to determine the value.
• Sales today: The merchandise dollar amount of sales today, based on the processing date or job date. This dollar amount includes shipments confirmed. This is the $ orders shipped from the Order Control Summary table.
• Sales MTD: The merchandise dollar amount of sales month to date, based on the processing date or job date. This is the $ orders shipped from the Order Control Summary table, based on the accounting period start and stop date.
• Cash today: The dollar amount of cash, based on the processing date or job date. This amount is from the Deposit amount field in the Cash Receipts Header table.
• Cash MTD: The dollar amount of cash month to date, based on the processing date or job date. This dollar amount comes from the Deposit amount field in the Cash Receipts Header table based on the accounting period start and stop date defined in Working with Accounting Periods (WACP).
• Inventory primary warehouse: The system uses this calculation, based on the job date, to determine the inventory for the Default Warehouse (A04): on hand quantity for primary warehouse x item cost = inventory for primary warehouse.
• Inventory all others: The system uses this calculation, based on the job date, to determine the inventory for all other warehouses besides the default warehouse: on hand quantity for all non-primary warehouses x item cost = inventory for all other warehouses.
• Orders entered today #: The number of orders entered, based on the processing date or job date. This includes the total number of ship-to addresses, orders which include only sold out items or non-inventory items, returns processed by negative quantities in order entry. This total does not include batch orders that have not yet been accepted. This total is not based on the date, but from the last time you cleared the daily totals (Daily Clear Process periodic function, program name MSR0574). This is the Orders entered number in the Order Control Summary table.
• Orders entered today $: The merchandise dollar total of orders entered, based on the processing date or job date. This includes merchandise dollar total of sold out items and non-inventory items. This total does not include merchandise dollars for items returned during order entry or merchandise dollars for batch orders that have not yet been accepted. This total is not based on the date, but from the last time you cleared the daily totals (Daily Clear Process periodic function, program name MSR0574). This is the Orders entered dollars in the Order Control Summary table.
• Orders entered month to date #: The number of orders entered for the month, based on the processing date or job date. This total is not based on the date, but from the last time you cleared the monthly totals (Monthly Clear Process periodic function, program name MSR0576). The system totals the Orders entered number value in the Order Control Summary table for each transaction date in the accounting period to determine the number of orders entered for the accounting period.
• Orders entered month to date $: The merchandise dollar total of orders entered for the month, based on the processing date or job date. This total is not based on the date, but from the last time you cleared the monthly totals (Monthly Clear Process periodic function, program name MSR0576). The system totals the Orders entered dollars value in the Order Control Summary table for each transaction date in the accounting period to determine the merchandise dollar total of orders entered for the accounting period.
• Average per order entered today $: The average merchandise dollar amount for the orders entered, based on the processing date or job date. The system uses this calculation to determine the average per order: orders entered today dollars / order entered today number = average per order entered today dollars
• Average per order entered month to date $: The average merchandise dollar amount for the orders entered for the month, based on the processing date or job date. The system uses this calculation to determine the average per order: orders entered month to date dollars / order entered month to date number = average per order entered month to date dollars
• Number of units entered today: The number of units ordered for the day, based on the processing date or job date. This includes the main set item as well as each component item, units of sold out items or non-inventory items. This does not include units returned in order entry, units on batch orders that have not yet been accepted. This is the Quantity ordered in the Order Control Summary table.
• Number of units entered month to date: The number of units ordered for the month to date, based on the processing date or job date. The system totals the Quantity ordered value in the Order Control Summary table for each transaction date in the accounting period to determine the number of units ordered for the accounting period.
• Packages shipped today #: The total number of shipped orders, based on the processing date or job date. This is the Orders shipped number in the Order Control Summary table. The setting of the Order Control Summary Shipment Update Method (I55) system control value determines how the system updates the # Orders shipped field in the Order Control Summary table.
• Packages shipped today $: The merchandise dollar total of shipped items, based on the processing date or job date. This includes shipments confirmed. This total does not include dollars for returns processed in order entry. This is the Orders shipped dollars in the Order Control Summary table.
• Packages shipped month to date #: The total number of shipped orders for the month to date, based on processing date or job date. The system adds the Orders shipped number in the Order Control Summary table for each transaction date in the accounting period to determine the total number of shipped orders for the accounting period.
• Packages shipped month to date $: The merchandise dollar total of shipped items for the month to date, based on processing date or job date. The system totals the Orders shipped dollars value in the Order Control Summary table for each transaction date in the accounting period to determine the merchandise dollar total of shipped items for the accounting period.
• Average per package shipped today $: The average merchandise dollar amount for the orders shipped, based on processing date or job date. The system uses this calculation to determine the average per package shipped: packages shipped today dollars / packages shipped today number = average per package shipped today dollars
• Average per package shipped month to date $: The average merchandise dollar amount for the orders shipped for the month, based on processing date or job date. The system uses this calculation to determine the average per package shipped: packages shipped month to date dollars / packages shipped month to date number = average per package shipped month to date dollars
• Number of units shipped today: The total number of shipped units, based on processing date or job date. This includes shipped units confirmed. This total does not include units for returns processed in order entry. This is Quantity shipped in the Order Control Summary table.
• Number of units shipped month to date: The total number of shipped units for the month to date, based on processing date or job date. The system totals the Quantity shipped value in the Order Control Summary table for each transaction date in the accounting period to determine the total number of shipped units for the accounting period.
• Warehouse value: The merchandise dollar amount of the inventory located in the specified warehouse, based on job date. The system uses this calculation to determine the dollar amount: units x item cost = item inventory value.
• Warehouse units: The number of units of the inventory located in the specified warehouse, based on job date. PRIMARY displays to the right of the primary warehouse (from the Default Warehouse (A04).
How to print: Complete the Order Reconciliation Report Screen.
For more information: See the sample report in PDF format.
Contents:
• dates included in the report. These are the dates you entered at the Order Reconciliation Report screen.
• gross demand (not including returns), broken out by:
• total number of orders: includes the total number of orders, regardless of whether an order is a multiple or single ship-to order
• total units of merchandise
• total merchandise value; not including shipping, handling, or other additional order charges
• open, broken out by:
• total number of open orders, regardless of whether an order is a multiple or single ship-to order
• total units of merchandise on open orders
• total merchandise value; not including shipping, handling, or other additional order charges
• held, broken out by:
• total number of held orders
• total units of merchandise on held orders; does not include units of merchandise held at the order line level
• total value of merchandise on held orders; does not include merchandise held at the order line level.
• cancelled, broken out by:
• total number of cancelled orders
• total units of merchandise cancelled on all orders
• total value of merchandise cancelled on all orders
• sold out, broken out by:
• total units of merchandise sold out on all orders
• total value of merchandise sold out on all orders
• closed/shipped, broken out by:
• total number of closed orders, including quotes
• total units of merchandise shipped
• total value of merchandise shipped
• returned, broken out by:
• total number of orders for which at least one item has been returned
• total units of merchandise returned
• total value of merchandise returned
Sales Journal by Currency Report
This report displays invoices and credit invoices based on the invoice date range and optionally, currency, you defined. The amounts on this report display in the local currency and alternate (foreign) currency.
How to print: Select Submit at the Print Sales Journal by Currency Screen.
For more information: See the sample report in PDF format.
Contents:
• invoice dates: the invoice date range you selected at the Print Sales Journal by Currency Screen.
• currency: the currency associated with the invoices and credit invoices. The system looks at the currency code defined for the order in the Order Header Extended table to determine the currency associated with the invoices and credit invoices. If the invoices and credit invoices are for the local currency, this field is blank.
• invoice date: the date when you shipped and billed the merchandise.
• pay plan type: the payment plan type associated with the order. Valid values are regular (no payment plan), deferred, and installment.
• pay type: the payment type associated with the invoice or credit invoice.
• invoice: invoice number; this is an invoice that falls under the currency, invoice date, pay plan type, pay type combination.
• customer: the number of the customer associated with the invoice.
• order: the order number associated with the invoice.
• merchandise: the merchandise amount on the invoice in the alternate currency. The system multiplies the local merchandise amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate merchandise amount. If the invoice is for the local currency, the merchandise amount displays in the local currency.
• freight: the freight charges for the invoice in the alternate currency. The system multiplies the local freight amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate freight amount. If the invoice is for the local currency, the freight amount displays in the local currency.
• additional freight: the additional freight amount for the invoice in the alternate currency. The system multiplies the local additional freight amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate additional freight amount. If the invoice is for the local currency, the additional freight amount displays in the local currency.
• tax: the tax amount for the invoice in the alternate currency. The system multiplies the local tax amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate tax amount. If the invoice is for the local currency, the tax amount displays in the local currency.
• handling: the special handling amount for the invoice in the alternate currency. The system multiplies the local handling amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate handling amount. If the invoice is for the local currency, the handling amount displays in the local currency.
• additional charge: the additional charge amount for the invoice in the alternate currency. The system multiplies the local additional charge amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate additional charge amount. If the invoice is for the local currency, the additional charge amount displays in the local currency.
• total invoice: the amount billed for the invoice in the alternate currency. The system multiplies the local invoice total by the conversion rate defined for the order in the Order Header Extended table to determine the alternate invoice total. If the invoice is for the local currency, the total invoice amount displays in the local currency.
• amount collected: the amount you have received from the customer in the alternate currency. The system multiplies the local collected amount by the conversion rate defined for the order in the Order Header Extended table to determine the alternate collected amount. If the invoice is for the local currency, the amount collected displays in the local currency.
• total credits: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoice credits grouped under the currency, invoice date, payment plan, pay type combination.
• XXX total credits (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoice credits grouped under the currency, invoice date, payment plan, pay type combination. This field displays only for invoice credits associated with an alternate currency.
• total invoices: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, payment plan, pay type combination.
• XXX total invoices (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, payment plan, pay type combination. This field displays only for invoices associated with an alternate currency.
• totals for pay type: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, pay type combination.
• XXX totals for pay type (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, pay type combination. This field displays only for invoices associated with an alternate currency.
• totals for pay plan type: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, payment plan combination.
• XXX total for pay plan type (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date, payment plan combination. This field displays only for invoices associated with an alternate currency.
• total for date: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date combination.
• XXX total for date (where XXX is the currency code): the totals in the alternate currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices grouped under the currency, invoice date combination. This field displays only for invoices associated with an alternate currency.
• grand total: the totals in the local currency for merchandise, freight, additional freight, tax, handling, additional charges, invoice total, and amount collected for the invoices across all currencies, invoice dates, payment plans, and pay types. A grand total in the alternate currency does not display on this report.
How to print: Use the Print Held Orders by Pay Type Prompt Screen.
For more information: See the sample report in PDF format.
Contents:
• Selected Pay type: The code and name of the pay type for which the report was run.
• Order #: The order number using the pay type.
• Name: The name and address of the bill-to customer (who will be invoiced for the order, if different from the person who placed the order); otherwise, the name and address of the sold-to customer (the person who placed the order).
• Credit Card Last 4: The last four digits of the credit card number that was used as payment on the order.
• Amount: Ordinarily the order total, regardless of pay type. However, if the customer used two different credit cards that belong to the same payment type (such as two different Visa cards), only the first credit card used on the order prints on this report. In this case, the Amount field indicates the amount to charge for that payment method only, and does not include the amount for the catch-all.
Example: If the order total is $150.00 and there are two payment methods with the same pay type on the order, with one for $50.00 and the other as the catch-all, the Amount indicated is $50.00.
• Final Totals:The total dollar amount of charges for this payment type that are associated with held orders.
Purpose: Use this report to review the price override reason codes used to discount items for a range of dates, and the total discount amounts and percentages applied.
How to print: Complete the Print Price Override Reason Report Screen.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Different report options: Depending on your selections at the Print Price Override Reason Report Screen, the report can include items with price overrides or the users who overrode prices, or be restricted to a single price override reason code:
Selections: |
Report Generated |
||
|---|---|---|---|
Price override reason code |
Include users |
Include items |
Price Override Reason Report by: |
yes |
yes |
yes |
User, Code and Item |
yes |
yes |
no |
User and Code |
yes |
no |
yes |
Code and Item |
yes |
no |
no |
Code |
no |
yes |
yes |
User and Item |
no |
no |
yes |
Item |
no |
yes |
no |
User |
no |
no |
no |
N/A (produces the Price Override Reason Report) |
Contents:
• Date Range. The Start date and End date entered at the Print Price Override Reason Report Screen. These are the original order dates, not necessarily the dates when the price override was applied.
• User ID and Description. Included only if you selected the Include users flag at the Print Price Override Reason Report Screen. The description is from Working with User Records (WUSR). See the Include users field for a discussion on how the system determines the user ID who performed the price override.
• Price Override Code and Description. The price override reason assigned to the order line. The description is from Establishing Price Override Reason Codes (WPOR). The system excludes any price override reason codes whose Exclude from price override report field is selected; see Default Price Override Reasons for a list of system-assigned codes specified in system control values. You can also limit the report to a single code by completing the Price override reason field at the Print Price Override Reason Report Screen.
• Item/SKU and Item Description. Included only if you selected the Include items flag at the Print Price Override Reason Report Screen. The item description is displayed even if the item has SKU’s.
Calculated fields: The following fields are calculated for:
• detail entries: by item/SKU or price override reason code, depending on your selections at the Print Price Override Reason Report Screen
• subtotals: by user, price override reason code, depending on your selections at the Print Price Override Reason Report Screen
• grand totals
• Units with overrides: The total number of units ordered whose price was overridden using the specified code. Note:
• This total is not decreased by units that have been canceled if the cancel reason code is not flagged to reduce demand. Also, it is not decreased by units returned against the original order line.
• This total is increased by returned units if the return was created by entering a negative quantity.
Example: If there were 10 units ordered and 3 units returned by entering a negative quantity, the total number of units is 13.
• Total discount: The total discount applied, calculated by subtracting the total selling price of all included units from the total offer price, and multiplying the result by the unit quantity. Note:
• The total discount includes the price of any returned lines created by entering a negative quantity.
Example: If the total amount discounted on ordered lines was $20.00 and the total amount discounted on returned lines was $5.00, this total is $25.00. If the returned lines had their prices increased $5.00 instead of decreased, then the total discount would be $15.00.
• This is a negative number if the price override resulted in a price increase.
• When an item has an offer price that is greater than zero and the item is added to an order at no charge, the Total discount = the offer price, and the Discount % = 100.00.
• When the Override Item Offer Price flag for a price override reason is selected and the item is added to an order at no charge, the Total discount and Discount % are both = 0.00.
• Discount Percent: The discount percentage, calculated by dividing the sum of the offer prices by the sum of the selling prices on order lines using the price override reason code. This is a negative number if the price override resulted in a price increase. See the notes above under the Total discount for information on when the Discount % might be 100.00 or 0.00. Note: The Discount % is not included in the grand totals.
Order lines included in calculations:
• The report includes overridden order lines on orders originally created in the selected date range; however, the prices could have been overridden at a later date.
• Orders that are in error or suspended status are not included on the report.
• Order lines that originated on quotes are included in the totals for the Price Override Reason for Quotes (K75) even after you convert the quote to an order unless you apply another price override reason code.
How to print: Complete the Print Return Reason Report Screen.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Different report options: Depending on your selections at the Print Return Reason Report Screen:
Selections: |
Report Generated |
|
|---|---|---|
Return reason code |
Include item |
Return Reason Report by: |
yes |
yes |
Code and Item |
yes |
no |
Code |
no |
yes |
Item |
no |
no |
N/A (produces the Return Reason Report) |
Contents:
• Date Range. The Start date and End date entered at the Print Return Reason Report Screen. The report includes returns processed on that date or later, regardless of when the order was originally created. Based on the Date from the return transaction in the Order Line History table; see the Display Order Line History Screen for more information.
NOTE: If you use Working with Return Authorizations (WRTA), this is the date you receive the return, which might differ from the date you create or credit the return authorization.
• Return Reason Code. From Establishing Return Reason Codes (WRTR).
• Return Reason Description. From Establishing Return Reason Codes (WRTR).
The following three fields are included only if you selected the Include item flag at the Print Return Reason Report Screen:
• Item.
• SKU. Included only if the item has SKUs.
• Item Description. The item description rather than the SKU description, even if the item has SKUs.
Calculated fields: The following fields are calculated for:
• detail entries: by item/SKU or return reason code, depending on your selections at the Print Return Reason Report Screen
• subtotals: by return reason code, if you selected the Include item flag at the Print Return Reason Report Screen
• grand totals
• Units Returned: The total number of units returned using the return reason code. If you use Working with Return Authorizations (WRTA), this total includes units that you have received, even if you have not yet credited the return and even if the return did not affect inventory. Returns you process by entering a negative quantity on an order are included in and increase this total.
• Amount Returned: The total value of the returns, based on the actual selling prices. The selling price of an item might be zero if it was a free gift or a component on a set.
How to print: Complete the Print Exchange Reason Report Screen.
For more information: See the sample report in PDF format.
Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.
Different report options: Depending on your selections at the Print Exchange Reason Report Screen:
Selections: |
Report Generated |
|
|---|---|---|
Exchange reason code |
Include item |
Exchange Reason Report by: |
yes |
yes |
Code and Item |
yes |
no |
Code |
no |
yes |
Item |
no |
no |
N/A (produces the Exchange Reason Report) |
Contents:
• Date range. The Start date and End date entered at the Print Exchange Reason Report Screen. The report includes exchanges processed on that date or later, regardless of when the order was originally created. Based on the Date from the exchange transaction in the Order Line History table; see the Display Order Line History Screen for more information.
NOTE: If you use Working with Return Authorizations (WRTA), this is the date you receive the exchange, which might differ from the date you create or credit the return authorization, or ship the replacement item.
• Exchange reason code. From Establishing Exchange Reason Codes (WEXR).
• Exchange reason description. From Establishing Exchange Reason Codes (WEXR).
The following three fields are included only if you selected the Include item flag at the Print Exchange Reason Report Screen:
• Item.
• SKU. Included only if the item has SKUs.
• Description. The item description rather than the SKU description, even if the item has SKUs.
Calculated fields: The following fields are calculated for:
• detail entries: by item/SKU or exchange reason code, depending on your selections at the Print Exchange Reason Report Screen
• subtotals: by exchange reason code, if you selected the Include item flag at the Print Exchange Reason Report Screen
• grand totals
• Units exchanged: The total number of units exchanged using the exchange reason code. If you use Working with Return Authorizations (WRTA), this total includes units that you have received, even if you have not yet credited the return and even if the return did not affect inventory. Returns you process by entering a negative quantity on an order are included in and increase this total.
• Amount exchanged: The total value of the exchanges, based on the actual selling prices. The selling price of an item might be zero if it was a free gift or a component on a set. The report does not indicate or factor in the prices of the replacement items.
1. Soldout control codes are user-defined and are similar to this: 01 = Sell out immediately; 02 = Include on order quantity in sold out calculation; 03 = exclude on order quantity in sold out calculation.
2. Soldout control codes are user-defined and are similar to this: 01 = Sell out immediately; 02 = Include on order quantity in sold out calculation; 03 = exclude on order quantity in sold-out calculation.
3. Soldout control codes are user-defined and are similar to this: 01 = Sell out immediately; 02 = Include on order quantity in sold out calculation; 03 = exclude on order quantity in sold out calculation.
4. Soldout control codes are user-defined and are similar to this: 01 = Sell out immediately; 02 = Include on order quantity in sold out calculation; = exclude on order quantity in sold out calculation.
5. This information appears only if the Tax Included in Price (E70) system control value is selected. On orders subject to VAT, tax does not accumulate in the Tax bucket; instead, a “hidden tax” is included in the order detail line and the customer pays a tax-inclusive price for each item. For such orders, the Merchandise total indicated is net of VAT. In other words, if the customer paid $10.00 for the merchandise, but a $1.50 hidden tax was included in the order detail line, the merchandise total would be $8.50.
________________________________
Contents SCVs Reports XML Messages Glossary
Copyright © 2022, Oracle and/or its affiliates. All rights reserved.
Legal Notices