tolong di koreksi yahhh
===============mulai=================
CREATE PROCEDURE sp_Perhitungan_Stok
@kdbarang char(15),
@barangdibeli float,
@jlm float
AS
if @jlm = ''
begin
declare @max1 float
select @max1=sum(jumlah) from t_fifo where kdbarang = @kdbarang
select @[EMAIL PROTECTED]
end
update tabel_stock
set qty = (@jlm - @barangdibeli) where kdbrg = @kdbarang and status = 'A'
===============selesai====================
disini ada 2 tabel
1 tabel fifo (setiap barang masuk di buat record baru)
2 tabel stok (setiap barang masuk di jumlahkan barang masuk + barang yg ada)
di kasir saya memakai tabel fifo untuk transaksi
contoh kasus:
tabel fifo ada 2record : qty =1 kdbrg=01
qty = 9 kdbrg=01
pertanyaan saya kenapa
pada saat transaksi saya memilih qty yg 9 tapi kenapa tabel stoknya 8 yah
bukan 9
tolong bantuannya THX
---------------------------------
Don't be flakey. Get Yahoo! Mail for Mobile and
always stay connected to friends.
[Non-text portions of this message have been removed]
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
## Jaket ITCENTER tersedia di http://shop.itcenter.or.id
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> 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/
