Inventory App

L1 L2 L3 Code Item Size Variant UOM Qty Min
Level PAR
Qty Value/
Unit
(base) Value

(base) Avg.
Dem
and Inven
tory
Days Lead
Ordr
Time Proje
cted
OOS Excess/
Shortfall Open
Orders

Add New Master Item

Taxonomy

Category *

Sub-category *

Sub-sub-category *

Identity

Name *

Brand

Size

Variant

Description

Codes

Code1 *

Code2

Code3

Dimensions

Unit

Width

Length

Height

Measurements

Basic measure *

Basic unit *

Weight unit

Weight value

Force change basic measure — this item has stock; checking this will write off all existing stock and reset Min Lvl / PAR Stock on every warehouse subscribed to this item.

Extra measurements

e.g. case (6 bottles), pallet, etc.

Defaults

Default currency *

Default unit price

Preferred supplier

Similar items

Substitutes — used when this item is unavailable

Notes

Subscribed warehouses

Master Items

Suppliers

Master Suppliers List

Category Assignments

Subscribe Items to Warehouse

Warehouse:

Show all Subscribed only

Cost Centers

Throughput consumed by a cost center over a period, by category and item.

Cost center

From

To

Currency

Requisition Request, receiving: , supplying:

Code1 Name/Size/Variant UOM Current
Qty PAR
Stock Requested
Qty Currency Est Unit
Price Estimated
Budget

Purchase Request, receiving warehouse:

Code1 Name/Size/Variant UOM Current
Qty PAR
Stock Requested
Qty Currency Last
Unit Price Estimated
Unit Price Estimated
Budget Preffered
Supplier

Adjustment Order for warehouse:

Code1 Name/Size/Variant UOM Currency Current
Qty Current
Value/UOM Current
Value Qty
(new) Qty
(diff) Value/UOM Value

Inventory Tracking for warehouse:

Code Item Size Variant Quantity

Pending , receiving: , supplying:

Sel ID/Pr Recv Date Originator Warehouse
Receiving Who is
Supplying Status Currency Value

Report page (costs)

Project:

Configuration page

1. Projects, Categories, Sub-categories

In the text box below, please put one Project/Category/Sub-Category per line. Categories should be prefixed with one tab, Sub-Categories with 2 tabs. Mark with "#" the categories for which the transaction rows should be colored differently (e.g. #TEMP).

2. Suppliers

In the text box below, please put one Supplier per line.

Cancel Save

Settings

Warehouses

Rename warehouses and change their properties. Adding or removing warehouses is not supported here — ask Florin. Saving reloads the app for all connected users.