Invoices/Quotes/Packing Slips

[r31gnf1r3]

Invoices/Quotes/Packing slips will be done using RML to ensure compliance with printed positioning.

Done using ReportLAB. Need to create base invoice.rml using OpenOffice then convert for best results.

[r31gnf1r3]

Examples of invoices from old system

CAA Invoice:

Smart Methods Invoice:

Smart Practice Invoice:

[r31gnf1r3]

Back order customer note:

Packing Labels:

Back order Printout:

[zvadym]

Hi @r31gnf1r3

Done using ReportLAB. Need to create base invoice.rml using OpenOffice then convert for best results.

explain please.

[r31gnf1r3]

Basic PDF view mixin and utils using reportlab:

https://djangosnippets.org/snippets/2975/

[zvadym]

https://doc.openerp.com/6.0/developer/3_11_reports/11_1_openoffice_report/

[zvadym]

@r31gnf1r3 how it going with RML?

[r31gnf1r3]

Commands for converting odt into rml. And also rml into pdf:

cd /usr/lib/pymodules/python2.7/openerp/addons/base_report_designer/wizard/tiny_sxw2rml/

python tiny_sxw2rml.py /home/ubuntu/ExampleDocument.odt > /home/ubuntu/ExampleDocument.rml

trml2pdf /home/ubuntu/ExampleDocument.rml > /home/ubuntu/ExampleDocument.pdf

[zvadym]

http://www.reportlab.com/software/documentation/sample-projects/rml-with-django/

[r31gnf1r3]

Adding a image dynamically into rml.

http://stackoverflow.com/questions/5089886/adding-images-dynamically-to-an-openerp-rml-report-file

[zvadym]

https://pythonhosted.org/django-webodt/tables.html https://pythonhosted.org/django-webodt/quickstart.html so we can just work with the .odt files.. and remove the .rml's totally)

[r31gnf1r3]

Yup agreed. Seems like good solution, and use ooffice as the documents are complicated.

-- abiword is now installed. Opens odt fine as far as I can tell.

[r31gnf1r3]

Also add into models:

documents model with:

• [x] ID
• [x] Name/Title (document title)
• [x] Description (text description)
• [x] Document (text name of the file located in templates/odt - ODT file)

[r31gnf1r3]

Also add into company model:

• [x] LegalName (text)
• [x] POBox (text)
• [x] Address (text dscription)
• [x] DefaultInvoice (FK documents model)
• [x] DefaultPackingslip (FK documents model)

[zvadym]

Models have updated

[zvadym]

@r31gnf1r3 Hi

I have added two new fields to the Company model

payments = models.CharField(max_length=255, null=True, blank=True)
abn = models.CharField(max_length=255, null=True, blank=True)

[zvadym]

Invoice: http://ec2-54-215-172-148.us-west-1.compute.amazonaws.com/order/get_pdf/52572/

this is not final result

[zvadym]

@r31gnf1r3 Please check invoice

http://ec2-54-215-172-148.us-west-1.compute.amazonaws.com/order/get_pdf/52572/?a=1

[zvadym]

@r31gnf1r3 please explain how and when we use "Back order customer note", "Packing Labels" and "Back order Printout". I want to finish with it

[r31gnf1r3]

With chrome, with invoice, it goes to 'save as'. Would be better if it was opened in new-window within browser using the built-in browser pdf viewer.

Also file name- should be 'invoiceID-CustomerName.pdf'. Because staff aren't going to save it, they will just want to print it straight out to the printer.

[r31gnf1r3]

With email. Need a modal dialog to popup. Similar to Xero example below (but simpler).

With just these options:

• [ ] To: customer@email.com (editable / dropdown if there is other email contacts for that client)
• [ ] From: username/email (editable)
• [ ] Subject: Default subject should be: Invoice InvoiceID from CompanyName