Contoh Trace Data Audit OCS

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 15

CONTENT CLAIM STANDARD (CCS V2.

0)
CCSSP F02(02), Oct 2016

Annual Reconcilition Report Period


Certified Inward materials Certified Output materials
No. Supplier Material/ Product Type TC No. Net Qty recived Qty Used Qty stock balance No. Buyer Material/ Product TC No Net Qty in TC Total Qty Produced
Type

1 1

2 2

3 3

4 4

6 Belum Ada Transaksi 5

7 7

8 8

9 9

10 10

11 11

12 12

13 13

14 14

15 15

16 16

17 17

18 18

19 19

20 20

21 21

22 22
Total in Stock
Sample Data Sales PIPC ACCOUNTING
No ProdukRaw Material
Komposisi PIC Customer Contract PO Customer Tgl. PO Article Var Qty No. OP Qty Allocate Qty Release No. DN Tgl. DN Qty. Delivery No. Invoice Tgl. Invoice
1 Greige Yarn 100% Cotton Visionland GS200034/1 4500101033 15-Mar-20 TW010184 60,000.00 YDS 23981 25,342.30 YDS 95105989
24241 22,750.44 YDS 95106153
25786 10,309.49 YDS 95107233
27352 3,331.15 YDS 95108462
2 Greige Yarn 23% Cotton + 77 Lyocell Visionland GS190102 4500092975 28-Dec-19 TW090006 10,000.00 YDS 22179 3,584.86 YDS 95104487
100% Lyocel GTECL-0301-KW 20.09 0.77 27350 4,794.40 YDS 95108460
100% Cotton GCOTT-0251-SW 5.99 0.23 28547 1,833.99 YDS 95109429
26.08
3 Finished Yarn 100% Cotton Exaudi AKMM SO-201588/1 PL010087A 01 2,268.00 YDS FP-10314/1 2,226.00 2,204.36 27254 3-Nov-20 2,103.00 MTR 95108417 3-Nov-20
4 Finished Yarn Blend (35% Cotton + 65% Rayon) Vita ASIA SO-201781/1 PL180011B 01 1,000.00 MTR OW-1111/1 1,143.00 1,104.18 27766 27-Nov-20 1,118.00 MTR 95108771 27-Nov-20
5 Finished Greige 100% Cotton Exaudi KEWA SP-210046/1 M047669 24-Dec-20 PL010360A 81 2,821.64 YDS FP-10975/1 2,807.00
6 Finished Greige Blend (97% Cotton + 3% Spandex) Allice RNAG SO-201626/1 TW060027B 81 1,500.00 MTR FD-5542/1 1,575.00 1,586.29 27440 13-Nov-20 1,512.00 MTR 95108516 13-Nov-20
PIPC
No. SJ Yarn/Greige Tgl. SJ Tgl. Terima Qty In Yarn/Greige No. PO Yarn/Greige

ST0000010886 04-Jan-21 07-Jan-21 Makloon


No Produk Raw Material Komposisi Sales Customer Contract
1 Greige Yarn 100% Cotton K.Sharma Visionland GS200034/1

2 Greige Yarn 23% Cotton + 77 Lyocell K.Sharma Visionland GS190102

3 Finished Yarn 100% Cotton Exaudi AKMM SO-201588/1


4 Finished Yarn Blend (35% Cotton + 65% Rayon)
Vita ASIA SO-201781/1
5 Finished Greige 100% Cotton Exaudi KEWA SP-210046/1
6 Finished Greige Blend (97% Cotton + 3% Spandex)
Allice RNAG SO-201626/1
PO Customer Tgl. PO Article Qty No. OP Qty Allocate
4500101033 15-Mar-20 TW010184 60,000.00 YDS

4500092975 28-Dec-19 TW090006 10,000.00 YDS

PL010087A 01 2,268.00 YDS FP-10314/1 2,226.00


PL180011B 01 1,000.00 MTR OW-1111/1 1,143.00
M047669 24-Dec-20 PL010360A 81 2,821.64 YDS FP-10975/1 2,807.00
TW060027B 81 1,500.00 MTR FD-5542/1 1,575.00
Qty Release No. DN Qty. Delivery No. Invoice Yarn / Greige Supply
23981 25,342.30 YDS 95105989
24241 22,750.44 YDS 95106153
25786 10,309.49 YDS 95107233
27352 3,331.15 YDS 95108462
22179 3,584.86 YDS 95104487
27350 4,794.40 YDS 95108460
28547 1,833.99 YDS 95109429
2,204.36 27254 2,103.00 MTR 95108417
1,104.18 27766 1,118.00 MTR 95108771
Kewalram
1,586.29 27440 1,512.00 MTR 95108516
Article Qty Produksi Used No. SJ Tgl. SJ Qty Received

ST0000010 04-Jan-21
No Produk Raw Material Komposisi Sales Customer
1 Greige Yarn 100% Cotton K.Sharma Visionland

2 Greige Yarn 23% Cotton + 77 Lyocell K.Sharma Visionland

3 Finished Yarn 100% Cotton Exaudi AKMM


