[Vtigercrm-developers] Available money - Total fields missing in Invoices, Quotes, PO & SO reports - Should this be...

[Ivar Simpkins (prt)]

Hi all,

 

Am I missing the plot again. 

 

When creating a report on the following objects: 

Quotes, Sales Orders, Purchase Orders and Invoices 

there are no ‘Total Amount’ field selection possibilities. This would be
Invoice amount, Sales Order amount etc.

 

I reconstructed the events and 

                        getSecModuleColumnsList($module)

                        calls

getColumnsListbyBlock($module,$block) in the
\modules\Reports\reports.php class file

 

This produces the following (+-) Sql statement

 

SELECT * FROM vtiger_field
WHERE vtiger_field.uitype !=50
AND `tablename` = 'vtiger_potential'
AND vtiger_field.displaytype
IN ( 1, 2 ) ORDER BY sequence

 

I used 'vtiger_potential' as it has a type 71 – money field in it.
Trying the same SQL statement on Invoices etc, there is no sign of the
‘vtiger_invoice.total’ field.

 

So the questions that arise are:

 

1)       Are there not supposed to be money fields in Quotes, Sales
Orders, Purchase Orders and Invoices by design  (would be disappointing)

2)       Is this a bug

3)       Can I include an appropriate entry into ‘vtiger_field’ and just
see what happens – follow it from there.

 

Any ideas on this would be much appreciated.

 

Version: vt 5.0.1 – svn 9621 – XP

 

This vTiger is like a fractal puzzle, the deeper you delve, the more
beautiful it becomes,

Big thanks to all the team and community – the limits to this creation
are just where you set them.

 

Regards,

 

Ivar 

 

 


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.408 / Virus Database: 268.13.2/471 - Release Date:
2006/10/10
 
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20061011/e29dcf6e/attachment-0004.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 2743 bytes
Desc: not available
Url : http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20061011/e29dcf6e/attachment-0005.jpe