[Vtigercrm-developers] Vtiger 5.4 - Report last sales orders by account

[PlaymaN Tepes]

Hi, thanks for your answer but i cant get the results that I'm expecting.

I need for example: "Show me all accounts which last order is in December
2015".

So I put as primary module Accounts, as second module Sales Order with one
condition: "due date in 2015". Then it shows me all the sales order in
december 2015 (Even if I resume by accountid). Its shows me all sales
orders even if there are in Januarty 2016.

Finally I think to achieve this, the only way, is creating a field in
Accounts module saving "Last Order Date" and when a Sales Order is created,
update this field? With this system, all will works but I expect if I can
do it natively with vtiger.

Thanks for your patience!

2016-01-11 11:59 GMT+01:00 Manu urs <manu.k at vtiger.com>:

> Hi
>
> You can achieve this through  the Report module. Select Sales Order has a
> secondary module during Report generation.
>
> Regards,
> Manu Urs
>
> On Mon, Jan 11, 2016 at 3:22 PM, PlaymaN Tepes <sshhocckk at gmail.com>
> wrote:
>
>> Hi all,
>>
>> I have an vtiger 5.4 installation where accounts have differents Sales
>> Order.
>>
>> My customer needs to retrieve last Sales Order from every Account to know
>> which account is "inactive" or is "active". (For example, customers without
>> sales orders in current month are inactive).
>>
>> Is there some native option to do this? Or should I to code external
>> program to do this?
>>
>> Thanks.
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
>
> --
> Regards,
> Manu
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20160111/2e65dd7b/attachment.html>