Welcome, Guest
You have to register before you can post on our site.

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 449,004
» Latest member: camrodfjzr
» Forum threads: 1,743
» Forum posts: 9,040

Full Statistics

Online Users
There are currently 580 online users.
» 1 Member(s) | 579 Guest(s)

Latest Threads
Workflow: función para ex...
Forum: User Support
Last Post: joebordes
2 hours ago
» Replies: 1
» Views: 6
Actualizar campo relacion...
Forum: User Support
Last Post: joebordes
Yesterday, 07:48 PM
» Replies: 1
» Views: 30
PRODUCTS IN ACCOUNTS BY O...
Forum: User Support
Last Post: joebordes
Yesterday, 11:28 AM
» Replies: 3
» Views: 425
[RESUELTO] - Tipo de impu...
Forum: Administrator Support
Last Post: joebordes
04-25-2024, 05:49 PM
» Replies: 13
» Views: 8,153
little bug trasformin LEA...
Forum: Administrator Support
Last Post: payalbatra
04-23-2024, 06:57 AM
» Replies: 4
» Views: 3,682
como manejar github en un...
Forum: International
Last Post: ntermacabre
04-10-2024, 03:52 AM
» Replies: 2
» Views: 1,332
whatsapp
Forum: User Support
Last Post: Yash
04-03-2024, 09:26 AM
» Replies: 2
» Views: 6,177
Attachment in e-mail not ...
Forum: User Support
Last Post: julikarole
03-13-2024, 05:59 AM
» Replies: 2
» Views: 1,206
Mail Manager - Options Se...
Forum: Administrator Support
Last Post: joebordes
03-06-2024, 11:52 PM
» Replies: 16
» Views: 18,577
Intermittent issues after...
Forum: User Support
Last Post: joebordes
03-06-2024, 11:44 PM
» Replies: 9
» Views: 1,811

 
  What's the use of the tax1, tax2 and tax3 columns
Posted by: Guido1982 - 10-19-2016, 11:21 AM - Forum: coreBOS Development - Replies (10)

Why are there 3 columns for tax in the productinventoryrel table? Is this for S&H?

Print this item

  Having trouble with a report
Posted by: Guido1982 - 10-15-2016, 08:09 AM - Forum: coreBOS Development - Replies (1)

Having trouble with a report I want to use, that lists all timecontrol records from a certain report. The error is:

" Unknown column 'vtiger_projectRelProjectTask637.projectname' in 'where clause' "

Anybody have some tips on where to look in the code?

Print this item

  a small manual on Global Variables
Posted by: Guido1982 - 10-15-2016, 08:02 AM - Forum: coreBOS Development - Replies (6)

Since I've just discovered the power of these, I'll post a small manual here. I'll use the example that got me going. In my case I needed the invoice creation to leave the status of the related sales order alone. So I set my Global Variable up like this:

  • I chose "SalesOrderStatusOnInvoiceChange" from the "name" dropdown. That handles this specific case.
  • As a value I entered "DoNotChange", which is a special value the system checks for.
  • I checked the 'mandatory' box.
  • I chose "Module Functionality" from the 'Category' dropdown.

You could also set a different value if you do want the SalesOrder status to change, but not to "Approved".

The order GlobalVariables use as priority is:
  1. First it looks for a GV marked as 'mandatory'.
  2. If none is found, it'll look for one assigned to the current user.
  3. If none is found, it'll look for the group of the current user.
  4. Finally, it'll look for one that's marked as 'default'
  5. If no GV was set, default system behaviour will take place.

Print this item

Exclamation Campo personalizado (relacionado con) en Eventos
Posted by: julioval - 10-14-2016, 08:25 AM - Forum: Administrator Support - Replies (4)

Buenos días,
A la hora de crear un Evento (una llamada o una reunión), actualmente tengo la posibilidad de relacionarlo con:

  • por una parte, un desplegable en el que puedo elegir entre: precontactos, cuentas, oportunidades, incidencias, campañas, proveedores.
  • o, por otro lado, con contactos
