Welcome, Guest |
You have to register before you can post on our site.
|
Online Users |
There are currently 3 online users. » 0 Member(s) | 1 Guest(s) Bing, Google
|
Latest Threads |
Finetuning the way you se...
Forum: coreBOS Development
Last Post: alexandy40d
12-06-2024, 07:38 AM
» Replies: 4
» Views: 8,135
|
MariaDB Version
Forum: Administrator Support
Last Post: joebordes
11-01-2024, 11:49 AM
» Replies: 1
» Views: 617
|
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,757
|
Zapier | Integration
Forum: Modules/Extension Support
Last Post: bernardgbailey
07-29-2024, 11:45 PM
» Replies: 7
» Views: 9,843
|
Versión PHP recomendada
Forum: International
Last Post: joebordes
07-04-2024, 05:42 PM
» Replies: 7
» Views: 3,319
|
Could Someone Give me Adv...
Forum: Open Discussions
Last Post: joebordes
06-27-2024, 08:32 AM
» Replies: 1
» Views: 1,697
|
RESTRICTED FILE
Forum: Administrator Support
Last Post: inspectorflint
06-22-2024, 08:08 AM
» Replies: 7
» Views: 5,654
|
GENDOC imágenes
Forum: Open Discussions
Last Post: joebordes
06-02-2024, 05:11 PM
» Replies: 4
» Views: 2,020
|
|
|
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.
|
|
|
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?
|
|
|
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:
- The technical part. Of course I am an expert developer now , 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.
- 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.
|
|
|
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"
|
|
|
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
|
|
|
|