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

Customer product sales report deplicating

Submitted by the equine practice on Tue, 30/12/2008 - 16:47
in

Our Customer Product sales report is duplicating most entries (not all) Has any one had this same problem and could maybe offer some advice???

‹ How to display a screen 'capture photo' of issues in openvpms Document attached to Patient summary or Patient documents ›

Comment viewing options

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

RE: Customer product sales report deplicating

Submitted by Tony De Keizer (not verified) on Wed, 31/12/2008 - 09:01.
Hi,

Yes, I think there is a problem in this report wherby it will double up product listings under certian conditions.

I will make some changes and then post the new report on the web site ..

Cheers Tony

-----Original Message----- From: users-bounces@lists.openvpms.org [mailto:users-bounces@lists.openvpms.org]On Behalf Of theequinepractice@gmail.com Sent: Tuesday, 30 December 2008 16:47 To: users@lists.openvpms.org Subject: [OpenVPMS Users] Customer product sales report deplicating

Our Customer Product sales report is duplicating most entries (not all) Has any one had this same problem and could maybe offer some advice??? _______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/mailman/listinfo/users

_______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/mailman/listinfo/users

Re Customer Product Sales Report update

Submitted by jboot (not verified) on Thu, 05/02/2009 - 15:03.

Hi Tony - has this update been made, we have the same problem. How to I get the new version of the report? Sorry if this has been asked before, but i havent found it yet.

Re Customer Sales Report

Submitted by jboot (not verified) on Thu, 05/02/2009 - 16:28.

Hi Tony,

I've found the download site and have picked up all the documents to have a play with - the Gribbles and ASAP submission forms are useful. However I don't know how to deal with the jrxml files. How do I down load them and where do I save them to so that I can use these new reports? Ta. Jon

How to use reports

Submitted by Matt C on Thu, 05/02/2009 - 19:57.

Try here Jon

 

www.openvpms.org/documentation/how-use-report-downloaded-community-shared-resources-area

re How to use reports

Submitted by jboot (not verified) on Thu, 05/02/2009 - 20:53.

Thanks Matt

I've managed it all except part f) ie downloading the file from the net.

Maybe our system has a block on downloading this type of file. I had no trouble with the document templates. Jon

Re: re How to use reports

Submitted by Matt C on Thu, 05/02/2009 - 23:01.
Hi Jon, The way I download the files is right-click on the clink as choose "Save Link As" or the like. Then I choose to save file to desktop or other spot on my computer.

Make sure you RIGHT CLICK. Not left click.

If you still can't download then it may be a setting in your internet browser.

Matt C

On 5 Feb 2009 09:53:45 -0000, clinic@kilsythvet.com.au wrote:

> Thanks Matt > I've managed it all except part f) ie downloading the file from the net. > Maybe our system has a block on downloading this type of file. I had no > trouble with the document templates. Jon > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/mailman/listinfo/users >

_______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/mailman/listinfo/users

Customer product sales

Submitted by jboot (not verified) on Fri, 06/02/2009 - 13:32.

Thanks Matt,

That worked. I' ve got the report up but it still won't run. Ive got the following error code:

Unknown column 'p.act_id' in 'on clause'. is this perhaps because we are still on v 1.2?

Jon

Re: Re: Customer product sales

Submitted by Tony De Keizer (not verified) on Fri, 06/02/2009 - 14:01.
Hi Matt and Jon,

That report is only compatible with version 1.3 not 1.2.

Matt, is it possible to provide another version that uses linkId's and post to web as well .. ??

Cheers Tony

On 6/02/09 1:32 PM, "clinic@kilsythvet.com.au" :

> Thanks Matt, > That worked. I' ve got the report up but it still won't run. Ive got the > following error code: > Unknown column 'p.act_id' in 'on clause'. is this perhaps because we are still > on v 1.2? > Jon > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/mailman/listinfo/users > Posts from this mailing list can be viewed online and replied to in the > OpenVPMS User's forum- http://tinyurl.com/openvfu

_______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/mailman/listinfo/users Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- http://tinyurl.com/openvfu

Customer product sales

Submitted by jboot (not verified) on Fri, 06/02/2009 - 14:24.

Thank you Matt and Tony. (and forum)

 

I'm very happy that I have several new reports up and running.

Cheers Jon

Syndicate content