Project

General

Profile

Actions
Copy link

Project progress work #52

closed

Parent project #545: [PJ230017]Handy Terminal Stock Management System phase1&2

Issue topics

Added by Kittisak Isarapongporn about 2 years ago. Updated over 1 year ago.

Status:
Closed
Priority:
High
Assignee:
Kittisak Isarapongporn
Start date:
16 Oct 2023
Due date:
22 Oct 2023
% Done:

100%

Estimated time:
56.00 h
Spent time:
37.00 h
Finish date:
Programming skills:
DB skills:
OS skills:

Description

:: last updated: 2023-10-16

- Summarize the remaining topics and issues below.
1. Nisshin Ship & Air
- unit_qty from import (Is it use stock_in instead?)
YES.
[CLOSED]

2. Bom
- Supplier_no (Need to declare)
Try to use the supplier name to map to items.
The supplier would be changed according to items on tag label generator web page.
[IN PROGRESS]

- Duplicated error ( reference part no 2R5GM8129-1, product no MRO-F5AE2 )
Will check the entire 51 files by this month.
[IN PROGRESS]
- No need to management flag(Show only)

MRO-F5AE2 2R5GM8129-1 248 250 2
2R5GM8129-1 2R5GM8129G 249 251 2
MRO-F5AE2 3B3GQ6592-1 266 268 2
3B3GQ6592-1 3B3GQ6592-1G 267 269 2
MRO-F5AE2 2R5AF5835-3 284 286 2
2R5AF5835-3 PP-RHA 285 287 2

[CLOSED]

- Outsource(3rd party) production
BOM doesn't provided the below information
1. Incharge - who will do the outbound job
2. Store - where will store the WIP
[IN PROGRESS]

BOM table
- Add the outsource_flg production
  • No need to do, will manage by the uncontrol items master
    [CLOSED]

Generate the job
1. Outbound from PC (Outbound production)
2. Inbound to store (May be PC store like as material store)
3. Don't need to create the Inbound/Outbound material at production store
[CLOSED]

3. Item
- Create column stock_out_min_qty. The stock_out is used to define the withdrawn unit from its store(The unit has to be checked when choosing the location within the store section referred to [item].[store_section]).
[IN PROGRESS]

4. Stock
- Create columns reserve_qty & reserve_unit.
[CLOSED]

5. Location
- Add section_id (Link to department ID)
[CLOSED]

6. Stock maintenance
- Need to check each label
[CLOSED]

7. Stock_out_min_qty

- In the case of the PC Store is as same as the production store
[CLOSED]

8. Uncontrol parts master
Informed to K.Thip. Waiting for information
[NEW TOPIC]

9. Reprint
[NEW TOPIC]

10. Request parts_no of plastic beads
Informed to K.Thip. Waiting for information
[NEW TOPIC]

11. Request supplier code in BOM
[DUPPLICATED]

Actions
Copy link

Also available in: Atom PDF