2BizBox® Manual

Go back to

9.0 Main

9.5 Inventory

9.5.1 Inventory Adjustment

9.5.1.1 Look up Onhand by Part#

Input a part# and click the button to see parts onhand and move among different locations in one warehouse. 

At the search results interface, you can see all locations of the part; click the edit button to go to the updating interface.

You can adjust, add, or delete the location of parts onhand. You cannot change part’s total onhand, and you are only allowed to alter the quantity of parts onhand in different locations in one warehouse.

9.5.1.2 Reset Average Cost 

Be cautious to when using this function. For Serva Software LLC, only use the function when the part’s cost contains serious errors; otherwise, you should avoid using it. Input the part# and click the button to reset average cost. After resetting, the part’s cost will become zero. 

Click the button; the system will open a window asking if you would like to reset average cost. 

9.5.1.3 Search Inventory Adjustment Records

Inventory adjustment records indicate changes of a part’s onhand quantity, average cost, etc. You can change only inventory quantity by part# at “Accounting Module->Inventory->Update Inventory by Part#.” 

Search part inventory adjustment records by conditions like cycle count man, and part. The search results will appear as below: 

9.5.2 Cycle Count

A cycle count is an inventory auditing procedure, which falls under inventory management, where a small subset of inventory, in a specific location, is counted on a specified day. Cycle counts differ from traditional physical inventory in that a full physical inventory may stop operation at a facility while all items are counted at one time. Cycle counts are less disruptive to daily operations, provide an ongoing measure of inventory accuracy and procedure execution, and can be tailored to focus on items with higher value, higher movement volume, or that are critical to business processes. Cycle counting should only be performed in facilities with a high degree of inventory accuracy (greater than 95%). The purpose of cycle counting is to verify the inventory accuracy and is not an adequate procedure to be used to correct inventory errors.

You can create a cycle count worksheet for inventory parts per day, per week, per month or per year and print it. 

Click the button to see the parts inventory information as below:  

Click the “Print” button to generate a cycle count work sheet. 

9.5.3 Search Part Issued for WO

Search parts issued to WO by conditions like issue number. The search results will be listed by WO item. 

At the search results interface, you can see detailed issue information, including date issued, qty issued, average cost when issuing, and issued total cost. At the bottom of the interface, there are statistics for number of item issued, total average cost and total STD cost. 

9.5.4 High Usage Part

Click the button to search high usage parts.

At the search results interface, you can see high usage parts’ yearly usage and quarterly usage.

9.5.5 Check Inventory 

9.5.5.1 Look up MRP by Part#

Input part# and click the button to see a part’s material requirements plan. It is a function similar to the “Look up MRP by part#” function in “PO Module->MRP” and warehouse home. 

9.5.5.2 Search Inventory by Location

Search part inventory information at a specific location. Choose if “Onhand>0” or “List all locations” 

The search results will be shown as below:  

Search by conditions at the search results interface, which can be printed. 

9.5.5.3 Search Inventory 

Search part inventory by conditions; you can define the part by part#, part description, commodity code, model number, product code, etc. Among which, part description has to be the part description’s starting content.

The search results will appear as below: 

The upper part of the interface shows various inventory information. The lower part of interface lists inventory of all searched parts.

9.5.6 Part with Inventory Not Used

To avoid overstocked products, you can search parts not used for a long time in the warehouse by date or month. 

9.5.6.1 Search by Date

Input a last used date and click the button to search parts not used after the specified date. Check to “Show Zero Onhand Items.”

9.5.6.2 Search by Month 

Input a month and click the button to search parts not used in this month. Check to “Show Zero Onhand Items.”

9.5.7 Search Parts in WIP by Vendor ID

Parts in WIP are those parts used in production, not including WO’s part item. 

Click the button to search parts in WIP by conditions like WO, part# and vendor ID. 


At the search results interface, it will list information like WO#, WO part item, WO vendor, and also run statistics on total item, total issue average cost and STD cost. 

9.5.8 Search History Inventory

Search a part’s historical inventory by part#, date begin or end. Check to “Show Onhand>0” 

9.5.9 Inventory Log

Here you can see the most detailed parts inventory log, which keeps a record for part inventory changing, adjustment, including part in & out warehouse quantity, cost, old and new onhand, and locations, in QA, in SIP, in SIT. Multiple conditions can be set to search the inventory log. 

The part inventory log cannot be deleted. 

Search results will be shown as below:  

9.5.10 Reports

Under the reports tab, 2BizBox provides many ways to look up and generate reports. 

9.5.10.1 Search Excessive Inventory 

