Coba dalam query-nya anda tambahkan tanggal transaksinya ... good luck ...
> > > > > > > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On > > Behalf Of Handoko > > Sent: Tuesday, September 06, 2005 3:34 PM > > To: [email protected] > > Cc: [EMAIL PROTECTED] > > Subject: [indo-oracle] Query Posisi Stock > > > > Dear All.. > > Saya lagi kebingungan...:-( membuat query posisi stock...!! > > > > Berikut ini adalah table-table yang saya gunakan > > > > Table Barang : > > > > KODE_BRG NAMA_BRG > > A-001 SANDAL > > > > A-002 SEPATU > > > > A-003 MEJA > > > > A-004 KURSI > > > > A-005 SEPEDA > > > > Table Barang_masuk > > > > NO_BUKTI TANGGAL KODE_BRG QTY HARGA > > > > 123 9/6/2005 A-002 10 1500 > > > > 123 9/6/2005 A-003 5 2000 > > > > 123 9/6/2005 A-005 5 5000 > > > > 123 9/6/2005 A-004 10 3000 > > > > 12345 9/7/2005 A-005 10 10000 > > > > 123 9/6/2005 A-001 10 1000 > > > > Table Barang Keluar > > > > NO_BUKTI KODE_BRG TANGGAL_FIFO QTY_FIFO HARGA_FIFO > > > > O-001 A-005 9/6/2005 3 5000 > > > > O-001 A-001 9/6/2005 5 1000 > > > > O-001 A-002 9/6/2005 4 1500 > > > > O-002 A-005 9/8/2005 1 5000 > > > > O-003 A-005 9/6/2005 1 5000 > > > > O-003 A-005 9/7/2005 7 10000 > > > > Saya telah mencoba dengan menggunakan single query seperti dibawah ini : > > > > SELECT A.KODE_BRG,A.NAMA_BRG,B.MASUK,c.keluar,B.HARGA FROM BARANG A, > > (SELECT B1.KODE_BRG,SUM(B1.QTY) AS MASUK,B1.HARGA FROM > > BARANG A1, PEMASUKAN B1 > > WHERE A1.KODE_BRG=B1.KODE_BRG > > GROUP BY B1.KODE_BRG,B1.QTY,B1.HARGA) B, > > (SELECT B2.KODE_brg, sum(qty_fifo) as keluar from > > barang a2, pemakaian b2 > > where > > a2.kode_brg=b2.kode_brg > > group by b2.kode_brg) c > > WHERE A.KODE_BRG=B.KODE_BRG > > and a.kode_brg=c.kode_brg > > > > Hasilnya tidak sesuai dengan keingianan saya, hasilnya sbb > > > > KODE_BRG NAMA_BRG MASUK KELUAR HARGA > > A-001 SANDAL 10 5 1000 > > > > A-002 SEPATU 10 4 1500 > > > > A-005 SEPEDA 5 12 5000 > > > > A-005 SEPEDA 10 12 10000 > > > > Yang saya kasih tanda bold pada posisi keluar merupakan qty yang salah..!, > > > > Hasil Query yang saya inginkan adalah Sbb > > > > KODE_BRG NAMA_BRG MASUK KELUAR HARGA > > > > A-001 SANDAL 10 5 1000 > > > > A-002 SEPATU 10 4 1500 > > > > A-005 SEPEDA 5 5 5000 > > > > A-005 SEPEDA 10 7 10000 > > > > Pada transaksi pengeluaran barang menggunakan metode FIFO..! > > > > Ada yang bisa Bantu.. > > > > Maaf Posting lagi coz datanya tadi amburadol... hehehe. > > > > Thanks > > Handoko > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: [EMAIL PROTECTED] > > Website: http://indo-oracle.lizt.org (NEW) > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.vze.com > > Yahoo! Groups Links > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: [EMAIL PROTECTED] > > Website: http://indo-oracle.lizt.org (NEW) > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.vze.com > > > > > > > > > > > > > > > SPONSORED LINKS > > > > > Membership database software > > > Database mortgage software > > > Pda database software > > > > > Database management software > > > Oracle database administration > > > Oracle database management > > > > > > > > > > > > > > > > YAHOO! GROUPS LINKS > > > > > Visit your group "indo-oracle" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
