The Items tab consists of options for the Items and Inventory modules.

item OptionsItem Options

Options

  Default No Discount – A check in this box will cause the No Disc. box to be checked on all newly created items. Marking an item as no discount means that users are not able to lower the sales price of an item in the system. Additionally, iPoint will not reduce the price of items when using automated modifiers. Note: Checking this box does not modify existing parts.

  Base Calculations on Adjusted Cost – With this option checked, iPoint will calculate the sales price of an item based on the Adjusted Cost rather than the Hard Cost. As an example, if you have a hard cost of $12.99, but an adjusted cost of $14.00 and then do a 30% margin, the Unit Price will be $20.00 (adjust cost X 30%) instead of $18.56 (hard cost X 30%).

  Always Show All Types – When selecting Manufacturer, Category, and Type filters on an item, the Type filter only displays options that are associated with Categories on other items. So searching for a Category Display Device will only return Projector, LED, and LCD types and exclude all other Types that are not associated with display devices. Enabling this option will show all item Types as defined in Settings > Pop Up Lists > Item Type from settings instead of filtering based on Category.

  Show Installed Price in List View – When looking at the Items list, the prices displayed are the item’s sale price. Checking this box will cause the list to show the installed price instead of the item price. The installed price is the Item Price + (Labor Phase rate X Labor Time)

  Skip Label Printer Setup – When printing a computer program sends a series of instructions to the printer in a handshake designed to help the printer select the right paper size and type. Sometimes this handshake breaks the formatting of the Item Labels and causes misalignments or other misprints. Checking this box will repress the software handshake, allowing the settings to be hardcoded in the printer driver

  Lock Price on Margin – When creating items, you can enter a Hard Cost and Unit Price independently of each other. iPoint calculates the margin based on these two fields. Checking this box will cause the calculation to be based on the margin field. So if you have a 50% margin set and modify the cost to be $30, the software will automatically set the price to be $60. Note that selecting this option will hide the Lock Price on the Markup option below.

  Lock Price on Markup – This option works just like the margin option above, except that calculations are based on the markup field. Checking this option will hide the Margin option above.

  Always Open Portal Library In A New Window – Clicking on the Portal button in the Items module opens a pop-over window that is tied to the item list. Checking this box causes the Portal window to open in its own window making it possible to move to another screen or another location on your computer monitor. (For more information on Portal, visit Settings > Integrations > Portal)

  Default New Items to Non Taxable – There are a few states that don’t have sales tax! Say it isn’t so! If you are in one of those states, check this box and all new parts will have the Taxable checkbox un-checked. – New in 10.0604

  Default New Items to Non-Inventory – With this box checked, any new item, even those imported from Portal, will be set as Non-Inventory by default.

  Use Part Numbers in RMA Items List – By default, entering a part in the Product field of an RMA shows parts based on the Item Name. Checking this box causes the search to use the Manufactuer Part Number instead.

  Auto-Remove Text Formatting on Descriptions – if the description of an item has formatting (i.e. bold, underline, or size variance) it will be removed by checking this box. Leaving the box unchecked allows for descriptions to have formatted text.

Custom Group Summary

A Custom Group Summary (CGS) report is a detailed report of specific item details for each equipment group. This report can be used on its own or added to a proposal package.

The Initialize Custom Group Summary button and Custom Group Field Name list is used to set up this detailed report. Click here for complete instructions on setting up and using the CGS.

Inventory LocationsInventory Locations

Inventory Locations

Inventory locations are the physical places inventory will be stored in your company. Here are some suggestions for locations you might create for your company:

  • Warehouse – the primary storage location for items
  • Staging – the location where sold goods are stored before installation
  • Van 101 – each service vehicle could be a location so van stock can be tracked
  • Showroom – a way to designate equipment that is on display and not readily sellable
  • RMA/Defective – where to store equipment that is in process of being repaired or returned to vendors

Before we create a new location, we’ll review a couple of options.

  Enable Multi-Site Inventory – creates a second level of inventory locations, typically when a company has multiple storefronts.
