Project

General

Profile

Actions
Copy link

Project progress work #16

closed

Parent project #558: [PJ230025]WMS Digital Picking System

WMS Web Development

Added by Yutthapong Sricha about 2 years ago. Updated about 2 months ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Start date:
21 Sep 2024
Due date:
01 Feb 2025
% Done:

100%

Estimated time:
136.00 h (Total: 456.00 h)
Spent time:
643.00 h (Total: 936.00 h)
Finish date:
18 Nov 2023
Programming skills:
HTML/CSS
DB skills:
MS SQL Server
OS skills:
Windows server

Description

A WMS development project scheduled to be delivered to Ebisu foods.
Implement web coding with PHP.

Files

Download all files
WMS system specifications Documentation EN Blueprint for Ebisu_R1.pptx (7.45 MB) WMS system specifications Documentation EN Blueprint for Ebisu_R1.pptx Yutthapong Sricha, 07 Oct 2023 12:26
【Gantt chart】Project schedule for Ebisu Phase1 Pegasus_R2.xlsx (87.5 KB) 【Gantt chart】Project schedule for Ebisu Phase1 Pegasus_R2.xlsx Ryo Nozaki, 07 Oct 2023 12:34
【Gantt chart】Stock_management_system_Ebisu_Man_hour_R2.xlsx (109 KB) 【Gantt chart】Stock_management_system_Ebisu_Man_hour_R2.xlsx Ryo Nozaki, 07 Oct 2023 12:35
Test_Report_API_LInk_SAP_TO_WMS.xlsx (506 KB) Test_Report_API_LInk_SAP_TO_WMS.xlsx Yutthapong Sricha, 18 Oct 2023 10:58
Screenshot 2023-10-19 082350.png (60.5 KB) Screenshot 2023-10-19 082350.png Yutthapong Sricha, 19 Oct 2023 08:24
Screenshot 2023-10-24 073959.png (43.7 KB) Screenshot 2023-10-24 073959.png Yutthapong Sricha, 24 Oct 2023 07:56
Screenshot 2023-11-01 161227.png (301 KB) Screenshot 2023-11-01 161227.png Yutthapong Sricha, 01 Nov 2023 16:19
Screenshot 2023-11-01 161312.png (122 KB) Screenshot 2023-11-01 161312.png Yutthapong Sricha, 01 Nov 2023 16:31
Screenshot 2023-11-01 161402.png (161 KB) Screenshot 2023-11-01 161402.png Yutthapong Sricha, 01 Nov 2023 16:31
Screenshot 2023-11-01 161415.png (208 KB) Screenshot 2023-11-01 161415.png Yutthapong Sricha, 01 Nov 2023 16:31
Screenshot 2023-11-01 163257.png (144 KB) Screenshot 2023-11-01 163257.png Yutthapong Sricha, 01 Nov 2023 16:33
Test_Report_API_LInk_SAP_TO_WMS.xlsx (895 KB) Test_Report_API_LInk_SAP_TO_WMS.xlsx Yutthapong Sricha, 18 Nov 2023 16:50
ebisu_29112023.xlsx (13.1 KB) ebisu_29112023.xlsx Kittisak Isarapongporn, 29 Nov 2023 18:51
WMS_Ebisu_Action_Plan.pptx (1.11 MB) WMS_Ebisu_Action_Plan.pptx Tanawan Wongsa-ard, 24 Jan 2024 15:36
clipboard-202405091652-ewgjg.png (226 KB) clipboard-202405091652-ewgjg.png Anonymous, 09 May 2024 16:52

Subtasks 1 (0 open — 1 closed)

Project progress work #761: WMS Pegasus & API linkageClosedThiraporn Amornsirinukorh21 Sep 202401 Feb 2025

Actions
Actions
Copy link
 #1

Updated by Yutthapong Sricha about 2 years ago

  • Status changed from New to In Progress
Actions
Copy link
 #2

