Welcome, Guest |
You have to register before you can post on our site.
|
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.
|
|
|
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
|
|
|
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?
|
|
|
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.
|
|
|
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?
|
|
|
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.
|
|
|
|