Inventory Management and Reporting

Managing Inventory

cieTrade.net offers several inquiries and reports for the management of your lot-based inventory. The Inventory Manager, Available Inventory Inquiry, and Inventory Overview are available from within the Inventory tab of the left window pane and offer quick insight into the turnover of product lots in your warehouse(s). Additionally, several reports will aid in the successful management of Inventory purchases and sales. These reports can be found in the main Reports menu and are discussed further below.

Inventory Manager

The  Inventory Manager is a tool that allows you to view all available and uncommitted products. Once a product has been placed into inventory, it will appear under this management tool. Alternatively, if products are shipped out, they cease to appear here, unless you search by the Depleted inventory filter.  This report can be found under the Inventory tab in the left window pane.

The reporting filters give you the flexibility to search for a product using multiple attributes. You can manipulate the report by selecting a Product/Grade, searching within a specific Date Range, the Warehouse and Location, the Buyer/Sales Representative, the Inventory Class, a Supplier, a Department, a Buyer, a Condition, or even searching by one or more Paper-Stock Properties or Plastic Properties of a particular roll of paper. You also have the ability to include or exclude Depleted Inventory and Reserved Inventory. 

To run the report, click  GO in the upper left corner of the screen.

 The Item No. column in the Inventory Manager displays a product's Receiving number, followed by a '-1', '-2', etc. For example, Item No. 231016-2 would be the second product listed on Inventory Receiving Worksheet #231016.

The Inventory Manager also offers several features in the top row after an inventory item(s) had been checked off.

Split Inventory

1. To split serial inventory into multiple items, click the checkbox on the desired item and select Split Inventory on the top row. 
2. A window will open up where you can enter the New Split Quantity and New Split Units. This will deduct from the original quantity of the origin item.
3. Click Apply.  

Batch Edits

1. To make batch edits to inventory items, check off the desired items and select Batch Edit on the top row.
2. Check off the features you would like to change about the selected inventory. You have the option to edit the Warehouse, the Grade/Product, and the Location within a warehouse. 
3. Click Apply. 

Print Labels 

1. To print labels of inventory items, check off the desired items and select Print Labels on the top row. 
2. A PDF will open up in a second tab with the selected inventory item's label, which can be printed, downloaded, etc. 

Reserve Inventory

To learn more about the Reserve Inventory function, visit the helpfile here. 

Available Inventory

The  Inventory Available report provides a snapshot of the products that are available to sell and their unit cost. Products are defined by a combination of grade and packaging types. The inventory reported is consolidated or "rolled-up" based on product and packaging type. This inquiry also displays Committed inventory to provide a true picture of availability.

The Inventory Available inquiry can be filtered by Warehouse, Department, and Product. It can be toggled to display in different UOM. 

An important feature of this report is the product drill-down. By clicking on a listed product, such as Bond White, all products defined by the grade "Bond White" will be displayed.

Additionally, the Inventory Available Inquiry can be toggled to display several other features. To access these features click on " Inventory Available" at the top of the screen. 

Group by Inventory Class

This feature allows you to see available inventory sorted by Inventory Class. If an item does not have an inventory class, it will be sorted into an unassigned category.

1. Select Group by Inventory Class under the Inventory Available dropdown. 

Group by Location

This feature allows you to see available inventory sorted by Location within your warehouse. If an item does not have a location, it will be sorted into an unassigned category.

1. Select Group by Location under the Inventory Available dropdown.

Group by Supplier

This feature allows you to see available inventory sorted by Supplier it was received from.

1. Select Group by Supplier under the Inventory Available dropdown.

Bulk Inventory

This allows you to access the Bulk Inventory Report. For more information on the Bulk Inventory Report, visit the helpfile here. 

Available Reports

Inventory Valuation

The  Inventory Valuation Report can be found by navigating to Reports > Inventory > Inventory Valuation.  This report will show all on-hand inventory items based on the selected As Of Date. It can be filtered by Warehouse, Department, Supplier, and the Report On Currency. The Report On Currency allows you to see what inventory you purchased in other currencies that you have on-hand. 

The report can be grouped by Grade or grouped by Grade and Warehouse and the UOM can be modified. 

Each available inventory item will be displayed, along with an Item #, the original Rcv-Wks# (the Receiving Worksheet the material came into the warehouse on), the Post-Date, Unit Cost, Quantity available, and Value. The final value of each item is calculated as a landed cost, including any expenses.  For example, if a received item has a value of $2,000 and an associated $100 freight expense, the actual value reported would be $2,100. 

Inventory Sales

The  Inventory Sales Report can be found by navigating to Reports > Inventory > Inventory Sales.

This report provides a listing of all inventory sales activity for a user-specified time period. This report can be run for all Warehouses or for each Warehouse individually. It can also be filtered by Dept, Customer, and you can toggle the UOM using the Report In drop down. Additionally, it has the option to include or exclude Un-Invoiced Items. 

Inventory Purchases

The  Inventory Purchases Report can be found by navigating to Reports > Inventory > Inventory Purchases.

This report provides a listing of all inventory purchase activity for a user-specified time period. This report can be run for all Warehouses or for a specific Warehouse. It can also be filtered by Dept, Supplier, and you can toggle the UOM.

Inventory Roll-Forward

The Inventory Roll Forward Report produces a statement of changes in inventory value over a user-specified period. It can be filtered by Dept or by Inventory Model. 

This report is intended to be a backup to the inventory accrual that shows at the bottom of the Closing Adjustments Report. 

If you have additional questions, please contact the Support Team via email to  support@cietrade.net.