Re: MRP using Facility Group

2008-07-11 Thread Jacopo Cappellato
Hi Nico, in its current (pretty basic) implementation of the facility group support, you have to create a facility group: * with a facility associated as WAREHOUSE: used by the MRP for inventory levels * and with a facility associated as PLANT: used by the MRP when it generates

Re: MRP using Facility Group

2008-07-11 Thread nico61
Hi Jacopo, my current trunk version is 672765. I already used your suggestion and configured a facility as WAREHOUSE and the other as PLANT as follows: facility associated as WAREHOUSE Aluminum Door Handles, Plastic Door Handles and Hardboard Door anyone configured as: Product type =

Re: MRP using Facility Group

2008-07-11 Thread Jacopo Cappellato
Just try to set the inventory settings for the door into the WAREHOUSE and not into the PLANT. WAREHOUSE: door Product type = Configurable good ATP=QOH=OQ = 0 Minimum Stock = 10 Jacopo On Jul 11, 2008, at 10:34 AM, nico61 wrote: Hi Jacopo, my current trunk version is 672765. I already

Re: MRP using Facility Group

2008-07-11 Thread nico61
in this way, I obtain a third Proposed Purchase Order with a quantity = 10 for the door and I need to have a requirement for manufacturing orders for the door in the PLANT Nico Jacopo Cappellato-3 wrote: Just try to set the inventory settings for the door into the WAREHOUSE and not

Re: MRP using Facility Group

2008-07-11 Thread Jacopo Cappellato
how is the BOM of the door setup? Jacopo On Jul 11, 2008, at 11:07 AM, nico61 wrote: in this way, I obtain a third Proposed Purchase Order with a quantity = 10 for the door and I need to have a requirement for manufacturing orders for the door in the PLANT Nico Jacopo

Packing Order with Configurable Product

2008-07-11 Thread rnatavio
Hello everyone I have problems in packing configurable and virtual products for shipping. Here's what I did: First I ordered (PC001) in the eCommerce module. Then I completed the production run, and closed it. The problem arised when I try to pack the items that was ordered. It seems only

Re: Variants configurable

