Wednesday, July 12, 2017

Release to SPZ

I checked in my changes of the last days (for #1933 and #1934) and released to SPZ Eupen.

I had to manually change two lines in the restore.py file:

# vat_InvoiceItem = resolve_model("vat.InvoiceItem")
# vat_VatAccountInvoice = resolve_model("vat.VatAccountInvoice")
vat_InvoiceItem = resolve_model("ana.InvoiceItem")
vat_VatAccountInvoice = resolve_model("ana.AnaAccountInvoice")

The following error messages were normal because these two fields no longer exist:

TypeError: 'purchases_vat_account_id' is an invalid keyword argument for this function
TypeError: 'sales_vat_account_id' is an invalid keyword argument for this function

After the upgrade the list of purchase invoices was empty, but only in the web interface. In the console I could see them:

>>> from lino.api.shell import *
>>> ana.AnaAccountInvoice.objects.count()
14

>>> rt.show(ana.InvoicesByJournal, ledger.Journal.get_by_ref("EKR"))
========= ============== ========== =================== ================= ================= ============ ================
 No.       Voucher date   Due date   Partner             Total incl. VAT   Total excl. VAT   VAT          Actions
--------- -------------- ---------- ------------------- ----------------- ----------------- ------------ ----------------
 14        23.06.17                  GUIDE SOCIAL        450,05            450,05                         **Draft**
 13        23.06.17                  Apotheke SCHUNCK    5,96              5,96                           **Registered**
 12        23.06.17                  DELHAIZE            3,10              3,10                           **Registered**
 11        16.06.17                  Die Waschbären                                                       **Draft**
 10        16.06.17                  Rumma & Ko OÜ       3 774,37          3 774,37                       **Registered**
 9         16.06.17                  PANDAVA SA          289,00            289,00                         **Registered**
 8         16.06.17                  LESEZIRKEL          120,90            120,90                         **Registered**
 7         16.06.17                  ETHIAS ASSURANCES   81,94             81,94                          **Registered**
 6         16.06.17                  BNP PARIBAS         131,24            131,24                         **Registered**
 5         16.06.17                  ETHIAS ASSURANCES   4 035,87          4 035,87                       **Registered**
 4         16.06.17                  ETHIAS ASSURANCES   584,64            584,64                         **Registered**
 3         16.06.17                  ETHIAS ASSURANCES   155,62            155,62                         **Registered**
 2         14.06.17                  TELELINQ            1 066,13          881,10            185,03       **Draft**
 1         14.06.17                  TELELINQ            1 130,88          1 130,88                       **Draft**
 **105**                                                 **11 829,70**     **11 644,67**     **185,03**
========= ============== ========== =================== ================= ================= ============ ================

I also had an ImportError: No module named 'unohelper'. This came when I tried to print a table as pdf in spz. It was simply because Running a LibreOffice server was not yet installed.

In our meeting with Lydia I got one new change to do:

  • New checkbox lino_xl.lib.vat.VatRule.vat_returnable is needed because they want the returnable VAT to be booked to the base account and not to a constant separate one.

  • And the translation of “cleared” in German should be “beglichen” and not “ausgeglichen”.

Minor optimizations as side effect of today: