Difference between revisions of "Managing Inventory"

From HandiFox Desktop Wiki
Jump to navigation Jump to search
Line 173: Line 173:
 
*'''Export''' allows exporting a QOH report in an xls file.
 
*'''Export''' allows exporting a QOH report in an xls file.
 
*'''Close''' button allows closing the ''QOH Viewer'' window.
 
*'''Close''' button allows closing the ''QOH Viewer'' window.
 
+
 
 +
'''How to check QOH for items in Handifox Desktop:''' 
 
#Use filters to find the specific item.
 
#Use filters to find the specific item.
 +
#You can double-click the item to see additional information.
 
#Click the '''Export''' button to export the QOH table in an xls file if it is needed.
 
#Click the '''Export''' button to export the QOH table in an xls file if it is needed.
  

Revision as of 22:20, 27 April 2021

Inventory Screen

This is the Inventory window that opens from the Main window:

Inventoryscreen.jpg




  • Item List button - Tap it to go to Item List.
  • Inventory Counting button - Tap it to go to Inventory Counting screen.
  • P.O. Center button - Tap it to go to P.O. Center screen.
  • Bin Locations button - Opens Bin Location List screen.
  • Build Assembly button - Tap it to open the New Assembly screen.





Info-sign.png Access to Inventory Counting and P.O. Center screens are enabled or disabled based on current user’s permissions and the status of Inventory function defined in the license.







Infocircle.pngPress the "Back" button Backbutton.PNG on the device to return to the Main window.

[Back to top]


Item List

Item List Screen

The Item List allows navigating through the list of all items.

In this window, you will find all active items of Inventory Part, Inventory Assembly, Other Charge (with fixed amount) and Service type with their sales descriptions and current quantities on hand (QOH). Infocircle.png Quantity on hand is shown in base units of measure. Infocircle.png Tapping on the column headers of the grid sorts the list alphanumerically.


Info-sign.png If your company file contains more than 5000 active items of Inventory Part, Inventory Assembly, Service and Other Charge (with fixed amount) types (for HandiFox Multi-Location - more than 5000 items at the current location) then the Item List opens blank. To see the items, type an item name or just the first few symbols of it in the Look for Name field.
  • Look for Name field

When you type into the Look for Name field the system scrolls to the first name that starts with the entered sequence and highlights it.

  • Filter check box

Tap it to open the Item Filter window.

Lookforitem.PNG

The Item Filter window is used to filter items that include what is typed in the Look for Filter field.

Infocircle.png If you have already used a filter then the previous filtering criteria are shown. The Look for field is empty if you open the Filter window for the first time.

Infocircle.png Searches can be performed either in all fields (default criterion) or in one of the following specific fields:

  •Name
  •Description
  •Preferred Vendor
  •Man. Part Number
  •U/M
  •U/M Set
  • Apply button

Tap it to apply your criteria for filtering. If no item is found then the corresponding message appears.

  • Back button

Tap it to return to the Item List without changing or applying any filter.

Info-sign.png The same filter can be found on the Inventory Counting screen.


[Back to top]



  • Scanner and Scan button

A barcode scanner can be used on this screen to find required items. When you scan a barcode, the system highlights the corresponding item. If the barcode is not assigned to any inventory item, then the error message “Cannot find scanned inventory item” appears. You can also tap the Scan button to scan a barcode with your device’s camera,

Info-sign.png This button will appear on all screens where barcode scanning is applicable.


  • Edit button

Tap it to open the Item editor screen for the selected item.

  • View QOH button

Tap it to open the QOH Viewer screen for the selected item.

Press the Back button on the device to return to the Inventory window.

Info-sign.png Only active items are displayed in the Item List.


[Back to top]


Item Editor

Item Editor allows the user to edit barcodes for the selected item and review the inventory item’s information. Select the necessary item in the items list and tap the Edit button.

Edititemgen.jpg

Tabs

  • The Item Editor screen opens with the General tab active:

