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

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 439,659
» Latest member: beunnamwta
» Forum threads: 1,741
» Forum posts: 9,026

Full Statistics

Online Users
There are currently 611 online users.
» 0 Member(s) | 611 Guest(s)

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

 
  Calculation of the 'All Menu' top
Posted by: Guido1982 - 01-24-2016, 02:24 PM - Forum: coreBOS Development - Replies (9)

I'm working on my theme, and noticed the top value of the fold-out menu for all modules is hardcoded to 70px. This causes unwanted results even in the standard softed theme. I've been looking a bit, but can't find the JS that does this (or is it even coded into the TPL file?) Anyway, I can override this with an !important rule, but I think there should be a better fix for this. Besides this, I think it's better to handle the hover through CSS then via javascript, but this will break compatibility with existing themes I think.

Print this item

  dynamic fields
Posted by: saidmsl - 01-19-2016, 03:29 PM - Forum: coreBOS - Replies (1)

Hi,

I found this :

http://danielrivers.com/visibly/

i have tested it on DetailView :

call it : 

jQuery('[visibly]').Visibly();

under function dtlViewAjaxSave
and on document load 

quite interesting 

Print this item

  Product types/hierarchy
Posted by: Guido1982 - 01-18-2016, 12:36 AM - Forum: coreBOS - Replies (9)

Well, since it hasn't been done yet I'll start this:

I've been thinking about the need for product hierarchy as discussed. Since I've worked and maintained a coreBOS system at a manufacturing company I've got some background. I don't think there is the need for a real 'hierarchy'. In stead, I think we should start by looking at products in a more sub-divided way:

A product could roughly be three things (in a manufacturing context):

  • An end-product that you buy and sell as-is. Which is like it is now.
  • An assembly. Which basically means this is the product you sell, but it doesn't enter your company in the form it exits. In stead, you buy or manufacture the parts and assemble the product. Which leads to the third type:
  • A part. These products you buy from a supplier and use to create your end product (the assembly as mentioned above).

Now what should we do? First of all create the option to select which category (or more than one, more on that later in this text) the product belongs to. If it is an assembly, we should be able to choose which parts make up this assembly and how many of each part is needed to create one assembly. This way, by keeping stock you could see (and this should be automated) if you have enough of each part to create the assembly. Here's where the 'hierarchy' character kicks in, because a part could also be in turn an assembly. So a lot of small part could make one assembly, which in turn is a part for a larger assembly.

Functionality that comes to mind is:
  • When you sell an assembly, you should immediately see if you have all the required parts. If not, you should be able to create purchase orders for these parts (and preferably send an e-mail to the supplier).
  • You could easily produce lists for factory workers (the assemblers) that list which parts they need (and for instance where in the warehouse these are located).

There are probably a lot of other functions that could some to mind, and that is where I'd like some comment.

Now this is only internally. On quotes, sales orders and invoices you should only see the end-product. Customers don't care which parts you needed to assemble their end-product (and shouldn't know). Note, this should not be about the technical side of the manufacturing. That is way beyond the scope of what a CRM should be able to do.

Print this item

  Upgrade Service for coreBOS from vtiger
Posted by: lorenzoperez - 01-12-2016, 12:03 PM - Forum: Market - No Replies

We offer a update service from ** any ** version of vtiger to the latest version of coreBOS.

Here you have more information about this Update Service for coreBOS CRM

For more information -> send us an email

Print this item

  Working on a new theme....
Posted by: Guido1982 - 01-11-2016, 05:52 PM - Forum: coreBOS Development - Replies (40)

I've started work on a new theme. Now I'd also like to incorporate some autocomplete functionality. Now I'd like some advice on how to do this as best as we can so that this can be integrated into the app. At first I tried just copying the standard 'softed' theme and modifting CSS. This works fine, but ir won't allow you to set new scripts in the head. So now I'm thinking about creating the theme as a module, which will allow me to register new head links. The third option is, I create commits on my github fork that can be implemented in the app no matter which theme is chosen, so that the functionality will always be available. The question is, which do you prefer?

Print this item

  Servicio de actualización a coreBOS desde vtiger [Spanish]
Posted by: lorenzoperez - 01-05-2016, 12:09 PM - Forum: Market - No Replies

Disponemos de un servicio de actualización desde **cualquier** versión de vtiger a la última versión de coreBOS.

Aquí tienes más información SERVICIO DE ACTUALIZACIÓN a coreBOS CRM

Para más información -> lorenzo@tsolucio.com

Print this item

  The need for an accounting suite
Posted by: Guido1982 - 01-04-2016, 07:48 PM - Forum: Modules/Extension Support - Replies (10)

I'm working on the last touches of my module that connects coreBOS to Exact Online. In this process, I realized something. Any Exact sales person that comes into contact with someone using coreBOS will try to talk that person into moving their entire CRM system to Exact, since they also offer that. This brings us into a situation (or at least it has brought me into that situation) where offering the connection could in the end loose a customer. CoreBOS of course has many advantages over Exact, but there is one in which it lacks: official Accounting possibilities.

