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 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 Track Use Tax – When this box is checked, all new items added to the database will be marked to track use tax. This assumes that you have turned on use tax in your system.

  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 un-checked 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 are 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 prior to 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 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 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 entier 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.

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.

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 items 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: 9.1113
Last modified: 18 Nov 2020

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.