Re: get all fields of an Entity
Jeremy Olmstead wrote > If you pass null as your set of fields, it will select all fields. > > Jeremy Oh, thanks. That works great to select all fields when executing the query. I still need to get all fields of an entity at other parts of our code, do you know how to achieve this? -- View this message in context: http://ofbiz.135035.n4.nabble.com/get-all-fields-of-an-Entity-tp4676259p4676262.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: different Invoice types with same Invoice ID range -> Chilean case
Fe de erratas: We use "partyIdFrom" instead of "partyId". Gabriel Oberreuter wrote > For the record, at the end we implemented it like this: > > 1) Add new fields for entity Invoice: invoiceTypeSII and invoiceNumberSII. > invoiceTypeSII is defined by the Tax Authority (SII) in Chile and must be > implemented strictly by their specification. It is "similar" to ofbiz OOTB > invoiceTypeId (like SALES_INVOICE), but we decided that it was easier to > just implement a new field for this. invoiceNumberSII is the "folio": each > invoice issued in Chile must have a number (BigInteger), and those numbers > must be previously approved by SII before using them. (in fact, one has to > submit a request of a range of these folios to SII). > > 2) The ID of an Invoice (in Chile, generally speaking), is unique > nationwide if one consider: the ID of the company who issue the invoice > (the RUT, like the tax id in USA), the invoiceNumberSII, and the > invoiceTypeSII. So, for us to keep control of this uniqueness, we build > the invoiceId ourselves, using those 3 parameters: > invoiceId = > > _ > > _ > > And for Party, we defined partyId as the RUT for each company in Chile. > > Hope this help someone else. -- View this message in context: http://ofbiz.135035.n4.nabble.com/different-Invoice-types-with-same-Invoice-ID-range-Chilean-case-tp4672808p4676260.html Sent from the OFBiz - User mailing list archive at Nabble.com.
get all fields of an Entity
Hi all, Do anyone knows how to get all fields of a given Entity programmatically? I can't seem to find that functionality of just lack the java knowledge to just do it. I am creating a query and want to select "all" current fields of an entity. When executing the query, I can pass a Set of fields to select. I need something of the like: Set fieldsOfEntityInvoice = Invoice.getAllEntityFields(); For now, I am building the Set manually, adding each field of the entities using set.add("invoiceId"), for example. Thanks -- View this message in context: http://ofbiz.135035.n4.nabble.com/get-all-fields-of-an-Entity-tp4676259.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Adrian Crum
Sad news, my sincere condolences of him. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Adrian-Crum-tp4675676p4676258.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: different Invoice types with same Invoice ID range -> Chilean case
For the record, at the end we implemented it like this: 1) Add new fields for entity Invoice: invoiceTypeSII and invoiceNumberSII. invoiceTypeSII is defined by the Tax Authority (SII) in Chile and must be implemented strictly by their specification. It is "similar" to ofbiz OOTB invoiceTypeId (like SALES_INVOICE), but we decided that it was easier to just implement a new field for this. invoiceNumberSII is the "folio": each invoice issued in Chile must have a number (BigInteger), and those numbers must be previously approved by SII before using them. (in fact, one has to submit a request of a range of these folios to SII). 2) The ID of an Invoice (in Chile, generally speaking), is unique nationwide if one consider: the ID of the company who issue the invoice (the RUT, like the tax id in USA), the invoiceNumberSII, and the invoiceTypeSII. So, for us to keep control of this uniqueness, we build the invoiceId ourselves, using those 3 parameters: invoiceId = __ And for Party, we defined partyId as the RUT for each company in Chile. Hope this help someone else. -- View this message in context: http://ofbiz.135035.n4.nabble.com/different-Invoice-types-with-same-Invoice-ID-range-Chilean-case-tp4672808p4676257.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: AW: different Invoice types with same Invoice ID range -> Chilean case
Hi Igno, nice idea! This is what I was looking for. Thank you for sharing your solution with us. It seems that it is exactly what we need, and it sounds not-so-hard to implement. In the next few weeks we are going to try something like this, and post our findings and results here. If we need your code as example, I will take your offer of sharing it ;) Thanks again, Gabriel iwolf wrote > Hi Gabriel, > > I had almost the same request and solved it this way: > > Within my "add-on" > > 1) extend entity "InvoiceType" > > > > > > > > > > > > > --> I want to define a prefix for every invoice type > --> I store the last invoice number for the specific invoice type > --> I can define to use the invoice number (counter) from another invoice > type > > 2) override services > getNextInvoiceId > invoiceSequenceEnforced > createInvoice > > --> I had to change only a view lines of code to make it work as I use the > mechanism the is defined in " PartyAcctgPreference " for the sales > invoice. I can forward you the code if your interested. > > At the end I had to add an entry in the sequence entity for each > invoicetype. > > Finally: > - Invoice Prefix for each invoice type > - Invoice Id range for each invoice type > - Share invoice range between invoice types > > Best Regards, > Ingo > > > > -Ursprüngliche Nachricht- > Von: Gabriel Oberreuter [mailto: > goberreuter@ > ] > Gesendet: Montag, 28. September 2015 01:34 > An: > user@.apache > Betreff: different Invoice types with same Invoice ID range -> Chilean > case > > Hi all, > > I have the following requirement and if any of you guys can help me think > about this I would really appreciate it. > > In Chile we have different kinds of Invoices, as expected. Now Chile is > migrating to a electronic system, were all documents must be generated in > XML form, signed with a ssl certificate and sent to the tax authority > after the issue of those documents. The transition to this electronic > system nation-wide has been kind of smooth, with its problems but I think > it is a great thing. > > Well, to the point: I need to manage the following types of documents, all > issued from: > - Sales Invoices > - Sales Invoices without tax > - Credit Notes (must be related to a document already issued, be it type > 1, > 2 or 4) > - Debit Notes (must be related to a document already issued, be it type 1, > 2 or 3) > > The thing here is that all types of invoices have different id ranges for > the tax authority: we can have a Credit Note with ID=1 and a Sales > Invoices with ID=1, for example. > > In Ofbiz we have: > - SALES_INVOICE, which maps perfectly to type 1 Chilean way > - CUST_RTN_INVOICE, which could be used for Credit Notes Chilean way > > I can think of writing new types, something like SALES_INVOICE_NO_TAX and > DEBIT_NOTE or similar. But I need to define a way to handle the IDs issue. > I really want to use the ids of the entities, and not implement a new > custom_type or a new code to each document. > > So, my questions: > 1) How would you do it? I am thinking of adding the INVOICE_TYPE to the > Invoice Entity key, so now the id of Invoice is composed of (id,type) > instead of only being (id). This would allow to have different ID ranges > for different types of invoices, but I would have to check and probably > change lots of ofbiz code to make it work this way. > 2) how are usually Debit Notes handled in Ofbiz? > > Any suggestion or idea is welcome, > Gabriel > > > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/different-Invoice-types-with-same-Invoice-ID-range-Chilean-case-tp4672808.html > Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://ofbiz.135035.n4.nabble.com/different-Invoice-types-with-same-Invoice-ID-range-Chilean-case-tp4672808p4672843.html Sent from the OFBiz - User mailing list archive at Nabble.com.
RE: different Invoice types with same Invoice ID range -> Chilean case
Hi Peter, good news there are 2 teams in Chile with the same requirements. But in our case we have already running electronic invoices: we implemented a solution were we connected our existing ERP (based on Cobol running on AS400) with a commercial solution: Acepta. The implementation process alone took us 3 months, and now we have three running components: 1) our ERP 2) a "mediation" module that connects our ERP and Acepta module, written in java + rails for web interface 3) Acepta module, which connects with their servers and finally with SII and other electronic customers/suppliers. So, the hardest part, implementing the "electronic exchange" is being done by Acepta. We control the IDs though. We plan on implementing a similar scenario, replacing the AS400 ERP with ofbiz, and use our existing mediation module to connect with Acepta module. Afterwards we plan to migrate this mediation module inside Ofbiz, and generate our own SII connection module at the end. So for now, we just want Ofbiz to work as a standar ERP, without having to deal with electronic exchange inside of it. Btw, I am really familiarized with the SII documentation, I have been working with it for the past year. Thanks for your insights. Bests, Gabriel Peter Arnold wrote > Hi Gabriel, > > Glad to hear that you also are thinking about implementing electronic > invoices in Chile. As you know all Chilean companies will have to do that > sooner or later and so do I. > Are you thinking about certifying strait for type 56) invoices? Legal > requirement is to do at least 33), 56) and 61) in one step. > Personally I would also need the 4 document types you are mentioning but > implementing everything seems to be a lot of work since these requirements > of course are not fulfilled in OFBiz out of the box. So for a first step I > personally would be glad to have the three obligatory document types > running. Of course the approach depends on individual business > requirement. > So, will you try to certify all 4 doc types at once? > > As for the sequence numbering of each document type I personally think it > would be a wise decision to add an additional data field to each invoice. > Just imagine for whatever reason OFBiz produces a failure and consumes an > ID > which was not sent to the tax authority (SII). You would in that case have > an invoice Id which was authorized by SII but a corresponding document was > never officially sent to the SII. I don't know how the tax authority would > treat that case. I believe that all authorized IDs should be consumed at > some point. > That's why I believe it would be wiser to add another data field to each > invoice which contains the authorized Invoice Id. It simply gives you more > flexibility. > How you would fill in this data is another question but I don't think this > would be the hardest part to overcome. Implementing all the rest is in my > opinion far bigger. > Furthermore SII recommendation is as in the following link: > http://www.sii.cl/factura_electronica/factura_mercado/instructivo_emision.pd > f > Especially see page 2 which clearly states that in the invoicing system > the > authorized IDs should be stored. > Another scenario: Just imagine that your system would have as next ID > let's > say the number 10, but for whatever reason SII would not authorize that > number, for example due to an error in their system. > In my opinion the SII Authorized Doc ID should be stored in a different > data > field then the by OFBiz assigned Invoice ID. > In that way you would comply with their instructions. > > I am personally not ready to go for certification yet since I have other > issues with the system and therefore have not yet started to run it for > commercial use. Nevertheless of course I am very much interested in your > approach and am thankful that you share your experience. > > Regards, > Peter > > > > --- > El software de antivirus Avast ha analizado este correo electrónico en > busca de virus. > http://www.avast.com -- View this message in context: http://ofbiz.135035.n4.nabble.com/different-Invoice-types-with-same-Invoice-ID-range-Chilean-case-tp4672808p4672842.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: different Invoice types with same Invoice ID range -> Chilean case
Hi Taher, ** What are the types 1, 2, 3 and 4? what do they mean? * In fact, the types are as follows: 33) Electronic Sales Invoice 34) Electronic Sales Invoice without tax 56) Electronic Debit Note 61) Electronic Credit Note These types were defined by Chilean Tax Authority, Servicios de Impuestos Internos (SII). This means that when submitting the documents to SII we have to use those types. *Who decides what the sequence of invoices is and how is it generated? under which examples would you have identical credit and debit IDs?* SII decided that each type of document has its own sequence of IDs. When a company wants to issue any of these documents, first a request for IDs must be made to SII. SII then generated the IDs you can use. For example, a company just starting business can ask SII for the following ranges: type 33, range 1-1000 type 34, range 1-1000 type 56, range 1-1000 type 61, range 1-1000 That means that the issued documents must use those IDs, and only those. And of course each ID for each type can be used only once. When submitting the documents to SII they validate this. Each issued document can be validated at SII webpage: the issuer or its client or any other person on hold of that document can enter its values at SII webpage and the SII informs if it is a valid document, that the issuer company sent to them. If you run out of IDs, new requests must be generated. There is no relation between the IDs beforehand: I can have an Invoice with ID=1 issued to Client 1, then Invoice ID=2 to Client2, and then issue a Debit/Credit Note ID=1 to the Client 1 referencing Invoice ID=1. *Why do you want the sequence to be in the ID and not in any other placeholder? For example, why not just another field to add to the invoice entity, or add it as an invoice attribute?* I don't want to use a new field in Invoice entity, for the simple purpose that in Chile the invoice number is really important. So all the lookups, the references (Debit/Credit notes MUST reference a previously issued document) and the reporting must be based on these IDs. If we implement a new field for this purporse, we will have the extra work of modifying and implementing everything in accounting aroung this new field. I strongly believe that this is a solution, but not the easiest one. That's why I want to use the inherent ID of the Invoice entity. But it is still not decided, that's why I am asking here for feedback ;) *Why do you need to distinguish between an invoice without tax and a regular invoice? Why not just create a report for invoices that have a tax invoice item versus those that do not?* SII decided to implement it this way: all Chilean companies works like this. If an Invoice is issued, and the Invoice has items which do not pay taxes, it must be of type 34 (Electronic Invoice with no taxes...). Put it simple, its the law. *What is the difference between an invoice and debit/credit notes?* Credit Note is a document were you reference an Invoice and issue a credit to the same client. For example, for an item that was never shipped, or a service that did not conclude well and the client ask for a discount, or just an error in the Invoice. As the Invoice are electronic and synchronized with SII, it can not be just modified: it must be modified through a Credit Note, or a Debit Note (in case instead of a discount, more charges apply). As you can see, all this is regulated by SII. And sadly for us, it is not in the way Ofbiz was coded, or as in other countries these documents are regulated. In the other hand, everything is well documented, and I really like that now all is electronic and synchronized with SII. Other latinamerican countries are following our example. Hope to have cleared your questions! -- View this message in context: http://ofbiz.135035.n4.nabble.com/different-Invoice-types-with-same-Invoice-ID-range-Chilean-case-tp4672808p4672814.html Sent from the OFBiz - User mailing list archive at Nabble.com.
different Invoice types with same Invoice ID range -> Chilean case
Hi all, I have the following requirement and if any of you guys can help me think about this I would really appreciate it. In Chile we have different kinds of Invoices, as expected. Now Chile is migrating to a electronic system, were all documents must be generated in XML form, signed with a ssl certificate and sent to the tax authority after the issue of those documents. The transition to this electronic system nation-wide has been kind of smooth, with its problems but I think it is a great thing. Well, to the point: I need to manage the following types of documents, all issued from: - Sales Invoices - Sales Invoices without tax - Credit Notes (must be related to a document already issued, be it type 1, 2 or 4) - Debit Notes (must be related to a document already issued, be it type 1, 2 or 3) The thing here is that all types of invoices have different id ranges for the tax authority: we can have a Credit Note with ID=1 and a Sales Invoices with ID=1, for example. In Ofbiz we have: - SALES_INVOICE, which maps perfectly to type 1 Chilean way - CUST_RTN_INVOICE, which could be used for Credit Notes Chilean way I can think of writing new types, something like SALES_INVOICE_NO_TAX and DEBIT_NOTE or similar. But I need to define a way to handle the IDs issue. I really want to use the ids of the entities, and not implement a new custom_type or a new code to each document. So, my questions: 1) How would you do it? I am thinking of adding the INVOICE_TYPE to the Invoice Entity key, so now the id of Invoice is composed of (id,type) instead of only being (id). This would allow to have different ID ranges for different types of invoices, but I would have to check and probably change lots of ofbiz code to make it work this way. 2) how are usually Debit Notes handled in Ofbiz? Any suggestion or idea is welcome, Gabriel -- View this message in context: http://ofbiz.135035.n4.nabble.com/different-Invoice-types-with-same-Invoice-ID-range-Chilean-case-tp4672808.html Sent from the OFBiz - User mailing list archive at Nabble.com.
RE: using H2 database for accelerated development
Thanks, We use webtools, and for now we are not using the demo data. We only load seed and seed-initial, and we have started loading other data from scratch. It is a good excersise to learn all what its required to get a minimal setup running. A script is being build to migrate all data from the old system: this script gets all current data from our current rtp, format it in a proper XML ofbiz-way, a post it automatically to a ofbiz instance. To avoid loading data more than once, I have included a servlet in ofbiz which returns, for example, all paid invoices, all products, and so on, in json format, so our migration script can query ofbiz first and filter out those entries. The idea is to post to ofbiz only the new or updated data from the current system. The script is being built so it works with a freshly instance of ofbiz. The instance needs only to be loaded with: seed, seed-initial and create-admin-user-login ant target. So we can easily generate and start new ofbiz instances without much effort. -- View this message in context: http://ofbiz.135035.n4.nabble.com/using-H2-database-for-accelerated-development-tp4672568p4672632.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: new functionality: payments collection
Hi Sharan, of course, no problem. We are still developing this functionality, but right now it is already being used and liked by our users. I would like to point a few thoughts about the erp decition process we went through: As discussed before in the forums, when deciding which ERP to implement it is important to clear a few points: - does the solution meets the company requirements, in general terms? - how many companies are using the solution worldwide? in our country? - which big companies choose it? - whats the cost of buying and implementing the solution? - if the implementation must be done by the company itself, does it have the proper team to do so? is the solution well documented? - in case of problems or any specific need, is there easy to access teams willing to be paid to get them solved? I think that, once technical issues are solved (the solution meet technically the requirements), the decision is mostly emotional: the company need to trust that the implementation process will be succesful. Yesterday I was reading a post about the goals of ofbiz development: should it be to create a product? a better framework? I think that both. By its very nature, ERP needs customization for each company implementing it: by industry, by country, by specific needs, and so on. So a great framework is a must. But at the same time, as a starting point one needs as a complete product as possible. I think that now Ofbiz kind of meet these. The documentation is a bit unorganized, and the only good way to get to know the system is to play with it, to develop some components, to try and implement some functionality and use it in a daily basis. Anyway, I am happy that we decided to go with Ofbiz, and so far it has been a great experience. In general terms all the code follows a logic, and by understanding it and learning which patterns the framework uses, it is not that hard. Just my 2 cents. -- View this message in context: http://ofbiz.135035.n4.nabble.com/new-functionality-payments-collection-tp4672567p4672621.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: using H2 database for accelerated development
Thanks Adrian for the info, I hadn't checked that. We haven't seen problems related to h2 hdbc driver supporting only up to 4.0, but anyway, its not good to have something fundamental as the db in the "air". Thanks Peter and Ron for the info on RAMDisks. I think that first one should increase RAM and switch to SSD, though. -- View this message in context: http://ofbiz.135035.n4.nabble.com/using-H2-database-for-accelerated-development-tp4672568p4672619.html Sent from the OFBiz - User mailing list archive at Nabble.com.
RE: using H2 database for accelerated development
Thanks for the link Peter. Yes, anyone using RAMDisks should know for which cases it is a good idea for which ones it isn't. I remember seeing a few years back a product which was Ram bundled inside a 5.25" bay (like a cd-rom), using sata v1. But having to take considerations for it, I think it is far easier to just mount a ram disk without that accesory. -- View this message in context: http://ofbiz.135035.n4.nabble.com/using-H2-database-for-accelerated-development-tp4672568p4672577.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: using H2 database for accelerated development
Ron, which tool are you using for the ram driver? Are you on linux or windows? I am on Windows. I want to give it a try, thanks! -- View this message in context: http://ofbiz.135035.n4.nabble.com/using-H2-database-for-accelerated-development-tp4672568p4672575.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: using H2 database for accelerated development
Yes, putting everything on RAM would help too. But the point here is that using the same settings and platform, H2 is faster than Derby. -- View this message in context: http://ofbiz.135035.n4.nabble.com/using-H2-database-for-accelerated-development-tp4672568p4672574.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: using H2 database for accelerated development
Thanks Adrian, We will try your settings. Gabriel -- View this message in context: http://ofbiz.135035.n4.nabble.com/using-H2-database-for-accelerated-development-tp4672568p4672572.html Sent from the OFBiz - User mailing list archive at Nabble.com.
using H2 database for accelerated development
Hi, I would like to share with guys new to Ofbiz that you can gain lot of DB related speed using the H2 database rather that the default Derby one. When building the project and creating the databases, on one of our engineers laptop the whole process took about ~15 minutes with Derby, and switching to H2 reduced that time to about ~3 minutes. That is a lot of time. On my workstation the time went from 3 minutes to ~2. (SSD and more powerful CPU). This has proven very helpful specially since we are just starting using ofbiz and need to create the db lots of times. Just for your info. -- View this message in context: http://ofbiz.135035.n4.nabble.com/using-H2-database-for-accelerated-development-tp4672568.html Sent from the OFBiz - User mailing list archive at Nabble.com.
new functionality: payments collection
Hi all, I would like to share what we have been doing with ofbiz. We had an urgent requirement from administration which involved collecting payments from customers. Our company usually sells products/services and ask for the payment 30 days later. So we have this "collection" issue. Normally, with usual customers, this topic is under control, but recently we have seen lots of invoices not being paid. The causes of this are mainly a lack of (pro)action by our side. In Chile we have migrate to a system were all invoices should be electronic: now Servicios de Impuestos Internos (SII - government tax collector) requires that all Invoices are generated so that a XML representation is send to their servers, and the obligation of companies regarding the exchange of these documents ends with the sending by email of these XML to the other companies. So, if we sell something, we send the XML by email to the customer, and that's it. With this change lots of companies are having issues adapting to this new way of handling invoices. Ok, now to the topic: We were asked to implement a system to manage collections, and as we are in the process of implementing ofbiz, we decided to do it ofbiz way. Accouting component was extended so now each Invoice has "Collection Actions" (for example, to send the PDF representation of the Invoice to the customer, not only the XML one). Our staff should register all actions excecuted to collect payments: - calls/emails made to the customer, asking if they got the Invoice - calls/emais sent to the customer, asking if everything is fine, and that they should pay withing the time accorded - and so on The implementation is already in production in beta status, and is proving to be very helpful. We import Invoice data from our existing system, and the staff in charge of collections use Ofbiz to register all the collection actions. They also use the Party component to register all customers contact information. Has anyone else had this requirement before, or now? For us Collections is a big topic. Greetings, Gabriel -- View this message in context: http://ofbiz.135035.n4.nabble.com/new-functionality-payments-collection-tp4672567.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: limit Invoice access by logged user (or the Invoice Sales Rep)
As an update to this topic: We got it working, doing the following: Each Invoice has an association using entity InvoiceRole with a Sales Rep. At our company, were each sales rep gets a commision for every Inovice he generates, when migrating invoices from our existing system to Ofbiz, we generate these InvoiceRoles. Invoice: Our Company -> Sales Rep = BILL_FROM_VENDOR Invoice: Sales Rep -> Our Company = SALES_REP Then, we are modifying the Accounting component to use groovy at all places to process the find requests. This way, in groovy we can filter by this association. We use a mix of InvoiceRole with SecurityPermission of the logged user to generate a hierarchy: if the logged user has the right permissions, no filter is applied (an adminitrator, for example). If the logged user has permission as a Sales Rep only, we must filter all invoices that do not "belong" to him. Another thing we are implementing is that Sales Reps have supervisors, or bosses, that can access not all invoices but all the ones of the people they supervise. It is not that easy at first, but thanks to the patterns Ofbiz follows it is not difficult either. Thanks again. -- View this message in context: http://ofbiz.135035.n4.nabble.com/limit-Invoice-access-by-logged-user-or-the-Invoice-Sales-Rep-tp4671577p4672565.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: limit Invoice access by logged user (or the Invoice Sales Rep)
Thanks Taher, I will have a look at the document, and decide later how to implement this. Once implemented, I will post my impressions in this thread. Gabriel -- View this message in context: http://ofbiz.135035.n4.nabble.com/limit-Invoice-access-by-logged-user-or-the-Invoice-Sales-Rep-tp4671577p4671591.html Sent from the OFBiz - User mailing list archive at Nabble.com.
limit Invoice access by logged user (or the Invoice Sales Rep)
Hello, I have the following requirement: At our company, Invoices are always assigned to a sales_rep executive, and in Ofbiz we do this by creating an InvoiceRole (roleTypeId SALES_REP) between each Invoice and its corresponding sales rep. Now, we need to limit the access of each sales rep only to his own Invoices. Can be this done within the included Ofbiz functionality? As far as I know (don't know much of inner part of ofbiz yet), we need some customization. I am thinking of modifying each invoice screen (or screen's forms) to limit the invoice list based on the logged in user, which has to be some kind of admin or a sales rep. In the latter case, the filter should only include invoices belonging to this sales rep. I am also thinking in a hierarchical schemma, were sales_rep supervisors have access to all their supervised sales_rep. Any better idea? Am I pointing in the right direction? I know that we can limit access to accounting with security groups, but I think that security groups is not the way to go, as I believe they are thought to restrict by kinds of operations, but not by (sub)groups of elements meeting certain conditions. Thanks!! -- Gabriel Oberreuter Mobile: +56 9 85299198
Re: Using OFBiz with DB2 for i (AS400) database
Thanks. Then I will file a Jira ticket (hopefully doing it right, never done that before). On Wed, Apr 23, 2014 at 10:27 AM, adrian.crum [via OFBiz] < ml-node+s135035n4650637...@n4.nabble.com> wrote: > For the most part, that is the normal configuration process. I am > surprised we don't have a fieldtype.xml file for DB2. Please feel free > to create a Jira ticket and include your DB2 fieldtype.xml file. > > Adrian Crum > Sandglass Software > www.sandglass-software.com > > On 4/23/2014 5:55 AM, Gabriel Oberreuter wrote: > > > Hi, I was trying to connect OFBiz to the database which is included in > IBMi > > operating system. > > This database is "DB2 for i", and as DERBY (the db OFBiz includes and > uses > > by default) was bought by IBM and certified with its own db, I thought > it > > shouldn't be so hard to use DB2 for i instead. > > I had to do the following: > > > > - copy the file framework\entity\fieldtype\fieldtypederby.xml into the > new > > framework\entity\fieldtype\fieldtypedb2fori.xml file > > - replace sql-type="DOUBLE" with sql-type="FLOAT" (DB2 for i > specification > > names FLOAT to DOUBLES) > > - create the db2fori entry in framework\entity\config\entityengine.xml > > (copying the entries of derby) and pointing to the new file, as with the > > other databases > > - include lib for db2fori connection (I used jt400-6.7.jar): copied into > > framework\entity\lib\jdbc > > - also, schemas have to be manually created (I don't know if there is a > > command to create schemas automatically if they don't exist as ofbiz > does > > with derby db) > > (create schema OFBIZ, create schema OFBIZOLAP, create schema OFBIZTENAN) > > > > doing this, and configuring entityengine.xml accordingly, I could use > OFBiz > > with DB2 for i, the database that comes with IBMi systems. > > > > Just informing this as some other could find this useful. Also, is this > > worth to consider it as a modification to ofbiz to make it more generic? > > > > Cheers! > > > > > > > > -- > > View this message in context: > http://ofbiz.135035.n4.nabble.com/Using-OFBiz-with-DB2-for-i-AS400-database-tp4650633.html > > Sent from the OFBiz - User mailing list archive at Nabble.com. > > > > > -- > If you reply to this email, your message will be added to the discussion > below: > > http://ofbiz.135035.n4.nabble.com/Using-OFBiz-with-DB2-for-i-AS400-database-tp4650633p4650637.html > To unsubscribe from Using OFBiz with DB2 for i (AS400) database, click > here<http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4650633&code=Z29iZXJyZXV0ZXJAZ21haWwuY29tfDQ2NTA2MzN8MjA4MDg2ODQ4NQ==> > . > NAML<http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- Gabriel Oberreuter Mobile: +56 9 85299198 Innovandio S.A. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Using-OFBiz-with-DB2-for-i-AS400-database-tp4650633p4650641.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: See margin (total price-total cost) in Sales Order to approve it
Thanks Paramjit, Then I will be thinking of a way of implementing an application (or a new tab in the order application) which contains, for each sales order, the estimated cost of that order. The idea is to provide the margin (or profit) of the SO to the approver, so he can make a decision on approving it or not. As this is quite common for us, I thought maybe OFBiz has this somehow implemented out of the box. If anybody does a similar process and consider the margin to approve the SO or not, and mind sharing how to do it, I would appreciate it! On Wed, Apr 23, 2014 at 1:19 AM, paramjit.saini [via OFBiz] < ml-node+s135035n4650571...@n4.nabble.com> wrote: > Hi, > > There is many type of price in ProductPrice entity, you can define average > cost for all items and calculate margin from orderItem price - item avarage > cost. > > > On Wed, Apr 23, 2014 at 1:37 AM, Gabriel Oberreuter [via OFBiz] <[hidden > email] <http://user/SendEmail.jtp?type=node&node=4650571&i=0>> wrote: > >> Hi all, I am Gabriel Oberreuter and am new to OFBiz. First, thanks to >> this community for this project! ;) >> >> I am in the process of deciding which Information System to implement at >> the company I work for, and I am a big supporter of OFBiz. There are a >> couple of things that must be cleared beforehand, though. >> >> We want to be able to see the margin (total price - total cost of the >> items) of a Sales Order before approving it. This has been one of the most >> important ways our company has to decide which sales to execute. Does OFBiz >> have a better or different way to provide this kind of information to the >> Sales Order approver? (I mean in the out of the box ofbiz, I am using >> trunk). >> >> If not, how do usually approvers decide (using ofbiz of course) which >> projects (or basically sales order) to approve? >> >> Thanks! >> >> -- >> If you reply to this email, your message will be added to the >> discussion below: >> >> http://ofbiz.135035.n4.nabble.com/See-margin-total-price-total-cost-in-Sales-Order-to-approve-it-tp4650565.html >> To start a new topic under OFBiz - User, email [hidden >> email]<http://user/SendEmail.jtp?type=node&node=4650571&i=1> >> To unsubscribe from OFBiz, click here. >> NAML<http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> >> > > > > -- > Thanks,Paramjit > > > -- > If you reply to this email, your message will be added to the discussion > below: > > http://ofbiz.135035.n4.nabble.com/See-margin-total-price-total-cost-in-Sales-Order-to-approve-it-tp4650565p4650571.html > To unsubscribe from See margin (total price-total cost) in Sales Order to > approve it, click > here<http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4650565&code=Z29iZXJyZXV0ZXJAZ21haWwuY29tfDQ2NTA1NjV8MjA4MDg2ODQ4NQ==> > . > NAML<http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- Gabriel Oberreuter Mobile: +56 9 85299198 Innovandio S.A. -- View this message in context: http://ofbiz.135035.n4.nabble.com/See-margin-total-price-total-cost-in-Sales-Order-to-approve-it-tp4650565p4650640.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Using OFBiz with DB2 for i (AS400) database
Hi, I was trying to connect OFBiz to the database which is included in IBMi operating system. This database is "DB2 for i", and as DERBY (the db OFBiz includes and uses by default) was bought by IBM and certified with its own db, I thought it shouldn't be so hard to use DB2 for i instead. I had to do the following: - copy the file framework\entity\fieldtype\fieldtypederby.xml into the new framework\entity\fieldtype\fieldtypedb2fori.xml file - replace sql-type="DOUBLE" with sql-type="FLOAT" (DB2 for i specification names FLOAT to DOUBLES) - create the db2fori entry in framework\entity\config\entityengine.xml (copying the entries of derby) and pointing to the new file, as with the other databases - include lib for db2fori connection (I used jt400-6.7.jar): copied into framework\entity\lib\jdbc - also, schemas have to be manually created (I don't know if there is a command to create schemas automatically if they don't exist as ofbiz does with derby db) (create schema OFBIZ, create schema OFBIZOLAP, create schema OFBIZTENAN) doing this, and configuring entityengine.xml accordingly, I could use OFBiz with DB2 for i, the database that comes with IBMi systems. Just informing this as some other could find this useful. Also, is this worth to consider it as a modification to ofbiz to make it more generic? Cheers! -- View this message in context: http://ofbiz.135035.n4.nabble.com/Using-OFBiz-with-DB2-for-i-AS400-database-tp4650633.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Running OFBiz on IBM POWER Architecture
Hi, I was experimenting with OFBiz and SUSE Enterprise 11 over IBM Power. As we have java on that configuration, I wanted do give it a try. When compiling, I got an error related to an algorithm, which is present in the "normal" java implementation and not present in the IBM one. In normal java: SunX509 In ibm java: IbmX509 It is related to the certificates used for security. I modified the codes of the following files: framework\base\src\org\ofbiz\base\util\SSLUtil.java framework\catalina\ofbiz-component.xml replacing SunX509 for IbmX509, and the problem was solved. I got the system running with (apparently) no problem. Investigating the issue, some people recommend not to specify the algorithm to use, but let java decide on its own: http://stackoverflow.com/questions/10073202/what-is-sunx509-used-for-and-can-it-work-with-parties-using-ibmx509 KeyManagerFactory.getInstance("SunX509") -> KeyManagerFactory.getInstance(KeyManagerFactory.getDefaultAlgorithm()) Just informing this as some other could find this useful. Also, is this worth to consider it as a modification to ofbiz to make it more generic? Cheers! -- View this message in context: http://ofbiz.135035.n4.nabble.com/Running-OFBiz-on-IBM-POWER-Architecture-tp4650632.html Sent from the OFBiz - User mailing list archive at Nabble.com.
See margin (total price-total cost) in Sales Order to approve it
Hi all, I am Gabriel Oberreuter and am new to OFBiz. First, thanks to this community for this project! ;) I am in the process of deciding which Information System to implement at the company I work for, and I am a big supporter of OFBiz. There are a couple of things that must be cleared beforehand, though. We want to be able to see the margin (total price - total cost of the items) of a Sales Order before approving it. This has been one of the most important ways our company has to decide which sales to execute. Does OFBiz have a better or different way to provide this kind of information to the Sales Order approver? (I mean in the out of the box ofbiz, I am using trunk). If not, how do usually approvers decide (using ofbiz of course) which projects (or basically sales order) to approve? Thanks! -- View this message in context: http://ofbiz.135035.n4.nabble.com/See-margin-total-price-total-cost-in-Sales-Order-to-approve-it-tp4650565.html Sent from the OFBiz - User mailing list archive at Nabble.com.