About WSACE 2.1.1.3 integration with ofbiz
Hai , When I saw forum I could only see the steps to configure ofbiz with JBOSS. But I need it to do with Web Sphere Application Server 2.1.1.3 version.Could you tell me the steps to do so. Many Thanks
Re: About WSACE 2.1.1.3 integration with ofbiz
It was only tested with WASCE 2.0.0.1 so far https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=7045153 Jacques From: Selvakumar Ganesan selvaku...@formativesolutions.co.in Hai , When I saw forum I could only see the steps to configure ofbiz with JBOSS. But I need it to do with Web Sphere Application Server 2.1.1.3 version.Could you tell me the steps to do so. Many Thanks
Re: About WSACE 2.1.1.3 integration with ofbiz
On Mon, Apr 26, 2010 at 2:07 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: It was only tested with WASCE 2.0.0.1 so far https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=7045153 Jacques From: Selvakumar Ganesan selvaku...@formativesolutions.co.in Hai , When I saw forum I could only see the steps to configure ofbiz with JBOSS. But I need it to do with Web Sphere Application Server 2.1.1.3 version.Could you tell me the steps to do so. Yes, I saw ,the version is varied, for that I could not get the backup (ie with the version 2.0.0.1).It is said to be outdated. Many Thanks
Layered lookups
Hi, At r937852 I have commited changes for most lookups to be now layered. There are some exceptions: the lookups called from lookup are not layered. If you find any issues please report here and we will see if it's necessary to create a Jira issue under https://issues.apache.org/jira/browse/OFBIZ-3445 for them Thanks Jacques
Disabling Autocomplete in XML Forms
Hi, How do I disable auto-complete in a field in a XML form. I tried the *client-autocomplete-field=false *option in the Lookup tag, but this doesnt work. Regards, Kranti Agrawal Student, IIIT Bangalore krantiagrawal.blogspot.com
Multitenant with CAS-LDAP
Hi all, We are using and testing a multitenant version of Ofbiz/Tercompta with purpose ldap (coupled with CAS). When ldap purpose is not used, we are able to choose a tenant in GUI during login. But with ldap/cas there is no GUI! How can we set correct tenantId ? what is best procedure to follow ? modify classes in package org.ofbiz.webapp.control? Customize a LoginWorker for instance? Thanks
Re: ofbiz entity sync.
Done, though I did not refactor all yet has I wanted Jacques From: Jacques Le Roux jacques.le.r...@les7arts.com Hi David, Thanks for you feedback in your 2 last messages. From what I have understood so far, here is an as simple as possible how to, I'd like to put in the wiki. 1st, I will suggest to follow the Sync Setup Notes and Example page in wiki http://cwiki.apache.org/confluence/x/bgFk. I will try to clarify it though. Notably will adapt or move (or even remove) the Fixing Timestamps issues section I previoulsy hastily added as a quick help. Then I will add following tips to use in case of problems (chances are they will appear) Syncing issues If, for any reasons, the syncing has failed and did not recover automatically, you will need to check the status and reset it. For that, use the Entity Sync Status feature in Webtools. If it's still in running state, put it back to not started status in order for the job to pick things again. Note that these jobs should run on the client(s) only and you should not run multi-instances of them. TimeStamp issues 1) Fix the timezone on all machines to be the same (sorry if this is an issue but I can't find another way) 2) use an (preferably the same) NTP server to adjust the time on each machine. Remember that OOTB the minimun period of time used is 5 mins for push (1 hour for pull). So you get any issues as long as your machines have the same time between this window. 3) If you get an issue with foreign keyd because the NTP server adjusted time inside a transaction, use the Check/Update Database feature in Webtools I will also put a link to https://issues.apache.org/jira/browse/OFBIZ- where there are suggestion for a new way and a link back to this thread All comments are welcome Jacques From: David E Jones d...@me.com A transaction has a lot of overhead, but is a good way to go. For removes the current EntitySync implementation does in fact use a sort of transaction log. The nice thing about timestamps is they tell you what records have been changed since a certain time so you know which records have changes that need to be updated since the last update time. There are issues with multiple app servers if their times are out of sync by more than a few minutes. Most other issues seem to be related to people not understanding how this works and how to handle different issues. Of course, that alone can be fatal flaw in a design and probably is in this case. To really do this you'd have to have a more structured record of the changes than just recording an SQL statement if you want to support syncing from one type of database to another (which is currently supported). -David On Apr 7, 2010, at 3:41 AM, Deyan Tsvetanov wrote: Hi guys, so about the transaction log: I have a table called TRANSLOG with the following structure: CREATE TABLE translog ( id bigserial NOT NULL, table character varying(30) NOT NULL, operation character varying(6) NOT NULL, statement character varying NOT NULL, created_on timestamp with time zone NOT NULL DEFAULT now(), CONSTRAINT id_fk PRIMARY KEY (id) ) Records in the TRANSLOG table are being inserted by the triggers for the table we are watching for changes on INSERT, UPDATE and DELETE. The STATEMENT column contains executable SQL statement which is generated by the trigger function. The following screenshot shows some data in the TRANSLOG table: So every time some database action is performed on the tables we are watching we get a TRANSLOG entry. Each translog entry has a sequence ID. So when we want to PUSH that transaction log to the main server we actually execute the statements ON the main server. We execute the statements wrapped in a transaction which gets rolled back if an error has occured. The translog push gets invoked by a stored procedure which gets called by a scheduled reoccuring job in ofbiz. For each sync SP execution we store a record in a table called TRANSLOG_EXEC_LOG . There we keep the currently reached translog_id so we know from where to start the next time when the sync SP is invoked. So in general that's the mechanism. Pretty simple to implement, pretty simple to troubleshoot and pretty error resistant . Here's the screenshot of TRANSLOG_EXEC_LOG: The result message could be either OK or the DB error message - either a constraint error or some other error. We always know which was the last successfully executed statement ( last_command_id ). If there is an error then we know at which statement the error has happened - the next after the last successful one. That's all in general. -- deyan -Original Message- From: Jacques Le Roux jacques.le.r...@les7arts.com Reply-to: Jacques Le Roux jacques.le.r...@les7arts.com To: Deyan Tsvetanov deyan.tsveta...@ittconsult.com, user@ofbiz.apache.org Cc: Hans Bakker h.bak...@antwebsystems.com, m...@emforium.com Subject: Re: ofbiz entity sync. Date: Tue, 6 Apr 2010 12:31:49 +0200 Hi
data models
I can no longer find the data models (e.g. AllDiagramsAndTOC_20081030.pdf). Can someone please point me in the right direction? Many thanks, Chris
Re: data models
https://cwiki.apache.org/confluence/display/OFBTECH/Home fourth one down. = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=93 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Linkedin http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Chris Snow sent the following on 4/26/2010 7:19 AM: I can no longer find the data models (e.g. AllDiagramsAndTOC_20081030.pdf). Can someone please point me in the right direction? Many thanks, Chris
Re: Layered lookups
Noted thanks for the effort = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=93 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Linkedin http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Jacques Le Roux sent the following on 4/26/2010 2:23 AM: Hi, At r937852 I have commited changes for most lookups to be now layered. There are some exceptions: the lookups called from lookup are not layered. If you find any issues please report here and we will see if it's necessary to create a Jira issue under https://issues.apache.org/jira/browse/OFBIZ-3445 for them Thanks Jacques
puzzling error on ajp
using a recent nightly build when I set the mount-point=/ and I am using the AJP 1.3 I get an error, which I can not see because of another problem. it does not show in the logs. not asking to debug why I have an error, more why ofbiz has this way of handling an error when using AJP. when I first installed and before much modification, url http://somedomain.com/ worked fine. Now the first url http://somedomain.com/ creates an error. yet when I do a url http://somedomain.com/ecommerce the first time, this work and the rest of the URL's are using the mount-point=/. work as expected. so my url is http://somedomain.com/control/* Note: this works fine with a local copy and not using AJP with the same mods. anyone have any thoughts BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=93 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Linkedin http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro
Trunk VS Release?
Hi people! I'd need some guidance towards which version of OFBiz to choose from. I have a few things to take into account: I'm a single developer, and will in due time be committed full-time by my boss to work on an OFBiz setup for the business. In my line of work I will be asked to: -Develop new features they would like -Enhance features they don't like -Adjust the interface to their needs So I see that there will be a new release branch. Should I use that in production, and use another instance reserved for development? Should I use trunk to provide my users with the bleeding edge version of OFBiz, or will that be far too unstable for their taste? Thank you!
Re: puzzling error on ajp
BJ - This doesn't really answer your question but this is how I handle it. I do not mount any OFBiz webapp with mount point= /. This is because I have had other problems in the past trying to do this and getting OFBiz to find resources such as style sheets and images. There is probably a reasonable explanation and solution but I chose to just avoid it. When using Apache to proxy requests I use a server side include. Here is the content in my index.shtml file: !--#include virtual=/store/control/main -- That's it. So I do not have to mount any OFBiz webapp as root, I can still serve other resources from Apache if I want to. Any mount point I need to proxy to OFBiz is configured in the Apache config file. Vince Clark vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell - Original Message - From: BJ Freeman bjf...@free-man.net To: user@ofbiz.apache.org Sent: Monday, April 26, 2010 10:55:17 AM Subject: puzzling error on ajp using a recent nightly build when I set the mount-point=/ and I am using the AJP 1.3 I get an error, which I can not see because of another problem. it does not show in the logs. not asking to debug why I have an error, more why ofbiz has this way of handling an error when using AJP. when I first installed and before much modification, url http://somedomain.com/ worked fine. Now the first url http://somedomain.com/ creates an error. yet when I do a url http://somedomain.com/ecommerce the first time, this work and the rest of the URL's are using the mount-point=/. work as expected. so my url is http://somedomain.com/control/* Note: this works fine with a local copy and not using AJP with the same mods. anyone have any thoughts BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=93 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Linkedin http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro
Re: Trunk VS Release?
http://ci.apache.org/waterfall?show=ofbiz-trunk will give you the last sucessful build from the trunk. then you can create your mods and additions but doing an ant create-component that puts them in the hotdeploy. this way you can update trunk and not effect your code. then if you created test units in your components you can verify if your code still works. now if you don't what to go to all of that, then plan on using a release which does not change except for bugs. you would then have to watch the commit ml for updates and see if you ca n use them. my 2 cents. = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=93 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Linkedin http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Olivier Tremblay sent the following on 4/26/2010 10:31 AM: Hi people! I'd need some guidance towards which version of OFBiz to choose from. I have a few things to take into account: I'm a single developer, and will in due time be committed full-time by my boss to work on an OFBiz setup for the business. In my line of work I will be asked to: -Develop new features they would like -Enhance features they don't like -Adjust the interface to their needs So I see that there will be a new release branch. Should I use that in production, and use another instance reserved for development? Should I use trunk to provide my users with the bleeding edge version of OFBiz, or will that be far too unstable for their taste? Thank you!
Re: Trunk VS Release?
Maybe you will find some answers here https://cwiki.apache.org/confluence/display/OFBADMIN/Apache+OFBiz+Getting+Started This page may be also useful https://cwiki.apache.org/confluence/display/OFBIZ/Is+OFBiz+for+Me Jacques From: Olivier Tremblay oliviertrembla...@gmail.com Hi people! I'd need some guidance towards which version of OFBiz to choose from. I have a few things to take into account: I'm a single developer, and will in due time be committed full-time by my boss to work on an OFBiz setup for the business. In my line of work I will be asked to: -Develop new features they would like -Enhance features they don't like -Adjust the interface to their needs So I see that there will be a new release branch. Should I use that in production, and use another instance reserved for development? Should I use trunk to provide my users with the bleeding edge version of OFBiz, or will that be far too unstable for their taste? Thank you!
Re: puzzling error on ajp
thanks vince. yes when I use /mystorename it works what puzzle me is that the localhost / works fine that is what I use to test. so what is changed. = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=93 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Linkedin http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Vince Clark sent the following on 4/26/2010 11:05 AM: BJ - This doesn't really answer your question but this is how I handle it. I do not mount any OFBiz webapp with mount point= /. This is because I have had other problems in the past trying to do this and getting OFBiz to find resources such as style sheets and images. There is probably a reasonable explanation and solution but I chose to just avoid it. When using Apache to proxy requests I use a server side include. Here is the content in my index.shtml file: !--#include virtual=/store/control/main -- That's it. So I do not have to mount any OFBiz webapp as root, I can still serve other resources from Apache if I want to. Any mount point I need to proxy to OFBiz is configured in the Apache config file. Vince Clark vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell - Original Message - From: BJ Freeman bjf...@free-man.net To: user@ofbiz.apache.org Sent: Monday, April 26, 2010 10:55:17 AM Subject: puzzling error on ajp using a recent nightly build when I set the mount-point=/ and I am using the AJP 1.3 I get an error, which I can not see because of another problem. it does not show in the logs. not asking to debug why I have an error, more why ofbiz has this way of handling an error when using AJP. when I first installed and before much modification, url http://somedomain.com/ worked fine. Now the first url http://somedomain.com/ creates an error. yet when I do a url http://somedomain.com/ecommerce the first time, this work and the rest of the URL's are using the mount-point=/. work as expected. so my url is http://somedomain.com/control/* Note: this works fine with a local copy and not using AJP with the same mods. anyone have any thoughts BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=93 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Linkedin http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro
Re: data models
Thanks BJ. On 26 Apr 2010 16:03, BJ Freeman bjf...@free-man.net wrote: https://cwiki.apache.org/confluence/display/OFBTECH/Home fourth one down. = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=93 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Linkedin http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Chris Snow sent the following on 4/26/2010 7:19 AM: I can no longer find the data models (e.g. AllDiagramsAndTOC_20081030.pdf). Can someone please ...
Re: minimum hardware requirement for ofbiz
thanks, my VPS has 768M allocated memory isn't it enough to run ofbiz for test? i checked memory status with free and used 226M and about 550M left when i tried to run ./ant run-install i got this message at the end of installation run-install: [java] Error occurred during initialization of VM [java] Could not reserve enough space for object heap [java] Could not create the Java virtual machine. [java] Java Result: 1 is that because of memory? or something else i commented out the sepcialpurpose before i installed with !-- -- thing, did i do right? thanks for your help and time in advance. hyun On Apr 24, 2010, at 12:01 PM, BJ Freeman wrote: \framework\base\config\component-load.xml comment out the specialpurpose if you want some of the specialpurpose then specialpurpose\component-load.xml comment out the features you don't want = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=93 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Linkedin http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro HyunWoo Jo sent the following on 4/24/2010 7:33 AM: BJ, thank you for the information. can you give me a link to look for disabling the specialpurpose folder? or can you tell me how to disable? thank you hyun On Apr 23, 2010, at 9:03 PM, BJ Freeman wrote: minimum memory is 512. You may be able to reduce this by disabling the specialpurpose folder. for a 3ghz cpu it usually is about 2%. around midnight there are some services that take up about 75% of cpu time for about an hour. This is dependent on how much the services have to manage. as ofbiz has gotten new features, it has required more memory. I run on a dedicated Centos, but there are a couple of others. = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=93 Specialtymarket.com http://www.specialtymarket.com/ Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Linkedin http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro HyunWoo Jo sent the following on 4/23/2010 1:24 PM: hi, i just subscribed Virtual Private Server from java hosting company. but my memory is 288MB i am just going to run some purchases and sales for my own business internally. is the memory enough? and is this server ok to run ofbiz? thank you in advance. hyun
Re: Multitenant with CAS-LDAP
I haven't read the new multitenant. If the login page is same for all, you can either customize it for user to choose his tenant or parse his tenant from the attributes of CAS service validation. Personally I prefer the latter one. Regards, Shi Jinghai/Beijing Langhua Ltd. 在 2010-04-26一的 12:57 +0200,bpaume@orange-ftgroup.com写道: Hi all, We are using and testing a multitenant version of Ofbiz/Tercompta with purpose ldap (coupled with CAS). When ldap purpose is not used, we are able to choose a tenant in GUI during login. But with ldap/cas there is no GUI! How can we set correct tenantId ? what is best procedure to follow ? modify classes in package org.ofbiz.webapp.control? Customize a LoginWorker for instance? Thanks
inventory adaptation when manual order entry
Hello, When i give a manual order entry, i have at a certain moment, after entering all the products, i have to click on the button reserve inventory and choosing priority normal, low, or high. But nothing is modified in the inventory amounts. What is the error i do? Does someone know that? regards, Heidi
Re: SV: accounting
Hi, I recover this topic because I'm working on the adaptation of the spanish accountancy plan (Plan General Contable) to Ofbiz and I think it is reusable for other european countries and also to resolve some doubts. In fact I am working on the low-medium sized companies PGC there is another one for bigger enterprises, but it doesn't matter. The firsts steps I have done are: - I've downloaded the PGC_ES_PYME.cvs from OpenBravo as Jeroen recommended and it contains all the chart accounts. - I've selected the columns that matches the *accountCode glAccountId parentGlAccountId accountName glAccountClassId*. With a little regexp and string replacement I've generated a data xml. I've used OpenBravo reference to know the meanings of the columns ( http://wiki.openbravo.com/wiki/Creating_Accounts_Files) Now, it seems that I have the PGC correctly loaded. I don't know if I have to do more things in order to get the PGC fully integrated. I have some doubts and I hope someone can point me to the right direction: The first thing is related to https://issues.apache.org/jira/browse/OFBIZ-3411. Regarding to point 1, what are intended for the changes of the parentGlAccountid? In my case I used a few predefined in Ofbiz (asset, liability, revenue, expense, resource) as was referenced on the OpenBravo document. I don't know I will experience some side-effect because I have a very limited knowledge of how accountancy app works internally. I left the GL_ACCOUNT_TYPE_ID and GL_RESOURCE_TYPE_ID with null values. In this case I also don't know what can cause. Another thing concerned to the adaptation is to know how to do auto calculations for some accounts. In the spanish PGC there are a few accounts that are calculated using the values of another ones. It this possible by default? I am probably missing some questions, but I think they will come along the time... Thanks a lot! PS: If it is the interest of somebody I can attach the spanish PGC I have created to the jira or wiki. On Mon, Jan 18, 2010 at 3:44 PM, malin.nico...@librenberry.net wrote: No, or not writing by neogia team's. If I want revert Naccounting improvement in OFBiz, it's the first operation that will do. Nicolas Is there a document (in English) that outlines the main differences between OFBiz accounting and the nAccounting? Med vennlig hilsen Torstein Hegbom IT Polaris A/S tlf: 95832697 -Opprinnelig melding- Fra: Info Olagos [mailto:info.ola...@gmail.com] Sendt: 18. januar 2010 13:28 Til: user@ofbiz.apache.org Emne: Re: accounting Thanks Nicolas, Interesting to know this information. C'est bien de savoir cette information. Merci, thanks, Heidi 2010/1/18 malin.nico...@librenberry.net Hello Heidi, TerCompta works on neogia accounting components and not OFBiz accounting components. Why ? When I started five years ago on OFBiz we need an accounting europeen system and we do an error to create a new component (inspired from baan accounting system). I hope on next years, go back on ofbiz accounting and contribute tu main project. But actually TerCompta is only an addon that embded easier screen to make accounting for small businness. It's use many addon : naccounting-base : to manage account, period and entries naccounting-integ : to use integration engine (you have some event in your system and with define rules you up in you accounting entries by fonctionnal event) naccouting-french-document : contains an hierarchy account use to make french income statement (you can show all on addons.neogia.org/addons) TerCompta do not have french account define, and you can create a new addon with an other hierarchy account and income statement document for an other state with change TerCompta. If you have more question, I am available ;) Nicolas Yes nAccounting is specific to Neogia. It *replaces* OFBiz accounting. The Noegia team is working (for one year now) on so called addons. And if I have well understood, when the addons mechanim will be released you will be able to plugin nAccounting in OFBiz. I have always found weird their way of doing it (instead of using hot-deploy overrides capabilities and such), but this is how things are going... Jacques From: Info Olagos info.ola...@gmail.com Hello, I have downloaded the source code. It is using a separate component naccounting. Need to investigate it further. (so means i need time for all these things) regards, Heidi 2010/1/16 Jacques Le Roux jacques.le.r...@les7arts.com Yes sure, it's maintained by Nicolas Malin from libreenberry http://librenberry.net/spip.php?article21 I'm not quite sure about the licence, most of the time the Neogia team uses GPL... Jacques From: Info Olagos info.ola...@gmail.com Jacques, Is there source code available from
Clustering and Session Replication without multicast
Hello, I am interested in doing clustering and session replication within ofbiz. I have it working using the DeltaManager within the Catalina Container. But I need to do session replication without the use of multicast. I am deploying my ofbiz instance on Amazon's EC2 and I believe multicast is not an option in that environment. Any suggestions? Thanks -craig
Re: Change Item price on a COMPLETED Purchase Order
On Wed, Apr 21, 2010 at 5:48 PM, BJ Freeman bjf...@free-man.net wrote: you may confused by InventoryItEM and its variance. see the Datamodel book Vol 1 page 84 the product is the item you ordered the inventory item is how many and where located. Inventtory Item has a variance about how many you actually have. Ok, but the scenario is something like this: A purchase order is cut for Product 1, qty 1, price $100.00. That item is then received. The person doing the receiving has no authority to vary the price, only to inspect it and give it a lot number (InventoryItemId.) Inventory record is written. After this, while invoicing, and long after the Order is COMPLETED, we want to change the price, and have that altered price be reflected in the inventory record that was written. I'm obviously not communicating the scenario very well, and I don't understand how inventory variance can change an OrderItem line. I think I solved the problem for my shop by doing exactly that, making it possible to edit the price on an OrderItem after the fact, and having that price change update whatever inventory was received against that item, all while keeping the order closed. What I'm trying to learn is whether there are going to be any strange consequences from doing that.
Meta product ordering (e.g., kits)
A requirement we have is to order and invoice a Kit, but to receive the components of that kit. For example, purchasing will order Product 1. But ProductId 1 is a kit that contains ProductId 10001 QTY 4, ProductID 10002 QTY 1, etc. Receiving will indicate the receipt of the (non-inventory) Kit, but will receive the *components* of the kit into inventory. I have an idea how I will implement this, but I want to again check and see if OFBiz already provides the function I'm describing, and if so, whether it will fit our workflow. -- James McGill Phoenix Arizona
Re: Meta product ordering (e.g., kits)
You'll want to look into the Marketing Package ProductType (and it's subtypes). I'm not sure what the support is like for purchasing as opposed to sales but even if it isn't there it shouldn't be too hard to implement. There is definitely support for deconstructing a marketing package as part of a sales order return so look to that if purchasing doesn't already support it. Regards Scott HotWax Media http://www.hotwaxmedia.com On 27/04/2010, at 10:25 AM, James McGill wrote: A requirement we have is to order and invoice a Kit, but to receive the components of that kit. For example, purchasing will order Product 1. But ProductId 1 is a kit that contains ProductId 10001 QTY 4, ProductID 10002 QTY 1, etc. Receiving will indicate the receipt of the (non-inventory) Kit, but will receive the *components* of the kit into inventory. I have an idea how I will implement this, but I want to again check and see if OFBiz already provides the function I'm describing, and if so, whether it will fit our workflow. -- James McGill Phoenix Arizona smime.p7s Description: S/MIME cryptographic signature
Re: Meta product ordering (e.g., kits)
On Mon, Apr 26, 2010 at 3:35 PM, Scott Gray scott.g...@hotwaxmedia.comwrote: You'll want to look into the Marketing Package ProductType (and it's subtypes). I'm not sure what the support is like for purchasing as opposed to sales but even if it isn't there it shouldn't be too hard to implement. Thank you Scott, I'm sure that will set me on the right track for this. -- James
MySql related
*This is what I got when I followed steps to configure MySql and used url to check whether it worked fine.What should I do to get rid of this? * *type* Exception report *message* *description* *The server encountered an internal error () that prevented it from fulfilling this request.* *exception* java.lang.IllegalArgumentException: Could not get next sequenced ID for sequence name: Visit org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:3123) org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:3109) org.ofbiz.entity.GenericEntity.setNextSeqId(GenericEntity.java:553) org.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator.java:703) org.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:169) org.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:88) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:185) javax.servlet.http.HttpServlet.service(HttpServlet.java:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259) *note* *The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.*
Re: MySql related
Few questions: 1) Are you using trunk? Which version? 2) Are you deploying application on external tomcat? -- Ashish On Tue, Apr 27, 2010 at 10:38 AM, Selvakumar Ganesan selvaku...@formativesolutions.co.in wrote: *This is what I got when I followed steps to configure MySql and used url to check whether it worked fine.What should I do to get rid of this? * *type* Exception report *message* *description* *The server encountered an internal error () that prevented it from fulfilling this request.* *exception* java.lang.IllegalArgumentException: Could not get next sequenced ID for sequence name: Visit org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:3123) org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:3109) org.ofbiz.entity.GenericEntity.setNextSeqId(GenericEntity.java:553) org.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator.java:703) org.ofbiz.webapp.stats.VisitHandler.getVisit(VisitHandler.java:169) org.ofbiz.webapp.stats.VisitHandler.getVisitId(VisitHandler.java:88) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:185) javax.servlet.http.HttpServlet.service(HttpServlet.java:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259) *note* *The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.*