Hi, Could someone from katipo explain what is the meaning of the various columns in aqorders table that are related to an amount. I see : * listprice (the price entered when placing the order ?) * totalamount (seems always empty) * freight (empty or=0 for me ? Maybe should be attached to the aqbasket table if it's freight fees, as they should be counted only once) * unitprice (the price really paid ?) * rrp (?) * ecost (?) * gst (?) Many thanks. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
Paul POULAIN wrote:
Could someone from katipo explain what is the meaning of the various=20 columns in aqorders table that are related to an amount.
I'm not katipo, but here's my impression.
I see : * listprice (the price entered when placing the order ?)
The full catalgue price of the item (not including discounts)
* totalamount (seems always empty)
I'd expect this to be unitprice*number ordered after discounts and surcharges.
* freight (empty or=3D0 for me ? Maybe should be attached to the aqbasket= table if it's freight fees, as they should be counted only once) * unitprice (the price really paid ?) * rrp (?)
Recommended retail price (not trade price).
* ecost (?) * gst (?)
General sales tax (our local equivalent, VAT, is not paid on books in the UK - don't know about TVA). -- MJ Ray (slef), K. Lynn, England, email see http://mjr.towers.org.uk/ http://www.ttllp.co.uk/koha/
Hi all MJ Ray has covered some of these, ill grab the ones not. Freight, is post and packaging, its entered when the order is received. unitprice = list price + tax + freight .. so yes the price really paid ecost = estimated cost Chris -- Chris Cormack Katipo Communications Programmer www.katipo.co.nz 027 4500 789
participants (3)
-
Chris Cormack -
MJ Ray -
Paul POULAIN