ACCESS FEED: Re: [belajar-access] Pengurangan pada piutang

Senin, 25 Mei 2015

Re: [belajar-access] Pengurangan pada piutang

death_akira....,

Bisa diuraikan bagaimana struktur masing-masing tabel tersebut?

hariyanto (Surabaya)

--------------------------------------------
On Mon, 25/5/15, death_akira_light@yahoo.com [belajar-access] <belajar-access@yahoogroups.com> wrote:

Subject: [belajar-access] Pengurangan pada piutang
To: belajar-access@yahoogroups.com
Date: Monday, 25 May, 2015, 11:13 AM

Salam kenal semuanya,

saya ada sedikit kendala pada program sederhana
ini,
saya ingin buat program piutang
sederhana.

saya hanya
membuat 3 table
1.table pelanggan
2.table pembelian
3.table
pembayaran
disisni saja menjadikan pembelian
sebagai piutang awal,
yg saya ingin tanyakan
bagaimana cara menggurangi piutang awal secara otomatis saat
pembayaran, dan pembayaran tidak langsung lunas

contoh hasilnya

no. No_faktur Nama_customer
Piutang_Awal Tgl_pembayaran Pembayaran Piutang_akhir
01. 0001
andi

2000000         23/05/2015
1000000      1000000
02
0001
andi
1000000         25/05/2015
100000           0

terimakasiih

#yiv7532803845 #yiv7532803845 --
#yiv7532803845ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv7532803845 #yiv7532803845ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv7532803845 #yiv7532803845ygrp-mkp #yiv7532803845hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv7532803845 #yiv7532803845ygrp-mkp #yiv7532803845ads {
margin-bottom:10px;}

#yiv7532803845 #yiv7532803845ygrp-mkp .yiv7532803845ad {
padding:0 0;}

#yiv7532803845 #yiv7532803845ygrp-mkp .yiv7532803845ad p {
margin:0;}

#yiv7532803845 #yiv7532803845ygrp-mkp .yiv7532803845ad a {
color:#0000ff;text-decoration:none;}
#yiv7532803845 #yiv7532803845ygrp-sponsor
#yiv7532803845ygrp-lc {
font-family:Arial;}

#yiv7532803845 #yiv7532803845ygrp-sponsor
#yiv7532803845ygrp-lc #yiv7532803845hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv7532803845 #yiv7532803845ygrp-sponsor
#yiv7532803845ygrp-lc .yiv7532803845ad {
margin-bottom:10px;padding:0 0;}

#yiv7532803845 #yiv7532803845actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv7532803845 #yiv7532803845activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv7532803845 #yiv7532803845activity span {
font-weight:700;}

#yiv7532803845 #yiv7532803845activity span:first-child {
text-transform:uppercase;}

#yiv7532803845 #yiv7532803845activity span a {
color:#5085b6;text-decoration:none;}

#yiv7532803845 #yiv7532803845activity span span {
color:#ff7900;}

#yiv7532803845 #yiv7532803845activity span
.yiv7532803845underline {
text-decoration:underline;}

#yiv7532803845 .yiv7532803845attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv7532803845 .yiv7532803845attach div a {
text-decoration:none;}

#yiv7532803845 .yiv7532803845attach img {
border:none;padding-right:5px;}

#yiv7532803845 .yiv7532803845attach label {
display:block;margin-bottom:5px;}

#yiv7532803845 .yiv7532803845attach label a {
text-decoration:none;}

#yiv7532803845 blockquote {
margin:0 0 0 4px;}

#yiv7532803845 .yiv7532803845bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv7532803845 .yiv7532803845bold a {
text-decoration:none;}

#yiv7532803845 dd.yiv7532803845last p a {
font-family:Verdana;font-weight:700;}

#yiv7532803845 dd.yiv7532803845last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv7532803845 dd.yiv7532803845last p
span.yiv7532803845yshortcuts {
margin-right:0;}

#yiv7532803845 div.yiv7532803845attach-table div div a {
text-decoration:none;}

#yiv7532803845 div.yiv7532803845attach-table {
width:400px;}

#yiv7532803845 div.yiv7532803845file-title a, #yiv7532803845
div.yiv7532803845file-title a:active, #yiv7532803845
div.yiv7532803845file-title a:hover, #yiv7532803845
div.yiv7532803845file-title a:visited {
text-decoration:none;}

#yiv7532803845 div.yiv7532803845photo-title a,
#yiv7532803845 div.yiv7532803845photo-title a:active,
#yiv7532803845 div.yiv7532803845photo-title a:hover,
#yiv7532803845 div.yiv7532803845photo-title a:visited {
text-decoration:none;}

#yiv7532803845 div#yiv7532803845ygrp-mlmsg
#yiv7532803845ygrp-msg p a span.yiv7532803845yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv7532803845 .yiv7532803845green {
color:#628c2a;}

#yiv7532803845 .yiv7532803845MsoNormal {
margin:0 0 0 0;}

#yiv7532803845 o {
font-size:0;}

#yiv7532803845 #yiv7532803845photos div {
float:left;width:72px;}

#yiv7532803845 #yiv7532803845photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv7532803845 #yiv7532803845photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv7532803845 #yiv7532803845reco-category {
font-size:77%;}

#yiv7532803845 #yiv7532803845reco-desc {
font-size:77%;}

#yiv7532803845 .yiv7532803845replbq {
margin:4px;}

#yiv7532803845 #yiv7532803845ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv7532803845 #yiv7532803845ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv7532803845 #yiv7532803845ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv7532803845 #yiv7532803845ygrp-mlmsg select,
#yiv7532803845 input, #yiv7532803845 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv7532803845 #yiv7532803845ygrp-mlmsg pre, #yiv7532803845
code {
font:115% monospace;}

#yiv7532803845 #yiv7532803845ygrp-mlmsg * {
line-height:1.22em;}

#yiv7532803845 #yiv7532803845ygrp-mlmsg #yiv7532803845logo {
padding-bottom:10px;}

#yiv7532803845 #yiv7532803845ygrp-msg p a {
font-family:Verdana;}

#yiv7532803845 #yiv7532803845ygrp-msg
p#yiv7532803845attach-count span {
color:#1E66AE;font-weight:700;}

#yiv7532803845 #yiv7532803845ygrp-reco
#yiv7532803845reco-head {
color:#ff7900;font-weight:700;}

#yiv7532803845 #yiv7532803845ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv7532803845 #yiv7532803845ygrp-sponsor #yiv7532803845ov
li a {
font-size:130%;text-decoration:none;}

#yiv7532803845 #yiv7532803845ygrp-sponsor #yiv7532803845ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv7532803845 #yiv7532803845ygrp-sponsor #yiv7532803845ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv7532803845 #yiv7532803845ygrp-text {
font-family:Georgia;}

#yiv7532803845 #yiv7532803845ygrp-text p {
margin:0 0 1em 0;}

#yiv7532803845 #yiv7532803845ygrp-text tt {
font-size:120%;}

#yiv7532803845 #yiv7532803845ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv7532803845