On the General tab you will find the following information (this information matches the corresponding item's information in QuickBooks):

  •Item Name/No
  •Type
  •Subitem Of
  •Man. Part Number - Manufacturer’s Part Number
  •Asset Account
  •Reorder Point
  •On Hand - Quantity on Hand on the current location
  •Avg. Cost - (Average Cost)
  •On P.O/S.O (this site/all sites) - Quantity in purchase or sales orders for current or all sites.

Infocircle.png It is not possible to edit the information on the General tab.

Infocircle.pngAvg. Cost doesn't appear on the tab if Show cost permission is disabled for the user.

  • The second tab on the Item Editor screen is Sales:

On the Sales tab you will find the following information:

  •Description of Sales Transactions
  •Quantity on Sales Orders for current location
  •Quantity on Sales Orders in total
  •Sales Price
  •Tax Code
  •Income Account

Infocircle.pngIt is not possible to edit the information on the Sales tab.
Infocircle.pngThe Sales Price doesn't appear on the tab if Show cost permission is disabled for the user.

  • The next tab on the Item Editor screen is Purchase:

On the Purchase tab you will find the following information:

  •Description of Purchase Transactions
  •Quantity on Purchase Orders for the current location and in total
  •Cost
  •COGS Account
  •Preferred Vendor
  •Purchase Tax Code (only for QuickBooks Canada)

Infocircle.pngIt is not possible to edit the information on the Purchase tab.
Infocircle.pngCost doesn't appear on the tab if Show cost permission is disabled for the user.



  • The last tab on the Item Editor screen is Barcode:
Edititembc.jpg

On the Barcode tab you will find the following information:

  •U/M Set name
  •List of Units of Measure with barcodes

Infocircle.png "NONE" is displayed if no unit of measure is assigned to the inventory item. The abbreviation, number of ea (base units) and Barcode preview are shown for the currently selected unit of measure.
Infocircle.png "NONE" is also displayed if you use QuickBooks Pro (as it doesn't support Units of Measure).
Infocircle.png You can forbid a user to edit barcodes by disabling the corresponding permission.

Info-sign.png The maximum length of the barcode that can be printed from HandiFox (Barcodes List window in QuickBooks Integrated Module) is 18 characters.


Tap the Save button to save barcode changes. The barcode you have entered must be unique, otherwise, the system will not allow saving.
Press the Back button on the device to return to the previous Item List screen. Confirmation is needed if you want to leave the Item Editor screen without saving the barcode.

Info-sign.png Each item can have several barcodes - one for each unit of measure from the u/m set assigned to the item.


[Back to top]


Quantity on Hand

Quantity on Hand (QOH) is a minimum quantity for inventory in stock. In HandiFox you can check the Quantity on Hand for items.

On the desktop, go to File → HandiFox → QOH Viewer. You will see the following buttons:

  • Look For field allows looking for the item via typing its data in the field. You can specify the type of data in the All Fields drop-down menu.
  • Search button allows applying filters for searching the items.
  • Reset button allows resetting filter results.
  • Refresh button allows retrieving the latest QOH information and clearing filters as well.
  • View Details allows viewing details for the item selected in the list.
  • Adjust Quantity button allows changing the QOH for items.
  • Desired QOH allows setting the desired quantity on hand for items.
  • Export allows exporting a QOH report in an xls file.
  • Close button allows closing the QOH Viewer window.

How to check QOH for items in Handifox Desktop:

  1. Use filters to find the specific item.
  2. You can double-click the item to see additional information.
  3. Click the Export button to export the QOH table in an xls file if it is needed.

How to adjust quantity in HandiFox desktop:

  1. On the desktop, go to File → HandiFox → QOH Viewer.
  2. Click the Adjust Quantity button.
  3. Select the item you want to edit the quantity for.
  4. Type new quantity for the item in the New Qty column.
  5. Type number in the Ref.No.: field if it is needed.
  6. Type memo in the Memo field if it is needed.
  7. Click the Save button to save changes or the Cancel button to discard them.

How to set the desired QOH in HandiFox desktop:

  1. On the desktop, go to File → HandiFox → QOH Viewer.
  2. Qlick the Desired QOH button.
  3. Choose the location of the items you want to set the desired QOH for in the Location drop-down menu.
  4. Use filters to find the specific item.
  5. Select item you want to change the desired QOH for.
  6. Type the desired QOH in the Desired QOH column.
  7. Click the Save button to save changes or the Cancel button to discard them.
  8. Use the Import button to import data from an xls file or the Export button to export data to an xls file. You can also print a table with the desired QOH using the Print button.


[Back to top]


Transfers between sites

Inventory transfer transports items from one location to another. In HandiFox, you can create transfers and fill them with inventory to send them to any site you need.

Multi-location enabled in QuickBooks

Mobile application

How to Create Fill in the mobile app:

  1. In HandiFox app, go to Main → Transfer → Create Fill to fill transfer with inventory.
  2. Choose the site you want to create a transfer for and add a comment in the Comment field if it is needed, tap the Next button.
  3. Change transfer number in Tr.No.: field via typing it if it is needed.
  4. Add items using Find button, or Scan button to find items via barcodes. You can also type item’s name in the field and tap Add button to add item you need. Type item’s quantity you want to add to transfer in Qty field.
  5. Tap Memo tab to create memo for transfer.
  6. Tap U/M data to change the Unit of Measure. Use drop-down box and tap OK button to save changes. To discard changes, tap Cancel button.
  7. Tap S button to set Serial Number for chosen item. Type it or use barcode scanner. Tap OK to save changes. To discard changes, tap Cancel button.
  8. Tap Save button to save changes or use Apply&Save button to saved and apply transfer (you cannot change applied transfers).
  9. Sync your device to send new data to desktop.

How to Create Quick Transfer in the mobile app:

  1. In HandiFox app, go to Main → Transfer → Quick Transfer to create an inventory transfer.
  2. Select transfer type:
    1. Receive Inventory from other site
    2. Send inventory to other site
  3. Tap the Next button. Choose the site you want to transfer inventory from/to. Fill in the Comment field if it is needed and tap the Next button.
  4. Change transfer number in the Tr.No.: field via typing it if it is needed.
  5. Add items using the Find button, or the Scan button to find items via barcodes. You can also type the item’s name in the field and tap the Add button to add items you need. Type the item’s quantity you want to add to the transfer in the Qty field.
  6. Tap the Memo tab to create a memo for the transfer.
  7. Tap U/M data to change the Unit of Measure. Use the drop-down box and tap the OK button to save changes. To discard changes, tap the Cancel button.
  8. Tap the S button to set a Serial Number for the chosen item. Type it or use a barcode scanner. Tap OK to save changes. To discard changes, tap the Cancel button.
  9. Tap the Save button to save changes or use the Apply&Save button to save and apply the transfer (you cannot change applied transfers).
  10. Sync your device to send new data to the desktop.

Desktop application

How to Create Fill in the desktop:

  1. On the desktop, go to File → HandiFox → Transfer Center and click the Create Fill button.
  2. Select source and target site using Source Site and Site to Fill Transfer for drop-down menu.
  3. Check Generate Transfer checkbox to generate a transfer.
    1. Add items to the transfer based on Sales rates: choose the period you need to form sales rate using the drop-down menu. Check the checkbox if the account for the item is already at the target site.
    2. Add items to the transfer based on the Desired QOH Level.
  4. Click the Next button to continue or use the Cancel button to discard the steps made before.
  5. Change the transfer number if it is needed via typing it in the Transfer No.: field.
  6. Choose the item in the drop-down menu, type the item's quantity you want to transfer via typing it in the Transfer Qty column. Choose the Unit of Measure for the item in the U/M column in the drop-down menu.
  7. Click the Add Item button to add items in the list. Use the Delete Item button to delete chosen items from the list.
  8. Add memo using the Memo field if it is needed.
  9. Click the Save button to save the transfer or click Apply to apply the transfer.

How to receive a transfer in the desktop:

  1. On the desktop, go to File → HandiFox → Transfer Center.
  2. Select the transfer you want to receive (you can receive only applied transfers).
  3. Click the Receive button and the received quantity of items via typing it in the Receive Qty column. If you receive all items, check the Receive all checkbox.
  4. Use the Print button to print Receive Transfer list.
  5. Add memo using the Memo field if it is needed.
  6. Click the Apply button to apply changes or Save to save them.

How to edit a transfer on the desktop:

  ! This option works only for not applied transfers.
  1. On the desktop, go to File → HandiFox → Transfer Center. Choose not-applied transfer from the list and click View/Edit button.
  2. Change transfer number via typing it manually in the Transfer No.: field.
  3. Use drop-down menu in Item column to change item.
  4. Use drop-down menu in U/M column to change unit of measure for item.
  5. Click S button in corresponding raw in Item number column to specify serial number in the field. Click OK button to save changes or use Cancel to discard changes.
  6. Use Add Item button to add item to the list if it is needed.
  7. If you want to delete the item from the list, select it and click Delete Item button.
  8. Type memo in Memo: field if it is needed.
  9. Click Save button to save changes.

No multi-location/single location enabled:

To create Transfer in HandiFox with no multi-location/single location enabled, open Fie → HandiFox → Inventory Site Manager to create sites. Tap New to add the site's name via typing in the Site Name field and tap the Save button to save changes. Sync your device to send data to the app.

Mobile application

How to Create Fill in the mobile app:

  1. In HandiFox app, go to Main → Transfer → Create Fill to fill transfer with the inventory.
  2. Choose the site you want to create a transfer for and add a comment in the Comment field if it is needed, tap the Next button.
  3. Change the transfer number in the Tr.No.: field via typing it if it is needed.
  4. Add items using the Find button, or the Scan button to find items via barcodes. You can also type the item’s name in the field and tap the Add button to add it. Type the item’s quantity you want to add to the transfer in the Qty field.
  5. Tap the Memo tab to create a memo for the transfer.
  6. Tap U/M data to change the Unit of Measure. Use the drop-down box and tap the OK button to save changes. To discard changes, tap the Cancel button.
  7. Tap the S button to set a Serial Number for the chosen item. Type it or use a barcode scanner. Tap OK to save changes. To discard changes, tap the Cancel button.
  8. Tap the Save button to save changes or use the Apply&Save button to save and apply the transfer (you cannot edit applied transfers).
  9. Sync your device to send new data to the desktop.

Desktop application

How to Create Fill on the desktop:

  1. On the desktop, go to File → HandiFox → Transfer Center and click the Create Fill button.
  2. Select the source and target sites using Source Site and Site to Fill Transfer for drop-down menu.
  3. Check the Generate Transfer checkbox to generate a transfer.
  4. Add items to the transfer based on Sales rates: choose the period you need to form sales rate using the drop-down menu. Check the checkbox if the account for the item is already at the target site. Desired QOH Level.
  5. Click the Next button to continue or use the Cancel button to discard the steps made before.
  6. Change the transfer number if it is needed via typing it in the Transfer No.: field.
  7. Choose the item in the drop-down menu, type the item's quantity you want to transfer via typing it in the Transfer Qty column. Choose the Unit of Measure for the item in the U/M column in the drop-down menu.
  8. Click the Add Item button to add items to the list. Use the Delete Item button to delete chosen items from the list.
  9. Add a memo using the Memo field if it is needed.
  10. Click the Save button to save the transfer or click Apply to apply transfer.

How to receive a transfer in the desktop.

  1. On the desktop, go to File → HandiFox → Transfer Center.
  2. Select the transfer you want to receive (you can receive only applied transfers).
  3. Click the Receive button and add the received quantity of the items via typing in the Receive Qty column. If you receive all items, check the Receive all checkbox.
  4. Use the Print button to print the Receive Transfer list.
  5. Add a memo using the Memo field if it is needed.
  6. Click the Apply button to apply changes or Save to save them.



[Back to top]