4 Finished Yarn Blend (35% Cotton + 65% Rayon)
Vita ASIA

5 Finished Greige 100% Cotton Exaudi KEWA


6 Finished Greige Blend (97% Cotton + 3% Spandex)
Allice RNAG
OUTPUT
Contract PO Customer Tgl. PO Article Qty
GS200034/1 P 4500101033 P 15-Mar-20 TW010184 60,000.00 YDS

GS190102/1 P 4500092975 P 28-Dec-19 TW090006 10,000.00 YDS

SO-201588/1 P PL010087A 01 2,268.00 YDS


SO-201781/1 PL180011B 01 1,000.00 MTR

SP-210046/1 P M047669 P 24-Dec-20 PL010360A 81 2,821.64 YDS


SO-201626/1 P GMJBGR/IX/27 P 14-Oct-20 TW060027B 81 1,500.00 MTR
OUTPUT
No. OP Qty Allocate Qty Release No. DN Tgl. DN Qty. Delivery
23981 P 26-Mar-20 25,342.30 YDS
24241 P 8-Apr-20 22,750.44 YDS
25786 P 6-Aug-20 10,309.49 YDS
27352 P 10-Nov-20 3,331.15 YDS

22179 P 3,584.86 YDS


27350 P 4,794.40 YDS
28547 P 1,833.99 YDS

FP-10314/1 2,226.00 2,204.36 27254 P 2,103.00 MTR


OW-1111/1 1,143.00 1,104.18 27766 P 1,118.00 MTR

FP-10975/1 2,807.00
FD-5542/1 1,575.00 1,586.29 27440 P 1,512.00 MTR

23981, 24241, 26-Mar-20, 08-Apr-20, 06-Aug-20, 10


22179, 27350, 28547
No. Invoice Tgl. Invoice Id Yarn / Greige Supply
95105989 P 26-Mar-20 Lot 3144 BCI
95106153 P 8-Apr-20 Lot 3110 BCI
95107233 P 6-Aug-20
95108462 P 10-Nov-20

95104487 P Lot 2656 BCI


95108460 P Lot 2812 BCI
95109429 P Lot 2497 BCI
Lot 2520 BCI

Lot 2681 BCI


Lot 2476 BCI
95108417 P 23021 GMJ
95108771 P 23665 LPA
23666 LPA
23932 LPA
27509 KEWALRAM
95108516 P 25810 RNAG

95105989, 95106153,26-Mar-20, 08-Apr-20, 06-Aug-20, 10-Nov-20


INPUT
Article Qty Produksi Used No. SJ PO Tgl. SJ
GCOTT-0401-PW DN 4565 P YP 200149 P 14.03.20
GCOTT-0401-PW DN 4535 P YP 200111 P 09.03.20

GTECL-0301-KW DN 3923 P YP 190250 P 31.12.19


GTECL-0301-KW DN 4183 P YP 190280 P 29.01.20
GTECL-0301-KW DN 3771 P YP 190191 P 21.11.19
GTECL-0301-KW DN 3813 P YP 190203 P 27.11.19

GCOTT-025-SW DN 3999 P YP 190248 P 06.01.20


GCOTT-025-SW DN 3727 P YP 190188 P 12.11.19
PL010087 2,226 20020466 GP 190124 P 20.02.20
PL180011 282 23665 20.04.20
PL180011 255 23666 08.04.20
PL180011 606 23932 16.06.20
PL010360 2,807 IC162946 MKLN 08.01.21
TW060027 1,575 2009MK248 MKLN 25.09.20

DN 4565, DN 4535, ,
DN 3923, DN 4183, DN 3771, DN 3813, DN 3999, DN 3727
20020466,
23665, 23666, 23932
Qty Received
5,444.52
8,288.89

6,291
1,079
1,120
2,192

583
434
30,096
4,904
4,782
4,593
2,807
18,041

DN 3999, DN 3727
Yarn / Greige Article Qty Used No. SJ PO Tgl. SJ Qty Received
Supply
BCI GCOTT-0401-PW DN 4565 YP 200149 14.03.20 5,444.52
BCI GCOTT-0401-PW DN 4535 YP 200111 09.03.20 8,288.89

BCI GTECL-0301-KW DN 3923 YP 190250 31.12.19 6,291


BCI GTECL-0301-KW DN 4183 YP 190280 29.01.20 1,079
BCI GTECL-0301-KW DN 3771 YP 190191 21.11.19 1,120
BCI GTECL-0301-KW DN 3813 YP 190203 27.11.19 2,192

BCI GCOTT-025-SW DN 3999 YP 190248 06.01.20 583


BCI GCOTT-025-SW DN 3727 YP 190188 12.11.19 434
GMJ PL010087 2,226 20020466 GP 190124 20.02.20 30,096
LPA PL180011 282 23665 20.04.20 4,904
LPA PL180011 255 23666 08.04.20 4,782
LPA PL180011 606 23932 16.06.20 4,593
KEWALRAM PL010360 2,807 IC162946 MKLN 08.01.21 2,807
RNAG TW060027 1,575 2009MK248 MKLN 25.09.20 18,041

You might also like