Home › Forums › implementation › Implementation discussion ›

Report for listing specific product sales over a given timeframe

Submitted by Guest on Thu, 06/02/2014 - 06:58
in

Hello all.

I need to implement a report that lists sales of a product over a given time period.  The report needs to list the amount of the product sold on each occasion, and which patient it was sold /administered to.  I need this for complying with regulations tracking where certain "controlled drugs" go in the UK.

 

Matt's report (http://www.openvpms.org/customisation/product-sales) nearly gets there.  There is just one bit that bugs me.  The "amount of product" column keeps rounding to the nearest whole number, even though I have set the decimal place setting to 2.  So, for example, if a patient received 1.5ml of xylazine as an injection, the report would list that as 1.0.  I am not really sure why this is, but it is probably only a simple error on my part.

 

Cahir

‹ Planned system maintenance on login screen Synchronisation errors ›

Comment viewing options

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

Re: Report for listing specific product sales over a given ...

Submitted by tony on Thu, 06/02/2014 - 07:08.

Hi Cahir,

Have you tried the existing report here http://www.openvpms.org/customisation/customer-product-sales-report  ?

Cheers Tony

Re: Report for listing specific product sales over a given ...

Submitted by ck234 (not verified) on Thu, 06/02/2014 - 17:55.

Tony,

    Thanks for the pointer.  However, when I run that "customer-product-sales-report", it gives me the drug name and amount, but for some reason the customer column is blank.  Not sure why, I have entered parameters for drugs that I know certain customers have bought in the given time frame.

Cahir

Syndicate content