Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 17 Current »

Overview

Managing inventory is an important part of maintaining your business operations, with Rx-Inventory. You have ease of access to all kinds of different tools and functions to help you better manage your frames, frame parts, and miscellaneous items.

The main window used to mange your inventory can be found by navigating to the following: Rx-Inventory → SKUs

Relevant Permissions

When it comes to frame inventory items there are many relevant permissions that need to be granted in order to properly manage the inventory. Below you’ll find the list of relevant permissions.

All permissions can be found by navigating to Rx-Hub → Roles → (Select Relevant Role) → Rx-Inventory Section

SKU

This part of the permissions allows control over creating, updating, viewing, deleting, and mass updating inventory items.

Filtering/Sorting Items

Navigating and finding specific inventory items is a fundamental part of managing your inventory. We can easily find the desired item by using the provided filtering and sorting tools on the SKU page.

We can filter our inventory item by using the two menu bars displayed at the top of the SKU page.

The topmost section defines what status we wish to view (You can view what each status means in the Item Category Definitions section). The second section displayed above allows you to filter what item type you wish to see. By using both of these tools together you can easily narrow down the list items displayed on screen.

Creating New Items

Creating new inventory items is an easy task. To start, navigate to the appropriate SKU page Rx-Inventory → SKUs. From here to start the process we simply need to click on the Create button located near the top of the page

Now that we’ve clicked on the create button, you will be redirected to the inventory item creation page. From here we can enter values to all the relevant fields that are part of an item. Once this step is complete simply hit the Create button located at the bottom of the page and your new item will appear!

Note

Not all fields are required to complete the creation process, the fields that must be present are denoted with relevant error text below the field box.

Other Details

Aside from the general frame-specific fields, you can also manage other details about the frame item in the Other Details section. In this area, you are able to set details such as status, trace reorder method, and more. You can also see a preview of the shape of the trace. Additionally, if a trace is selected, the A, B, and ED will be populated with values from the trace and these fields become uneditable.

See the definition of these columns here.

Generating UPC

You are able to generate a UPC when creating or updating an SKU. You can set up the starting sequence in the Settings → Configuration page.

To generate a UPC, you can just click on the barcode icon on the right side of the UPC field.

Updating Existing Items

To update the fields on an existing item we simply have to navigate to the SKU page (Rx-Inventory → SKUs) and click on the line item (or the pencil on the right hand side of the line) to open up the modification menu.

Once we’re in the SKU item modification page, we can make any changes we need to by simple clicking on the field and changing its values. Once we’ve made all our modifications simply click the Update button located at the bottom of the page.

Frame Associations Section

When viewing an inventory item you’ll find a list of important information about Warehouses, Purchase Orders, Vendor Returns, Transactions, Price List, and any User Defined Field the item is part of.

You can find this section by navigating to Rx-Inventory → SKUs → Selecting any Item, the section will be located at the bottom of the page. By changing the menu selected at the top we can view different pieces of information.

Warehouse

The Warehouses section displays all warehouses the item belongs to. This has important information about the quantities you have on hand, the cost of the item, the vendor, and more.

Add to Warehouse

Adding inventory items to the warehouse is an easy task. To begin the process, ensure you have the Warehouse Tab selected at the bottom of the page, and simply click the Add to Warehouse button

Once you’ve clicked the Add to Warehouse button, you’ll notice a menu open. Select a warehouse and fill in all the required fields with the appropriate information. You can set ordering and stocking information of the invengtory item in the warehouse. The final step is to click the Submit button located at the bottom and you’ll have successfully added the item to your warehouse!

Stock Adjustments

Adjusting warehouse stock can be done by navigating to Rx-Inventory → Manage Inventory → Adjust Quantities. We can easily navigate there from the SKUs page by clicking the +/- symbol located on the right-hand side of the desired warehouse, this will redirect us to the Adjust Quantity page with details pre-populated with the frame item information.

Update Frame-Warehouse Information

Updating the frame warehouse information can easily be done. From the SKUs Warehouse section simply click the Edit symbol on the right-hand side of the warehouse you which to make modifications.

From here you’ll notice a new menu is displayed on screen. You can make all the modifications you wish, once you’ve done so simply click the Submit button located at the bottom of the menu, this will finalize and save all your changes.

Setting Ordering and Stocking Details

In the SKU → Warehouse field, you can configure relevant settings for the ordering and stocking of the item. This includes Vendor, Lead days, Stock status, Min/Max. These details are then used when generating the purchase order to replenish the quantity depending on the reordering method selected for the frame item. You can also set the Cost From Frame flag which, if on, uses the Standard Cost of the item as the Standard Cost in the warehouse.

Purchase Orders

The Purchase Order section displays all orders, that currently have the selected item part of the order. We can Export, Release, and View the order from this section as well by simply selecting the line we wish to view.

Vendor Returns

The Vendor Returns section displays all returns that currently have the selected item part of the return. We can Export, Release, and View the order from this section as well by simply selecting the line we wish to view.

Transactions

The Transactions section displays all transactions that have occurred on the selected item. This includes stock adjustments from varying sources, vendor returns, purchase orders, and more. The adjustment type is displayed, along with the adjustment date, and the change in quantity that was applied to the item.

Price Lists

The price list section shows all price list that include the selected item. From this view you can see the name of the price list, the price assigned to the item, and the warehouse it belongs to.

