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

Export Product Details

Submitted by Guest on Tue, 28/07/2015 - 16:39
in

Hi

Does anyone know the reason why the Mark Up is not included in the export product details?  How are users changing mark ups in Bulk?

Is is possible to add this to the detail?

Thanks

Cath

‹ OT - survey for Language Testing Research Centre at The University of Melbourne Transfer to WorkList ›

Comment viewing options

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

Re: Export Product Details

Submitted by Ben_Charlton on Tue, 28/07/2015 - 16:54.

In effect its a calculated field each time a product price is changed.

We basically export the products create a column called curr_markup which is calculated from the cost - and sale price ie (((Sale / 1.1) / COST)-1) *100 

I think thats right I would have to check it its based on a reversal of 

(Cost * (1+(Markup/100))) * (1+(TAXRATE/100) = SALE 

Then we use that to update the saleprice in the final sheet we reimport into the Open

 

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au

Re: Export Product Details

Submitted by tanderson on Tue, 28/07/2015 - 18:00.

Hi Cath, the markup is excluded as it can be derived using the cost and price columns. We don't import the markup as the rounding conventions used in the spreadsheet may be different to those within OpenVPMS.

To calculate the markup from the exported columns use:

Unit Price Markup = ((Unit Price / (Unit Cost * ( 1 + Tax Rate/100))) - 1) * 100
Fixed Price Markup = ((Fixed Price / (Fixed Cost * ( 1 + Tax Rate/100))) - 1) * 100

-Tim

Syndicate content