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]
