Install and Setup: Retail Management

Caution: For best results, Wizard recommends users install this software during business hours when technical support is available.

You will install the Store Server and one or more Store Integrated Framer® Retail Management (IFRM) Clients. The Server and one IFRM Client may be installed on a single PC if desired, or they can be installed on separate PCs. If the software is installed on two separate computers, then these computers must be connected using an Ethernet local area network. It is the customer’s responsibility to provide this networking.

The IFRM software operates in a networked environment on Microsoft’s .NET 2.0 using Microsoft’s SQL server or Express server database engine.

IFRM software requires the installation of the following Microsoft products:

• Microsoft SQL Express Server or Microsoft SQL 2005 Server on the store server computer (the user will be asked during installation if they wish to install Microsoft SQL Express Server). The user may elect to install Microsoft SQL 2005 Server if they prefer. Microsoft SQL 2005 is not provided with the IFRM software; it is the customer’s responsibility to procure that software and satisfy its license requirements.

Microsoft SQL Express Server is free from Microsoft and is adequate for small systems of five or fewer users.

• Microsoft .NET 2.0. This software is free from Microsoft and is provided by and installed with the IFRM software.

• IFRM corporate server web services software may also be installed on the store server computer. The installation procedure contains instructions on how to install MatDesigner™ and Integrated Framer® Visualization.

Install IFRM Store Server from the Wizard CD. If you have a CD, install it in the CD drive; it should automatically start the installer and display the screen illustrated below. If the installer does not start, or if you downloaded the CD, start the installer manually. Launch Windows Explorer and go to the CD drive, double click on the “Install.exe” file name. The installer will also install the .NET 2.0 and Microsoft SQL Express database engine if desired.

Click Install IFRM Server.

Enter the Customer ID and the product key for the store server software if prompted and then click Continue. The product key for a single software program is 20 characters; it is 30 characters for a bundled product key. A bundled product key licenses a set of programs as a group – it needs to be entered only once for the entire group. The product key you have is dependent on how you acquired your software (purchase or subscription).

The software displays a key accepted message.

Click OK. The installer prompts to shut down other windows applications. Do that, and then click Next.

Read the End User License Agreement and click Accept.

The installer now displays the connection information for the database.

Confirm the server name is the name of your store server computer (from Windows), the database instance name is WIZRMS (set by Wizard) and set the database name as STORE. Click Install SQL Express UNLESS you have previously installed the full MS SQL Server 2005. If you do have MS SQL Server 2005 installed then enter the appropriate connection, database user name and password for it here.

Select “Install Wizard default product data” if desired (this loads products from Bainbridge, Crescent, Larson-Juhl and Tru Vue and Wizard’s example project definitions). Do not make this selection if you wish to define your own products and do not want Wizard’s basic content and examples.

To continue, click Next.

The installer displays a progress screen while the software and data are loaded.

The installation process runs to completion – this install may take 15 minutes or more as the installer is setting up the database and populating it with data if you selected that option. When the installation process completes, click Next.

Following installation the installer may ask the user to activate a product’s license or the bundled software license. When activating a bundled license one single activation will apply to all the products licensed by the bundle.

Activation requires either a live connection to the internet, a dial up connection to the internet, or a manual telephone call to Wizard’s customer support desk for manual assistance with the activation sequence. It is preferred that you activate with your computer connected to the internet. Activation is a simple process that records your installation on a data server at Wizard. If you have an internet connection the fully automated activation process takes only seconds. If you do not have access to the internet, call Wizard’s Customer Services for assistance.

Click Finish.

This section gives instructions to install the Wizard software on a Store IFRM client computer; this computer may be the same computer used for the Store Server or it may be a separate computer. If installed on separate computers the machines must be connected using an Ethernet local area network as discussed earlier.

Install IFRM Client software from the Wizard CD image. If you have a CD, install it in the CD drive; it should automatically start the installer and display the screen illustrated (Fig A). If the installer does not start, or if you downloaded the CD image, go find the folder where the image is then locate and click setup.

Click Install Retail Management.

You may be prompted for a product key. Enter the Customer ID and the product key for the store server software if prompted and then click Continue. The product key for a single software program is 20 characters; it is 30 characters for a bundled product key. A bundled product key license a set of programs as a group – it needs to be entered only once for the entire group. The product key you have is dependent on how you acquired your software.

The installer prompts to shut down other windows applications. Close down the other applications, and then click Next.

Read the end user license agreement and click Accept.

The installer now displays the connection information for the database.

Confirm that the server name is the name of your computer (from Windows), the database name is STORE (or whatever name you used when you installed the store server) and then click Next.

The installer displays a progress screen while the software and data are loaded.

The installation process runs to completion – this install may take 15 minutes or more as the installer is setting up the database and populating it with data. When the installation process completes, click Next.

When the load process finishes, the software announces the install is complete.

