<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">On 12-03-2025 14:16, Rene Balvers
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:66eeff1a-fe71-4d02-bf3f-d4348d7e8d9d@balvers.nl">Vraag:
is er ergens een site waar ik alle formaten van CSV bestanden kan
inzien en afhalen?
<br>
</blockquote>
Bedoel je deze:<br>
<br>
<a class="moz-txt-link-freetext" href="https://lists.gnucash.org/docs/C/gnucash-guide/import-invoices.html">https://lists.gnucash.org/docs/C/gnucash-guide/import-invoices.html</a><br>
<a class="moz-txt-link-freetext" href="https://lists.gnucash.org/docs/C/gnucash-guide/busnss-imp-customer-vendor.html">https://lists.gnucash.org/docs/C/gnucash-guide/busnss-imp-customer-vendor.html</a><br>
<br>
Ik gebruik overigens gewoon 1 regel per factuur en niet zoals bij
jou journaalposten.<br>
<br>
Zelf gebruik ik voor de klanten:<br>
<font face="monospace">{ 01 id       . } SetField(01, 'id');<br>
{ 02 company  . } SetField(02, 'company');<br>
{ 03 name     . } SetField(03, 'name');<br>
{ 04 addr1Â Â Â Â . } SetField(04, 'addr1');<br>
{ 05 addr2Â Â Â Â . } SetField(05, 'addr2');<br>
{ 06 addr3Â Â Â Â . } SetField(06, 'addr3');<br>
{ 07 addr4Â Â Â Â . } SetField(07, 'addr4');<br>
{ 08 phone    . } SetField(08, 'phone');<br>
{ 09 fax      . } SetField(09, 'fax');<br>
{ 10 email    . } SetField(10, 'email');<br>
{ 11 notes    . } SetField(11, 'notes');<br>
{ 12 shipname . } SetField(12, 'shipname');<br>
{ 13 shipaddr1 . } SetField(13, 'shipaddr1');<br>
{ 14 shipaddr2 . } SetField(14, 'shipaddr2');<br>
{ 15 shipaddr3 . } SetField(15, 'shipaddr3');<br>
{ 16 shipaddr4 . } SetField(16, 'shipaddr4');<br>
{ 17 shipphone . } SetField(17, 'shipphone');<br>
{ 18 shipfax  . } SetField(18, 'shipfax');<br>
{ 19 shipemail . } SetField(19, 'shipemail');</font><br>
<br>
En voor de verkoopfacturen:<br>
<font face="monospace">{ 01 id            . } SetField(01,
'id');Â Â Â Â Â Â Â Â Â Â Â Â factuurnr<br>
{ 02 date_opened   . } SetField(02, 'date_opened');  Â
factuurdatum<br>
{ 03 owner_id      . } SetField(03, 'owner_id');     Â
debiteurnummer<br>
{ 04 billing_id    . } SetField(04, 'billing_id');<br>
{ 05 notes         . } SetField(05, 'notes');<br>
{ 06 date          . } SetField(06, 'date');         Â
factuurdatum<br>
{ 07 desc          . } SetField(07, 'desc');          betreft<br>
{ 08 action        . } SetField(08, 'action');<br>
{ 09 account       . } SetField(09, 'account');       omzet hoog
e.d.<br>
{ 10 quantity      . } SetField(10, 'quantity');      1<br>
{ 11 price         . } SetField(11, 'price');         bedrag<br>
{ 12 disc_type     . } SetField(12, 'disc_type');<br>
{ 13 disc_how      . } SetField(13, 'disc_how');<br>
{ 14 discount      . } SetField(14, 'discount');<br>
{ 15 taxable       . } SetField(15, 'taxable');       yes<br>
{ 16 taxincluded   . } SetField(16, 'taxincluded');<br>
{ 17 tax_table     . } SetField(17, 'tax_table');     btwcode<br>
{ 18 date_posted   . } SetField(18, 'date_posted');  Â
factuurdatum<br>
{ 19 due_date      . } SetField(19, 'due_date');     Â
vervaldatum<br>
{ 20 account_posted . } SetField(20, 'account_posted'); 1300
DEBITEUREN<br>
{ 21 memo_posted   . } SetField(21, 'memo_posted');<br>
{ 22 accu_splits   . } SetField(22, 'accu_splits');<br>
</font><br>
<br>
Grtz,<br>
Rik<br>
<br>
</body>
</html>