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

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 439,869
» Latest member: herianbkkx
» Forum threads: 1,741
» Forum posts: 9,026

Full Statistics

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

Latest Threads
PRODUCTS IN ACCOUNTS BY O...
Forum: User Support
Last Post: Joana
03-26-2024, 03:48 PM
» Replies: 0
» Views: 30
[RESUELTO] - Tipo de impu...
Forum: Administrator Support
Last Post: inspectorflint
03-22-2024, 05:23 PM
» Replies: 10
» Views: 6,627
Attachment in e-mail not ...
Forum: User Support
Last Post: julikarole
03-13-2024, 05:59 AM
» Replies: 2
» Views: 803
Mail Manager - Options Se...
Forum: Administrator Support
Last Post: joebordes
03-06-2024, 11:52 PM
» Replies: 16
» Views: 17,601
Intermittent issues after...
Forum: User Support
Last Post: joebordes
03-06-2024, 11:44 PM
» Replies: 9
» Views: 1,019
Custom Columns in Mail Ma...
Forum: Modules/Extension Support
Last Post: joebordes
03-06-2024, 11:42 PM
» Replies: 1
» Views: 1,540
[Solved] Gendoc - Contact...
Forum: Administrator Support
Last Post: geraldbigot
02-10-2024, 08:32 AM
» Replies: 2
» Views: 618
Orden en Custom View Lead...
Forum: International
Last Post: juanmax
01-22-2024, 12:38 PM
» Replies: 7
» Views: 1,862
Email Woes: Images Not Lo...
Forum: User Support
Last Post: levis19
11-29-2023, 07:11 AM
» Replies: 0
» Views: 767
Workflow and field betwee...
Forum: Administrator Support
Last Post: joebordes
11-17-2023, 09:15 AM
» Replies: 3
» Views: 1,364

 
  [ Solved ] Bug filter not working anymore
Posted by: rslemer - 08-28-2018, 06:33 PM - Forum: Administrator Support - Replies (12)

I have a strange situation in my coreBOS installation.

Any filter with a basics condition not working anymore ..

For example, I need filter a Lead Source = "text"  and system shows nothing ( but when I listed with sql command, directly in database has many records )

Anybody can help I can solved that?

I applied all changes from github and corebos_updater ( today .. )


In campaign I received this error

Fatal error: Uncaught Error: Call to a member function FetchRow() on boolean in /usr/share/coreBOS/corebos-master/include/database/PearDatabase.php:668 Stack trace: #0 /usr/share/coreBOS/corebos-master/modules/Campaigns/LoadList.php(35): PearDatabase->fetch_array(false) #1 /usr/share/coreBOS/corebos-master/include/Ajax/CommonAjax.php(18): require_once('/usr/share/core...') #2 /usr/share/coreBOS/corebos-master/modules/Campaigns/CampaignsAjax.php(10): require_once('/usr/share/core...') #3 /usr/share/coreBOS/corebos-master/index.php(475): include_once('/usr/share/core...') #4 {main} thrown in /usr/share/coreBOS/corebos-master/include/database/PearDatabase.php on line 668

Print this item

  Would this usecase be a candidate for any of the new report types?
Posted by: Guido1982 - 08-28-2018, 12:45 PM - Forum: Administrator Support - Replies (2)

I have a usecase that is not completely thought through yet, but I would like to leverage one of the new report types to combine work with fun. Would this be applicable:

I need to get salesorders, for a certain time period and a certain user. That part is easy. I also need to get the inventorydetail records (or product lines) that belong to that salesorder, their related product name, quantity, sell price and cost price. Then, lastly I need to get all the related invoices per salesorder to determine the invoice with the latest date.

De we have something like reports with sub-items yet? Something like grouping? So basically top-level would be the salesorders, then beneath that the inventorydetail lines and the invoices.

As you can see I'm not 100% sure about the data I need yet, just want to experiment with the new report types.

Print this item

  Mass update stalls after first record on one module only
Posted by: Guido1982 - 08-28-2018, 10:15 AM - Forum: Administrator Support - Replies (4)

