X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/a87694dc525b4eabff11029f1e5401621e2bd3bc..53593baa211863fbf66540cf1bcc36c8fb37257f:/SL/DB/Manager/OrderItem.pm diff --git a/SL/DB/Manager/OrderItem.pm b/SL/DB/Manager/OrderItem.pm index ce673db95..379e1fdb7 100644 --- a/SL/DB/Manager/OrderItem.pm +++ b/SL/DB/Manager/OrderItem.pm @@ -34,11 +34,11 @@ sub _sort_spec { qty => [ 'qty' ], ordnumber => [ 'order.ordnumber' ], customer => [ 'lower(customer.name)', ], - position => [ 'trans_id', 'runningnumber' ], + position => [ 'trans_id', 'position' ], reqdate => [ 'COALESCE(orderitems.reqdate, order.reqdate)' ], orddate => [ 'order.orddate' ], - sellprice => [ 'sellprice' ], - discount => [ 'discount' ], + sellprice => [ 'orderitems.sellprice' ], + discount => [ 'orderitems.discount' ], transdate => [ 'orderitems.transdate::date', 'order.reqdate' ], }, default => [ 'position', 1 ],