Click Finish. The Store client is now installed.

Wizard Integrated Framer Visualization and Wizard MatDesigner are packaged on the Store CD and may be installed on the store client computers. The installation of those products is similar to the installation sequences defined above.

The IFRM software is installed in a folder on your computer at C:\Program Files\Wizard.

The server database is supplied populated with framing moulding, glass and matboard and initial program setup and pricing settings, if you choose to install it as an option (Click Install Wizard default product data under install Server instructions). This will get most users started – thereafter the software includes an administration system to allow you to customize your system setup, item pricing structures and vendor product content (mouldings, mats, glass, etc.).

Introduction

IF Retail Management Content Management (CM) is the IF Visualization component used to manage products and pricing. All products used within the IF Suite (Visualization, Retail Management, MatDesigner) access a single database, and that database is managed using the CM software.
This document will guide you through setting up your database quickly for the first time. The topics do not follow menus top to bottom but rather follow the logical steps for a first time set up.

Note: The default product data installed with the server is intended to be appropriate in many situations.

The following instructions are to help you customize your products and pricing when necessary. You are encouraged to use the default pricing and products whenever possible.

There are 3 methods available to users to update their product information:

• Manual input – entering data for each SKU one at a time.

• Content Subscription: Wizard maintains a large database of vendor’s products and prices. You can subscribe to the vendors that you use and periodically update this information directly from Wizard.

• Content Loader Tool – a spreadsheet application with defined columns that will update the product database in bulk.

Launch the Content Management program and login.

• Login: Administrator

• Password: WizRMS

The software opens to the main screen.

Here you can set up your base prices to be used on new products and when adding new vendors. You can make these same pricing choices under each vendor. Vendor choices will take priority over choices made in this table.

First, choose the cost basis under Base Price On.
Then select a Mark-Up table that will multiply this cost to calculate the selling price of the materials involved in this process.

Then you can add a surcharge - either a flat fee or a percentage. You can add a labor charge, as well.

1. Product Type
   Select the product type that you would like to modify.

2. Base Price On
   Select the cost basis for the materials involved in this process. For instance, if you usually buy moulding in length, select length. Mat pricing is usually by the sheet.
   The term Sub-Product means that the materials for an item are chosen from many supply items. Clear glass, for example, will be chosen from all the different sizes of clear glass your shop carries. These sub-products will be defined later in the setup process.
   You can also select charges based on user-defined values.

3. Selected Mark-Up
   Select the desired cost mark-up table. The choices that are made will give you the multipliers for your final prices for these processes. You can always edit them or create new mark-up tables later.

4. Surcharge
   Enter any desired surcharge (dollar or percentage). Surcharges and labor can be added to the price of a process to cover overhead items.

5. Labor
   Enter the average number of minutes for this process.

6. Labor Mark-Up
   Select the desired labor mark-up table. A labor mark-up table will multiply labor minutes based on size. Typically you will want to charge more labor for larger frame jobs than you do for smaller ones.
   The mark-up tables can be edited to multiply the labor minutes exactly how you want for each size.

7. Labor/Shop Rate
   Enter your hourly labor rate, this will determine the base price for calculating labor charges.

In this section you can add or remove vendors and modify how you price their products. If your pricing strategy for any given vendor differs from the pricing defaults then you should modify the vendor pricing.

Add New Vendor

Click Add New Vendor to add a new vendor.

Remove Vendor

Click Remove Vendor to remove the currently selected vendor.

Refresh List

Click Refresh List to refresh the list after adding/removing a vendor.

1. Select a Vendor
   Select a vendor then click on Edit/Remove, depending upon what you want to do.
   Show Subscribed Only
   Check Show Subscribed Only to display only your subscribed vendors.

2. Selected Vendor Information
   Name:
   Name of the vendor.
   Short Name:
   Short name of the vendor.
   Last Updated:
   This field displays the date the database was last updated for this vendor.
   Vendor Prefix:
   The alpha-numeric prefix code for this vendor. These letters and numbers will precede all SKU numbers in the framing ticket.
   Subscribed
   Select Subscribed checkbox if this vendor is subscribed. Subscribed means that you will be getting electronic updates to the vendor’s merchandise price list.

3. Contact Information
   Enter the contact information for the vendor, and select the appropriate category for the contact information.

4. Pricing Options
   Click on the Pricing Options Tab of the current vendor to continue.
   Important Note: If you enter discounts, shipping fees, or taxes here, they will be applied to every item you purchase from this vendor. Every moulding bundle, every moulding chop, every sheet of matboard will reflect these additions. You have the option of applying these discounts or other charges to your retail price mark ups, or base retail pricing on the “list” price supplied.
   Discount
   If a vendor gives you a discount and you would like to pass it on to your customers, enter it here. This can be either a dollar amount or a percentage. Then select Apply Discount if you would like to apply it to the vendor’s product costs.
   Shipping Fee
   Enter in the shipping fee, then select either dollars or a percentage from the drop down list. Then select Apply Shipping to Cost if you would like to apply it to the vendor’s product cost.
   Tax Rate
   Enter the tax rate for this vendor and select Apply Tax Rate to Cost if you would like to apply it to the vendor’s product cost.
   Vendor Product Cost Defaults
   It is important that you enter pricing options for each subscribed vendor because default pricing is only applied to new products and vendors
   Cost Used
   Select the cost basis from the dropdown list, i.e., Length.
   Cost Mark-Up
   Select the cost mark-up table to use.
   Surcharge
   Enter the desired surcharge, either $ or %, from the small drop down arrow.
   Labor
   Enter the number of labor minutes.
   Labor Mark-Up
   Select the desired labor mark-up table to use.

This section is for managing your vendor subscriptions and updates. Wizard maintains a large database that you can access to update your vendors and products.

Vendor Subscription

From the main screen under Pricing, click Subscription. It is important to note that if you do not subscribe to a particular vendor, that vendor’s merchandise will not be displayed within the software.

You can also manually enter/edit information for a vendor that is not part of the subscribed database. List them as Subscribed so that their products will show up when you design a project, then go into the individual vendor and make the desired changes to pricing and products as desired.

1. Available Vendors
   Listing of all of the available vendors entered.

2. Subscribed Vendors
   Listing of all of your subscribed vendors.
   To Subscribe
   Select a vendor, and use the right arrow between the screens to move that vendor to the Subscribed list.
   To Unsubscribe
   Select a vendor, and use the left arrow between the screens to move that vendor out of the Subscribed list and into the Available Vendors list. That vendor’s products will no longer display within the software.

3. Refresh Vendor List
   Refreshes the list after adding/deleting a subscription or to see if Wizard has added new vendors to the database.

4. Update Vendor Content
   Click Update Vendor Content to update the vendor content of subscribed vendors. This will open the Updates screen.

1. Subscribed Vendors to Update
   Click the appropriate checkbox of the vendors you wish to update.

2. Update Vendor Content Now
   Click Update Vendor Content Now to update the currently selected vendors.
   Reload Entire Product List
   Click Reload Entire Product List checkbox to reload the entire product list. Any changes that you’ve made to this vendors products will be overwritten.

3. Refresh List
   Click Refresh List to refresh the list after adding/deleting a selection.

4. Update Status and Results
   Displays any pertinent information about the update progress.

Here you can define additional charges to associate with design elements in your mats. If you use IF Visualization or MatDesigner, these systems will pre-populate these items in the work ticket.
On the left-hand Categories column, under Pricing, click on Designs.
Enter the desired cost and Mark-Up for the listed categories and design elements.
Design Details Pricing

1. Design Type
   List of design types that can have additional charges assigned.

2. Design Cost
   Enter the specific design cost for the individual items.

3. Cost Mark-Up
   Select the desired cost mark-up table to apply to the individual item.

4. Surcharge %/$
   Enter any desired surcharge, and select % or $ for the numeric specifier.

5. Labor
   Enter the number of labor minutes to be applied to the individual item.

6. Labor Mark-Up
   Select the desired labor mark-up table to apply to the individual item.

Here you can set your prices for mounting.

Adding a New Mounting Record

Select the user-defined Category first from the dropdown list on the Mounting Records List, then click Add New Product to add a new mounting record. Click on New SKU to add the name for the new mounting then fill in the rest of the information for the new mounting record.

To select multiple SKU’s for the sub-products hold down the CTRL key while clicking on the SKU’s you want to add.

Editing a Mounting Record

Select the desired mounting record to edit from the Mounting Record List by clicking on it. Click on theEdit/Add Mounting Record. Click Edit and make the desired changes. Click Save to save the new changes

Labor

Here you can set up pricing for labor tasks such as shadow box assembly or fitting.

Adding a New Labor Record

On the Labor Records List, click Add New Product. Fill in the fields as described below, then click Save to save the new labor record.

Editing a Labor Record

Select the desired labor record to edit from the labor records list by clicking on it. Click on the Edit/Add Labor Record. Click Edit and make the desired changes. Click Save to save the new changes.

The Products section allows you to customize your pricing on individual products and services. Buttons along the top allow you to add or remove products from the selected category.

Each category has two tabs:

Records List - lists all of the items in the selected category

Edit/Add Record - edit the selected item or add a new one.
Product Settings

1. Merchandise Categories
   Merchandise are products typically sold as unique items - not custom framing. Items like art, ready mades or photo frames, sculptures, etc. are considered merchandise items.
   New Category
   Click New Category to create a new category with the name entered into the text field.
   Remove
   Click Remove to remove the currently selected category.

2. Category Listing
   Displays a listing of the currently entered categories.

