<!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>