I've taken it upon myself therefor to investigate the possibilities of creating a set of modules (a suite) that fixes this, so that coreBOS can also offer real Accounting features. My investigation will split into two parts, for which I'm looking for input here:

  1. The technical part. Of course I am an expert developer now Wink , but I could still use a lot of help. I read somewhere in some documentation (I don't remember where) that it was possible to install a 'chain' of modules. Kind of like making the modules dependant of each other. Is this real, or just a distorted recollection? Also, any advice on implementation of what I'm describing below on the accounting side would be welcome.
  2. The Accounting part. I've been going through my Exact Online test account to see what they offer, and how they approach the accounting part. I will post my findings hereunder, as a 'part 1' list, meant to be expanded by you: reader! Anyone with experience in the field of accounting, please respond, because I am not experienced or educated in this field so I'd like to setup a basic system to work from.

For the accounting part, I've established we need the following:
  • A 'General Ledgers' module. This is a 'homo economicus' term for 'category', simple as that. Let's say you run a supermarket. Your General Ledgers could be:
    • Meat
    • Vegetables
    • Bread
    • Etc...
  • The General Ledgers can be on three sides of your balance sheet, costs, revenue or stock. They can only be on one at the same time so this can be a simple dropdown.
  • Within products, you'd have to create a new block for the general ledgers. For each product, you'd have three fields. There you can choose, for that product which Ledger you book the costs on, on which Ledger you book the Profits and on Which ledger you book the stock. Let's say my supermarket will now buy ten tomatoes. The purchase value of these tomatoes will now be booked on the Ledger I indicated as the cost one, AND on the stock one (since I also add ten to my stock). Now, if I sell three tomatoes, these three will be deducted from the stock Ledger I chose for tomatoes, and the revenue for these tomatoes will be added to the revenue Ledger I selected for tomatoes.
  • The purchase part takes me to the second part. We already have purchase orders, but this module doesn't cover the needs for accounting. We need to be able to also import other costs, like rent, or electrical bills. So there should also be a module for 'Purchase Invoices'. You should be able to select a general Ledger here also, so we know which ledger to book these costs on to. From a purchase order (the existing module) we should also be able to create a purchase invoice (the same way a sales order can create one or more sales invoices). After saving the purchase invoice (using the aftersave events?) we can automatically book the purchase value of the products to the correct Ledgers (that are of the 'cost' type).
  • The above leads to adding a new field in products (in the 'price' block), called 'cost price'. When a purchase order is created or converted to a purchase invoice, the system should take the value of this cost price field in creating the inventory lines. You should also be able to change these (as you are able to change sales prices per salesorder also), when for instance you received a one-time discount.
  • Journals. Journals are nothing else then a record of any financial transaction you made. I'm not wuite sure how to describe this, and don't have a firm grasp on what they should show. I'm thinking every invoice you make should show that some amount of money transferred from one Ledger to another. So booking your electrical bill could be a journal, adding the amount to the Ledger you created for 'housing costs'. I'm not sure, but I think you should be able to tell the system which 'booking period' this journal belongs to.
  • I don't know squat about a profit/loss balance, but if someone could explain in in a 'accounting for dummies' way, that would be nice.

Of course the integration with existing modules, like 'payment' are also important, I don't want to re-invent the wheel here. I'm more than happy to take on the programming side, would be good excersize for me, but I really do need some pointers before I embark on a mission into nowhere. One thing that I feel is also a real advantage of a lot of CRM's is the possibility of a direct import of bank records, so you can cross-reference these with your invoices (and purchase invoices). I know a lot of banks offer digitized records. I've no experience with the format, but anyone that has any experience, please shout out. I'm thinking of a module that could import a digital bank record, create a record for each transaction made in your account and see if it can find the correct invoice for that booking.

I'm hoping this post will result in a more clear and detailed spec of what an accounting suite should be able to do, so I can start building modules that lead up to such a suite.

Print this item

  MySQL >= 5.5.3 bug
Posted by: addady2 - 12-18-2015, 08:09 AM - Forum: coreBOS - Replies (3)

Hello

One of my customer face this issue:

https://discussions.vtiger.com/index.php?p=/discussion/comment/1198220


FYI: After check coreBOS code it look like the above vtiger issue also relevance to coreBOS.

Regards
Addady

Print this item

  How to "attach/relate" products and/or services to project?
Posted by: Peter A. Gebhardt - 12-17-2015, 02:36 PM - Forum: coreBOS - Replies (2)

I would like to attach "productized" (and sometimes bundled) steps of financial advice/analysis to projects related to contacts.

Bundled products fit the bill already - but how to make products/services to appear under "More Information" in project tasks (and likewise in the parent project)?

Might be interesting for all kinds of Consultants, Advisors and Lawyers.

If a code snippet is readily available that would help most - but a pointer to applicable documentation is also very supportive ;-)

Best regards

PS: There are other extensions which I will post in Feature Requests - like: Adding up Units (here: billable hours) or cloning "Master Projects"

Print this item

Question Usage on ZYXEL NAS: INNODB mandatory?
Posted by: Peter A. Gebhardt - 12-16-2015, 11:44 AM - Forum: Administrator Support - Replies (3)

Just tried this, because using ENGINE=INNODB throws 'Can't create' error:

Code:
CREATE TABLE IF NOT EXISTS `vtiger_cbupdater` (
 `cbupdaterid` int(11) NOT NULL DEFAULT '0',
 `cbupd_no` varchar(26) DEFAULT NULL,
 `author` varchar(83) DEFAULT NULL,
 `filename` varchar(218) DEFAULT NULL,
 `pathfilename` varchar(218) DEFAULT NULL,
 `classname` varchar(183) DEFAULT NULL,
 `execstate` varchar(56) DEFAULT NULL,
 `systemupdate` varchar(3) DEFAULT NULL,
 `blocked` varchar(3) DEFAULT NULL,
 `perspective` varchar(3) DEFAULT NULL,
 `execdate` date DEFAULT NULL,
 `execorder` int(11) DEFAULT NULL,
 PRIMARY KEY (`cbupdaterid`),
 UNIQUE KEY `findupdate` (`filename`,`classname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

Bummer too. Error: 1071 SQLSTATE: 42000 (ER_TOO_LONG_KEY)

(Problem: ZYXEL doesn't support INNODB in it's mySQL packages yet)

Any idea?

Best regards

Print this item