Note: Once you have created a parent location, this checkbox cannot be unchecked.

  ALWAYS Require Site – For companies with multiple locations, checking this box will require a Site to be entered on a Proposal and Invoice.

.
.
.
.
.
.
.
.
.
.

Create New Locations

Add New Location windowAdd New Location window

Add New Inventory Location button
To create a new Inventory location, click the Add New Inventory Location button to open the Inventory Location entry screen.

  Site Location – Check this box to create a parent location. For example, if you have stores in Salem and Portland, you would create two parents, “Salem” and “Portland”. Then under each location, you would have a warehouse, staging, vans, and so on. This location is a Site and is a hierarchal parent to other locations. No inventory can be allocated to or from a site.

Checking the Site Location box gives you the ability to enter site-specific names, contact, address, and tax rate. It also hides the “Default Location” checkbox described below.

  Default Location – Checking this box marks the default location at a site for allocation purposes. In our example above, Salem and Portland both have warehouse, staging, and van locations. Marking the warehouse as default in Salem makes it the default location. However, Portland is a much bigger site and as such also has a Receiving Dock location where all inventory is first received. So in Portland, the Receiving Dock will be marked the Default Location.

Other fields in the New Inventory Location window are:

  • Name – the name of the warehouse location
  • Attention – a text field where you can enter the name of the person who receives inventory at that location. This is printed on various documents in iPoint.
  • Address Street – this required field is the delivery address for the location.
  • Address City – the required city.
  • Address Zip – the required postal zip code.
  • Address Country – useful if you have locations in multiple countries.
  • Description – an internal description for this location
  • Tax Rate – set the tax rate for this location from the pop-up tax rate list. The tax rate is used on invoices so that retail stores charge the correct sales tax for over-the-counter sales.

Edit Locations

Edit Location button
Each location in the Inventory Locations list has an Edit button. Clicking the button opens an Inventory Location Edit window where you can modify information about the specific location.

Site Locations, listed in blue, have the following fields available:

  Archive – check this box if you want to inactivate a location. There is no delete function available since iPoint will maintain the history for transactions in each location. Archiving the location will keep the site from being referenced in the software but still maintain past transactions. Note: Archived locations WILL be displayed in the Item Stock tab if there is inventory still available.

In addition to the Name, Description, Tax Rate, and Shipping Address which you set up when the location was created, you can also enter Billing Address information.

  Invoice Company Override activates additional fields where you can define a specific Logo, Company Name, and Company Address Info for use on invoices generated for the site. This is useful if your sites have unique branding or address information that is different from the company details set up in iPoint Settings.

To add a site-specific logo, right-click in the Logo field and choose *Insert Picture…” Then you will navigate to the directory on your computer where the logo is stored. Or, you can copy the image from your editing software and paste it in the field by right-clicking and choosing *Paste.”

Editing a warehouse location within a site removes the ability to change address and logo information. But you can still Archive, change the Name and Tax Rate, as well as assign the location to a specific Parent Location or site. Additionally, you can check the   Default Location checkbox to define a location as the primary warehouse for allocating product to jobs.

To the far right of each location is a sort field. Placing numbers here will organize the list in numeric order. Put the frequently used locations at the top of the list.

The Toggle Archived button at the bottom of the list of inventory locations will hide or display any locations that have been marked archived.


Item Defaults

This section defines default settings for new items as they are created in the Items Module.

Items Default Image If you enter an image here, it will automatically be included when you create a new item. This is so that future new items will automatically have an image when printed. Just like other defaults elsewhere in the system, it can be changed on an item-by-item basis.

  • To add a default item image, right-click in the field and use the pop-up menu to Insert Picture by navigating to the directory on your computer and clicking on the image. Alternatively, you can copy the image onto your computer’s clipboard and then Paste it into the image field.

