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

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 539,593
» Latest member: lotioncoast6
» Forum threads: 1,745
» Forum posts: 9,084

Full Statistics

Online Users
There are currently 4 online users.
» 0 Member(s) | 1 Guest(s)
Bing, Google, Yandex

Latest Threads
Finetuning the way you se...
Forum: coreBOS Development
Last Post: alexandy40d
12-06-2024, 07:38 AM
» Replies: 4
» Views: 8,134
MariaDB Version
Forum: Administrator Support
Last Post: joebordes
11-01-2024, 11:49 AM
» Replies: 1
» Views: 613
Product Catalog / parts c...
Forum: Modules/Extension Support
Last Post: joebordes
09-15-2024, 09:40 AM
» Replies: 1
» Views: 1,106
Challenges and Best Pract...
Forum: coreBOS Development
Last Post: wishforbes
08-30-2024, 04:21 PM
» Replies: 0
» Views: 717
PRODUCTS IN ACCOUNTS BY O...
Forum: User Support
Last Post: jonathanmoore858
08-03-2024, 04:14 PM
» Replies: 4
» Views: 2,755
Zapier | Integration
Forum: Modules/Extension Support
Last Post: bernardgbailey
07-29-2024, 11:45 PM
» Replies: 7
» Views: 9,841
Versión PHP recomendada
Forum: International
Last Post: joebordes
07-04-2024, 05:42 PM
» Replies: 7
» Views: 3,318
Could Someone Give me Adv...
Forum: Open Discussions
Last Post: joebordes
06-27-2024, 08:32 AM
» Replies: 1
» Views: 1,696
RESTRICTED FILE
Forum: Administrator Support
Last Post: inspectorflint
06-22-2024, 08:08 AM
» Replies: 7
» Views: 5,652
GENDOC imágenes
Forum: Open Discussions
Last Post: joebordes
06-02-2024, 05:11 PM
» Replies: 4
» Views: 2,018

 
  Popup open hook
Posted by: radu - 06-22-2020, 08:41 AM - Forum: Administrator Support - Replies (3)

I tested the wiki example for using a popup hook to filter the popup list of Assets based on a given Product's name. This is about the behavior of that popup list and the fact that it works, but if the result is split in more pages, when you go to the next page it reverts to the original 'all' list.
So in more detail, i can't be sure if I'm doing it entirely right and that procedure might be deprecated now with the business actions but:
-i did saved the js file
-i did execute the php that contains the addlink instruction
-i did insert in Products.php the condition(before the existing one in that function)
The hook did not work until i defined a business action stating what was in the addlink php. But then it worked, at least for the first page. It shows the correct number of results and the button for 'show all' but if you move to another page it loses the whole list and reverts to the default all list.

Print this item

  Product compnents / Product bundle
Posted by: radu - 06-22-2020, 08:23 AM - Forum: Modules/Extension Support - No Replies

If i understand correctly, product  bundles permit to establish a relation between products. It is governed by some GV's and two of them refers to price roll-up and cost roll-up. I set price roll-up to 1, did not necessarily apply to Products module but to all of the modules just to be sure. I set it to default and mandatory.
It's either i don't understand it correctly or  something does not function properly. Here is what I noticed:
- I make 2 products kit1 and subkit1
- in product bundle related list of kit1 i select subkit1. A relation is established and a new element representing this relation is added in Product Components module. The 'subproduct'(not the relation) is showing in Product Bundles table of kit1. At this point I would expect the unit price of kit1 to be increased with the unit price of subkit1. It does not happen, price of kit1 remains the same.
- if i try to view/edit the subproduct from the related table I get an error saying Record you are trying to access is not found. When I try to delete the relation, table collapses and nothing else happens. Here is the details with that 'not found' error:
kit1 record number is 25435
subkit1 record number is 25444
product component relation record number is 25459
the record number shown in the 'not found' error is 25459: 'index.php?action=DetailView&module=Products&record=25459'
so things Are not working properly in my installation. Could be that it does refer to the relation's id instead of the 'subroduct' id. make sense not being able to display/edit a product id that is not in the products table. Also adding prices would not work if it refers to a Product Components element(if that in itself does not return some kind of value).
-if i view the relation from the 'subproduct's' point of view, in it's Parent Product related list I can see the correct relation and links point to the correct elements, i can delete the relation from there.
So it's either that i do something wrong or there's something else going on. In the end the price does not roll-up(and neither the cost if tested)
Of course i can update the unit price with an aggregation workflow, but that leads into some issues later on.
Hope I explained it right.

UPDATE
After doing some more tests i found out that roll-up functions work if you ADD the product instead of SELECT it on the Product Bundles related table. In that case, the new element that is presented is a product component relation where you can establish the details of the relation, that's where you are supposed to chose the bundled product. Unlike if you just press SELECT then a capture popup shows with the available products and you can chose one to relate but no relation in the product components is selected. In both cases, the product bundle related list shows the related elements from Products not from Product Components(the product parent table shows the product components not the product). So that's why you can't view/edit/delete the elements in the list i guess.
UPDATE2
And then i found that on Product's Layout editor you can add the correct Product Components table instead of the default Product Bundle there and then it relates as supposed. But the cost and unit price columns of the bundled are empty so roll-ups does not function in this way. This one got a bit messy to explain Wink

