Detil COGM (1).xlsx

	A	B	C	D	E
1		COGM
2		Raw Material
3	1	Persediaan Awal
4			Report	Inventory Valuation Detail
5			Filter Inventory Part Type	Raw & Subs
6			Groups	Checked Show Total
7			Filter Date	dari awal sampai sehari sebelum tanggal From
8
9
10	2	Kenaikan
11		1	Total Masuk (value in) & Total Keluar (value out)
12				Report	Inventory Valuation Detail
13				Filter Inventory Part Type	Raw & Subs
14				Groups	Checked Show Total
15				Filter Date	periode cogm
16
17		2	Material Release
18				Report	Inventory Valuation Detail
19				Filter Inventory Part Type	Raw & Subs
20				Groups	Checked Show Total
21				Filter Date	periode cogm
22				Filter Type Transaksi	Material Release
23
24		3	total masuk – (total keluar - material release)
25
26	3	Persediaan Akhir
27			Report	Inventory Valuation Detail
28			Filter Inventory Part Type	Raw & Subs
29			Groups	Checked Show Total
30			Filter Date	dari tanggal awal - tanggal to
31
32		Work In Process
33	1	Persediaan Awal
34			Report	Inventory Valuation Detail
35			Filter Inventory Part Type	WIP
36			Groups	Checked Show Total
37			Filter Date	dari awal sampai sehari sebelum tanggal From
38
39	2	Kenaikan
40		1	Total Masuk (value in) & Total Keluar (value out)
41				Report	Inventory Valuation Detail
42				Filter Inventory Part Type	WIP
43				Groups	Checked Show Total
44				Filter Date	periode cogm
45
46		2	Material Release
47				Report	Inventory Valuation Detail
48				Filter Inventory Part Type	WIP
49				Groups	Checked Show Total
50				Filter Date	periode cogm
51				Filter Type Transaksi	Material Release
52
53		3	Product Material Result
54				Report	Inventory Valuation Detail
55				Filter Inventory Part Type	WIP
56				Groups	Checked Show Total
57				Filter Date	periode cogm
58				Filter Type Transaksi	Product Material Result
59
60		4	Total Masuk (value in) - Total Keluar (value out) + Material Release - Product Material Result
61
62
63	3	Persediaan Akhir	Report	Inventory Valuation Detail
64			Filter Inventory Part Type	WIP
65			Groups	Checked Show Total
66			Filter Date	dari tanggal awal - tanggal to
67
68	4	WIP Inventory Awal
69			JV Period End periode cogm, nilai before period
70			harusnya sama spt report WIP inventory
71	5	WIP Inventory Akhir
72			JV Period End periode cogm, nilai wip inventory
73			harusnya sama spt report WIP inventory
74
75
76		Finished Good
77	1	Persediaan Awal
78			Report	Inventory Valuation Detail
79			Filter Inventory Part Type	FG
80			Groups	Checked Show Total
81			Filter Date	dari awal sampai sehari sebelum tanggal From
82
83
84	2	Kenaikan
85		1	Total Masuk (value in) & Total Keluar (value out)
86				Report	Inventory Valuation Detail
87				Filter Inventory Part Type	FG
88				Groups	Checked Show Total
89				Filter Date	periode cogm
90
91		2	Material Release
92				Report	Inventory Valuation Detail
93				Filter Inventory Part Type	FG
94				Groups	Checked Show Total
95				Filter Date	periode cogm
96				Filter Type Transaksi	Material Release
97
98		3	Product Material Result
99				Report	Inventory Valuation Detail
100				Filter Inventory Part Type	FG