Inventory Snapshot By Basepart

The Inventory Snapshot By Basepart module provides a detailed breakdown of your inventory by its most basic unit: the Basepart. By providing a comprehensive view of your inventory, this module enables you to identify trends, optimize stock levels, and make data-driven decisions.

By interpreting the information provided within the "Inventory Snapshot by Basepart" module, businesses can gain critical insights into:

• Current inventory levels

• Demand and sales trends

• Supply chain management

• Production planning

• Customer service

Inventory Snapshot By Basepart Search Fields

The Inventory Snapshot By Basepart module includes several search fields allowing precise filtering and retrieval of inventory information. By utilizing these fields, users can quickly access relevant data, streamline inventory management processes, and ensure accurate oversight of their stock across various locations and categories.

• Store: This field allows you to filter the inventory based on a specific store or location. If your inventory is distributed across multiple stores, selecting a store will display the inventory snapshot for that particular store only.

• Consolidated View: This option provides you with the flexibility to toggle between viewing individual item details and an aggregated overview of inventory data across all stores or locations. This aids in obtaining a comprehensive snapshot of inventory status and facilitates strategic decision-making.

• Show Active Only: By enabling this option, you can narrow down search results to display only active items within the inventory.

• Basepart#: This field allows you to search for specific base part. Entering a Basepart# will narrow down the search to the inventory snapshot of that particular item.

• Title: This field allows you to search for baseparts based on their title or description.

• Category: This field allows you to filter the inventory data by the product category.

• Group: This field allows you to filter the inventory data by the product group.

Inventory Snapshot By Basepart Columns