3. User-Defined Category Names
   Enter the desired list of category names. These user-defined categories are items that can be part of the frame job.
   You can add only one item from each category to a frame job, though.

The user-defined category is for custom items or services such as jersey mounts or stretcher bars. You can define the supplies that are used in the category.

User-Defined Records List

There are four user-defined categories. You can give them new names on the Products screen.
You will see them on the custom ticket under Options.

Adding a New User-Defined Record

Select the User-Defined Category first from the dropdown list on the user-defined records list, then click Add New Product to have the new item assigned to the correct category. If the category is not on the list, you will have to go back to Product Settings and create it. Select New SKU, then fill in the fields and click Save to save the new User-Defined Record.

Editing a User-Defined Record

To edit a User-Defined record, click it and then click Edit/Add User-Defined Record. Make the desired changes and click Save.

The Other/Misc category allows framers the ability to add miscellaneous charges with multiple quantities. Items like “Object Mount” can be set up with a set price per object and then a quantity can be assigned in the custom work ticket. Same for labor - a set amount of time can be pre-set and then multiples charged based on the designer’s assessment. An unlimited number of Other/Misc items can be created.

Merchandise

Merchandise can be used to define items such as ready-made frames that you can add to your order.

Here you can modify matboard prices and specifications.

Adding a New Mat

On the mats List, click Add New Product, then select New SKU. Fill in the fields as described below, then click Save.

Editing a Mat Record

Select the desired mat to edit from the mats list by clicking on it. Click Edit and make the desired changes. Click Save to save the new changes.

Mat Families

Mat Families allows you to set default values (including mark-up tables) to specified groups of matboard. Typical groups could be Paper, Rag, Acid-Free, Suedes, Linens, etc.

Because Mat Families are completely customizable based on your various entries of matboards into the database, creating a mat family is usually done after adding your mats into the database.

Adding a New Glass Record

Select the vendor first from the dropdown list on the glass records list, then click Add New Product to have the new item assigned to the correct vendor. If the vendor is not on the list, you will have to go back to vendors and add it. Click New SKU, fill in the fields and click Save to save the new glass record.

Editing a Glass Record

Select the desired glass record to edit from the glass records list by clicking on it. Click Edit and make the desired changes. Click Save to save the new changes.

Adding a New Moulding

On the mouldings List, click Add New Product. Click New SKU, fill in the fields as described below, then click Save to save the new moulding.

Editing a Moulding Record

Select the desired moulding to edit from the mouldings list by clicking on it. Click Edit and make the desired changes. Click Save to save the new changes.

Adding New Supplies

On the supplies list, click Add New Product, then click New SKU. Fill in the fields as described below, then click Save to save the new supplies.

Editing a Supplies Record

Select the desired supplies to edit from the supplies list by clicking on it. Click on the Edit/Add Supplies. Click Save to save the new changes.

On the left-hand categories column under Pricing, click on Project Types.

A Project Type is a saved set of material choices for a specific order type. The items available to be included in a Project Type are Glass, Mount, Labor, User-Defined categories and Other/Misc items. For instance, selecting “Limited Edition” will auto-populate the selections of materials typical for this project on the Custom Ticket Screen, including the type of glass, mounting, labor, etc. You still have the ability to change any selection individually, for instance, if the customer wants to upgrade to Museum Glass.

There are a number of default project types already available in the software. You can add more or modify the existing ones.

Roles are specific tasks that employees perform in your shop. The default role is System Administrator which has permission to use all of the features of the software. This is where you can create and define roles and permissions for your employees. Typical roles include: Store Manager, Framer, Cashier etc.

Permissions directly correlate to permissions in the software. If an employee does not have permission to a specific screen/task, they will not have access to it. Roles can be assigned to as many Permissions as desired.

Roles Header

Add New Role

Click Add New Role to create a new employee role. Give it a role name, select the desired permissions. Click Save to save the new role.

Edit a Role

To edit an existing role, click on the role in the Select a Role Panel, and change the desired permissions. Click Save to save the changes.

Remove Role

Click Remove Role to remove the currently selected employee role.

Refresh List

Click Refresh List to redraw the screen after deleting/creating a role.

Select a Role

Lists the currently created roles. Click on one to select it.

Selected Role Information

Role Name (Required)

Displays the name of the currently selected role. Click Add New Role, and enter Store Assistant for the employee role name.

Permissions

Permissions directly correlate to permissions in the software. If an employee’s assigned role (or roles, they can have more than one assigned) does not have permission to a specific screen/task, they will not have access to it. You can select more than one Permission when creating a Role.

In this section you can add employees and assign their roles.

Employee Records List

This displays the list of employees and roles currently created. Define user accounts for your employees here.

Edit/Add Employee Record

Name and Login Info

Enter the employee’s name and login information.

Contact Info

Enter the contact information and select the category as Home or Cell Phone.

Roles