User Defined Fields

The user defined fields is a section that allows you to define your own unique fields and give them a value. This is used when an item is added to an Rx-Order. To create a new field simply click the Create button, provide a unique field name and value, and hit the Create button.

Definitions

In this section, you can find descriptions of all the relevant fields and statuses associated with an inventory item.

Item Status Definitions

Each inventory item has one of the following categories associated with it.

Category

Description

Usable

A usable item is any active item, or any item with a quantity in a warehouse (including backordered quantities)

Un-Usable

Un-usable items are discontinued, on order, or inactive items, as well as any item that isn’t part of a warehouse

Active

Active items have their status marked as active. This means these items are available and still in use in production.

Inactive

Inactive items have their status marked as inactive. This means these items are no longer used in production.

Discontinued

Discontinued items have their status marked as discontinued. This means these items typically are no longer manufacturer by the suppliers.

On Order

On Order items have their status marked as on order. This means there is currently an active purchase order/transfer that includes this item.

Back Ordered

Back Ordered items have their status marked as backordered. This means these items are on order but are temporarily unavailable from the supplier.

Recalled

Recalled items have their status marked as recalled. This means these items have been request to be returned to their suppliers. (Typically these items are on a Vendor Return)

Item Fields Definitions

Below you can find the fields associated with an inventory item and its description.

Field

Description

Part Type

This field defines the type of item. (Whole, Front, Temple, Bridge, Clip, Side Shield, Miscellaneous)

Name

The name associated to the item

Manufacturer

The manufacturer that makes the item

Gender

The gender the item was designed to be worn by

Collection

The collection the item belongs to

Brand

The brand of the item

Model

The model of the item

Class

The class of the item (Standard or Safety)

Print Sticker Template

The template used when printing the SKU label (The template must be an XML file and saved on the RX-XML folder in your Rx-Universe directory

Material

The material the item is made of

Color

The color of the item

Edge Type

The edge type of the frame. (This is provided by the Rx-Universe)

 Eye

 The eye measurement. It only accepts whole number

 Temple

 The temple measurement. It only accepts whole number

 Bridge

 The bridge measurement. It only accepts whole number

A

The horizontal width of each lens at its widest point of the lens within the frame. This commonly has the same value as the eye

B

The vertical height of the lenses at the widest point of the lens within the frame

ED

The longest diagonal distance inside the frame edges in mm

REQ BC

The requested base curve for the item

Min BC

The smallest accepted base curve that will fit in the frame

UPC

The Universal Product Code for the item. This is the most common frame identifier and is the code printed on the barcode sticker label

Manufacturer UPC

This is the univesal product code used by the manufacturer to identify this item

Cost

The cost of item charged by the supplier

MSRP

The Manufacturer Suggested Retail Price of the item

Suggested Retail Price

The suggested retail price for the frame

Price Group

The price group that the frame is a member of

Trace

The trace of the frame. The options that show on this field comes from Rx-Universe

Status

The status on the item in the inventory

Reorder Method

The method used to reorder this item. There are

Min/Max - Based on the set minimum or maximum quantity available in the warehouse. If an inventory item is below the set minimum, it will be flagged as needs replenishment.

Quantity Replenishment -

Dynamic -

Vendor Default - Based on the set reorder method on the vendor profile of the item

Dynamic Days

The number of days after item creation to switch from min/max to usage history reorder method

Description

An optional freetext description of the item

Source

How the item was imported into the system

Vision Star Item Number

Primarily used when importing from Vision Star. This is used for the “CODE” field of the frame extract file that is sent to AcuityLogic.

Created

The date and time the item was created in the system

Date Last Used

The date when the frame was most recently used

Date Last Modified

The date when a change was most recently made to this item, it's associated categories, or it's value on a price list

Back Order Date

The date the item is expected to be available again. This is only availale if the frame has “Back Ordered” status

Web?

This flag tracks if the frame is displayed on the lab's website, if applicable

Frame - Warehouse Fields Definitions

Below you can find the fields associated with the frame warehouse page and its description.

Column/Field Name

Description

 Quantity in Warehouse

The total stock in the warehouse. This will include stocks that are allocated and in process.

Quantity Available

The total stock available for new orders/transactions. This is total stock in warehouse less allocated and in process stocks (Qty Available = Qty In Warehouse - In Process - Allocated ).

This quantity is used when generating the purchase order depending on the reordering method of the inventory item.

 Quantity Allocated

The total stock allocated for jobs

 Quantity In Process

The total stock picked for jobs. If Rx-Universe is set to update inventory on Order Entry, this items can still be on shelf.

Quantity On Order

The total on open/released Purchase Orders

Used since last PO

The quantity allocated since last PO

Vendor

The name of the Vendor that supplies the item

 Lead Days

The number of lead days to use in the EOQ calculation

Last Ordered PO

The number of the last Purchase Order released that included this record

Last Ordered Date

The date the Last Ordered PO was released

 Cost

 The cost of the frame at this warehouse

 Average Cost

The average cost of acquisition from the vendor (computed when receiving Purchase Orders)

 Stock Status

Whether or not the item should be kept on hand (stocked) or ordered when required (special)

 Bin

The bin this item is stocked in

 Min

The smallest amount of stock that should be kept on hand

 Max

The largest amount of stock that should be kept on hand

 Safety Stock

The safety stock to use in the EOQ calculation

  • No labels