Project

General

Profile

Actions

roos-fs tasks #306

open

(STORAGE) Seperate area "Warehouse"

Added by Vadim Pariev 9 months ago. Updated 5 days ago.

Status:
Closed
Priority:
Normal
Assignee:
Vitalii Shevchenko
Start date:
08/18/2025
Due date:
08/19/2025 (about 9 months late)
% Done:

0%

Estimated time:
40:00 h

Description

General
There are different spare parts used for different customers. Each spare part is installed based on the service performed on the vehicle. Since there will be a bulk import of the spare parts, it is necessary to prepare the table in the correct format so that the spare parts are, on one hand, categorized, and on the other hand, still listed individually.
In the end, the result should be a table of spare part types, along with a detailed list of the parts with their IDs and related information.

TO DO:

  • Separate area in the leftside menu "Warehouse"
  • The table consists of a main table and sumtable items See exampe HTML
  • In the main table there are 3 main Items (Name if the sapre part, Assigned, not assigned)
  • the main tableitems could be filtered and sorted, see the implimentation in the fither parts of the application
  • The subtables are hidden in default - and could be opened whe the user clicks on the main table item
  • the subtables contain columns with: ID (our internal system ID), Product Serial number (Unique number of the spare part), Customer (assignement of the Customer from the OMS system), Stocked Day (day it was stored), PSP (PSP (for Info: Project-Structure-Plan-Element)), Status (can have only 2 values, installed and in stock), Status Day (date when the status was changed) To whom, Location (from the exisitng locations form the OMS), Complaint (Bullian), Ticket Nr. (Free text), Service (if assigned the service name would be stated, Vechicle (is normally retrieved from the service that was added to)
  • All items could be filtered and sorted
  • all ui items are supported in english and German

See the subtable example attached


Files

tables2.html (4.08 KB) tables2.html Vadim Pariev, 08/18/2025 05:05 PM
OMS Material Storage.xlsm (10.3 KB) OMS Material Storage.xlsm Vadim Pariev, 08/18/2025 05:21 PM
Actions

Also available in: Atom PDF