Add’l Settings Defaults The Item Additional Settings tab has several settings that define how an item is used throughout the software. Here, you can define the defaults for new items as they are created. Checking various boxes here will cause new items to inherit those defaults. Of course, on the item itself, these defaults can be modified on an item-by-item basis.

  • Hide Manufacturer – when printing a proposal, the manufacturer for the item will not be printed
  • Hide Item Name – hides the item name on a printed proposal
  • Hide Item Picture – causes the item picture to be hidden on printed proposals
  • Disable Label for Each Qty Sold – causes only a single job tracking label to be printed when the item is ordered in bulk (e.g. Only one label for a spool of 1,000 feet of wire instead of 1,000 labels being printed for each foot.)
  • Disable Task Creation from Sales Order – normally, every item on a proposal is available in the Project Task creation process so that there is a task for technicians to complete on every item sold. Checking this box will cause this item not to appear in the task creation window, so no task will ever be added to a technician’s work order. You might use this option if the item is a package of other items and you want individual item tasks rather than a single task for the entire package.
  • Disable Item Display Label for Each Qty Ordered – this causes only a single Stock label to be printed when bulk quantities are ordered.
  • Track Use Tax on Qualified Sales – Use Tax is generally defined as a tax on the storage, use, or consumption of a taxable item where no sales tax has been paid. This can be a fairly complex tax calculation and can vary dramatically from state to state. If your company has set up iPoint to track Use Tax, you’ll have the opportunity to mark this item as something where Use Tax can be calculated.
  • Hide on Product Manager and Product List – normally, every line item that is sold to a customer will appear on the sales order’s product manager so that the item can be staged or ordered. Checking this box will keep the item from being available on the Product Manager at all so there is no possibility of the item being ordered or staged/allocated. This option also excludes parts from the Product List Report in the Sales Order.
  • Run Notification When Item is Fully Allocated – this causes the Product Request Allocated in Full notification to be run once the item has been fully allocated. This notification is defined in the Notification Builder.

Select Credit Card TerminalSelect Credit Card Terminal

TransNational Credit Card Terminal

If your company is using a credit card terminal device from TransNataional, you can define the default terminal used for each Site. At the bottom of the Site Edit window, you’ll see the default CC Terminal, if one is selected. Click the Select Site CC Terminal button to open the list of available credit card terminals where you can add or change the default device.

Learn more about TransNational credit card terminal setup in Settings > Integrations > Credit Card Processing.


Product Customer Tracking LabelsProduct Customer Tracking Labels

Product Customer Tracking Labels

Tracking labels are printed for items that are staged for customers’ jobs. The label helps identify that a particular part has been staged for the customer in the system and is not available for sale on another job. Additionally, the label can help technicians in the transfer and delivery of equipment. A technician can use their iOS device to scan the QR code on the label to move parts through the work order process. Printing of labels occurs on the Purchase Order Receipt and on the Sales Order > Product Manager.

  Enable QR Codes will print the QR code on the label as shown below:

Tracking LabelTracking Label

  Do Not Print until Required Serial Added – which this option checked, you will not be able to print the QR labels in the Purchase Order or from the Product Manager screen of a Sales Order unless a serial number has been entered for the item.

Next, you need to define what printer you have. Check the radio button next to the printer/label combination you have.

  • Dymo 450 with 1 1/8 × 3 1/2 in labels
  • Dymo 450 with 2 1/8 × 4 in labels
  • Brother QL-7xx printer
  • Zebra printer

The Printed Label text box is where you can customize the information printed on the label.

You’ll notice that checking the Enable QR Codes box reduces the available label space for the customized text.

