Re: Using OFBiz with DB2 for i (AS400) database

[robertpic]

>>Or is that a legacy system? 
Yes. We use an self-made ERP on this system for ~ 350 Users.  Most parts of
the ERP working with "green screen/telnet".

Why we chosse ofbiz?
- it can handle all our needs (multishop, variants)
- very clean overrides for i.e. own prices --> override event, extend Event
- well known technology (J2EE)

why we use db2/as400?
- for seamless integration with our greenscreen ERP (Cobol/RPG could
read/update ofbiz data)
- our db2 is clustered




--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Using-OFBiz-with-DB2-for-i-AS400-database-tp4650633p4707487.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Add Tax in AP invoice

[Jacques Le Roux]

Hi Moatasim,

You were very lucky that the attachment passed, they don't normally. But it's 
hardly legible, it's better to create a Jira in such cases.

Thanks

Jacques


Le 06/07/2017 à 12:58, Moatasim Al Masri a écrit :


Dears

I tried to add sales tax in AP invoice with press Add tax button in invoice menu, but when I pressed ready to post, I found the totals credit not 
equal total debit, and also the transaction go to suspense journal.


Kindly see attachment.

screen

Add Tax in AP invoice

[Moatasim Al Masri]

Dears
I tried to add sales tax in AP invoice with press Add tax button in invoice 
menu, but when I pressed ready to post, I found the totals credit not equal 
total debit, and also the transaction go to suspense journal.

Kindly see attachment.

[screen]

Re: Fwd: MODERATE for user@ofbiz.apache.org

[Jacques Le Roux]

Velusamy,

I see that you have already created 
https://issues.apache.org/jira/browse/OFBIZ-9420

This will hopefully help other users to help you


Jacques


Le 06/07/2017 à 12:14, Jacques Le Roux a écrit :


Hi Velusamy ,

Your mail has been moderated, Please subscribe to the user mailing list
http://ofbiz.apache.org/mailing-lists.html

Jacques



 Message transféré 
Sujet : MODERATE for user@ofbiz.apache.org
Date :  6 Jul 2017 05:35:37 -









ForwardedMessage.eml

Sujet :
Unable to find Purchase Return - Accounting entries
De :
Velusamy Thiruvenkadam 
Date :
06/07/2017 07:35

Pour :
user@ofbiz.apache.org


Dear Team,

Need you expertise help / advise on the below topic as i m just started 
exploring Ofbiz product
Issue:
Cant able to find the accounting entries for the purchase return but the inventory impact happening correctly ( reducing the quantity based on the 
Purchase Return shipment )


Steps followed:
1. Create & Accept the purchase return based on a purchase order.
2. Create "Outgoing Purchase Return Shipment " & Add the item section and 
changed the status to shipped.
3. Purchase return invoice created by system and the status is "Ready For 
Posting"

But accounting transaction not created there is no financial impact to the inventory account as well as to the payable account. ( Tried in demo 
trunk also )


Did I missed any of the configuration / steps , please suggest.

with smile
velusamy

Re: error in requesting new password

[pierre.gaudin]

Thanks  Jacques ;-)

Pierre
On 06/07/2017 10:24, Jacques Le Roux wrote:

Hi Pierre,

I'll have a look today...

Jacques


Le 06/07/2017 à 10:09, pierre.gaudin a écrit :

Hi all,

Is there anyone with the same error?

regards,

Pierre
On 04/07/2017 11:01, pierre.gaudin wrote:

Hi all,

While testing the sending of a new password on a local trunk, I meet 
an error.

Here are the stapes to reproduce:
 - ont the login page click on 'Forgot Your Password?'
 - an email is sent with a link
 - click the link
 - a form is display allowing to indicate the new password
 - clik on submit button and then an error message is display

In the local OFBiz log i can see this errror message :
Unable to execute 'doFinal' with cipher instance 
[javax.crypto.Cipher@42f40da].


If i do the same on on trunk demo i see this error message :
org.apache.ofbiz.entity.EntityCryptoException: 
org.apache.ofbiz.entity.EntityCryptoException: key(Secret Key) not 
found in database (key(Secret Key) not found in database)
at 
org.apache.ofbiz.entity.util.EntityCrypto.decrypt(EntityCrypto.java:138) 
~[ofbiz.jar:?]
at 
org.apache.ofbiz.webapp.control.LoginWorker.login(LoginWorker.java:336) 
[ofbiz.jar:?]