Click the button to search excessive inventory. The method to calculate excessive inventory is:  excessive inventory = onhand + onorder - ondemand; here minimum quantity is not considered. If consider Max Qty, then excessive inventory = onhand + onorder – ondemand – Max Qty

The search results will be shown as below; click “Print” to generate a report. Also, you can click “MRP” at the end of each row to see a part’s requirements plan. 

9.5.10.2 Search Parts in WIP

Click this button to search parts in WIP (materials issued to WO), not including WO part items. The finished part in a sub-WO issued to a main work order belongs to WIP parts. Check to “List Refdoc.” 

Search results will be shown as below. Click “Print” to print a WIP parts reports. Click refdoc to go to the corresponding WO interface. 

9.5.10.3 Search All Parts in SIP

Click the button to see all parts in SIP that have been created by the proforma shipper but not shipped yet. The inventory information will show as SIP inventory. 

l Refer to more information about the proforma shipper at “Warehouse Module->Proforma Shipper.”

The search results will appear as below: 

Click the corresponding link to see part’s inventory and proforma shipper information; click “Print” to generate related reports. 

9.5.10.4 All Parts in SIT

Click this button to see all parts in SIT information, including part quantity, refdoc, etc.

Parts in SIT, matching parts in SIP, are parts added to the proforma shipper by the vendor; the function needs to use the 2BizBox VG module. 

9.5.10.5 Search All Parts in QA

Click this button to search all parts in QA that are parts pulled from the warehouse after their NCR is created. 

Search results will be shown as below; click “In QA” to see all QA quantity and NCR information. 

9.5.10.6 Search Part Onhand<=Min Qty

Search parts onhand less than or equal to their minimum quantity by product code and commodity code. For parts onhand with quantity is lower than minimum quantity, purchasing needs to be done.

9.5.10.7 Search Part OnhandMax Qty

Search parts onhand more than or equal to their maximum quantity by product code and commodity code. For parts onhand quantity that are more than maximum quantity, further investigation is needed. 

9.5.10.8 Search All Parts in TO

Click the button to search all parts in TO which are in a transfer order and shipped already but have not reached their specified location yet. 

At the search results interface, you can check a part’s transfer quantity, average cost, etc. and reports can be generated. 

9.5.10.9 Search Parts with Onloan

Click the button to search all parts with onloan that are in the onloan order and shipped already but not yet returned. This part of the inventory will be listed as on loan quantity.

9.5.10.10 Inventory Total by $

Click the button to see statistics of the total amount of inventory. 

Inventory total amount includes total warehouse onhand, total in WIP, total in QA, total onloan, total shipping qty, OnOrder, OnDemand, min qty and max qty.

Click a number to go to a part’s inventory information list. Click “Print” to generate a report. 

9.5.10.11 Part Inventory List

Click the button to go to the part inventory list.

In the parts onhand list shown below, you can set search conditions at above part of interface. 

Click “Total by $” to check the total amount and cost information of various inventory amounts. 

9.5.10.12 Search Parts without Location

Input part# and click the button to search parts without location.

9.5.10.13 Inventory Monthly Report

Choose the month to be checked and click the button to see an inventory monthly report.

The inventory monthly report will appear as below:  

Click “Print” to generate a report. 

9.5.10.14 Inventory Monthly Report (Location)

Check part inventory monthly reports by location.

The search results will appear as below:

Click “Print” to generate a report.

9.5.10.15 On Hand Stock Inventory by Location

Fill in the location#, such as “A,” “B,” “C” to search parts’s inventory on these locations.

9.5.10.16 Search Locations with Zero

Search part location with zero by part#.

The search results will appear as below: 

9.5.10.17 Search Inventory Monthly Change Report

Input “Date Begin” and” Date End” to check inventory monthly reports.

9.5.10.18 Search Part in SIP Need to be Audited

The function is used to search parts in SIP quantity showing at part property that do not match the system total in SIP. Users can find reasons to adjust it manually here.

9.5.10.19 Search Part Inventory by Backup Need to be Audited

Backup part inventory periodically. Use this function to adjust part inventory that needs to be audited in a specific time frame. 

9.5.10.20 Search Part in QA Need to be Audited

This function is used to search for parts in QA quantity showing at part property that do not match the system total in QA. Users can find reasons to adjust it manually here.

9.5.10.21 Search Location for Backflush Part

This function is used to search a location for backflush parts while using the backflush function.

9.5.10.22 Part Max/Min Qty Report

This report will show you the Max/Min Quantity of the parts, and allows you set the part’s Max/Min quantity in the search result.