1. System Overview

Computerize Finished goods sales/stockflow by using Internet

Refrigerator

POTV, etc

In-Transit

. Delivery Order

. Delivery Receipt

. Delivery Order

. Delivery Receipt

2. Internet Infrastructure

Internet

InternetVPNDial-up

VPN64kbps

128kbps

Internet

VPN

1Mbps

e-logistics system

3. DataFlow Overview

Input Data

Front-ending . Purchase Order

System . In-Transit / Delivery Receipt

. Delivery Order

. Delivery Receipt

. Master file update

Daily data conversion

. Delivery Receipt Data

. Master File Transaction

Back-office

System

  1. Data Processing Chart

12

SJ/DR

Rec

2

SJ/DR

2

SJ/DR

3

D/O Print

D/R

4

2

SJ/DR

2

SJ/DR

3

D/O Print

D/R

4-1 Data Processing at SIL ( Warehouse )

(1)Receiving Finished Goods – Job menu “ Receive by Invoice “

(2)Transfer Finished Goods – Job menu “ Issuing(S/J) “

(3)Print Delivery Order (DO input by Sanjaya Office)

Send Goods to Dealer – Job menu “ Issue D/R “

4-2Data Processing at ISL

(2) Transfer Finished Goods – Job menu “ Issuing(S/J) “

(3) Print Delivery Order “Issuing DO”

Send Goods to Dealer – Job menu “ Issue D/R “

(4) Receiving Goods by IT data – Job menu Receiving(S/J-D/R)


42

6 SJ / DR

Key-in on behalf

Of Warehouse

3

DO Print

DR

5

PO

4-3Data processing at Sanjaya Sakti Office

(2) Transfer Finished Goods – Job menu “ Issuing (S/J)“

(SJ/DR)

(3) Print Delivery Order (DO input by Sanjaya Office)

Send Goods to Dealer – Job menu “ Issue D/R “

(4)Receiving Goods by IT data – Job menu Receiving(S/J-D/R)

. Delivery Order Input – Job menu “ Issuing D/O

(For each delivery site)

. Invoice Data input / print – Use by Foxpro System

(5)Issue PO – Job menu “PO Menu(Issue P/O) “

(6)Receiving Goods by PO – Job menu “ Receive by PO “


42

SJ / DR

3

DO Print

DR

4-4 Data processing at Branch

(2) Transfer Finished Goods – Job menu “ Issuing (S/J) “

(3) Print Delivery Order (DO input “Issuing (D/O)”

Send Goods to Dealer – Job menu “ Issue D/R “

(7)Receiving Goods by IT data – Job menu “Receiving (S/J-D/R)”

5. Computer Job Menu & Person in-charge
NO. / Description / SIL / ISL / Sanjaya / Branch / Sanjaya
Office / MIS
1 / PO Menu ( Issue P/O ) /
2 / Receive By P/O /
3 / Receive By Invoice /
4 / Issuing (SJ) / / / /
5 / Receiving (SJ/DR) / / / /
6 / Edit / Delete Received Entry (SJ/DR) / / / /
7 / Issuing D/O /
8 / Issuing D/R / / / /
9 / Inventory Trace / / / /
10 / Print DO(Reserve) / / / /
11 / Print SJ/DR / / / /
12 / Print DL/DR / / / /
13 / Print PO /
14 / Master Update Location Master /
15 / Master Update Dealer Master / /
16 / Master Update SubDealer Master / /
17 / Master Update Salesman Master / /
18 / Master Update Model Group Master 1 /
19 / Master Update Model Group Master 2 /
20 / Master Update Model Master /
NO. / Description / SIL / ISL / Sanjaya / Branch / Sanjaya
Office / MIS
21 / Daily data conversion Master Data /
22 / Daily data conversion DR (DO) Data /
23 / Monthly Closing Job /
Report Menu
1 / Monthly Stocking Report /
2
3
4
5
6
7
8
9
10
Person-In-Charge / Mr Daeng


Monthly Stocktaking Report Feb/2004

  • Night batchjob on 1 day before from the last day of the month

By Location

Register under Location Master

No-registration send to

Sanjaya office Mis e-mail

Report Sequence ;

Location, Kode-stock, Brand, Model code

Print Item ;

MM/YY

Location, Kode-stock, Brand, Mode code, Modelname

Bal B/F, Receive, Issue, Balance, Stocktake, Reserve.…I/T

PAGE 1