Select the desired role for this employee. The roles are created in the roles category. You may assign one or more roles to each employee.

Notes

Enter any notes desired about this employee.

This screen defines how your software connects to the database server and content update server. In most cases you will not need to change these. If you are setting up a system with a server on a different computer then you will need to change the server settings.

You should spend some time customizing your store settings. In this section you will see how to set up items specific to your store such as taxes, store information and discounts.

Start IFRM, login and click on Application Settings.

Store Settings

Store Setup

Setting Up Store

Enter the Store Name, Store ID (Identifier) and contact information.

Weekly Schedule (Production)

Select the checkbox next to the days of the week that orders are worked on (production). Selecting the correct days helps determine the Order Due Date - if you work on custom orders Monday - Friday, then the number of days to complete a job should only include those days.

Payment Types Accepted

Verify the payment types that the store will accept. Date Due Settings

Default Daily Slots

Enter the number of Daily Production Slots (number of time-defined slots) the store will use as the default. This helps a store manage the number of jobs available to take in a day. If the number of jobs is exceeded, the ticket Due Date is adjusted to the next available day. Multiple slots can be assigned individually to a specific ticket.

Default Lag Days

Enter the number of Lag Days (days between placing the order and picking up the finished order) the store will use as the default.

Store Logo

Here you can add a store logo. This logo will print at the top of tickets, invoices, quotes and receipts. It should include the store’s name and contact information. If a store logo is selected, no additional contact information will be printed.To load a logo, click Set New Image, locate the graphic file and click Open. Acceptable file types are *.jpg, *.png, *.bmp, *.tif and *.gif. For best results use a horizontal 800X300 image.

Standard Sizes

Standard Sizes will appear in the drop down menu when you click the Sizes button by Opening and Outer on the ticket screen. Verify the list of standard sizes and edit or insert any alternative sizes. If you decide that no changes are needed, then skip to Art Condition.

Size Category

Select Opening or Outer.

Insert

Click Insert to insert the currently entered standard size into the Standard Sizes list.

Update

Click Update to change the currently selected standard size to the new size entered.

Remove

Click Remove to delete the currently selected standard size.

Number Formats

Determine the number formats for each item here. Enter any letter/number to precede the number in the first field; i.e., O- for Order. Select the number format from the drop down list. An example is displayed to the right of the field.

Application Behavior

Here you can select how art condition and discounts are handled in tickets.

Localization

The default localization settings should be appropriate for most North American users. However, if you would like to modify units of measure and phone number format you can change it here.

Taxes must be defined at each store. On the left-hand categories column, click on Taxes.

Default Table

Name

Enter a name for this tax rate.

Itemize Rates (Checkbox)

Check Itemize Rates checkbox if you want each of the rates to be itemized on all printed items, such as tickets, receipts, invoices, etc. Printing out itemized tax rates is a requirement in some areas, so check your tax laws. Note that they will not be itemized on the screen, and will appear as the total tax amount.

Rate Names

Enter a name for each rate listed for this tax table. Here you can enter individual labels such as GST, PST, HST, etc.

Rate Total

Displays the rate total of the tax table.

Rates

Enter the individual tax rates for each labeled entry.

User-Defined Table #1-3:

Enter up to three separate customized tax tables. As with the default table, you can select whether to itemize the rates on all printed forms.

The printing setup can be found on the left-hand categories column, click on Printing, located under store settings.

Default Number of Copies

Enter the desired number of default copies for each item listed to be printed.

Printing Options

Show prices on work tickets (Checkbox)
Check Show prices on work tickets checkbox if you want the prices to display on the work tickets.

Receipt Printer/Type

Select the receipt printer and type from the pull down list.

Drawer Open Codes

Enter the Drawer Open Codes. If you select from a receipt print type available from the pull down list, this field will automatically be filled in.

Cut Receipt Codes

Enter the Cut Receipt Codes. If you select from a receipt print type available from the pull down list, this field will automatically be filled in. The software comes with support for selected Star and Epson receipt printers. If you use another, you can manually enter the drawer and cutter codes in the fields provided.

On the left-hand categories column, click on Printed Footers, located under store settings.
Enter any information you would like to print out onto the footers of the documents listed. If you require a signature line, make sure you add that here also.

Roles and employees are covered earlier in this document, see Roles and/or Employees.
The IF Retail Management software is now set up. The next section will help you use it.

We’re going to walk you through the process of creating a ticket, billing it, and paying it. As you get familiar with the IFRM software, you will see that there are many ways to do things, so select the method that works best for you. You will be making choices from dropdown lists that will be created by your Administrator, so your choices may be different than displayed in this manual.

Login using your username and password. Note that if your account does not have rights to certain screens or areas, you will not have access to them.

Click on Custom Ticket to go to the Order Information screen to start a new ticket.

We’re going to start by creating a customer for this ticket.

1. Click to Assign Customer

