ZUGFeRD

[sweitmann]

Hi Armaghan,

in order to enable small and medium-sized enterprises to benefit from the advantages of e-invoicing and thus help them make their accounting transactions easier and faster to handle, we have started a project to include the Sales Invoice data from invoices created in SQL-Leder in an .xml file that would be attached to the PDF created with LaTeX (PDF/A). The concept is based on the new ZUGFeRD standard for electronic invoices which is currently gaining ground in Europe.

You will find some more detailed information on ZUGFeRD here: http://www.pdfunit.com/en/documentation/java/testscope/zugferd.html

We have done some testing and found that SQL-Ledger/LaTeX can already almost do this with the aid of some LaTeX plugins (\usepackage{embedfile} \usepackage{filecontents}, but unfortunately there are still some small things missing in SQL-Ledger to make it work:

1.) We need a new variable in the Sales Invoice LaTeX template with the Invoice Date and Due Date in the following strict format "YYYYMMDD", no matter what the date format has been set to in the 'Prefereces' settings;

2.) We need a new variable in the Sales Invoice LaTeX template with the total sum of all taxes <%totaltax%>;

3.) And we also need to have more detailed variables for the Default Company Address:

The best would be if the Default Company Address could be as detailed as the standard customer and vendor address information:

Regards

[ledger123]

Hi Sebastian,

<%totaltax% variable is already there.

I have added following new variables:

<%invdate2%> <%duedate2%> <%companyaddress1%> <%companyaddress2%> <%companycity%> <%companystate%> <%companyzip%> <%companycountry%>

For company variables you just need to add address information in defaults in the format shown in the attached image. I have not added seperate columns as you had suggested but if you think that will be better than the solution I have implemented then I shall do that.

Regards

[ledger123]

And here goes the image to show how to add address for above variables.

Regards

[sweitmann]

Hi Armaghan, tested and everything looks great. Thanks. Please feel free to merge into develop.

Regards

[sweitmann]

Hi Armaghan,

as discussed, we would need the following variables for the xml file:

<%xml_invdate%> (will replace <%invdate2%> which can be removed) <%xml_duedate%> (will replace <%duedate2%> which can be removed) <%xml_tax%> <%xml_taxbase%> <%xml_taxrate%> <%xml_taxbaseinclusive%> <%xml_subtotal%> <%xml_totaltax%> <%xml_qty%> <%xml_linetotal%> <%xml_sumcarriedforward%> <%xml_deliverydate%> <%xml_sellprice%> <%xml_invtotal%> <%xml_total%> <%xml_paid%>

Regards

[ledger123]

Hi Sebastian,

I have pushed the code in 087_ZUGFeRD branch with the required changes.

Variables needs to be tested in the particular template. Please let me know if there any adjustments to be made.

Regards

[sweitmann]

Hi Armaghan,

This code has been tested and it looks good. Thank you!

Only one more minor thing. Could you please add four decimal places to <%xml_qty%>?

Regards

[ledger123]

Hi Sebastian,

Added 4 decimals to xml_qty and pushed to github.

Regards

[sweitmann]

Hi Armaghan,

Tested. Beautiful. Looks great. Thanks! Please release into develop whenever convenient.

Regards

[ledger123]

Hi Sebastian,

Merged and updated release date.

Regards