Updated by Yutthapong Sricha about 2 years ago

  • % Done changed from 0 to 10
Actions
Copy link
 #4

Updated by Ryo Nozaki about 2 years ago

  • Finish date deleted (30 Oct 2023)
Actions
Copy link
 #5

Updated by Yutthapong Sricha about 2 years ago

Test report API sap to wms excerl

update create storeprocedure schedule waiting data form SAP and check trigger inbound and outbound from acme modify to ebisu

Actions
Copy link
 #6

Updated by Yutthapong Sricha about 2 years ago

Today

Waiting Team SAP Ebisu send API Link Sales Order to me

Actions
Copy link
 #7

Updated by Yutthapong Sricha about 2 years ago

Today 24-Oct-2023
1. checking test and Triggers Inbound (insertAfter_Inbound/updateModifired_Inbound)
2. Waitting SAP API Link Sales Order / UOM group Master / Item group Master / Warehouse Master

Actions
Copy link
 #8

Updated by Yutthapong Sricha about 2 years ago

Modify sql

trigger insertAfter_Inbound
Store procedure sp_update_stock

test by manual insert inbound

Modify web pegasus

Actions
Copy link
 #9

Updated by Yutthapong Sricha about 2 years ago

  • Finish date changed from 30 Oct 2023 to 01 Nov 2023

Change schema database LabelStatus

add lbl_inbound_date , lbl_expiry_date

Change trigger insertAfter_LabelStatus
modify qr_code data plattle

"inbound date | expiry_date | lot | item_id | item_name | qty | unit_name | Next_revise"

change web pegasus label generate

Actions
Copy link
 #11

Updated by Yutthapong Sricha about 2 years ago

  • Subject changed from WMS Web Development to WMS Web Development
  • Finish date changed from 01 Nov 2023 to 30 Oct 2023

check Web Pegasus
test add manual inbound for test trigger and store

Modify trigger and StoredProcedure

Actions
Copy link
 #12

Updated by Yutthapong Sricha about 2 years ago

  • Finish date changed from 30 Oct 2023 to 31 Oct 2023

check Web Pegasus
สร้าง StoredProcedure ไว้รอ import data Sales Order จาก SAP

Test Manual โดยไม่มี ข้อมูล SAP

Actions
Copy link
 #13

Updated by Yutthapong Sricha about 2 years ago

UPDATE API SAP to WMS

Detail in Excel

Update sql structure and store procedure on Server Ebisu

Actions
Copy link
 #15

Updated by Tanawan Wongsa-ard almost 2 years ago

  • Assignee changed from Yutthapong Sricha to Tanawan Wongsa-ard

transfer issue

Actions
Copy link
 #16

Updated by Tanawan Wongsa-ard almost 2 years ago

create action plan and diagram

Actions
Copy link
 #17

Updated by Ryo Nozaki over 1 year ago

  • Assignee changed from Tanawan Wongsa-ard to Nongnut Tophimai
Actions
Copy link
 #18

Updated by Ryo Nozaki over 1 year ago

  • Assignee changed from Nongnut Tophimai to Anonymous
Actions
Copy link
 #19

Updated by Ryo Nozaki over 1 year ago

  • Due date changed from 30 Oct 2023 to 31 May 2024
Actions
Copy link
 #20

Updated by Ryo Nozaki over 1 year ago

  • Project changed from 24 to Ebisu Foods Co Ltd.
  • Parent task set to #558
Actions
Copy link
 #21

Updated by Anonymous over 1 year ago

  • Programming skills HTML/CSS added
  • DB skills MS SQL Server added
  • OS skills Windows server added
Actions
Copy link
 #22

Updated by Anonymous over 1 year ago

dev excel and web page Stock Inquiry Report

Actions
Copy link
 #23

Updated by Siriwilai Chaiwattanaphon about 2 months ago

  • Status changed from In Progress to Closed
Actions
Copy link

Also available in: Atom PDF