Click the Click to Assign Customer button to go to the Customer screen.

Customer List

The Customer screen will open to the Customer List tab where you can search for existing customers. But, for this walk-through, we’re going to create a new customer.

New - Add a Customer

Click New to add a new customer. This will take you to the Edit/Add Record screen to fill in the appropriate fields for your new customer.
If you wanted to edit an existing customer, select the customer first, then click on Edit/Add Record.

Edit Customer

Name and Info:

Enter the name and contact information of the customer. Select the appropriate categories and select the preferred contact method.

Save and Select

Click Save to save the new customer. Click Select to select the customer which returns you to the New Ticket screen.

Now that we have created/selected our customer, it is time to fill in the rest of the ticket information.

2. Art
This panel may be hidden by your administrator; if so, then skip it. Select if it is the customer’s or the gallery’s art, enter a description, condition, and declared value of the artwork.

3. Sizes

Enter the size of the outside, borders, and opening. If this is a multi-opening design brought in from IF Visualization or MatDesigner, these fields will automatically populate with window width/height representing the bounding rectangle area of the combination of openings.

4. Frames / Fillets

#of Frames:

Enter the number of Frames/Fillets to be used in this project.

(Blank Fields) Enter/Scan SKU’s

Scan or click on the magnifying glass to select the SKU’s of the Frame/Fillet moulding from the list. If you know the SKU number, you can also type it in, and the software will try to auto-fill the field as appropriate.

5. Mats / Fillets

#of Mats:

Enter the number of Mats/Fillets to be used in this project.

(Blank Fields) Enter/Scan SKU’s

Scan or click on the magnifying glass to select the SKU’s of the Mats/Fillets from the list. If you know the SKU number, you can also type it in, and the software will try to auto-fill the field as appropriate.

Reveals:

Enter the reveal value for each layer, if using more than one layer.

RB? (Reverse Bevel)

Click the RB? checkbox on the layers that you want to cut as Reverse Bevels.

6. Project Types (Drop Down List)

A Project Type is a saved set of material and labor choices for a specific order type.

Selecting a Project Type is a great way to get the final price quickly for the customer and to make sure the sales people do not forget to add any special charges for these kinds of frame jobs.

Select one of the choices and see how the program automatically populates the options fields. You still have the ability to add or change any selection at any time, such as upgrading the customer to Museum Glass or adding an Object Mount.

Select another Project Type and see how the options change.

7. Options

If you decide not to use the Project Types, or if there is not an appropriate category for the project at hand, you can manually choose the individual selections. Note that the choices are completely customizable by the administrator.

Choose Glass

Select the desired Glass from the dropdown list.

Choose Mounting

Select the desired Mounting from the dropdown list.

Choose Labor

Select the type of Labor for this kind of project from the dropdown list.

User-Defined List

Select the desired options from each of the remaining dropdown lists. You can choose only one item from each user-defined category per frame job, and there are four different categories. The administrator can assign them and use them for anything they would like.

8. Design Details (lower left bottom of screen)

You can select other design elements to be added to the project.

Add Detail

Click Add Detail and select one of the choices.
See also how the changes to the design are reflected. Add a couple more design elements. See how the price changes. Their itemized prices also appears when you hover over the Other price field under Materials in the Totals column.

9. Other

Choose Other

Select Other Item from the dropdown list. This list is defined by your content administrator. You can choose as many of these other items for a frame job as you want. You can even specify multiple quantities of each other item you add.

Add Item

Click Add Item to add the new item to the project.

Remove Selected

Click Remove Selected to remove the selected item from the project.

10. Quick Sale

Instantly add a new item that was not available otherwise. This item will be added to your ticket. It will also be added to your Other/Misc list so it is available for future sales

11. Due Date / Status

We want to change the date that this project will be due. Click on the date itself to open the Date Due Calendar. If this frame job is expected to take more time than normal, you can increase the number of slots it will take so that you do not schedule too much work per day.

Assign Due Date:

Due Date:

Displays the currently selected Due Date.

Slots used for this Ticket

If this frame job is expected to take more time than normal, you can increase the number of slots so that you do not schedule too much work per day. (A slot is an amount of time assigned to complete a custom ticket).

Select Date

We want to select the day after the current Due Date. Click on that date on the calendar (it will move to the center of the display), then click Assign Ticket to Date. It will then return you to the ticket screen.

Alternatively, click on the Jump button and you will see a calendar where you can pick any day you like.

Totals

You can see that the totals section is broken down into components. Make a couple of changes to your design, like selecting a different moulding, matboard, or even glass, and see how the totals change.

When you hover over a price, there is a caption balloon that breaks down the price that you see even further. The total mat price here is broken down into the separate prices for the top and the inner mat, and the color names are displayed as well.

12. Discount

