The Inventory Dashboard: Purchase Request Manager displays a list of parts that have been requested from various locations in iPoint. The requests could come from Sales Orders, Projects, Work Orders, or Invoices. You’ll see the:
- Created – the date when the request was created
- Created By – the name of the user who created the request
- Required By – the date the part requested is needed
- Memo – if a note was entered on the purchase request, it will be displayed here
- Originated – each line shows the name of the sales order where the request came from.
Clicking on any of the line items will open the Purchase Request Manager (PRM) filtered by that specific request.
Clicking the Go To Purchase Request Manager button will open the full, unfiltered PRM.
The Purchase Request Manager or PRM is the dashboard for your purchasing and warehouse managers to allocate and buy the items you’ve sold to your customers. Parts appear on this list when they have been requested through a Sales Order, Project, Work Order, or Invoice. The list displays
The list shows all of the parts and is broken down into five colored categories.
- A yellow header is used to summarize the Class assigned to the jobs where the part is requested.
- The black header displays the Vendor where the product will be purchased from.
- The teal header shows the Manufacturer of the items.
- The tan header shows the Part Number, Item Number, or both. This line also displays the total number of the item required, received, ordered, on-hand, or available throughout the company.
- The white section shows the individual parts needed for various jobs, each on a separate line.
Clicking on each of these headers will provide various levels of additional information.
Vendor Header Details
Item Header Details
Click on the tan Part header to open details about the individual part. These details come directly from the Item master in the Items module, and changing any detail here also updates the master record.
- manufacturer is the name of the manufacturer who makes the part
- category is the category filter assigned to the product
- type is a secondary filter assigned to the part.
- item is the name of the item as it will appear on sales documents
- Part Number is the manufacturer part number that will appear on purchasing documents.
- Inventory Type tells you if the item is inventory or non-inventory. This field is not-modifiable here.
- Color is the color of the item.
- Vendor Name is the default vendor where you typically by the part.
- Unit Cost reflects the cost listed on the Item master record.
- Unit Price is the amount that the part sells for to our customer. Note this is the master price and not necessarily the price the item was sold for on an individual sales order, project, or invoice.
- Sold, Received, and On Order give you a quick visual on the status of inventory that has been sold to the customer, received from a purchase order (this includes staged/allocated parts), and the quantity on unfulfilled purchase orders.
%(color-red)Note: %This information is also available by clicking on the individual items listed under a job. The difference is that the quantities reflect the individual line (rather than the collective parts across all jobs). This view also provides details about re-order and maximum stock levels, as well as quantities available and on hand. These numbers are typically used for staging products, which we’ll discuss soon.
Job Header Details
To reveal details about the project where the part is requested, click the job name in the white section of the list.
If the job is a sales order, you’ll have these fields available:
- Required By is the date that the item is needed by. This was set by the salesperson or project manager on a sales order.
- Client Name is the name of the entity buying the product.
- Design Name is the name of the sales order
- Location lists where the item is being installed – this comes from the location of the part as assigned on the Proposal/Sales Order.
- Status shows the Sales Order Status as defined on the Info tab of the sales order.
- versionNumber represents the revision number of the sales order and is determined by which proposal revision was used when it was converted to a sales order.
- Designer Name is the Sales Staff Name on the sales order.
- Project Manager Name comes from the Project Manager on the sales order.
- Proposal Type reflects the Proposal Type field on the proposal. This sticks to the sales order when it is converted, although it is not editable on the sales order.
- Item is the *Iten Name*from the item master.
- Purchase Description comes from the item master where there are three item descriptions, one of which is the Purchase description.
- Request Memo is entered by the salesperson or project manager when they requested the part on the Product Manager of the sales order.
- Funds Available/Needed refers to the money that has been received via RFP invoices as compared to what has been delivered. This is helpful to see if you’ve been paid for the items ordered or not.
- Go To Sales Order button is your shortcut to the Sales Order.
If the part was requested from a Project, Work Order, or Invoice, your available fields are a bit different.
- Required By is the date that the item is needed by. This was set by the project manager on the project or the technician on a work order.
- Client Name is the name of the person or company buying the item.
- Ref # is the Project Ref#.
- Location is the name of the room or location where the product is installed.
- Purchase Description comes from the item master where there are three item descriptions, one of which is the Purchase description.
- Request Memo is entered by the individual who requested the part.
- Go To Project, Go To Work Order, or Go To Invoice buttons takes you to the individual document where the item was requested.
The displayed job names will have one of three colors. Black – indicates a current product request. Blue – indicates the product request is due today. Red – indicates that the due date for this item has passed.
Each item shows the:
- Date Required – when the part needs to be available. This is set by the person requesting the parts.
- The Customer/Job name – where the part is needed
- The job Name – this might be a work order, project name, or sales order reference.
- The Cost of the item – as determined by the Item record in the Items module.
- The number of items Required – to fulfill the job. This number is the quantity sold minus any quantity that has been delivered.
- The quantity Received represents the number of items that are allocated or have been delivered to the customer.
- Ordered reflects the quantity of the item that is on a Purchase Order and has not yet been received.
- On-Hand reflects the number of items that are physically in one of the warehouse locations. This information is helpful because you might need to steal an item from a job not being installed for a while to use on a job that is being installed right away.
- Available tells you the number of items that are available to sell to your customer. They are in the warehouse(s) and not allocated to a particular job.
The Options button, like other places in iPoint, give you the ability to adjust the list of items on the Purchase Request Manager.
The Filters tab helps you adjust the displayed list of items to quickly find the items that need to be ordered or staged in your company.
- Summarize By gives you the ability to display the list in over a dozen different ways.
- Class / Ven – organizes the list of parts by the class tied to the related jobs and then shows each vendor under each class.
- Class / Ven / Man – expands the list above to include the manufacturers under each vendor.
- Class / Ven / Man / Part – adds the individual parts under each manufacturer.
- Class / Ven / Man / Part / Due – includes the due date for each individual purchase request
- Class / Ven / Man / Part / Due / Line – adds the individual sales order line references for each part.
- Note: The same options are available sorted first by Vendor or Manufacturer
- Due / Part – shows the parts sorted by the date the product is requested to be available. There is no vendor reference when viewing this layout.
- Due / Part / Line – adds the ability to allocate inventory to the parts sorted by due date.
- Filter by Class lets you choose a specific class of products to be displayed. Classes are set in Settings > QuickBooks > Lists.
- Filter by Due Date shows only parts that have been requested to by the date entered. Any future dated requests will not be displayed.
- Filter Stock can show or hide stock requests. Stock requests are not associated with a sales order, project, work order or invoice. These are items requested to increase available inventory levels.
- Show Only gives you the ability to filter out products based on their order status.
- Show All – shows every product request
- Needs Ordered – shows items that are not allocated from existing inventory or included on a purchase order.
- On Order – displays only items that are on purchase orders.
- Pending Transfer – shows only items that are being transferred from one location to another. On a Stock Transfer/Request Form.
- Available Stock – shows only requested items where inventory is in stock. This is designed for warehouse staff to use any existing inventory to fulfill product requests.
- No Available Stock – when product is requested that is not in inventory, it will appear on this sort. This is a great way to find things that need to be ordered.
- View Item Name or Part Number is where you decide what part number information is displayed on the PRM list.
- Item Number – will display the sales name as defined on the Item Master.
- Part Number – displays the Manufacturer Part Number as entered on the Item Master.
- Both – displays both the Item Name and Part Number.
- Filter by Sales Order Ref # – lets you look for all the product for a particular sales order. The dropdown list shows all active sales orders sorted by customer name/job name.
- Filter Selected – is where you can Show Only items that you’ve checked on the item list. You can also Hide the items you’ve checked.
- Sites – use this dropdown to display parts needed from a specific store/site. This is used by companies with multiple stores in multiple locations.
- Show On Order Red Color When PO No Submitted – with this option selected, the quantity on order will display red numbers if the purchase order has not been marked Submitted.
The Delete button removes any request that has been checked. This button does not delete the items on the list. It simply deletes the request for the item. So, if the item was requested on a Sales Order Product Manager, the requested box will be unchecked. However, the part stays on the sales order for requesting at a later date.
This button updates the information on the PRM list of items. There are a number of places in the software where the product can be requested, added to purchase orders, and so on. A programming script updates the PRM list with changes made in other modules. However, some changes can take place in the minutes between the update script firing. If you believe that the numbers displayed on the PRM are inaccurate, click this button to force the script to run now, instead of waiting for the coded time.
Allocating Existing Product
Before you order any items on the PRM, you may want to allocate existing inventory available in your warehouse. You will know you have product available to allocate by looking for quantities in the Available column of the PRM.
- On the Purchase Request Manager, select the Options button
- Choose any of the Summarize By items that have the / Line option. The line option is where you can allocate specific items
- Now, click on the quantity requested on the individual part line item. In our example, you would click on the 1 in the Required column next to the “1 Button Dimmer Light” listed under the “Bekinsale, Kate” project. Note: You won’t be able to click on the quantity required in the tan Item header.
- Clicking on the individual item’s quantity required opens an Inventory Details popover window that shows all of your existing warehouse locations with Available inventory quantities.
- Click the Stage button next to the warehouse location where you will be moving the inventory from.
- Choose the Transfer To location from the dropdown.
- Verify the Transfer Qty.
- Click the Save Transfer button. iPoint will move the inventory from the Warehouse – Available location into the Transfer To – On Hand location. The item will also be marked as staged on the sales order, project, work order, or invoice where the product request came from.
- Back on the PRM list, you’ll see that the Available inventory of the item header has been reduced and the Received on the individual item line quantity has increased.
Using the Purchase Request Manager is fairly simple. This tutorial will walk through the process of adding items from one distributor to a purchase order.
In front of each line, you see a + and – button. This is you go about selecting or de-selecting items.
Clicking the + on a Manufacturer line, for example, will select all items associated with that manufacturer.
Clicking the – on a Part line will de-select all of that part for all job requests in the system.
- Select the items from the vendor you want to purchase by checking one + or – by vendor, manufacturer, job, or individual product.
- Once the items you want to order from your vendor are selected, click the Create PO button.
- iPoint will prompt you to verify the vendor you are ordering from.
- Now the Purchase Order will be created for the vendor chosen and the selected items. – We go into more details on the Purchase Order itself here.
Alternately, you can add the selected product to an existing purchase order by clicking the . This will open a pop-up window displaying all the available Purchase Orders for a particular vendor.
- Choose the desired vendor from the Select Vendor dropdown.
- All available purchase orders are available. A Purchase Order is available if it is not marked as Submitted, which is the iPoint indicator that the PO has been sent to the vendor.
- Click the Add to PO button and the selected items will be added to the PO you just chose.
- Clicking the red View PO button will open the PO without adding the selected items so you can verify which PO you are adding the product to.