bilgi verirmisiniz lütfen...
alış faturaları kdv 1 lik 8 lik 18 lik ve 00 olan faturaları nasıl hızlı fiş olarara kayde debilirz..
örnek olarak verebilirmisinmiz?
bilgi verirmisiniz lütfen...
LÜTFEN YARDIMCI OLURMUSUNUZ?
Merhaba Sanırım şu şekilde bir tanımlama yapabilirsiniz.
<table style="border-collapse: collapse; width: 714pt;" width="951" border="0" cellpadding="0" cellspacing="0"><col style="width: 136pt;" width="181">
<col style="width: 70pt;" width="93">
<col style="width: 77pt;" width="102">
<col style="width: 81pt;" width="108">
<col style="width: 320pt;" width="427">
<col style="width: 30pt;" width="40">
<t><tr style="height: 30pt;" height="40">
<td ="xl63" style="height: 30pt; width: 136pt;" width="181" height="40">Z RAPORU
1-8-18 SATIŞLAR</td>
<td ="xl64" style="border-left: medium none; width: 70pt;" width="93"></td>
<td ="xl64" style="border-left: medium none; width: 77pt;" width="102"></td>
<td ="xl64" style="border-left: medium none; width: 81pt;" width="108"></td>
<td ="xl64" style="border-left: medium none; width: 320pt;" width="427"></td>
<td ="xl64" style="border-left: medium none; width: 30pt;" width="40"></td>
</tr>
<tr style="height: 30pt;" height="40">
<td ="xl65" style="height: 30pt; border-top: medium none;" height="40">VERİ ADI</td>
<td ="xl65" style="border-top: medium none; border-left: medium none;">HESAP KODU</td>
<td ="xl65" style="border-top: medium none; border-left: medium none;">BORÇ/ALACAK</td>
<td ="xl65" style="border-top: medium none; border-left: medium none;">İŞLEM TİPİ</td>
<td ="xl65" style="border-top: medium none; border-left: medium none;"></td>
<td ="xl65" style="border-top: medium none; border-left: medium none;">GİZLİ</td>
</tr>
<tr style="height: 30pt;" height="40">
<td ="xl64" style="height: 30pt; border-top: medium none;" height="40">MATRAH01</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">A</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">GİRİLEN DEĞER</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">X</td>
</tr>
<tr style="height: 30pt;" height="40">
<td ="xl64" style="height: 30pt; border-top: medium none;" height="40">MATRAH08</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">A</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">GİRİLEN DEĞER</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">X</td>
</tr>
<tr style="height: 30pt;" height="40">
<td ="xl64" style="height: 30pt; border-top: medium none;" height="40">MATRAH018</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">A</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">GİRİLEN DEĞER</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">X</td>
</tr>
<tr style="height: 30pt;" height="40">
<td ="xl64" style="height: 30pt; border-top: medium none;" height="40">KDV01</td>
<td ="xl67" style="border-top: medium none; border-left: medium none;">391.01</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">A</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">FORMÜL</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">MATRAH01-(MATRAH01/1.01)</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
</tr>
<tr style="height: 30pt;" height="40">
<td ="xl64" style="height: 30pt; border-top: medium none;" height="40">KDV08</td>
<td ="xl67" style="border-top: medium none; border-left: medium none;">391.08</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">A</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">FORMÜL</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">MATRAH08-(MATRAH08/1.08)</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
</tr>
<tr style="height: 30pt;" height="40">
<td ="xl64" style="height: 30pt; border-top: medium none;" height="40">KDV018</td>
<td ="xl67" style="border-top: medium none; border-left: medium none;">391.18</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">A</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">FORMÜL</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">MATRAH018-(MATRAH01/1.18)</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
</tr>
<tr style="height: 30pt;" height="40">
<td ="xl64" style="height: 30pt; border-top: medium none;" height="40">MATRAH1</td>
<td ="xl67" style="border-top: medium none; border-left: medium none;">600.01</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">A</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">FORMÜL</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">MATRAH01-KDV01</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
</tr>
<tr style="height: 30pt;" height="40">
<td ="xl64" style="height: 30pt; border-top: medium none;" height="40">MATRAH8</td>
<td ="xl67" style="border-top: medium none; border-left: medium none;">600.08</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">A</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">FORMÜL</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">MATRAH08-KDV08</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
</tr>
<tr style="height: 30pt;" height="40">
<td ="xl64" style="height: 30pt; border-top: medium none;" height="40">MATRAH18</td>
<td ="xl67" style="border-top: medium none; border-left: medium none;">600.18</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">A</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">FORMÜL</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">MATRAH018-KDV018</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
</tr>
<tr style="height: 30pt;" height="40">
<td ="xl64" style="height: 30pt; border-top: medium none;" height="40">KASA</td>
<td ="xl67" style="border-top: medium none; border-left: medium none;">100.01</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">B</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">GİRİLEN DEĞER</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
</tr>
<tr style="height: 30pt;" height="40">
<td ="xl64" style="height: 30pt; border-top: medium none;" height="40">KREDİ</td>
<td ="xl67" style="border-top: medium none; border-left: medium none;">108.01</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">B</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">FORMÜL</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;">(MATRAH18+MATRAH8+MATRAH1+KDV018+KDV08 +KDV01)-KASA</td>
<td ="xl64" style="border-top: medium none; border-left: medium none;"></td>
</tr>
</t></table>
SATIŞLARLA İLGİLİ FORMÜLLER ( ÇOKLU KDV ORANLI FATURA / Z RAPORU İÇİN)
Muhasebe ==> fiş işlemleri ==> hızlı fiş tanımları
Adı* ( satışlar olarak yazabilirsin )===> ekle
eklemiş oldugun satışlar hızlı fiş çift tıklayarak giriş yap
<TABLE id=TBL cellSpacing=1 cellPadding=0 width="100%"><T id=t>
<T>
<TR style="CURSOR: pointer" id=tr1 ="sec;">
<TD width="5%" align=left ="_Metin_01">SATIŞ0 </TD>
<TD width="5%" align=left ="_Metin_01">600.00 </TD>
<TD width="5%" align=middle ="_Metin_01">Alacak </TD>
<TD width="5%" align=left ="_Metin_01">Girilen değer </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0,00000 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0,00 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0 </TD></TR>
<TR style="CURSOR: pointer" id=tr2 ="sec;">
<TD style="DISPLAY: none">2 </TD>
<TD width="5%" align=left ="_Metin_02">SATIŞ1 </TD>
<TD width="5%" align=left ="_Metin_02">600.99 (gizli)</TD>
<TD width="5%" align=middle ="_Metin_02">Alacak </TD>
<TD width="5%" align=left ="_Metin_02">Girilen değer </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">0,00000 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">0,00 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">1 </TD></TR>
<TR style="CURSOR: pointer" id=tr3 ="sec;">
<TD style="DISPLAY: none">3 </TD>
<TD width="5%" align=left ="_Metin_01">SATIŞ8 </TD>
<TD width="5%" align=left ="_Metin_01">600.99 (gizli)</TD>
<TD width="5%" align=middle ="_Metin_01">Alacak </TD>
<TD width="5%" align=left ="_Metin_01">Girilen değer </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0,00000 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0,00 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">1 </TD></TR>
<TR style="CURSOR: pointer" id=tr4 ="sec;">
<TD style="DISPLAY: none">4 </TD>
<TD width="5%" align=left ="_Metin_02">SATIŞ18 </TD>
<TD width="5%" align=left ="_Metin_02">600.99 (gizli)</TD>
<TD width="5%" align=middle ="_Metin_02">Alacak </TD>
<TD width="5%" align=left ="_Metin_02">Girilen değer </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">0,00000 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">0,00 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">1 </TD></TR>
<TR style="CURSOR: pointer" id=tr5 ="sec;">
<TD style="DISPLAY: none">5 </TD>
<TD width="5%" align=left ="_Metin_01">SATIŞLAR1 </TD>
<TD width="5%" align=left ="_Metin_01">600.01 </TD>
<TD width="5%" align=middle ="_Metin_01">Alacak </TD>
<TD width="5%" align=left ="_Metin_01">Formül </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0,00000 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0,00 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">SATIŞ1/1.01 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0 </TD></TR>
<TR style="CURSOR: pointer" id=tr6 ="sec;">
<TD style="DISPLAY: none">6 </TD>
<TD width="5%" align=left ="_Metin_02">SATIŞLAR8 </TD>
<TD width="5%" align=left ="_Metin_02">600.08 </TD>
<TD width="5%" align=middle ="_Metin_02">Alacak </TD>
<TD width="5%" align=left ="_Metin_02">Formül </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">0,00000 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">0,00 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">SATIŞ8/1.08 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">0 </TD></TR>
<TR style="CURSOR: pointer" id=tr7 ="sec;">
<TD style="DISPLAY: none">7 </TD>
<TD width="5%" align=left ="_Metin_01">SATIŞLAR18 </TD>
<TD width="5%" align=left ="_Metin_01">600.18 </TD>
<TD width="5%" align=middle ="_Metin_01">Alacak </TD>
<TD width="5%" align=left ="_Metin_01">Formül </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0,00000 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0,00 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">SATIŞ18/1.18 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0 </TD></TR>
<TR style="CURSOR: pointer" id=tr8 ="sec;">
<TD style="DISPLAY: none">8 </TD>
<TD width="5%" align=left ="_Metin_02">KDV1 </TD>
<TD width="5%" align=left ="_Metin_02">391.01 </TD>
<TD width="5%" align=middle ="_Metin_02">Alacak </TD>
<TD width="5%" align=left ="_Metin_02">Formül </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">0,00000 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">0,00 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">SATIŞLAR1*0.01 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">0 </TD></TR>
<TR style="CURSOR: pointer" id=tr9 ="sec;">
<TD style="DISPLAY: none">9 </TD>
<TD width="5%" align=left ="_Metin_01">KDV8 </TD>
<TD width="5%" align=left ="_Metin_01">391.08 </TD>
<TD width="5%" align=middle ="_Metin_01">Alacak </TD>
<TD width="5%" align=left ="_Metin_01">Formül </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0,00000 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0,00 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">SATIŞLAR8*0.08 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0 </TD></TR>
<TR style="CURSOR: pointer" id=tr10 ="sec;">
<TD style="DISPLAY: none">10 </TD>
<TD width="5%" align=left ="_Metin_02">KDV18 </TD>
<TD width="5%" align=left ="_Metin_02">391.18 </TD>
<TD width="5%" align=middle ="_Metin_02">Alacak </TD>
<TD width="5%" align=left ="_Metin_02">Formül </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">0,00000 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">0,00 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">SATIŞLAR18*0.18 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_02">0 </TD></TR>
<TR style="CURSOR: pointer" id=tr11 ="sec;">
<TD style="DISPLAY: none">11 </TD>
<TD width="5%" align=left ="_Metin_01">KREDİ </TD>
<TD width="5%" align=left ="_Metin_01">108.01 </TD>
<TD width="5%" align=middle ="_Metin_01">Borç </TD>
<TD width="5%" align=left ="_Metin_01">Girilen değer </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0,00000 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0,00 </TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01"></TD>
<TD style="DISPLAY: none" width="5%" align=middle ="_Metin_01">0 </TD></TR>
<TR style="CURSOR: pointer" id=tr12 ="sec;">
<TD style="DISPLAY: none">12 </TD>
<TD width="5%" align=left ="_Metin_02">KASA </TD>
<TD width="5%" align=left ="_Metin_02">100.01 </TD>
<TD width="5%" align=middle ="_Metin_02">Borç </TD>
<TD width="5%" align=left ="_Metin_02">Formül </TD></TR></T></T></TABLE>
formüller yukarıdaki şemada( formül olan kısımlar sadece)
SATIŞLAR1 SATIŞ1/1.01
SATIŞLAR8 SATIŞ8/1.08
SATIŞLAR18SATIŞ18/1.18
KDV1 SATIŞLAR1*0.01
KDV8 SATIŞLAR8*0.08
KDV18 SATIŞLAR18*0.18
KASA SATIŞ0+SATIŞLAR1+SATIŞLAR8+SATIŞLAR18+KDV1+KDV8+KD V18-KREDİ
Aynı şekilde alışlar içinde yukarıdaki formüllerden baglantı kuararak ALIŞLAR için hızlı fiş oluşturabilirsiniz.
Edited by: bybaspinar
Davalı ben davacı ben... Yorgunum bu celselerdennn...!