Querría poder relacionar un Evento con un presupuesto pero el problema es que si quiero crear un campo personalizado, este no puede ser del tipo relacionado con.
Cómo puedo solucionar situación?
Saludos.

Print this item

  Different way of handling inventorylines in template
Posted by: Guido1982 - 10-12-2016, 07:40 PM - Forum: coreBOS Development - Replies (2)

I'd like to suggest a different way of handling inventorylines in the Smarty template (did not post this in the PackingSlip thread because I think it should be more generic):

In "Smarty/templates/Inventory" we have "InventoryEditView.tpl" and "InventoryCreateView.tpl" (and I think also detailview) we have this line:

PHP Code:
{if $MODULE eq 'PurchaseOrder' || $MODULE eq 'SalesOrder' || $MODULE eq 'Quotes' || $MODULE eq 'Invoice'

That limits the use of inventorylines to only these modules, but why? First of all, this is a special Inventory template, why would it even ask if it should show inventorylines? That's its job, right? And if we still want to impose an 'if' statement here, why not make it more general. Make every module that has inventory capabilities set a smarty variable called 'HAS_INVENTORY' (or something like that) in its EditView.php file and then use that in the 'if' statement. Right now, when creating the packingslip module I'm struggling because the only way to create packingslips using the system templates is to include my modulename in the file, which I don't want to do (shouldn't change core files for module development).

So, I'd be happy to create a PR for this if there are no objections.

Print this item

  Is coreBos ready for muti tenant
Posted by: estares - 10-12-2016, 04:30 PM - Forum: Administrator Support - Replies (2)

Hi all

Can coreBos be configured to run for more than one client? Each client must not see data from other clients but the database is the same.
Or is there a way to run mutliple instances of CoreBos which uses the same database?

Best regards.
Andy

Print this item

  Use one table for multple picklists?
Posted by: Guido1982 - 10-10-2016, 07:26 PM - Forum: coreBOS Development - Replies (2)

Is it possible to create multiple UI15 or 16 fields (in multiple modules) that use the same source table for the picklist values?

Print this item

  SOLVED: Setting standard dropdown item does not work
Posted by: Guido1982 - 10-10-2016, 03:00 PM - Forum: coreBOS Development - Replies (1)

Beware: this is on my ExactOnline module, the first module I made so probably I made some mistake there. One of the fields created is a dropdown in the invoice module. From time to time, it updates the optional items. The problem is, I set a standard value for this picklist in the layout editor of invoices, but it doesn't work. Where is this standard value stored?

EDIT
I found the default value is stored on the field row in vtiger_field. The default value I selected is stored, but not used when I create a new invoice.


Think I found it. The script I use to sync the field options adds a bunch of spaces. That's why when in Smarty the option labels/values don't exactly match and the "selected" attribute is not set.

Print this item

  Autofilling fields from one module to antoher
Posted by: Guido1982 - 10-09-2016, 04:23 PM - Forum: coreBOS Development - Replies (3)

This one took me some time to figure out, and in the end it was dead-simple:

Let's say you want to create a module, of which the records can be created using an entry from another module as the starting point. So you create an action link in the source module's action column that includes the record ID from that source module in the query params.

Now you have a UI10 field in your new module that needs to be filled out with that record. Just edit "CreateView.php" in your new module and add:

PHP Code:
if (isset($_REQUEST['source_id']) && $_REQUEST[source_id'] != '') {
 $focus->column_fields['
your_module_column_name'] = $_REQUEST['source_id'];


Before the smarty BLOCKS are assigned. This will take care of the rest. The source_id is your query param, the columnname is the field/column name in your new module, where you want the link to take place.

Hope this helps someone.

Print this item

  What is "validationdata"
Posted by: Guido1982 - 10-09-2016, 10:45 AM - Forum: coreBOS Development - Replies (2)

Again, as to not pollute the "PackingSlip" thread with global questions:

What does this part do:

PHP Code:
$tabid getTabid("PackingSlip");
$validationData getDBValidationData($focus->tab_name$tabid);
$data split_validationdataArray($validationData);
$category getParentTab();
$smarty->assign("CATEGORY"$category); 

Found here. Are all these functions native app functions?

Print this item