Imported Sortly snapshot · standalone test environment
EC
——
/
INVENTORY DB CONNECTING…
PO DB CONNECTING…
Eurocraft Operations
Welcome back, Eurocraft Team
Access the tools and information you need to keep inventory, purchasing, production and service running smoothly.
Low StockMaterials below minimum level
—
Open POsPurchase orders still active
—
Inventory ItemsActive material records across all inventories
—
ServiceTickets, visits and scheduling
Open
Inventory & Materials
Manage stock levels, materials, locations and transactions.
Purchasing
Create POs, review recommendations and manage procurement.
Production
Use optimization and estimating tools for shop-floor preparation.
Service
Service dashboard, tickets, schedules and customer visits.
Reports
View analytics, reports and operational insights.
Administration
Manage users, roles and system settings.
Shared inventory transition: once initialized, Warehouse/Production/Reserved/Paint balances, item master changes, Receiving, Pick Lists, painting reservations, adjustments, stock counts and transaction history are committed to the shared database first. Offline stock changes are blocked instead of creating a second inventory version.
AluminumWarehouse + Production inventory
WarehouseAvailable warehouse stock
Pieces
0
Aluminum currently in Warehouse
Estimated Value
$0
Warehouse pieces × current unit value
ProductionProduction floor stock
Pieces
0
Aluminum currently in Production
Estimated Value
$0
Production pieces × current unit value
ReservedPhysically reserved aluminum
Pieces
0
Aluminum currently in Reserved
Estimated Value
$0
Reserved pieces × current unit value
PaintMaterial currently at Paint
Pieces
0
Aluminum currently in Paint
Estimated Value
$0
Paint pieces × matching aluminum unit value
uPVCProfiles + steel reinforcement
Pieces
0
Current uPVC inventory on hand
Estimated Value
$0
On hand × current uPVC unit price
HardwareHardware Room inventory
Pieces
0
Current hardware units on hand
Estimated Value
$0
On hand × calculated hardware unit cost
Aluminum Low Stock / Open Purchase Ordersaluminum below its configured minimum stock
Extrusion / Item
Description
Color
Physical
Reserved
Available
On Order
Incoming Hold
Projected
Minimum
Buy to Max
Status
uPVC Low StockuPVC profiles and steel below their configured minimum stock
Profile / Part
Description
Color
On Hand
On Order
Projected
Minimum
Buy to Max
Status
Hardware Low Stockhardware below its configured minimum stock
Part #
Description
Supplier
On Hand
On Order
Projected
Minimum
Buy to Max
Status
Data Completenessfields can be completed gradually
Current Locationslive quantity by location
Recently Edited / Movedshared inventory activity
Date
Type
Item
Location
Qty
Reference
Inventory Actions
Columns
Visible columns
↗
Purchase RecommendationsSelect recommended items to build an aluminum PO.
0 selected
Extrusion / Item
Description
Color
Standard Length
Rack / Bin
Status
Actions
50 items per page
Page 1 of 1
Location Actions
Receive Material
Receive open purchase-order material into inventory, or post a non-PO receipt.
Pick List
Pick material from Warehouse, Production, Paint, or another stock location. Move it internally or send it Out of Warehouse to consume it from inventory.
Inventory Adjustments
Correct inventory for counts, damage, scrap, or other discrepancies with a recorded reason.
Pick List Historyshared company record · Pick Lists only
0 pick lists
Date / Time
Reference
From
To
Lines
Pieces
Items
By
Notes
Movement Rulesprototype behavior
Receive+ Quantity
Pick ListMove or Consume
Adjust+ / - Quantity
Audit TrailAlways Recorded
All Series
Item
Description
Color
Rack / Bin
System Qty
Counted Qty
Variance
Completed Stock Count History
Saved from the shared inventory audit trail. Recovered legacy counts contain changed lines only; new counts save every counted line.
Date / Time
Location
Scope
Results
User
Record
Download
Date / Time
Type
Item
From
To
Qty
Reference
Note
50 transactions per page
Page 1 of 1
Inventory
Independent Min / Max
Aluminum planning · separate reports and settings
Aluminum Planning Actions
Consumption rules updated: existing Aluminum reports are automatically regrouped to the corrected finish buckets in this version.
Aluminum: imports only Main Profile Aluminium. Production suffixes are grouped into their base extrusion and Eurocraft's Mill Finish / Clear Anodized corrections remain unchanged.
Planning ParametersAluminum settings · independent from uPVC and Hardware
AVG DAILY = AVG MONTHLY CONSUMPTION ÷ 30.4375
MINIMUM = AVG DAILY × (LEAD TIME + SAFETY STOCK DAYS)
MAXIMUM = MINIMUM + (AVG DAILY × REORDER CYCLE)
FLOOR RULE = IF CALCULATED MINIMUM < 10 → MINIMUM 10 / MAXIMUM 20
RECOMMENDED BUY = MAXIMUM − PROJECTED STOCK, only when PROJECTED STOCK < MINIMUM
Aluminum Monthly Consumption Reportsmaximum three reports for Aluminum
Monthly ReportsExample: June + July + August. Select up to three Aluminum reports, then import them.
Steel ReportsSelect up to three monthly Steel reports.
Reports Loaded
0 / 3
Suggested Items
0
Need Purchase
0
Needs Review
0
Aluminum Calculated Min / Max Suggestionsimport monthly Aluminum reports to calculate recommendations
Aluminum reports keep the existing Eurocraft consolidation rules. A missing extrusion in one imported month is treated as zero consumption for that month. Any calculated Minimum below 10 is raised to Minimum 10 / Maximum 20.
uPVC Inventory
uPVC master imported: 45 profiles from the supplied inventory file. Stock length is extracted from each Entry Name and stored as a separate Standard Length field. Supplier: Kommerling USA · 3402 Stanwood Blvd NE, Huntsville, AL 35811 · (256) 852-0874. Ordering: Kömmerling price-list purchasing is available from the uPVC Order Builder.
Master Profiles
0
On Hand
0
Below Minimum
0
Inventory Value
$0
Stock Lengths
0
uPVC Master & Stock45 imported profiles
Photo
Profile
Part #
Description
Color
Bin
Status
Actions
50 profiles per page
Page 1 of 1
Hardware Inventory
Shared Hardware: the hardware master, On Hand quantities, Min / Max, Hardware POs and receiving are synchronized through the company database. If the database is unavailable, stock-changing actions are blocked instead of creating a separate local version.
Master Items
0
On Hand
0
On Order
0
Below Minimum
0
Inventory Value
$0
On Hand × unit cost
Hardware Master & Stock472 imported itemsImage view is default for Hardware · switch to table view for column filters
↗
Hardware Purchase RecommendationsSelect recommended items from one supplier to build a Hardware PO.
0 selected
Part #
Description
Type
Classification
Finish
Supplier
Bin
Status
Actions
50 items per page
Page 1 of 1
Hardware Ordering
Hardware pricing rule: the latest matched Hardware export is the unit-price source. Prices are per inventory unit (EA / PC / PAIR / FT / M); Pack / Roll Quantity is only the supplier order multiple. Source rows with blank prices remain unchanged for manual review.
Order Setupsingle-supplier Hardware PO
Hardware Linespack/roll is an order multiple · all listed prices are per inventory unit
Type or select a Part #. Description, order multiple and per-unit price fill automatically.
Part #
Description
Classification
Order By
Pack Size
Order Qty
Units Ordered
Unit Price
Inventory Unit Cost
Line Total
Order Lines0
Packages / Units0
Physical Units0
PO Total$0.00
uPVC Ordering
Kömmerling purchasing: uPVC profiles are ordered in White only; steel reinforcement is ordered No Color / Mill Finish. Supplier prices are stored per meter and converted to full-piece cost using the supplier stock length. Profile minimum quantities from the supplied price lists are enforced. Orders are built as full stock lengths, so the supplier's $250/pallet cutting charge is not added automatically. Freight is entered separately because the price lists are FCA Huntsville.
Order SetupKömmerling USA · shared company PO sequence
Select a current uPVC inventory profile. Supplier length, minimum and price fill from the attached Kömmerling lists when available.
Profile
Description
Type
Finish
Supplier Length
Supplier Min
Crate
$/m
$/pc
Qty (pcs)
Line Total
Price Source
Order Lines0
Pieces0
Material$0.00
Freight + Other$0.00
PO Total$0.00
Purchase Planner
Intelligent Aluminum Purchasing: Aluminum Inventory recommendations define the Must Buy pool, while every compatible variant below Max remains available as a safe Top-Up. Preferred routing: supported non-anodized 100 / 200 / 300 material is routed to Florida Aluminum Alliance first; supported non-anodized 500 / 600 material is routed to Extrum first. The planner then checks real supplier requirements. If a preferred Florida or Extrum plan cannot form a valid 18 metric tonne order, it automatically tests safe consolidation into Extrusiones Metálicas. If supplier plans are still short, Consolidate & Fill Provider Requirements uses the same closest-container consolidation as the weight-fill button, but treats the target provider's die minimums as a hard requirement: every included die is filled first, and if Max must be exceeded to meet that die minimum, the excess is assigned to the finish with the highest historical consumption for that die. The 18 metric tonne total is not filled until all included dies meet their minimum. Consolidate & Fill Remaining Weight remains the weight-driven option: it targets the closest 18 metric tonne container by remaining pounds. Ready supplier orders are never broken apart. General container-weight fill keeps the one Min→Max replenishment band safety ceiling. Exception: an included Extrum/Metálicas die that is below its mandatory die minimum may exceed Max as far as needed to reach that die minimum, using the highest-consumption finish for that die. Hydro remains temporarily excluded. Freight entered manually in the Order Builder is not guessed here.
Must Buy Variants0projected below Minimum
Top-Up Pool0below Max · supplier eligible
Supplier Plans0recommended order groups
Ready Plans0supplier minimums satisfied
Estimated Material$0known price + known supplier tariff
Needs Review0short requirement / no supplier
Items Requiring Manual Supplier Reviewno priced compatible supplier could be selected automatically
Shared PO transition: this builder uses the full supplier-specific ordering engine. Approved POs can be synchronized with the existing company Approved PO archive. Automatic publishing of newly ordered POs is OFF by default and can be enabled in Settings; inventory quantities and receiving transactions are still local in this version.
Current purchase orderNew order
SupplierHydro
Pieces0
Weight0 lb
Landed cost$0.00
Eurocraft Industries · Purchasing
Hydro Aluminum Order
Active Supplier Rules
Order Setup & Pricingsupplier master + simple monthly market inputs
Total weight
0 lb
0.00 metric tonnes
Total pieces
0
Order lines
0
Base material
$0.00
Landed cost
$0.00
Requirement
—
Add order lines
1 · Order Linesprovider-supported dies and finishes
Extrusion
Description
Alloy
Temper
Finish
Pieces
Length
LB/FT
Weight
Base $/PC
Landed $/PC
Material Total
Pricing
Length Source
Enter each extrusion's length in feet (for example, 20.5 ft = 20 ft 6 in). Weight and price update when you finish editing. Use Standard to restore the supplier length. Hydro custom lengths without an exact quote show a proportional estimate.
2 · Supplier Requirements
Requirement
Scope
Weight
Minimum
Progress
Status
3 · Order by Finishpieces, weight and material cost
Finish
Pieces
Weight
Base Cost
4 · Landed Cost Summaryfreight allocated by weight · tariff applied to supplier-specific eligible basis
Base Material$0.00
Freight / Flete$0.00
Tariff$0.00
Total Landed Cost$0.00
Report Actions
System Configurationshared inventory transition
User Accounts
Accounts are intentionally disabled for this first build. The data model already keeps transaction/user fields so authentication and permissions can be added later without redesigning inventory.
Shared Purchase Order Database
Draft Aluminum and Painting POs are shared with the team for collaborative review and editing. Drafts do not reserve inventory, count as On Order, or affect Projected stock. Approval creates the locked shared Approved PO record.
CONNECTING
Automatic PO Publishing
When enabled, clicking Approve PO will also publish the locked PO snapshot to the shared Approved PO archive. Keep this OFF while testing. You can still explicitly publish an individual Ordered PO from its PO detail screen.
Shared Inventory & Transaction Database
Shared source of truth for item master, locations, Warehouse/Production balances and permanent transaction history. Stock writes are atomic and are blocked if the database is unavailable.
Checking database setup…
CONNECTING
Shared uPVC & Hardware
Company-wide uPVC and Hardware item masters, On Hand quantities, Min / Max, transaction history and Hardware purchase orders. Changes are conflict-protected so two browsers cannot silently overwrite each other.
Checking uPVC / Hardware shared database…
CONNECTING
Imported Snapshot
Warehouse and Production quantities were loaded from the attached exports. Aluminum master fields were added only where the attached purchasing tool provided them.
LOADED
Reload / Reset Local Cache
When Shared Inventory is active, this only discards the browser cache and reloads the shared database; it never deletes company inventory or transaction history.
User ManagementAdministrator only
Create or invite the authentication account in Supabase Authentication first. It will then appear here so an Administrator can activate it and assign one of the approved Eurocraft roles.
Name / Email
Role
Status
Save
Edit Item
Blank fields are valid. The extrusion / item code is also Eurocraft's internal code (for example, 100-01). The system is designed so Eurocraft can progressively complete rack locations, minimum / maximum stock levels, descriptions, and other details as they become available.
Item Detail
uPVC Profile Detail
uPVC Profile Master
The imported quantity is managed separately from the master fields. Kommerling USA is loaded as the supplier for the imported uPVC master. Minimum / Maximum, Location and Rack / Bin can be completed as the remaining uPVC purchasing information becomes available.
Hardware Detail
Adjust Hardware Quantity
±
Hardware Item
Adjust shared On Hand quantity
Current On Hand: 0
New On Hand after adjustment0
This posts directly to shared Hardware inventory. The signed quantity, reason, reference and notes are saved to the Transactions tab.
Hardware Item Master
Part # can be corrected here. The prior Part # is retained as a matching alias so older Hardware PO/history references continue to resolve to this item.
Optional internal code used to identify this Hardware item.
Choose a standard finish or type any custom color, e.g. Brushed Nickel.
Add up to 6 photos. Large phone images are resized automatically. Remove an image from the preview before saving if it should no longer appear.
Master information can be updated here without changing inventory quantities. Minimum / Maximum and Rack / Bin are maintained inside the item record instead of the main Hardware Inventory table.
Inventory Specialist access: item identity, operational master fields and photos can be edited. Supplier pricing / cost fields remain protected.
Inventory Movement
Extrusions to PickAdd as many extrusion lines as needed for this pick.
Extrusion
Available
Quantity to Pick
0 lines0 pieces
Add Location
Receive Hardware PO
Receive physical hardware units into inventory
Ordered0
Previously Received0
Outstanding0
Part #
Description
Ordered Units
Received
Outstanding
Receive Now
Receive uPVC PO
Receive Kömmerling profiles / reinforcement into uPVC inventory
Ordered0
Previously Received0
Outstanding0
Profile
Description
Finish
Ordered
Received
Outstanding
Receive Now
Create Purchase Order
18.5-ft standard: all new POs created here use 18.5 ft for series 100, 200, 300, 400, 450, 500, 600 and 700.
Extrusion
Description
Finish
Length
Suggested
PO Qty
Vendor Unit Price
Purchase Order
Receive Against Purchase Order
Total Ordered0
Previously Received0
Outstanding Before Receipt0
Receiving Now0
Extrusion
Description
Finish
Length
Ordered
Previously Received
Outstanding
Qty Receiving Now
Line Notes / Discrepancy
Inventory Match
Receiving Now0
Received After Posting0
Remaining After Posting0
Lines Entered0
Enter what physically arrived. Quantities intentionally start blank. Use Fill Outstanding only when the shipment matches the PO. Partial receipts are allowed. Over-receiving is allowed after a line-by-line warning. Lines without a unique inventory match cannot be received until the inventory item is corrected.
Receive Painted Material
Inventory conversion: receiving consumes the PO's reserved Current Finish material. White and Bronze return to Warehouse; Satin Black and all other colors return to Paint. If the finished inventory variant does not exist yet, it is created automatically.
Eurocraft System Update
A new version is available
Refresh when ready to load the latest Eurocraft system.