Click on Discount to open the discount window. Select the discount method and fill in the amount. You can select a percentage discount or dollar amount on the drop down menu to the right of each field. A discount may be applied with the button on the Ticket screen or through the options menu at the top of the window. Only people with permissions may have the ability to apply discounts.

13. Tax:

Click on Tax to open the tax window. You can also choose to select one of the pre-defined tax rates set up by your administrator. If you select Exempt, no tax will be applied. Click OK to accept the tax selection and return to the order information screen.

14. Quantity:

Enter the quantity of this project to be created, for instance if the customer wants two of the same frame created, enter 2.

Total:

This will display the total after all of our changes. The total will be immediately updated as changes are made to the ticket.

15. Add to Order (Button/Dropdown)

Click Add to Order to go to the Summary screen to make final adjustments and accept the job.

When you click the dropdown button beside Add To Order, there are other choices: Add Order, Add Order and Clone, and Add Order and Start New.
There should be some discussion of Work Orders and Work Tickets. A Work Ticket is a custom job request, a Work Order is an accumulation of Work Tickets and Merchandise purchases. The Work Ticket goes to the person producing the work and the Work Order is a document for the Customer.

Add To Order and Clone

When you want to show the customer another design or pricing choice, select Add To Order and Clone. The current design will be added to the Summary and a duplicate Custom Ticket will appear. When you have made the changes to it, click Add To Order. Both the original ticket and the cloned ticket with changes will be on the Summary screen.

Once the customer has made a decision, select the unwanted ticket and click the Cancel Ticket button to delete it.

Add To Order and Start New

When you want to include multiple frame jobs on one order, select Add To Order and Start New. The current ticket will be added to the Summary screen and a blank custom ticket will appear for you to fill out the next frame job.

Once you click Add To Order, the ticket appears in the listing on the Order Summary screen.
In IFRM, an order is where you sell frame jobs and merchandise. An order can have any number of each item.

From the order summary screen, there are buttons that allow you to open new framing tickets and view the existing ones. This is also the screen where you take payments.

1. Commit Order/Update Order:

Click Commit Order to commit this project. Whether this is a quote or an actual order, you must click Commit Order to save it.

Now this project will be assigned a ticket number if it is an order, or a quote number if it is a quote.

The Record Payment (Pay Deposit) screen will automatically open up so that the customer can immediately make a down payment on this order. Note that the Record Payment screen will only open when you initially commit the order. Otherwise, click Pay Deposit from the Summary screen to open the Record Payment screen.

2. Payment:

Payment Method

Select the payment method from the dropdown list.

Pay Deposit

Click the Pay Deposit button to pay an automatic 50% of the total.

You can also click the dropdown arrow next to the Pay Deposit to enter a specific percentage of the total.

You can also enter a specific deposit amount.
There is a Notes field below where you can enter comments regarding this transaction. The customer will see the comments entered into this field.

Submit

Click Submit to submit this payment and return to the Order Summary screen.

Cancel

Click Cancel to submit no payment.

3. Print Receipt

Click Print Receipt to print out a receipt of the deposit for the customer.

4. Customer Information

When a ticket is assigned to an existing customer, that customer’s tickets and quotes appear in the Order History field at the bottom.

The Invoiced Balance displays the total of all unpaid invoices for that customer.

The Committed Balance displays the total amount owed on all of the Committed tickets for that customer, that have not been invoiced.

5. Order Details

The Order Details field displays the status of this order and the Order Number. There is also a field where you can enter notes regarding this order.

6. Quotes

If the customer has not yet decided about a frame job, you will want to keep a record of the design and the price as a quote.

There are two ways to make a ticket into a quote:

On the Custom Ticket Screen

The Due Date/Status field is at the upper right corner of the Custom Ticket screen. Click on the name (it will probably say New) by Status.
The Ticket Status screen opens.

At the top under Status Options, the current status will probably say New again.

Click the dropdown arrow and select Quote.

Click the Change Status button at the bottom of the Status Options field.

Then click the Close button at the top right of the Ticket Status screen.

The status of the ticket will now be Quote.
Click Add To Order at the bottom right of the Custom Ticket screen.

Then click Commit Order at the bottom right of the Order Information screen to save the quote.

Cancel the Payment screen when it pops up.

On the Order Information Screen

Sometimes you will not know that this ticket will be a quote until you are on the Order Information screen.

On the Order Information screen select the ticket and click the Make Quote button. You will see the status change to quote.

Click the Commit Order button to save the quote.
Searching for Quotes

You can see all the quotes by clicking on Tickets and Orders on the main screen in the Find section.

They will be there in the listing. You can even search for Quotes by sorting on Status: Quotes.

Changing Quotes to Tickets

You can change a quote to a ticket at any time.
Select the quote from the Tickets and Orders list.
Click the View Ticket button at the top left. The quote will now be on the Custom Ticket screen.
In the Due Date/Status field at the upper right corner, click on the name Quote by Status.
The Ticket Status screen opens.

