Portfolio JET DP Magazyn
Every shipment in its own warehouse, with its own documents
A custom warehouse and customs accounting system for JET DP, a logistics company in Poland. It runs several warehouses and the goods of many clients, links every operation to its DSK and MRN numbers, and calculates the cost of warehouse services by itself.
Project
JET DP Magazyn
- Client
- JET DP A Polish logistics company delivering cargo and parcels from Poland to Ukraine. The system is built on the same base as the WOC accounting system.
- System
- Warehouse and customs accounting for several warehouses Stock is kept in kilograms and units, separately for each warehouse and each client.
- Our part
- Process analysis, design and development Also adapting the system to JET DP’s warehouses and ongoing support.
- Stack
-
- PHP
- Laravel
- Livewire
- MariaDB
- Access
- Everyone sees what they need An administrator, a supervisor, managers who work only with their own clients’ goods, and an auditor with view-only access.
The task
Several warehouses, many clients, one set of records
A logistics warehouse stores goods of different companies under customs procedures. The system had to show what is stored, whose it is and in which warehouse, which documents it came with and what handling it costs.
Several warehouses, one set of records
Goods are received into different warehouses, each with its own address and customs codes. Stock has to be visible per warehouse, and every receipt and dispatch tied to a specific one.
Goods of many clients
The warehouses hold goods of different companies. A manager should work only with their own clients’ goods and not see anyone else’s.
Every operation with its customs documents
Receipts and dispatches are linked to DSK and MRN numbers, CN codes and T1 and EX procedures. The full history of operations can be reproduced at any time.
Weight and quantity together
Goods arrive as pallets, boxes and pieces, while the records are kept in kilograms. Weight has to be recalculated from quantity, and no more can be dispatched than is in stock.
Solution
Warehouse, customs and services in one system
Warehouses as a directory
Warehouses are kept in a separate directory with their address and customs codes. Each document belongs to a specific warehouse, and stock is counted for each of them. A new warehouse is added without a developer.
Dispatch from real stock
A manager builds a dispatch from what is actually in stock: the system shows the available DSK and MRN numbers, recalculates weight from quantity and won’t release goods that are short. A document moves through draft, processed and closed.
Warehouse services calculated
For each document the system calculates the cost of services in euros: opening and closing T1 and EX, preparing the DSK, administrative handling, storage, and unloading by pallet or in bulk.
Capabilities
Accounting for a logistics warehouse
01 · 5
Goods and customs
- Goods received and dispatched
- Several warehouses with addresses and customs codes
- Operations linked to DSK and MRN numbers
- CN codes
- Documents and attachments for every operation
02 · 5
Warehouse and clients
- Stock in kilograms and units per warehouse
- How many days goods have been in storage
- Warehouse status for any period
- Seller, buyer and invoice on each dispatch
- Dispatch by specification
03 · 3
Control and access
- Full history of operations and changes
- Managers see only their own clients
- Separate access for the auditor
04 · 4
Reports and data
- Filtered reports, exported to PDF and Excel
- A separate export for the customs broker
- Operations history as a PDF generated in the background
- Automatic data backups
Result
What, whose and where — visible at any moment
JET DP runs several warehouses and the goods of many clients in one system: stock is visible per warehouse, and managers work only with their own clients.
Dispatches are built from real stock and linked to DSK and MRN numbers, warehouse services are calculated automatically, and reports for the broker and the auditor export to PDF and Excel.