Field	Description
Store Name	This field identifies the specific store location for which the inventory data is presented.
Basepart#	This field represents the unique identifier for the product.
Option 1 Value	This field displays the value for option 1 related to the product.
Option 1 Name	This field displays the name for option 1 related to the product.
On SO	This field displays the product variant quantity that is on released sales orders, but they haven’t been shipped yet.
On PO	This field displays the product variant quantity that is on released purchased orders. Closing a PO will remove units from “On PO”.
Title	This field displays the title of the base part.
Sold	The total quantity of the item that has been sold over a specified period or since the item was added to the inventory.
Purchased	This field represents the total quantity of the basepart and its variation that has been purchased over a specific period.
On MO (-)	This field displays the units of an raw material that are currently on a manufacturing order and will be consumed.
On MO (+)	This field displays the units of the manufacturable item that are currently on manufacturing orders and will be produced.
ATS (Inc MO)	This field displays the available units after being added to a Released Sales Order plus what is on a Released Manufacture Order.
ATS (Inc PO & MO)	This field displays the available units after being added to a Released Sales Order plus what is on a Released Purchase Order and Released Manufacture Order.
Producible On Hand	This is the maximum number of units of the finished good that can be produced based on the “On Hand” inventory of raw materials.
Producible Net Available	This is the maximum number of finished goods that can be produced based on the “Net Available” inventory of raw materials.
Producible Available	This is the maximum number of finished goods that can be produced based on the “Available” inventory of raw materials.
Producible ATS Qty	This is the maximum number of units of the finished good that can be produced based on the “Available to Sell (ATS)” qty of the Raw materials.
Producible ATS Qty (Inc PO)	This is the maximum number of units of the finished good that can be produced based on the “ATS (Inc PO)” qty of the Raw materials.
Producible ATS Qty (Inc MO)	This is the maximum number of units of the finished good that can be produced based on the “ATS (Inc MO)” qty of the Raw materials.
Producible ATS Qty (Inc PO & MO)	This is the maximum number of units of the finished good that can be produced based on the “ATS (Inc PO and MO)” qty of the Raw materials.
Total Producible On Hand	This is the sum of On Hand units of the item (finished good) and the maximum number of finished goods that can be produced based on the “On Hand” inventory of raw materials. (Total Producible On Hand = On Hand + Producible On Hand)
Total Producible Net Available	This is the sum of the “Net Available” units of the finished good and the maximum number of units of the finished good that can be produced based on the “Net Available” inventory of the raw material. (Total Producible Net Available = Net Available + Producible Net Available)
Total Producible Available	This is the sum of available units of the item and the maximum number of finished goods that can be produced based on the “Available” inventory of raw materials. (Total Producible Available = Available + Producible Available)
Total Producible ATS Qty	This is the sum of “Available To Sell” units of the Item and the maximum number of finished goods that can be produced based on the “ATS” inventory of raw materials.(Total Producible ATS = ATS + Producible ATS Qty)
Total Producible ATS Qty (Inc PO)	This is the sum of the “Available” units of the finished good after being added to a Released Sales Order plus what is on a Released Purchase Order and the maximum number of units of the finished good that can be produced based on the “ATS (Inc PO)” qty the Raw materials. (Total Producible ATS Qty (Inc PO) = ATS (Inc PO) + Producible ATS (Inc PO))
Total Producible ATS Qty (Inc MO)	This is the sum of the maximum number of units of the finished good that can be produced based on the “ATS (Inc MO)” qty the Raw materials and the units of finished good that are Available To Sell, including the units on a Released Manufacture Orders. (Total Producible ATS Qty (Inc MO) = ATS (Inc MO) + Producible ATS (Inc MO))
Total Producible ATS Qty (Inc PO & MO)	This is the sum of the maximum number of units of the finished good that can be produced based on the “ATS (Inc PO and MO)” qty the Raw materials and the units of finished good that are Available To Sell, including the units on a Released Manufacture and Purchase Orders. (Total Producible ATS Qty (Inc PO & MO) = ATS (Inc PO & MO) + Producible ATS (Inc PO & MO))
Is Active?	This field displays whether the product is active or not.
On Hand	This field displays the on hand quantity of the item on the specific location. On Hand = Available + Not Available.
Not Available	This field displays the not available quantity of the item on the specific location. A “Not Available” item is considered to be damaged or not sellable in some way. Therefore it is categorized separately from “Available”.
Available	This field displays the available quantity of the product on the specific location.
On PO (Draft)	This field displays the item quantity that is on open purchase orders. Once the PO is released, then these items will go over to “On PO”.
In Receiving	This field depicts the item quantity that is in the process of receiving.
On SO (Draft)	This field displays the item quantity that is on open sales orders. Once the SO is released, then these items will go over to “On SO”.
Net Available	This is essentially the units left after allocation/waving (Net Available = Available – Allocated).
ATS Qty	This field displays the available units after being added to a Released Sales Order. (ATS = Available – On Released SO)
ATS Qty (Including PO)	This field displays the available units after being added to a Released Sales Order plus what is on a Released Purchase Order. (ATS (Inc PO) = Available – On Released SO + On Released PO)
Standard Unit Cost	This field shows the standard unit cost of the product variant.
Standard Unit Price	This field shows the standard unit price of the product variant.
Product Category	This field indicates the category assigned to the basepart, if any.
Group Name	This field indicates the group associated with the base part, if any.
Item Category	This field shows the category of the product variant.
Custom Prices	The custom fields show any custom prices defined for the product variant.
On RMA	This field displays the quantity of the item on an RMA.
On RMA (Draft)	This field displays the quantity of the item on an unsaved RMA.

Header Level Icons

• Left and Right Arrows: These errors help to navigate the records. Click on these to scroll through all the columns and access the data easily.

• Refresh: This functionality empowers users to refresh search results based on selected criteria, ensuring that the displayed information is always up-to-date.

• Save: Save feature enables users to preserve any updated user interface (UI) settings, ensuring a personalized and consistent experience during future interactions with the module.

• Columns: All the columns available for the module are listed under this icon. You can use this option to hide or add the columns and tailor the module view as per your requirements.

• Download: This versatile feature allows users to export and download data in various file formats, providing a summarized overview for quick reference. Options include CSV, TXT, MS-Word, MS-Excel, PDF, and MS-Excel(.xlsx), catering to diverse user preferences and use cases.