Is there a way to fix this error?

Thanks in advance,

Pierre

Re: Fwd: Fwd: MODERATE for user@ofbiz.apache.org

[Jacques Le Roux]

Parikshit,

OFBiz can handle a such scenario.

I'd first recommend you to buy and read few books
At least "The Data Model Resource Book Volumes 1" and and "OFBiz Manufacturing 
Application."
See https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Related+Books

HTH

Jacques


Le 06/07/2017 à 12:12, Jacques Le Roux a écrit :





 Message transféré 
Sujet : Fwd: MODERATE for user@ofbiz.apache.org
Date :  Thu, 6 Jul 2017 12:11:47 +0200
De :Jacques Le Roux 
Organisation :  Les Arts Informatiques
Pour :  parikshit.pa...@divergentsl.com



Hi Parikshit ,

Your mail has been moderated, Please subscribe to the user mailing list
http://ofbiz.apache.org/mailing-lists.html

Jacques



ForwardedMessage.eml

Sujet :
Setup For Manufacturing Company
De :
Parikshit Patel 
Date :
06/07/2017 06:54

Pour :
user@ofbiz.apache.org


Hi OFBiz Team,

Thank you for providing such a wonderful product.

I have one client and he wants to use an ERP solution for his manufacturing unit. I am evaluating OfBiz for the purpose. So far I am very much 
impressed with it.
But I need your help to find the correct resources that could guide me to setup the entire flow for a manufacturing company. Also, the product that 
they develop is highly customizable and every client of theirs request different customization in the product.


First, would you recommend me to go for OFBiz for such scenario and if yes, please guide me to correct resources that could help me doing the 
initial setup.


Thanks and Regards,
Parikshit Patel

Fwd: MODERATE for user@ofbiz.apache.org

[Jacques Le Roux]

Hi Velusamy ,

Your mail has been moderated, Please subscribe to the user mailing list
http://ofbiz.apache.org/mailing-lists.html

Jacques



 Message transféré 
Sujet : MODERATE for user@ofbiz.apache.org
Date :  6 Jul 2017 05:35:37 -








--- Begin Message ---
Dear Team,

Need you expertise help / advise on the below topic as i m just started
exploring Ofbiz product
Issue:
Cant able to find the accounting entries for the purchase return but the
inventory impact happening correctly ( reducing the quantity based on the
Purchase Return shipment )

Steps followed:
1. Create & Accept the purchase return based on a purchase order.
2. Create "Outgoing Purchase Return Shipment " & Add the item section and
changed the status to shipped.
3. Purchase return invoice created by system and the status is "Ready For
Posting"

But accounting transaction not created there is no financial impact to the
inventory account as well as to the payable account. ( Tried in demo trunk
also )

Did I missed any of the configuration / steps , please suggest.

with smile
velusamy
--- End Message ---

Fwd: Fwd: MODERATE for user@ofbiz.apache.org

[Jacques Le Roux]

 Message transféré 
Sujet : Fwd: MODERATE for user@ofbiz.apache.org
Date :  Thu, 6 Jul 2017 12:11:47 +0200
De :Jacques Le Roux 
Organisation :  Les Arts Informatiques
Pour :  parikshit.pa...@divergentsl.com



Hi Parikshit ,

Your mail has been moderated, Please subscribe to the user mailing list
http://ofbiz.apache.org/mailing-lists.html

Jacques


--- Begin Message ---
Hi OFBiz Team,

Thank you for providing such a wonderful product.

I have one client and he wants to use an ERP solution for his manufacturing
unit. I am evaluating OfBiz for the purpose. So far I am very much
impressed with it.
But I need your help to find the correct resources that could guide me to
setup the entire flow for a manufacturing company. Also, the product that
they develop is highly customizable and every client of theirs request
different customization in the product.

First, would you recommend me to go for OFBiz for such scenario and if yes,
please guide me to correct resources that could help me doing the initial
setup.

Thanks and Regards,
Parikshit Patel
--- End Message ---

Re: error in requesting new password

[Jacques Le Roux]

Hi Pierre,

I'll have a look today...

Jacques


Le 06/07/2017 à 10:09, pierre.gaudin a écrit :

Hi all,

Is there anyone with the same error?

regards,