Print this item

  Timecontrol and Service Contracts with different rates
Posted by: gaardam - 06-22-2020, 12:31 AM - Forum: Modules/Extension Support - No Replies

Hi All,

I have employees with different charge out rates, as well as different loadings on those rates for outside of hours work.

For example :
Employee 1 has a charge out rate of $80 / hour
Employee 2 has a charge out rate of $100 / hour

Any work outside of business hours, for either employee is charged at 1.5 x their charge out rate.

We sell a fixed number of hours in blocks (at employee 1 rates), which fits well with the 'Service Contract' in coreBOS. Currently we have to do the calculation of deducted hours manually, depending which employee did the work, and if the work was done outside or hours.

So we sell a Service contract of 10 hours ($800)

If employee 1 creates a time control of 1 hour (for in business hours) - then the service contract is updated correctly - 1 hour is deducted
If employee 1 does 1 hour outside of of work, then 1.5 hours should be deducted
If employee 2 does 1 hour inside business hours, then 1.25 hours should be deducted
If employee 2 does 1 hour outside of business hours, then 1.875 hours should be deducted.

What's a good way to implement this in coreBOS?

Not just the calculation for the service contact, but also the fields to define chargeout and loading rates?

I could create a chargeout rate on Users table, then a loading drop down on the timecontrol?

Or I could just do a drop down on the timecontrol, with say
- lvl 1 - normal
- lvl 1 - 1.5
- lvl 2 - normal
- lvl 3 - 1.5

I would also like the option to use these values for invoicing time control, where the customer has not purchased a 'Service Contract'

Can someone point me in the right direction please?

Print this item

  Inventory Details sequence number -Solved-
Posted by: radu - 06-19-2020, 07:53 AM - Forum: Administrator Support - Replies (3)

I noticed that if you change line positions on a master-detail module, the order of associated inventory details does not change(although the sequence number it's correctly updated). I don't know how this can be achieved using the interface tools, i think if it is even possible it needs to be done in the internal logic when the relations are updated. Left as it is it creates a mess on a gendoc template given the fact that the 'for each inventorydetails' loop scans the inventory details in a linear mode and you can't scan that list sorted on sequence number for example. so in the end the list that you get from gendoc differs from what you see on the module in terms of line positions.

Print this item

  Migration from vtiger 5.4 ro coreBOS
Posted by: gedas - 06-12-2020, 09:56 AM - Forum: Administrator Support - Replies (6)

Hello,

We are trying to migrate from our current vtiger v.5.4 to coreBOS (from one machine to another)

We firstly installed the coreBOS, then we tried to upgrade as described here:
https://corebos.com/documentation/doku.p...gradevt2cb

We imported vtiger Mysql dump into new Mysql.
i.e. we copied the folders from the current vtiger install, edited the config.inc.php with new database info.
We were able to successfully execute the installupdater.php.
After that we also can login to the coreBOS (using old vtiger logins).
But after login we get a blank page.

coreBOS and vtiger are both on Windows system.

Could you please help us?

Print this item

  Workflow Currency details fields -Solved-
Posted by: radu - 06-10-2020, 02:21 PM - Forum: Administrator Support - Replies (2)

When in a 'update fields' task on a workflow, the currency related fields($(currency_id : (Currency) currency_code) and the others) does not evaluate and returns empty even though the currency_id field itself evaluates to the correct currency number.

Print this item

  Can't delete releted to do
Posted by: addady2 - 06-07-2020, 08:11 AM - Forum: Administrator Support - Replies (4)

Hi,

Look like a bug, Also happen  in Corebos demo.

I create two "to do"s the 2nd related to the 1st.

Pressing "del" link of related "to do" in "More information" don't delete it.
I didn't find any relevant JS error in the browser console.

Attach screenshot



Attached Files Thumbnail(s)
   
Print this item

  filleter problem when non latin picklist value
Posted by: addady2 - 06-04-2020, 01:44 PM - Forum: Administrator Support - Replies (5)

Hi

It look to me like a bug, I reproduce it on the live corebos demo.

Steps:
- Add to lead status picklist values non Latin characters value
- Create filer that show all the lead that modify today (see pic 1). all relevant record display
- Update the filter to show all the lead that modify today AND lead status "not equal to" some not exist Latin value (see pic 2).
- Now some relevant record not display (see pic 3).



Attached Files Thumbnail(s)
           
Print this item

Thumbs Up SalesOrder default recurring invoices Dates
Posted by: radu - 06-03-2020, 10:26 AM - Forum: Modules/Extension Support - Replies (2)

In current git ,when creating/editing a SO, the default dates that get filled into Billing Period Starts On  and Billing Period Ends On for recurring invoices are set to current date regardless of the activatio/deactivation checkbox for recurring invoicing. That, if left unmodified will trigger an error on save since the recurring interval cannot start on the same day.
This can be fixed by setting those fields to empty with business map, but I think that unless it's a form of validating those dates before saving, they should start empty and should be ignored recurring if is not checked. To test it just create a sales order and try to save without altering default recurring dates.

Print this item

  Export to csv columns from current filter
Posted by: radu - 05-29-2020, 06:50 AM - Forum: User Support - Replies (4)

When on a module, if you press export it will create a csv file with all the fields defined in that module. Is it possible to export only the fields(columns) visible in the filter?

Thanks

Print this item