LEFT JOIN oe
ON (oe.ordnumber = ${arap}.ordnumber AND NOT ${arap}.ordnumber = ''
- AND ". ($arap eq 'ar' ? 'oe.customer_id IS NOT NULL' : 'oe_vendor_id IS NOT NULL') ." )
+ AND ". ($arap eq 'ar' ? 'oe.customer_id IS NOT NULL' : 'oe.vendor_id IS NOT NULL') ." )
${where}
ORDER BY ${arap}.transdate DESC LIMIT 15";
my @hashes = map {
+{
- value => $_->name,
+ value => $_->displayable_name,
label => $_->displayable_name,
id => $_->id,
$number => $_->$number,
model => 'Customer',
sorted => {
_default => {
- by => 'name',
+ by => 'customernumber',
dir => 1,
},
- name => t8('Name'),
+ customernumber => t8('Customer Number'),
},
);
}
model => 'Vendor',
sorted => {
_default => {
- by => 'name',
+ by => 'vendornumber',
dir => 1,
},
- name => t8('Name'),
+ vendornumber => t8('Vendor Number'),
},
);
}