Home › Forums › Users › General User's Discussion ›

Invoice item

Submitted by Guest on Sat, 03/06/2017 - 16:21
in

Previous version 1.7

new version 1.9.1

sort order not working now

$F{target.product.entity.type.source.sortOrder}

What should this be update /replaced with

‹ Postcode as User Field in Reminder group staff email ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Invoice item

Submitted by tanderson on Sat, 03/06/2017 - 17:13.

From http://www.openvpms.org/documentation/csh/1.9/new-features/implementatio... :

Custom reports that refer to product.entity.type.source as a field or within expressions should instead use product.entity.type.target.

In your case, it will be:

       target.product.entity.type.target.sortOrder

 

Re: Invoice item

Submitted by ones4tech (not verified) on Sat, 03/06/2017 - 17:27.

I tried that after typing this post

Still getting errors

There is no sub-report named: net.sf.jasperreports.engine.design.JRValidationException: Report design not valid : 
1. Field not found : target.product.entity.type.target.sortOrder
This is needed by report: invoiceItems.jrxml

Re: Invoice item

Submitted by tanderson on Sat, 03/06/2017 - 21:38.

You need to update the field definition as well as everywhere it is used.

If you look at the .jrxml in a text editor, there should be a line:

    <field name="target.product.entity.type.target.sortOrder" class="java.lang.Integer"/>

Note that the templates have been updated for 1.9, and contain significant improvements over 1.8 and earlier. See Update Existing System - Document Templates for details.

 

Re: Invoice item

Submitted by tgething (not verified) on Mon, 05/06/2017 - 08:48.

As the bloke who did all the work on upgrading the 1.9 templates and adding the letterhead facility, I would strongly recommend that rather than trying to tweak the 1.7 templates, that you use the 1.9.1 ones. There is a lot of work in enhancing the 1.7 stuff to make use of the product templatres enhancements.

If you load the 1.9.1 template set, then you will end up with both the 1.7 invoice etc templates and the 1.9.1 ones. However, the system will continue to use the 1.7 ones until you deactivate and/or delete them.

You will have to set up the letterhead record(s) in order to specify the logo(s) to be used.

Regards, Tim G

Syndicate content