Product Price Templates & Type

Submitted by EastsideVetEmerg on Fri, 09/05/2014 - 18:01

General User's Discussion

Hi,

i was just editing products and tried to assign a product type to a product pice template (so I could draw out injection and dispensing fees as a separate entry in the chart of account system we are trying to set up). There is no product type associated with the product price templates. Why is this? Would it be hard to change? Any suggestions for how I might seperate the dispensing fees component of medications from the cost + markup component? Thanks, Adrian

Re: Product Price Templates & Type

Submitted by Ben_Charlton on Sat, 10/05/2014 - 09:47.

Strictly Speaking Price templates just adjust the fixed price component of a product they dont actually charge a seperate item.

I would imagine that the only way of doing what you describe is moving or adding Type to the product.price archetype. Meaning each price would have its own type.

I guess you could set the cardinality of such a node to 0 in which case the price derives its type from the product or it its set it overrides.

Regards

Ben

OpenVPMS Installer and Helper

Ph: +61423044823

Email: info[at]charltonit.com[dot]au

Re: Product Price Templates & Type

Submitted by EastsideVetEmerg on Sat, 10/05/2014 - 13:07.

Bummer, is this a major change?

I wonder if others would find this useful from an accounting perspective or otherwise?

Does anyone else use the "product types" to draw this data out?

Re: Product Price Templates & Type

Submitted by tanderson on Sat, 10/05/2014 - 17:30.

You could update the product.priceTemplate and entityRelationship.productTypeProduct archetypes to include this fairly easily.

I don't know that this is the right approach however; any discounts and taxes on the product type would not be applied to the price template and those products that link it.

The other possibility is to use classifications. Products may have any number of lookup.productGroup and lookup.productIncomeType classifications added. This is facility is currently disabled for product.priceTemplate, but can be changed by editing the archetype and setting the hidden flag of the "classifications" node to false.

Re: Product Price Templates & Type

Submitted by EastsideVetEmerg on Mon, 12/05/2014 - 11:30.

Hi,

I am not particularly concerned about the issues with discounts and taxes as our taxes as set at a practice level and we use discounts only rarely.

I looked into using classifications and can't remember the nitty gritty but abandoned it as a way of achieving this. Some of the discussion was here. http://www.openvpms.org/forum/avpma-chart-accounts

I have altered the product.priceTemplate and am part of the way there (unhidden type and max cardinality of 1). However I am not sure what I need to alter in the entityRelationship.productTypeProduct archetype to get the product type search box to appear and start linking the product types to the Price Templates?

Thanks, Adrian

Re: Product Price Templates & Type

Submitted by tanderson on Tue, 13/05/2014 - 08:59.

You need to change the entityRelationship.productTypeProduct archetype so that the target node looks like:

        <node name="target" displayName="Product" path="/target"
              type="org.openvpms.component.business.domain.im.common.IMObjectReference" minCardinality="1">
            <assertion name="archetypeRange">
                <propertyList name="archetypes">
                    <propertyMap name="archetype">
                        <property name="shortName" value="product.medication"/>
                    </propertyMap>
                    <propertyMap name="archetype">
                        <property name="shortName" value="product.merchandise"/>
                    </propertyMap>
                    <propertyMap name="archetype">
                        <property name="shortName" value="product.service"/>
                    </propertyMap>
                    <propertyMap name="archetype">
                        <property name="shortName" value="product.priceTemplate"/>
                    </propertyMap>
                </propertyList>
            </assertion>
        </node>

Re: Product Price Templates & Type

Submitted by Ben_Charlton on Tue, 13/05/2014 - 09:48.

So to get my head around this method

Basically you are looking at the product type of a linked product price template and applying that to the fixed componenent of the line item price. ?

If you, at a later date, change the product.pricetemplates classification/type you retrograde affect all previous entries. because type is not stored with line item.

Regards

Ben

OpenVPMS Installer and Helper

Ph: +61423044823

Email: info[at]charltonit.com[dot]au

Re: Product Price Templates & Type

Submitted by tgething (not verified) on Tue, 13/05/2014 - 14:33.

Adrian - as you know we are travelling and have been out of email contact and I am just catching up on things.

I have a strong suspicion that you are not going the best way with this. As I understand it, you want to track both the fixed and variable price components of an item in the accounting system. You are already using the product type to track the income from various products.

Why not simply track, not the total income per product type, but both the fixed and variable components? This would allow you to do the breakup you want when necessary.

Note that since you need to use the reporting system to generate the data to go into your accounting system, it would be quite easy to do 'if product type = xxx then split fixed and variable, else use total'.

Regards, Tim G

Re: Product Price Templates & Type

Submitted by EastsideVetEmerg on Wed, 14/05/2014 - 09:16.

Hi Tim,

Yes, aware you are travelling and was making a concerted effort not to bother you!

As you say the main idea is so I can compare the variable componant of medications and compare them to the COS.

I agree your solution is better and I will perhaps wait until you are back and chat further about it then.

Enjoy your holiday!!

Adrian

Re: Product Price Templates & Type

Submitted by ppvs on Thu, 27/06/2019 - 11:42.

Sorry to be digging up an old thread :)

I would like to able to run a report that does show the details of fees generated by the linked price eg Dispensing/Injection Fees etc.

Is this something that has been added to future versions and I maybe can't find the correct report?

We are running version 1.9.3

Thanks in advance and apologies if I have missed something

Bernie :)

Re: Product Price Templates & Type

Submitted by tanderson on Fri, 28/06/2019 - 13:15.

The Product Price Structure Report included in the standard distribution shows this.

If it hasn't been loaded it, it is located in <OPENVPMS_HOME>/reports/Reporting/Reports/Product/A4/Product Price Structure Report.jrxml

Product Price Templates & Type

Comment viewing options