Pierre
On 04/07/2017 11:01, pierre.gaudin wrote:

Hi all,

While testing the sending of a new password on a local trunk, I meet an error.
Here are the stapes to reproduce:
 - ont the login page click on 'Forgot Your Password?'
 - an email is sent with a link
 - click the link
 - a form is display allowing to indicate the new password
 - clik on submit button and then an error message is display

In the local OFBiz log i can see this errror message :

Unable to execute 'doFinal' with cipher instance [javax.crypto.Cipher@42f40da].


If i do the same on on trunk demo i see this error message :
org.apache.ofbiz.entity.EntityCryptoException: org.apache.ofbiz.entity.EntityCryptoException: key(Secret Key) not found in database (key(Secret 
Key) not found in database)

at org.apache.ofbiz.entity.util.EntityCrypto.decrypt(EntityCrypto.java:138) 
~[ofbiz.jar:?]
at org.apache.ofbiz.webapp.control.LoginWorker.login(LoginWorker.java:336) 
[ofbiz.jar:?]



Is there a way to fix this error?

Thanks in advance,

Pierre

Re: error in requesting new password

[pierre.gaudin]

Hi all,

Is there anyone with the same error?

regards,

Pierre
On 04/07/2017 11:01, pierre.gaudin wrote:

Hi all,

While testing the sending of a new password on a local trunk, I meet 
an error.

Here are the stapes to reproduce:
 - ont the login page click on 'Forgot Your Password?'
 - an email is sent with a link
 - click the link
 - a form is display allowing to indicate the new password
 - clik on submit button and then an error message is display

In the local OFBiz log i can see this errror message :
Unable to execute 'doFinal' with cipher instance 
[javax.crypto.Cipher@42f40da].


If i do the same on on trunk demo i see this error message :
org.apache.ofbiz.entity.EntityCryptoException: 
org.apache.ofbiz.entity.EntityCryptoException: key(Secret Key) not 
found in database (key(Secret Key) not found in database)
at 
org.apache.ofbiz.entity.util.EntityCrypto.decrypt(EntityCrypto.java:138) 
~[ofbiz.jar:?]
at 
org.apache.ofbiz.webapp.control.LoginWorker.login(LoginWorker.java:336) 
[ofbiz.jar:?]



Is there a way to fix this error?

Thanks in advance,

Pierre

Re: Using OFBiz with DB2 for i (AS400) database

[Taher Alkhateeb]

Hi Robert,

Just out of curiosity, are you folks actually running DB2 on an IBM
AS/400 machine?

I didn't know those still exist, any reason why you chose this
architecture in the first place? Or is that a legacy system?

On Thu, Jul 6, 2017 at 1:37 AM, robertpic
 wrote:
> @Jacques Le Roux
>
> DB2 data source at r1730616
> looks, fine
>
> there are some troubles with the native (AS/400) backup/restore tools
> (savobj/rstobj) and the contraints.
> --> actually we do an xml-export, 'll check this out later
>
>
> status update
> we will go online in about 2 weeks (B2B) ... and B2C in about 2 months
>
> 
>
> mobile
> 
>
>
>
> --
> View this message in context: 
> http://ofbiz.135035.n4.nabble.com/Using-OFBiz-with-DB2-for-i-AS400-database-tp4650633p4707470.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

Visual Themes Gallery

[Jacques Le Roux]

Hi,

Should we keep and maintain this page?

https://cwiki.apache.org/confluence/display/OFBIZ/Visual+Themes+Gallery

If we do should we remove the old themes (they still are there in the SVN 
repo)? And also, if we keep the page, the Rainbow theme misses.

Thanks

Jacques

Re: Using OFBiz with DB2 for i (AS400) database

[Jacques Le Roux]

Thanks for the update Robert,

I wish you best luck for the production release

Jacques


Le 06/07/2017 à 00:37, robertpic a écrit :

@Jacques Le Roux

DB2 data source at r1730616
looks, fine

there are some troubles with the native (AS/400) backup/restore tools
(savobj/rstobj) and the contraints.
--> actually we do an xml-export, 'll check this out later


status update
we will go online in about 2 weeks (B2B) ... and B2C in about 2 months



mobile




--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/Using-OFBiz-with-DB2-for-i-AS400-database-tp4650633p4707470.html
Sent from the OFBiz - User mailing list archive at Nabble.com.