MI100: Purchase Orders

The MI100 report displays Purchase Orders that were created during the date range, displayed in one of three modes: Invoice Mode, Received by PO, or Received by Manufacturer.

Report definitions

Click here for details on each of the fields that appear in the MI100 report.Click here for details on each of the fields that appear in the MI100 report.

Invoice Mode

  • PO#: The PO number.
  • Distributor Ref #: Distributor's reference number that was entered in the PO.
  • Account#: The account number associated with the distributor in the Distributor's maintenance form.
  • Created on: The date the PO was created.
  • Created by: The login associated with the creation of the PO.
  • Inventory Type: Indicates the product's Inventory Type as defined in the product definition. This column displays only if Retail/Shop was selected during the creation of the Purchase Order.
  • Line: This corresponds with the line numbers in the PO.
  • Barcode: The barcode of the product being ordered according to the product definition.
  • Description: The SKU/Code, Display Name, and attributes of the item being ordered.
  • Dist Product ID: If the PO is for one distributor, this column will display if any products in the PO have a distributor ID.
  • On Hand: Displays the current on-hand number if the PO is not yet received and the corresponding option is enabled in the report setup screen.
  • Ord: Quantity of item ordered according to the PO.
  • Rec: If items have been received, this columns indicates how many.
  • Unit Price: The cost of each item being ordered.
  • Line Total: If no items have yet been received, the formula is: (Qty x Unit Price). If at least 1 item has been received, the formula is: (Received x Unit Price)
  • Notes: Displays any notes that were entered during the creation of the PO.
  • Totals: Total cost of all items on Purchase Order according to the sum of all rows under the Line Total column.

Received by PO

  • Line: This corresponds with the line numbers in the PO.
  • Order Qty: Quantity of item ordered according to the PO.
  • Rec: The number of each item that was received.
  • Inventory Type: Indicates the product's Inventory Type as defined in the product definition.
  • Barcode: The barcode of the product being ordered according to the product definition.
  • Product: The SKU/Code, Display Name, and attributes of the item being ordered.
  • Line Total: (Received Qty x Unit Price)
  • Subtotal: Total cost of all items on Purchase Order according to the sum of all rows under the Line Total column.
  • Shipping & Handling: Shipping and handling cost according to what was entered on the PO screen.
  • Tax: The sum of all tax lines, if any.
  • Totals: (Subtotal + Shipping & Handling + Tax total)

Received by Manufacturer

  • Order Qty: Quantity of item ordered according to the PO.
  • Rec: The number of each item that was received.
  • Inventory Type: Indicates the product's Inventory Type as defined in the product definition.
  • Barcode: The barcode of the product being ordered according to the product definition.
  • Product: The SKU/Code, Display Name, and attributes of the item being ordered.
  • Line Total: (Received Qty x Unit Price)
  • Subtotal: Total cost of all items on Purchase Order according to the sum of all rows under the Line Total column.

Setting up the MI100 report

  1. Type MI100 in the Convobar, or go to Meevo > Reports > Inventory, and then select the MI100 report.
  2. Select the mode:
  • Invoice Mode: The report displays an invoice for each selected Purchase Order (shown in the image above).
  • Received by PO: The report displays, for each selected PO, its status, all items ordered, and how many of each item were received.
  • Received by Manufacturer: The report displays all products that were received in the date range, sorted by manufacturer.
  1. Select a date or date range for running the report:
  • To run a report for a specific date range, select Custom and specify the Start Date and End Date for the report.
  • Otherwise, select a predefined date or range (Yesterday, This Week, Last Week, etc.).

Note: If you select a predefined range (a date other than Custom), you can still change the Start Date and End Date. Doing so automatically changes the date range to Custom.

  1. Display On-Hand Amounts if PO Not Received (Invoice Mode only): If the PO was not yet received, this shows the current On-Hand count.
  2. All Purchase Orders (Purchase Order mode only): Define which Purchase Orders to include in the report. If you deselect All Purchase Orders, use the list to specify which to include.
  3. Sort report by (Summary of Received Items mode only): Choose to sort the report by Distributor or Manufacturer.

Running the report

  1. When you are ready to generate the report, select a Report Format beside the Run Report button.
  2. Here is a rundown of each format type:
    1. PDF: Each time you select Run Report with PDF selected, Meevo opens a separate browser tab that displays the PDF'ed report. Meevo remains on the setup page, so you can quickly jump back over to Meevo to run more date ranges or other reports. Each PDF report you run will open its own browser tab, so you can easily review and compare reports by simply jumping between browser tabs.
    2. HTML: This is our original legacy format, which opens the report within Meevo. All of the functionality within that report is still there and available via the toolbar.
    3. XLSX: Each time you select Run Report, your browser auto-downloads the report in .xlsx format. Select the downloaded file in the browser footer to open the spreadsheet.
  3. Select Run Report to generate the report in your chosen format. Depending on the type of report and criteria you entered, this process may take a few minutes.