Discussion Note TECO VIETNAM
W o r k f l o w d is c u ss io n
n ote
Author: Pham Ba Khanh NHAT
1
Date: 19-Aug-09 [Link] PM
Discussion Note TECO VIETNAM
Table of contents
1 WORKFLOW ...............................................................................................4
1.1 Quy trinh ban hang ..................................................................................................4
1.1.1 Nhan nhu cau cua khach hang........................................................................................................ 4
1.1.2 Lap 1 doi tuong khach hang moi ..................................................................................................... 4
1.1.3 Kiem tra ton kho ............................................................................................................................. 4
1.1.4 Kiem tra cong no............................................................................................................................. 4
1.1.5 Xuat hang....................................................................................................................................... 4
1.1.6 Xuat hoa don.................................................................................................................................. 4
1.1.7 Theo doi thanh toan ....................................................................................................................... 4
1.2 Quy trinh tra hang ....................................................................................................4
1.2.1 Nhan hang tra tu khach hang.......................................................................................................... 4
1.2.2 Nhan hoa don tra hang tu khach hang ............................................................................................ 4
1.3 Doi hang giong code ................................................................................................ 5
1.4 Doi hang khac code thay doi gia tri hoa don............................................................. 5
1.5 Doi hang khac code khong thay doi gia tri hoa don .................................................. 5
1.6 Quy trinh quan ly dich vu ......................................................................................... 5
1.6.1 Xuat spare part ra sua chua ............................................................................................................ 5
1.6.2 Xuat item dich vu ra sua chua ......................................................................................................... 5
1.6.3 Xuat hoa don doanh thu dich vu ..................................................................................................... 5
1.7 Quy trinh san xuat....................................................................................................6
1.7.1 Lap don hang san xuat ...................................................................................................................6
1.7.2 Xay dung dinh muc vat tu ...............................................................................................................6
1.7.3 Kiem tra va theo doi ke hoach mua hang va nhap hang...................................................................6
1.7.4 Theo doi xuat vat tu, nhap vat tu.....................................................................................................6
1.7.5 Theo doi nhap ban thanh pham, xuat ban thanh pham ....................................................................6
1.7.6 Theo doi nhap thanh pham, xuat thanh pham.................................................................................6
1.7.7 Ket thuc don hang san xuat ............................................................................................................6
1.8 Quy trinh mua hang .................................................................................................6
1.8.1 Nhan phieu yeu cau mua hang........................................................................................................6
1.8.2 Lap don mua hang.......................................................................................................................... 7
1.8.3 Duyet ............................................................................................................................................. 7
1.8.4 In don hang mua ............................................................................................................................ 7
1.8.5 Nhan hang...................................................................................................................................... 7
1.8.6 Ghi nhan gia tri hoa don mua hang ................................................................................................. 7
1.8.7 Cap nhat gia mua ........................................................................................................................... 7
1.9 Doi hang .................................................................................................................. 7
1.9.1 Nhan yeu cau tra hang.................................................................................................................... 7
1.9.2 Xuat doi hang ................................................................................................................................. 7
1.9.3 Nhap doi hang................................................................................................................................ 7
Author: Pham Ba Khanh NHAT
2
Date: 19-Aug-09 [Link] PM
Discussion Note TECO VIETNAM
1.10 Ra thanh pham de xuat kho ..................................................................................... 7
1.11 Kiem ke.................................................................................................................... 7
2 MASTER DAT ..............................................................................................8
2.1 Customer .................................................................................................................8
2.2 Customer Category...................................................................................................8
2.3 Item Category...........................................................................................................8
2.4 Item Group...............................................................................................................9
2.5 Items .......................................................................................................................9
2.6 Batch .......................................................................................................................9
2.7 Lot Number ............................................................................................................ 10
2.8 Serial ..................................................................................................................... 10
2.9 Sales Price ............................................................................................................. 10
2.10 Phuong thuc xuat hang (Selection Code).................................................................11
2.11 Sales man...............................................................................................................11
Author: Pham Ba Khanh NHAT
3
Date: 19-Aug-09 [Link] PM
Discussion Note TECO VIETNAM
1 WORKFLOW
1.1 Quy trinh ban hang
1.1.1 Nhan nhu cau cua khach hang
1.1.2 Lap 1 doi tuong khach hang moi
1.1.3 Kiem tra ton kho
- Buoc nay ket hop nhung viec sau
o Duyet gia
o Duyet so luong.
o Giam gia
o Kiem tra cong no, neu vuot thi phai len ke hoach thu no moi duoc xuat kho.
1.1.4 Kiem tra cong no
- Kiem tra cong no lan cuoi truoc khi xuat hang.
1.1.5 Xuat hang
Ghi nhan but toan
Dr 632
Cr 155
1.1.6 Xuat hoa don
Ghi nhan but toan
Dr 131
Cr 3331
Cr 511
1.1.7 Theo doi thanh toan
- Phong kinh doanh nhan tien mat cua KH, chuyen khoan ke toan ghi nhan tren Bank Account.
- Nhan tien mat Æ chuyen cho phong Ke toan.
1.2 Quy trinh tra hang
1.2.1 Nhan hang tra tu khach hang
Nhap kho but toan phat sinh
Dr 155
Cr 632
Luu y: Hang tra ve thi se Active lai so Serial da xuat di
1.2.2 Nhan hoa don tra hang tu khach hang
Ghi nhan hoa don but toan phat sinh
Author: Pham Ba Khanh NHAT
4
Date: 19-Aug-09 [Link] PM
Discussion Note TECO VIETNAM
Dr 531
Dr 3331
Cr 131
1.3 Doi hang giong code
- Chi thay doi hang ton kho, khong lien quan den gia tri cua hoa don.
- Phai kiem tra chat luong hang hoa duoc doi truoc khi dong y viec doi hang.
Luu y: Hang tra ve thi se Active lai so Serial da xuat di
1.4 Doi hang khac code thay doi gia tri hoa don
- Lam going quy trinh tra hang.
- Lap don hang ban moi.
Luu y: Hang tra ve thi se Active lai so Serial da xuat di
1.5 Doi hang khac code khong thay doi gia tri hoa don
- Giong nhu quy trinh doi hang giong code tuy nhien giai phap EXACT se khac.
- Phai kiem tra chat luong hang hoa duoc doi truoc khi dong y viec doi hang.
Luu y: Hang tra ve thi se Active lai so Serial da xuat di
1.6 Quy trinh quan ly dich vu
- Quan ly mat hang dich vu (Khong ton kho)
- Quan ly mat hang Spare part.
1.6.1 Xuat spare part ra sua chua
Hach toan nhu sau
Dr 156
Cr 632
1.6.2 Xuat item dich vu ra sua chua
Hach toan nhu sau
Dr 632
Cr 632
1.6.3 Xuat hoa don doanh thu dich vu
Ghi nhan but toan
Dr 131
Cr 3331
Cr 511
Author: Pham Ba Khanh NHAT
5
Date: 19-Aug-09 [Link] PM
Discussion Note TECO VIETNAM
1.7 Quy trinh san xuat
1.7.1 Lap don hang san xuat
TECO TECH
- So luong NVL ton.
- So luong NVL can thiet de san xuat truoc 4 thang + gia so neu co.(Dua don hang san xuat cua 4
thang + % gia so vao he thong)
- Can bao cao binh quan ban hang 1 thang (Hue – TECO TECH se cung cap form).
o So luong ban hang cua tung thang tren 1 mat hang.
o Thang co so luong ban cao nhat trong nam.
- Cung cap bao cao ton kho an toan cho 1 mat hang cua 1 kho.
- Thong ke so luong hang se duoc nhan trong thoi gian … la bao nhieu.
- Can xuat su cua mat hang – Can cu tren quoc tich cua supplier.
- Len ke hoach san xuat tu don ban hang.
TECO ELEC
- San xuat theo don hang.
- So luong NVL ton.
- Cung cap bao cao ton kho an toan cho 1 mat hang cua 1 kho.
- Bao cao san pham do dang.
- Thanh pham nhap kho.
1.7.2 Xay dung dinh muc vat tu
- Nhu tat ca 3 cap de xay dung 1 dinh muc vat tu.
- Nguyen vat lieu Æ Ban thanh pham Æ Thanh Pham Æ Thanh pham cuoi cung.
Level 1 2 3
- Thiet lao BOM voi nhieu phien ban de toi uu hoa cac NVL ton kho.
1.7.3 Kiem tra va theo doi ke hoach mua hang va nhap hang
- Ngay giao hang.
- So luong se giao hang.
- Khong dung chuc nang xuat NVL tu dong. (Backflush)
- Quan ly don vi tinh dong nhat tu khi mua den khi xuat san xuat.
- Xem WIP theo thanh pham.(Thanh pham duoi dang WIP con bao nhieu cai?)
1.7.4 Theo doi xuat vat tu, nhap vat tu
- Xuat NVL theo thuc phat sinh, tuy nhien van khong duoc vuot qua so luong du tinh tren dinh
muc.
- Quan ly NVL thua nhap lai kho.
1.7.5 Theo doi nhap ban thanh pham, xuat ban thanh pham
1.7.6 Theo doi nhap thanh pham, xuat thanh pham
1.7.7 Ket thuc don hang san xuat
1.8 Quy trinh mua hang
1.8.1 Nhan phieu yeu cau mua hang
- Nhan yeu cau tu cac bo phan khac.
Author: Pham Ba Khanh NHAT
6
Date: 19-Aug-09 [Link] PM
Discussion Note TECO VIETNAM
1.8.2 Lap don mua hang
- Gia mua duoc thiet lap va se giam gia tren tung truong hop cu the.
- Tach don hang neu khac kho nhap. Nhu vay don hang se co 1 kho duy nhat.
- Mua hang theo da tien te.
1.8.3 Duyet
- Kiem tra so luong, gia.
- Duoc in ra thanh phieu.
1.8.4 In don hang mua
1.8.5 Nhan hang
- Muon theo doi nhan hang nhieu lan.
1.8.6 Ghi nhan gia tri hoa don mua hang
1.8.7 Cap nhat gia mua
1.9 Doi hang
1.9.1 Nhan yeu cau tra hang
1.9.2 Xuat doi hang
- Muon theo doi nhung mat hang da tra va se nhan ve.
1.9.3 Nhap doi hang
- Nhap hang tu nhung don hang doi.
1.10 Ra thanh pham de xuat kho
- Ra cac thanh pham de nhap kho NVL.
- Gia von se duoc tu tinh tren gia von.
1.11 Kiem ke
- Nhap chenh lech.
- Cap nhat gia chenh lech theo gia von tren item.
Author: Pham Ba Khanh NHAT
7
Date: 19-Aug-09 [Link] PM
Discussion Note TECO VIETNAM
2 MASTER DAT
2.1 Customer
Cac noi dung chinh can duoc thiet lap trong danh sach khach hang.
- Han muc cong no
- Phuong thuc thanh toan
- Dong tien giao dich
- Account manager
-
-
2.2 Customer Category
- Chia theo khu vuc dia ly.
o Taiwan
o ThaiLand
o Korea
o Japan
- Chia theo dai ly.
o Dai ly
o End user
- Chia loai hinh cong ty.
o OEM
o Trading
o Project
o …
- Chia theo loai hinh dau tu.
o Quat
o Xi mang
o Sat thep
o ...
2.3 Item Category
Theo TECO Elec
- Phan theo Ma Luc
o Line A :
o Line B :
o Line C :
o Line D :
Theo TECO Tech
- Phan loai theo line
o Cong tac (Ky tu bat dau MS)
o Cau dao (MCCB)
o Ro le (Ky tu bat dau RHN)
o MCB (Ky tu bat dau MCB)
o HNEB (Ky tu bat dau HNEB)
Author: Pham Ba Khanh NHAT
8
Date: 19-Aug-09 [Link] PM
Discussion Note TECO VIETNAM
2.4 Item Group
1. Nhom Nguyen vat lieu
o Stock : 152
o Revenue : 5110
o COGS : 632
2. Nhom Cong cu dung cu
o Stock : 153
o Revenue : 5110
o COGS : 632
3. Nhom ban thanh pham
o Stock : 154
o Revenue : 5112
o COGS : 6322
4. Nhom thanh pham
o Stock : 155
o Revenue : 5111
o COGS : 6321
5. Nhom hang hoa
o Stock : 156
o Revenue : 5112
o COGS : 6322
6. Nhom service
o Stock : 6323
o Revenue : 5113
o COGS : 6323
Co 2 loai doanh thu khong duoc phan tach tren muc tai khoan la:
- Doanh thu noi dia
- Doanh thu xuat khau
2 loai nay se duoc phan biet tren 1 truong so lieu khac.
Doi voi TECO Tech se khong co nhom hang hoa.
2.5 Items
2.6 Batch
TECO TECH
Quan ly theo so don hang san xuat va BATCH
Quy tac thiet lap:
- 2 ky tu dau : MO – Co dinh cua Pruduction Order.
- 2 ky tu tiep theo : So nam
- 4 ky tu tiep theo : So thu tu cua Pruduction Order.
Author: Pham Ba Khanh NHAT
9
Date: 19-Aug-09 [Link] PM
Discussion Note TECO VIETNAM
2.7 Lot Number
- Se dung Lot Number de quan ly so Don hang san xuat.
Duoc thiep lap nhu sau:
- 2 ky tu dau : MO – Co dinh cua Pruduction Order.
- 2 ky tu tiep theo : So nam
- 4 ky tu tiep theo : So thu tu cua Pruduction Order.
2.8 Serial
- Duoc thiet lap cho tung may cu the, nen phat sinh tu dong so nay khi nhap thanh thap voi so
luong nhieu.
TECO ELECT
Hang san xuat tai cty
Duoc thiep lap nhu sau: So Lot number + So thu tu cua so luong may san xuat cua don hang
So Lot number
- 2 ky tu dau : MO – Co dinh cua Pruduction Order.
- 2 ky tu tiep theo : So nam
- 4 ky tu tiep theo : So thu tu cua Pruduction Order.
So thu tu cua so luong may san xuat cua don hang
- 3 ky tu : So phat sinh tu dong.
Hang nhap khau
Duoc thiep lap nhu sau:
So Lot number
- 2 ky tu dau : MO – Co dinh cua Pruduction Order.
- 2 ky tu tiep theo : So nam
- 4 ky tu tiep theo : So thu tu cua Pruduction Order.
So thu tu cua so luong may san xuat cua don hang
- Nhieu ky tu khong (khong co dinh duoc) : So phat sinh tu dong.
Exact toi da cho phep data so Serial number la 20 ky tu.
2.9 Sales Price
- Thiet lap chinh sach gia cho tung khach hang, cho tung mat hang.
- Thiet lap chinh sach giam gia tren so luong ban.(tren don gia ban)
Author: Pham Ba Khanh NHAT
10
Date: 19-Aug-09 [Link] PM
Discussion Note TECO VIETNAM
2.10 Phuong thuc xuat hang (Selection Code)
Cac phuong thuc xuat - Tai khoan doi ung voi 155/152/153
- Xuat ban - 632
- Xuat cho muon - 157 (Chuyen kho va lap 1 but toan gia tri vao
[Link])
- Xuat sua chua trong cty - 627
- Xuat sua chua ngoai cty - 632
- Xuat bieu tang - 632
- Xuat san xuat - 621/627
- Xuat khac - 641/642/621/627/154
2.11 Sales man
Co 3 loai tinh thuong cho tung Sales man
- Doanh thu theo hop dong, lau sales man tren Sales Order.
- Doanh thu theo hoa don, lay Resource tren line cua tai khoan 511
- Doanh thu theo so tien nhan duoc, lay Resource tren line cua tai khoan 111,112 doi voi 131.
Teco se chon 1 trong 3 phuong phap tren.
Author: Pham Ba Khanh NHAT
11
Date: 19-Aug-09 [Link] PM