I think this has something to do with a workflow that I have. I want to invoke a workflow on Invoices I just installed. Therefor I'm editing a non-used field on invoices, just to launch the workflow. The mass-edit stalls after one record and just sits there. On that one record, the workflow IS launched and executed. When I mass-edit on another module (I tried salesorders), the mass-edit seems to work fine. How would I debug this? I want to find out what makes the mass edit stall...

Print this item

  Could we get the field helpinfo on detail view
Posted by: Guido1982 - 08-28-2018, 09:09 AM - Forum: coreBOS Development - Replies (2)

Right now helpinfo for fields is only visible on edit view. Could we also show this on detail view? The reason for this is that some fields need some 'reading explanation', with which I mean tell the user what the data he/she is looking at means, even when they don't have rights to alter that data (like a displaytype 4).

Print this item

  How to get the CRM ID of a related record through expression
Posted by: Guido1982 - 08-28-2018, 08:45 AM - Forum: Administrator Support - Replies (7)

I have a workflow task that I want to use to update a field. I want to sum a field in a SalesOrder with all the Invoice nettotals summed up. Therefor I want to get all invoices that are related to the same salesorder that I am launching the workflow task on. So I'm using

Code:
$(salesorder_id : (SalesOrder) subject)
to do that. Problem is, there are many salesorders that have that exact subject. So the workflow engine gives me all of those and sums up all the invoices that have that text in the 'Related SalesOrder' field. Which is not what I want, I want only the Invoices that have that exact salesorder CRM ID. So basically I'd like to do something like
Code:
$(salesorder_id : (SalesOrder) salesorderid)
, but that's not working for me.

I worked around this now by adding a task before the update task that fills a custom field in the invoice with the salesorder_no. The second task (the one that sums) then checks against that salesorder_no on other invoices. This works, but I don't like it since it needs an extra field, task and only works correctly when every invoice has been saved once to update the related salesorder_no (to do the filtering).

Print this item

  InventoryDetails: Cost Total field doesn't work as I expect
Posted by: Guido1982 - 08-28-2018, 07:10 AM - Forum: coreBOS Development - Replies (5)

I see the cost-total field in InventoryDetails and expected it to show me the total cost of the line, so unit_cost * qty. In stead, it shows me the unit_cost / 100, rounded. So a unit cost of 1.338,00 gives me a cost_total of 1,34. Is that intended behaviour? Did I interpret the field wrong?

Print this item

  Suggestion for call pop up - uses a notification central
Posted by: rslemer - 08-27-2018, 12:10 PM - Forum: Administrator Support - Replies (1)

Call pop up - received calls and another calendar pop up

I think good improvement corebos changes this pop ups to announce in notificication system central ( in the operational system )

The best result of this, user can see your notification without a browser with corebos in first plan



Attached Files Thumbnail(s)
           
Print this item

  Some questions about the new financial fields
Posted by: Guido1982 - 08-24-2018, 04:24 PM - Forum: coreBOS Development - Replies (5)

I just found out that my tax hooks are being used to create fields in the financial block in inventory modules that display the sum of all those taxes from the lines on that record. That is very cool and usefull! I do have some issues with it:

  • Setting a tax to inactive does not set the field to inactive. Maybe there are reasons behind this, but right now I can't think of them
  • Updating the tax name does not update the field labels. I could write a commit for that.

Print this item

Smile Suggesting - Create a widget for e-mail - unread
Posted by: rslemer - 08-23-2018, 11:42 AM - Forum: Administrator Support - Replies (2)

In dashboard I wish created a widget to display a unread messages in inbox



Attached Files Thumbnail(s)
   
Print this item

  Google Calendar Sync - No sync happening
Posted by: partnerwerk - 08-23-2018, 08:19 AM - Forum: Administrator Support - No Replies

The GCal synchronization stopped working a while ago. I did not notice it because there was no notification. Now I created a new Google API, added the new credentials and the authorization process was successfully finished.

When I add new calendar items, they are not added to GCal. Neither are GCal items added to CoreBOS. (Settings for export and import to calendars are set correctly.)

The sync settings say: Google is connected.

Where can I look for errors?

Print this item