2008-07-11 Thread rnatavio
Hi Jacques, Having a configurable good as a variant of a virtual product seem impossible. I've tried this both ways, having a configurable good as a variant to a virtual product, and having a virtual product as a part/configuration of a configurable good. Both ways doesn't seem to work (as far

Re: Security.hasRolePermission or DataDrivenSecurity

2008-07-11 Thread Jacques Le Roux
You are welcome Ashish, It's a way for me to learn, there are much corners in there ;o) Jacques From: Ashish Vijaywargiya [EMAIL PROTECTED] Thanks Jacques for your valuable reply. I truly appreciate your efforts. -- Ashish On Thu, Jul 10, 2008 at 4:08 PM, Jacques Le Roux [EMAIL PROTECTED]

Re: Possible Payments Applied Transaction Error

2008-07-11 Thread Jacques Le Roux
Sharan, This is a very interestng point. I'm really interested in this, as I want to introduce it also https://issues.apache.org/jira/browse/OFBIZ-287 Could we share work on this ? BTW here are some clues : http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Contributors+Best+Practices Thanks

Re: Possible Payments Applied Transaction Error

2008-07-11 Thread Jacques Le Roux
Désolé Sharan, Je n'avais pas remarqué votre réponse. My apologies Jacques From: Sharan-F [EMAIL PROTECTED] Un grand merci monsieur I'm not an accountant either so I'm getting a local accountant to give me their feedback. I've taken a look at your links and I think the key to the problem

Re: Variants configurable

2008-07-11 Thread Jack McKinney
Jacques: I have also done a small amount of testing in this area and it does not work as far as I can tell. A product can be configurable or variant but not both. -- Jack D. McKinney Walnut Glenn Systems 5001 Jennie Kate Lane Lexington, KY 40510 Phone: 859.233.4299 Cell:859.433.4299

Re: Variants configurable

2008-07-11 Thread Jacques Le Roux
Thanks to both, I should defintively have a look too... Jacques From: Jack McKinney [EMAIL PROTECTED] Jacques: I have also done a small amount of testing in this area and it does not work as far as I can tell. A product can be configurable or variant but not both. -- Jack D. McKinney

Re: UPS online tools international shipping

2008-07-11 Thread BJ Freeman
some work would have to be done to use the sending address to activate the UPS rules outside of the US. To my knowledge this is not implemented at this time. mike_mcmillan sent the following on 7/10/2008 1:40 PM: Does anyone have experience shipping international shipments using the UPS online

Re: Packing Order with Configurable Product

2008-07-11 Thread Jacques Le Roux
Thanks for the input, Note that you don't need to execute a production run for PC001 http://docs.ofbiz.org/display/OFBIZ/using+the+UI+to+add+the+PC001 Jacques From: rnatavio [EMAIL PROTECTED] Hello everyone I have problems in packing configurable and virtual products for shipping. Here's

Re: Packing Order with Configurable Product

2008-07-11 Thread Jacques Le Roux
Hi Bilgin, I just tried with PC001 and there is nothing to pack. Also Quick Ship says : Warning: no shipments created; could not find anything ready and needing to be shipped. Jacques From: Bilgin Ibryam [EMAIL PROTECTED] Hi, In rev. 675929 I did a fix for configurable products (PC001) but

Re: Packing Order with Configurable Product

2008-07-11 Thread Bilgin Ibryam
Jacques, You can do it one of two ways: 1. Create an order for PC001 2. Complete the production run and add the produced PC to the inventory 3. From order view screen use Pack Shipment For Ship Group and then Pack items for shipment(this will issue the pc from inventory to shipment) 4. Set

Database version and updates in log missing

2008-07-11 Thread BJ Freeman
use to be we saw the database info when the driver was found and the verify of the data base if it was set in the entityengine. has this been changed?

Table missing so can't login

2008-07-11 Thread BJ Freeman
[java] Caused by: ERROR 42X04: Column 'USER_LDAP_DN' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE

Re: Data migration issue ... multi-valued Party attributes?

2008-07-11 Thread BJ Freeman
ofbiz handles this with many entities. if you hope to use ofbiz then I suggest you convert to the ofbiz model. as far as schemas that is defined in the entityengine.xml, schema-name=OFBIZ David Gay sent the following on 7/11/2008 9:47 AM: Hi all! We are in the process of migrating

Re: Table missing so can't login

2008-07-11 Thread Adrian Crum
Did you run ant run-install? -Adrian BJ Freeman wrote: [java] Caused by: ERROR 42X04: Column 'USER_LDAP_DN' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the

Re: Table missing so can't login

2008-07-11 Thread Jacques Le Roux
Could it be related to the changes I made in r675947 and the fix I put in r676022? I doubt but could you check please ? Jacques From: BJ Freeman [EMAIL PROTECTED] [java] Caused by: ERROR 42X04: Column 'USER_LDAP_DN' is either not in any table in the FROM list or appears within a join

Re: Data migration issue ... multi-valued Party attributes?

2008-07-11 Thread David Gay
On Fri, Jul 11, 2008 at 12:54 PM, BJ Freeman [EMAIL PROTECTED] wrote: ofbiz handles this with many entities. That's good news, but which entities would you suggest? I have yet to find one that will do the job. if you hope to use ofbiz then I suggest you convert to the ofbiz model. Yes, that

Re: Table missing so can't login

2008-07-11 Thread BJ Freeman
I am using 674908 will update Jacques Le Roux sent the following on 7/11/2008 10:08 AM: Could it be related to the changes I made in r675947 and the fix I put in r676022? I doubt but could you check please ? Jacques From: BJ Freeman [EMAIL PROTECTED] [java] Caused by: ERROR 42X04:

Re: Table missing so can't login

2008-07-11 Thread Adrian Crum
UserLdapDn is a field that was recently added to the userLogin entity. It sounds like you are running new code on an old version of the entity. -Adrian BJ Freeman wrote: ant clean ant run-install-seed Adrian Crum sent the following on 7/11/2008 10:01 AM: Did you run ant run-install?

Re: Table missing so can't login

2008-07-11 Thread Adrian Crum
I'm not having those problems on my local copy. -Adrian BJ Freeman wrote: This is an old db that I keep to find migration errors I believe the update part of the database check-on-start=true add-missing-on-start=true are not be done or are erroring. however I can not

Re: Data migration issue ... multi-valued Party attributes?

2008-07-11 Thread BJ Freeman
I am sure you can get someone here to help you for a fee. My suggestion is you get familiar with the entities using the webtools. https://demo.hotwaxmedia.com/webtools/control/entitymaint (online) or https://localhost:8443/webtools/control/entitymaint (on your machine) then create your mapping

Re: Table missing so can't login

2008-07-11 Thread BJ Freeman
guess I will have to dig into the code that connects the db and find out what happen to the loging. thanks. Adrian Crum sent the following on 7/11/2008 10:58 AM: I'm not having those problems on my local copy. -Adrian BJ Freeman wrote: This is an old db that I keep to find migration

Re: Data migration issue ... multi-valued Party attributes?

2008-07-11 Thread David Gay
On Fri, Jul 11, 2008 at 2:08 PM, Adrian Crum [EMAIL PROTECTED] wrote: Take a look at The Data Model Resource Book, chapter 4, Agreements. Aha! That's the spot we were looking for, thanks a bunch! :-)

Re: Data migration issue ... multi-valued Party attributes?

2008-07-11 Thread David Gay
I am sure you can get someone here to help you for a fee. We may do that; a sanity-check of our progress from a seasoned user/developer would be a good start. Is there a process or etiquette in place for such things? My suggestion is you get familiar with the entities using the webtools.

Re: Table missing so can't login

2008-07-11 Thread Jacques Le Roux
I also get an error with a clean instance (svn st being ok) after a clean-all and run-install. I have not this issue if I only clean the olap base (So its not relate to the changes I made recently removing all entitygroup.xml but BI's) [java] 2008-07-11 19:52:08,734 (main) [

Re: Database version and updates in log missing

2008-07-11 Thread Jacques Le Roux
Hi Scott, Yes, it was before I removed the entitygroup.xml files and theirs reference from ofbiz-component files in specialpurpose. Apart from BI (which use the olap datasource) at least one entitygroup.xml file and its reference from a ofbiz-component file is needed for now. I reverted in

Re: Database version and updates in log missing

2008-07-11 Thread BJ Freeman
so you can see the database driver version at boot up and see the database(derby) check the tables. should see old columns being reported as not used. Scott Gray sent the following on 7/11/2008 12:57 PM: I'm on rev. 675904 and it works for me. -Scott 2008/7/12 BJ Freeman [EMAIL PROTECTED]:

Re: Data migration issue ... multi-valued Party attributes?

2008-07-11 Thread BJ Freeman
No specific process or etiquette I know, but others may know of it. you can email someone on the mailing list that seems to know what they are talking about or you can use the providers list. you have done pretty good, for only being at it for several weeks. I have found that doing flat file

Re: Packing Order with Configurable Product

2008-07-11 Thread Jacques Le Roux
Thanks Bilgin, I did not try yet. But is this normal from a Quick Ship POV ? Jacques From: Bilgin Ibryam [EMAIL PROTECTED] Jacques, You can do it one of two ways: 1. Create an order for PC001 2. Complete the production run and add the produced PC to the inventory 3. From order view screen

Re: Data migration issue ... multi-valued Party attributes?

2008-07-11 Thread David E Jones
David, The best way to communicate the data concepts you'd like help mapping is to use data statement sentences to describe what each data element (entity, field, etc) means and how it relates to other things. Don't try to match it up to your current data model, try to describe it in