At the top under Status Options, the current Status will be quote.

Click the dropdown arrow and select In Progress.
Click the Change Status button at the bottom of the Status Options field.

Then click the Close button at the top right of the

Ticket Status screen.

Click Update Ticket at the bottom right of the Custom Ticket screen.

On the Order Information screen you will see that the status is now in progress and the ticket has a due date.

Click on Tickets and Orders on the main screen in the Find section to locate the desired ticket.

Search Options

Select the desired search option, such as Customer Name, Tickets Due Today, and/or Start-End Date, etc. Since we know that the ticket has not yet been invoiced, select Tickets Not Invoiced.

Send to CMC

Select the ticket and click Send to CMC to cut the design on the CMC. See the MatDesigner manual for specific information on cutting.

Click Back to return to the IFRM after cutting the mat.

An invoice is the completion in the find section of a transaction – the purchase of a Merchandise Item or the Pick Up of a Custom Work Ticket are examples.

New Invoice

Click on Tickets and Orders on the main screen to locate our ticket.

Search Options

Select Tickets Not Invoiced for the search option.
Click on the ticket to select it, then click New Invoice to create a new invoice.

If you are sure that you are ready to make the invoice, click Accept Invoice.

It will create and print out the invoice, and change the status of the ticket to Completed. Invoicing the ticket will lock the ticket and make it so you can no longer change anything in it.

Click Make Payment on the main screen to apply a payment to a project that has been invoiced.

Search Options:

Unpaid Balances

The Search Options will default to unpaid balances. You can select a different search parameter from the dropdown list.

Make Payment

Select the desired invoice by clicking on it. Click Make Payment to apply a payment toward the currently selected invoice. The customer wants to pay the remaining balance.

Payment Method:

Select the payment method from the dropdown list.

Pay Full Amount

Click Pay Full Amount to pay the full amount of the Invoice.

Notes:

Enter any notes in regards to this payment in the Notes field.

Submit

Click Submit to submit the payment to this account. You will be returned to the Ticket screen.

Now that the project has been completed, and paid for, the customer is ready to pick it up.

From the main Screen, click Tickets and Orders. Under Search Options, select Customer Last Name and click Search.

Select the ticket and click Status/History to edit/view the status and history of the current ticket.

Status

Change the status of the current ticket by selecting Picked Up from the dropdown list.

Change Status

Click Change Status to confirm the status change.

Event Type

Log an event type by selecting it from the dropdown list: called Customer. You can also type a note in the Notes field.

Log Event

Click Log Event to confirm the Log Event change.

Close

Click Close to return to the main screen. Our customer has now paid for their project, and has picked it up.

IF Visualization allows you to select the moulding, matboard, and even the art via connection to a camera, and gives you a preview of the finished piece. You can go to IF Visualization through either the main screen button, or through the Visualization button on the Order Information screen.

After creating your project, click Send To IF-RM on Step 3: Visualize to bring your project back to the IFRM software to the ticket screen. For more information, see the Integrated Framer® Visualization manual.

Preview

When you bring the IF Visualization project into the IFRM, it will display a preview of the current project in the preview screen. To complete the order, you must select a project type or finish the framing project by adding Mount, Glass, etc. as appropriate.

Continue or Add to Order

From here, you can continue editing the design, or, if you are finished, click Add to Order.

MatDesigner™ allows you to select different templates, multiple openings, LetterMat, CutArt, and other elements to design your project. You can go to MatDesigner through either the Main Screen button, or through the MatDesigner button in the ticket.

After creating your project in MatDesigner, click To IF-RM on the Editor screen to bring the information back to the IFRM. When you return to IFRM, you will be on the Order Information screen.

See the MatDesigner manual for more information.

Preview

When you bring your MatDesigner project into IFRM, it will display a preview of the current project in the preview screen.

Continue or Add to Order

From here, you can continue editing the design, or, if you are finished, click Add to Order.

Q. What is the default login?

A. User: Administrator

Password: WizRMS

Please leave this default information set up in your system as it helps Customer Support service your account.

Q. I installed the update but now my IFRM software can’t find the server or I get a database version error.

A. Make sure you update the server as well as the client. If the server isn’t updated IFRM won’t recognize your database. Always update the Server first, then the Client stations when upgrading to a new version.

Q. My fonts aren’t printing. What do I do?

A. Your anti-virus or firewall didn’t allow a complete installation of IFRM – please temporarily disable these and reinstall.

Q. My vendor isn’t listed or the prices are out of date. How do I update this information?

A. Be sure to hit Refresh Vendor List and update your vendor content. Wizard regularly updates this information. If a vendor is still not found, contact Customer Support with the vendor and contact information and Wizard will try to have that vendor added to our list.

Q. How often should I check for vendor updates?

A. Check for vendor updates at least once a month.