To customize, place your cursor in the text box and click on one of the Merge fields to the right. Repeat until all the information you want is on the label.
You can also type in the field as well as format the text using the Format menu at the top of the FileMaker window.

  • { Customer Full Name } – the first and last name of the customer
  • { Customer Last Name } – the customer’s last name only
  • { Customer/Job Name } – the customer name and job name
  • { Proposal Name } – the customer’s name followed by the name of the job as entered on the Sales Order
  • { Ref # } – the Sales Order #
  • { Sales Rep } – the company user whose name appears in the Sales Staff Name field of the Sales Order
  • { Description Sales } – the part’s Sales description from the Item Details
  • { Location } – the location or room name on the designer where the product is to be installed
  • { Group } – the equipment group that the item is labeled on the sales order
  • { PO Number } – the purchase order number where the product was purchased
  • { Phase } – the phase of the item as designated by the Labor Phase
  • { Qty } – the number of items sold on a particular line of the designer
  • { Project Manager } – the company user who’s named appears in the Project Manager field of the Sales Order
  • { Description Purchase } – the part’s Purchase description from the Item Details
  • { Item } – the Item Name of the product as defined on the Item Detail
  • { Part Number } – the Manufacturer Part Number as defined on the Item Detail
  • { Serial Number } – the serial number entered on the Purchase Order during item receipt
  • { Manufacturer } – the manufacturer of the item as defined on the Item Detail
  • { Printed Date } – the date the label was printed
  • { Job Title } – the name of the job where the part is added
  • { Description Tech } – the part’s Tech description from the Item Details
  • { Project Name } – the name of the project where the part is added
  • { WO Name } – the name of the work order where the part is added
  • { SO Related Customer Name } – the name of the Related Customer from the sales order (Not the Bill To customer)
  • { Job Name } – the name of the Job from CRM. For example, you have a customer “Builder, Bob” and there are jobs associated with that builder (like “Lot #1” and “Lot #2”). This is the job name or “Lot #1”. – New in 9.1113

  Print Label for each Qty By default, iPoint will print one label for each line on the PO that is specific to a sales order, project, work order, or invoice. So if you sold 4 speakers on a single line, iPoint would print one label for all 4 speakers. Checking this box will cause the system to print a unique label for each quantity. So if you have 4 speakers then 4 labels will be printed.

Item Display LabelsItem Display Labels

Item Display Labels

These labels are intended to be placed on shelves or bins where the identified product is stored. They can be printed from the Item Details under the barcode.

Display LabelDisplay Label

Define what printer you have. Check the radio button next to the printer/label combination you have.

  • Dymo 450 with 1 1/8 × 3 1/2 in labels
  • Dymo 450 with 2 1/8 × 4 in labels
  • Zebra printer

Customize the text displayed by clicking in the Text (tab) and then selecting a Merge Field from the list at the right. Repeat until the information you want is on the label.
You can also type in the field as well as format the text using the Format menu at the top of the FileMaker window.

The Image (tab) is used to place a custom graphic behind the printed text

  • Right-click on the image field
  • Choose Insert Picture…
  • Navigate to the directory on your computer where the image is stored
  • Open the image
  • Now the labels print with the graphic behind the text
    Display Label with GraphicsDisplay Label with Graphics

When printing Sheet Labels you can define what size of label you will be printing by selecting one of the radio buttons. Note: This only works for sheet labels, and not roll labels.
1 × 4
2 × 4

  Generate Default Bar Code – When this box is checked, iPoint will generate a barcode for every new item automatically. This barcode can be overwritten by typing or scanning the item’s UPC barcode. Note: When selecting this option, you will be prompted with a pop-up dialogue asking if you want to “generate barcodes for any items without an existing barcode.” Simply respond Yes or No to move forward.

The merge fields for the Display Labels are taken from the Item details.

  • { Manufacturer } – from the Manufacturer
  • { Category } – from the Filter Category
  • { Type } – from the Filter Type
  • { Default Qty } – from the Default Qty
  • { Printed Date } – the date the label was printed
  • { Vendor } – from the Default Vendor
  • { Description Sales } – the item sales description from the Item Details
  • { Item } – from the Item Name
  • { Part Number } – from the Manufacturer Part Number
  • { Color } – from the Color
  • { Units } – from the Units
  • { Item Created Date } – the date the item was created in iPoint – displayed at the bottom of the Item Details
  • { Description Purchase } – the item purchase description from the Item Details
  • { Price } – from the Unit Price
  • { Description } – from the Sales Desc.
  • { Proposal Group } – from the Default Proposal Group
  • { Bar Code } – from the Barcode
  • { Min } – from the Stock tab > Min Qty
  • { Max } – from the Stock tab > Max Qty
  • { Memo } – from the Add’l Settings tab > Memo – New in 9.1013
  • { Description Tech } – the item’s tech description from the Item Details
iPoint Version: 10.0604
Last modified: 7 Jun 2021

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.