Hello,

I add to Sale order and Invoice custom item fields.
Now when I create Invoice from the Sale order I want that those fields to be pupolat auitomaticaly.

Dose (Field) Mapping Business Mapping support custom item fields?

initial translate

Attached Files

  pt_br.lang.php (Size: 2.57 KB / Downloads: 1)

I need create a sql report, and try this command


SELECT sum( vtiger_cobropago.amount) as 'Soma Valor', sum(vtiger_cobropago.cost) as 'Soma Custos' , sum(vtiger_cobropago.benefit) as 'Soma Liquido',
COALESCE(CONCAT(vtiger_users.first_name,vtiger_users.last_name),vtiger_groups.groupname)
FROM vtiger_cobropago INNER JOIN vtiger_crmentity ON vtiger_cobropago.cobropagoid = vtiger_crmentity.crmid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid WHERE vtiger_crmentity.deleted=0 AND (( vtiger_crmentity.modifiedtime BETWEEN '2020-01-01 00:00:00' AND '2020-01-31 23:59:59') AND (( vtiger_cobropago.paid = '1') )) AND vtiger_cobropago.cobropagoid > 0 group BY COALESCE(CONCAT(vtiger_users.first_name,vtiger_users.last_name),vtiger_groups.groupname)


Working in sql directly command, in mySQL but in SQL reports, not

I think problem is with a user name

How i can solved that?

Thanks!

Is possible I created a report as pivot table like as

I have field user in employes module
I plan related with a assigned to in payments

and listen in columns, sum of amount, cost and paid

I should started choose how module first? ( employee or payments ? )
First field aggregation is a user ( in employes ) and second is amount in payments ( sum )

but system not show anything in report

how I do wrong?

in the Homepage Dashboard. One of the filter i created is the number of tickets by assigned user from the Support Tickets.
it shows decimal points. How to removed this one? see pics

Attached Files

Thumbnail(s)
   

Today I use a g suite to provides my email service

coreBOS need setting a non secure app to get and send emails from gsuite

Gsuite alert this option is deactived soon

There any plan to change a way coreBOS connect with gsuite?

Hello,

I have just finished a pretty new coreBOS installation and, when I'm trying to open Mobile module :

"Permission to perform the operation is denied"

What should I verify ?

Regards

Attached Files

Thumbnail(s)
   

Today is possible generated a csv file to listing all user in system

But role is listed as a code ( like as H1, H2 )

I suggest translated this code to a role name, for better user understand

Attached Files

Thumbnail(s)
   

I wish use that module, but a way to calculate the goal is different of default

I didn't use the opportunities, but will use all payments marked as paid, in specif period

The ideia is calculated, only the values, received, and really confirmed value in your bank account.

For example

User created a payments in module, opportunity, service contracts, tickets, etc, in that specific period

When a financial guy ( user ) will marked that's payment as confirmed in bank account

I will considering this value in goal of this salesman ( user ) in this specif period

How I can change a way system calculate a goal in this module?

and listed each payments is considering for this goal, in detail view too

Thanks

If you had this in a FieldInfo map: