Phil Daintree | 3 Feb 10:29 2011
Picon

Problem with mailing list???

Testing 123

------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
Julie Saville | 3 Feb 10:03 2011
Picon

FW: few questions

Hi

 

Could somebody please go through the steps of processing a receipt for approx $21,415 which was made in USD currency and paid into my AUS $ account.

Do I enter the bank exchange rate of 1.01610 and which amount do I put for amount received $21,415 USD or the actual $21,065.68 AUS.

 

Also still having quite a few purchase order issues:

 

1.       When I enter an order I have to go back into it 3 times before I can print it which is very time consuming – firstly I place the order, then I have to go back in to authorise it then go back in for the third time to print it – is there an easier / quicker way.

 

2.       I had to redo quite a few orders late last year in a different currency and now am trying to cancel the old original orders – following is the message that I get

 

Fatal error: Undefined class constant 'STATUS_CANCELLED' in /home/saveur/public_html/accounts/PO_Header.php on line 361.

 

 

3.    Also yesterday I received stock in but when I did the “Goods received” I entered the full amount instead of just part of the order that came.  I went in and reversed the goods received but now it is showing the order as “completed” and won’t let me receive any stock.

 

 

Thanks in advance for any help

 

Julie Saville

 

 

 

------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users
Phil Daintree | 3 Feb 11:27 2011
Picon

Re: FW: few questions


On 03/02/11 21:03, Julie Saville wrote:
> Hi
>
> Could somebody please go through the steps of processing a receipt for
> approx $21,415 which was made in USD currency and paid into my AUS $
> account.
>
> Do I enter the bank exchange rate of 1.01610 and which amount do I put
> for amount received $21,415 USD or the actual $21,065.68 AUS.
>
> Also still having quite a few purchase order issues:
>
> 1. When I enter an order I have to go back into it 3 times before I can
> print it which is very time consuming – firstly I place the order, then
> I have to go back in to authorise it then go back in for the third time
> to print it – is there an easier / quicker way.
>

I was thinking it might be an idea to have an option to allow authorised 
folks who add a purchase order to create the purchase order as 
authorised automatically to avoid this additional step. At the moment 
the assumption is a different person is required to authorise an order. 
In larger companies this would be necessary but in smaller businesses it 
would seem foolish - when the ownership of the business is in the hands 
of the operator!!

> 2. I had to redo quite a few orders late last year in a different
> currency and now am trying to cancel the old original orders – following
> is the message that I get
>
> *Fatal error*: Undefined class constant 'STATUS_CANCELLED' in
> */home/saveur/public_html/accounts/PO_Header.php* on line *361.*
>
> * *

I have re-written quite a bit of the purchasing stuff in the latest 
version... it would require an upgrade and I am not quite finished - it 
then needs a thorough testing of course.

>
> 3. Also yesterday I received stock in but when I did the “Goods
> received” I entered the full amount instead of just part of the order
> that came. I went in and reversed the goods received but now it is
> showing the order as “completed” and won’t let me receive any stock.
>

This sounds like a bug in the script - I will fix the reverse GRN 
script. Thanks for reporting.

> Thanks in advance for any help
>
> Julie Saville
>
> * *
>
> 	
>
>
>
> ------------------------------------------------------------------------------
> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> Finally, a world-class log management solution at an even better price-free!
> Download using promo code Free_Logger_4_Dev2Dev. Offer expires
> February 28th, so secure your free ArcSight Logger TODAY!
> http://p.sf.net/sfu/arcsight-sfd2d
>
>
>
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users

------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
Tim Schofield | 3 Feb 13:07 2011

Re: FW: few questions

On 3 February 2011 09:03, Julie Saville <juliesav@...> wrote:
> 2.       I had to redo quite a few orders late last year in a different currency and now am trying to
cancel the old original orders – following is the message that I get
>
>
>
> Fatal error: Undefined class constant 'STATUS_CANCELLED' in
/home/saveur/public_html/accounts/PO_Header.php on line 361.
>

Hi Julie,
What version of webERP are you using? This appears to be fine in
3.11.4 and in 4.0.1. Are there any customisations on your system?

Lines 7-14 of includes/DefinePOClass.php should be:

Class PurchOrder {
	const STATUS_NEW_ORDER  = 'New Order';
	const STATUS_PENDING    = 'Pending';
	const STATUS_AUTHORISED = 'Authorised';
	const STATUS_REJECTED   = 'Rejected';
	const STATUS_CANCELLED  = 'Cancelled';
	const STATUS_PRINTED    = 'Printed';
	const STATUS_COMPLITED  = 'Completed';

is this what they are on your system?

Thanks
Tim

--
WebERP Africa Ltd
+447710427049
+256752963327
+255784602561
www.weberpafrica.com

------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
Julie Saville | 3 Feb 13:13 2011
Picon

Re: FW: few questions

Hi Tim

I have version 3.11.4 - sorry where do I look for the customisations. 

Julie

-----Original Message-----
From: Tim Schofield [mailto:tim@...] 
Sent: Thursday, 3 February 2011 10:07 PM
To: For the general discussion of webERP project
Subject: Re: [webERP-users] FW: few questions

On 3 February 2011 09:03, Julie Saville <juliesav@...> wrote:
> 2.       I had to redo quite a few orders late last year in a different
currency and now am trying to cancel the old original orders – following is
the message that I get
>
>
>
> Fatal error: Undefined class constant 'STATUS_CANCELLED' in
/home/saveur/public_html/accounts/PO_Header.php on line 361.
>

Hi Julie,
What version of webERP are you using? This appears to be fine in
3.11.4 and in 4.0.1. Are there any customisations on your system?

Lines 7-14 of includes/DefinePOClass.php should be:

Class PurchOrder {
	const STATUS_NEW_ORDER  = 'New Order';
	const STATUS_PENDING    = 'Pending';
	const STATUS_AUTHORISED = 'Authorised';
	const STATUS_REJECTED   = 'Rejected';
	const STATUS_CANCELLED  = 'Cancelled';
	const STATUS_PRINTED    = 'Printed';
	const STATUS_COMPLITED  = 'Completed';

is this what they are on your system?

Thanks
Tim

--
WebERP Africa Ltd
+447710427049
+256752963327
+255784602561
www.weberpafrica.com

----------------------------------------------------------------------------
--
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users

------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
Tim Schofield | 3 Feb 13:44 2011

Re: FW: few questions

Hi Julie,

Well it looks like your system isn't a standard 3.11.4 as the constant
STATUS_CANCELLED wasn't brought in until later than that. If I
remember correctly they were brought in when the utf8 branch was
merged into the main line. It seems like some changes have been
affected on your system since 3.11.4.

I would recommend that you upgraded to 4.0.1 as it has a lot of
security fixes as well as bug fixes in it.

Thanks
Tim

On 3 February 2011 12:07, Tim Schofield <tim@...> wrote:
> On 3 February 2011 09:03, Julie Saville <juliesav@...> wrote:
>> 2.       I had to redo quite a few orders late last year in a different currency and now am trying to
cancel the old original orders – following is the message that I get
>>
>>
>>
>> Fatal error: Undefined class constant 'STATUS_CANCELLED' in
/home/saveur/public_html/accounts/PO_Header.php on line 361.
>>
>
> Hi Julie,
> What version of webERP are you using? This appears to be fine in
> 3.11.4 and in 4.0.1. Are there any customisations on your system?
>
> Lines 7-14 of includes/DefinePOClass.php should be:
>
> Class PurchOrder {
>        const STATUS_NEW_ORDER  = 'New Order';
>        const STATUS_PENDING    = 'Pending';
>        const STATUS_AUTHORISED = 'Authorised';
>        const STATUS_REJECTED   = 'Rejected';
>        const STATUS_CANCELLED  = 'Cancelled';
>        const STATUS_PRINTED    = 'Printed';
>        const STATUS_COMPLITED  = 'Completed';
>
> is this what they are on your system?
>
> Thanks
> Tim
>
>
> --
> WebERP Africa Ltd
> +447710427049
> +256752963327
> +255784602561
> www.weberpafrica.com
>

--

-- 
WebERP Africa Ltd
+447710427049
+256752963327
+255784602561
www.weberpafrica.com

------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
Julie Saville | 3 Feb 14:21 2011
Picon

Re: FW: few questions

Hi Tim / Phil

The orders in question were all entered at the same time and I was able to
cancel one of them in late November/early December.  I just forgot to cancel
the other 2 and only realised when I saw all the amounts of stock in
outstanding orders.  I was updated to 3.11.4 back in July last year.  I have
also been able to cancel other orders so why is there now a problem.  Does
this mean I have a bug in my system.  If so what do I need to do?

Thanks Julie

-----Original Message-----
From: Tim Schofield [mailto:tim@...] 
Sent: Thursday, 3 February 2011 10:45 PM
To: For the general discussion of webERP project
Subject: Re: [webERP-users] FW: few questions

Hi Julie,

Well it looks like your system isn't a standard 3.11.4 as the constant
STATUS_CANCELLED wasn't brought in until later than that. If I
remember correctly they were brought in when the utf8 branch was
merged into the main line. It seems like some changes have been
affected on your system since 3.11.4.

I would recommend that you upgraded to 4.0.1 as it has a lot of
security fixes as well as bug fixes in it.

Thanks
Tim

On 3 February 2011 12:07, Tim Schofield <tim@...> wrote:
> On 3 February 2011 09:03, Julie Saville <juliesav@...> wrote:
>> 2.       I had to redo quite a few orders late last year in a different
currency and now am trying to cancel the old original orders – following is
the message that I get
>>
>>
>>
>> Fatal error: Undefined class constant 'STATUS_CANCELLED' in
/home/saveur/public_html/accounts/PO_Header.php on line 361.
>>
>
> Hi Julie,
> What version of webERP are you using? This appears to be fine in
> 3.11.4 and in 4.0.1. Are there any customisations on your system?
>
> Lines 7-14 of includes/DefinePOClass.php should be:
>
> Class PurchOrder {
>        const STATUS_NEW_ORDER  = 'New Order';
>        const STATUS_PENDING    = 'Pending';
>        const STATUS_AUTHORISED = 'Authorised';
>        const STATUS_REJECTED   = 'Rejected';
>        const STATUS_CANCELLED  = 'Cancelled';
>        const STATUS_PRINTED    = 'Printed';
>        const STATUS_COMPLITED  = 'Completed';
>
> is this what they are on your system?
>
> Thanks
> Tim
>
>
> --
> WebERP Africa Ltd
> +447710427049
> +256752963327
> +255784602561
> www.weberpafrica.com
>

-- 
WebERP Africa Ltd
+447710427049
+256752963327
+255784602561
www.weberpafrica.com

----------------------------------------------------------------------------
--
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users

------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
Tim Schofield | 3 Feb 14:50 2011

Re: FW: few questions

Hi Julie,

Well without actually seeing your system its hard for me to say, but
the error message you gave was definitely created by code that was
added to webERP after 3.11.4 was released. So it seems to me you have
some code added that wasn't in 3.11.4. This code seems to be
incompatible with the rest of the code. Is it possible for you to send
me off list the files PO_Header.php and includes/DefinePOClass.php
from your system?

Thanks
Tim

On 3 February 2011 13:21, Julie Saville <juliesav@...> wrote:
> Hi Tim / Phil
>
> The orders in question were all entered at the same time and I was able to
> cancel one of them in late November/early December.  I just forgot to cancel
> the other 2 and only realised when I saw all the amounts of stock in
> outstanding orders.  I was updated to 3.11.4 back in July last year.  I have
> also been able to cancel other orders so why is there now a problem.  Does
> this mean I have a bug in my system.  If so what do I need to do?
>
> Thanks Julie
>
>
>
> -----Original Message-----
> From: Tim Schofield [mailto:tim@...]
> Sent: Thursday, 3 February 2011 10:45 PM
> To: For the general discussion of webERP project
> Subject: Re: [webERP-users] FW: few questions
>
> Hi Julie,
>
> Well it looks like your system isn't a standard 3.11.4 as the constant
> STATUS_CANCELLED wasn't brought in until later than that. If I
> remember correctly they were brought in when the utf8 branch was
> merged into the main line. It seems like some changes have been
> affected on your system since 3.11.4.
>
> I would recommend that you upgraded to 4.0.1 as it has a lot of
> security fixes as well as bug fixes in it.
>
> Thanks
> Tim
>
>
> On 3 February 2011 12:07, Tim Schofield <tim@...> wrote:
>> On 3 February 2011 09:03, Julie Saville <juliesav@...> wrote:
>>> 2.       I had to redo quite a few orders late last year in a different
> currency and now am trying to cancel the old original orders – following is
> the message that I get
>>>
>>>
>>>
>>> Fatal error: Undefined class constant 'STATUS_CANCELLED' in
> /home/saveur/public_html/accounts/PO_Header.php on line 361.
>>>
>>
>> Hi Julie,
>> What version of webERP are you using? This appears to be fine in
>> 3.11.4 and in 4.0.1. Are there any customisations on your system?
>>
>> Lines 7-14 of includes/DefinePOClass.php should be:
>>
>> Class PurchOrder {
>>        const STATUS_NEW_ORDER  = 'New Order';
>>        const STATUS_PENDING    = 'Pending';
>>        const STATUS_AUTHORISED = 'Authorised';
>>        const STATUS_REJECTED   = 'Rejected';
>>        const STATUS_CANCELLED  = 'Cancelled';
>>        const STATUS_PRINTED    = 'Printed';
>>        const STATUS_COMPLITED  = 'Completed';
>>
>> is this what they are on your system?
>>
>> Thanks
>> Tim
>>
>>
>> --
>> WebERP Africa Ltd
>> +447710427049
>> +256752963327
>> +255784602561
>> www.weberpafrica.com
>>
>
>
>
> --
> WebERP Africa Ltd
> +447710427049
> +256752963327
> +255784602561
> www.weberpafrica.com
>
> ----------------------------------------------------------------------------
> --
> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> Finally, a world-class log management solution at an even better price-free!
> Download using promo code Free_Logger_4_Dev2Dev. Offer expires
> February 28th, so secure your free ArcSight Logger TODAY!
> http://p.sf.net/sfu/arcsight-sfd2d
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>
> ------------------------------------------------------------------------------
> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> Finally, a world-class log management solution at an even better price-free!
> Download using promo code Free_Logger_4_Dev2Dev. Offer expires
> February 28th, so secure your free ArcSight Logger TODAY!
> http://p.sf.net/sfu/arcsight-sfd2d
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>

--

-- 
WebERP Africa Ltd
+447710427049
+256752963327
+255784602561
www.weberpafrica.com

------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
ExsonQu | 7 Feb 17:16 2011
Picon

Re: database corrupt after update to v4.00RC1


Hi, Heinrich:

     
       Sorry for my rush to reply, it's a little late here.  Just for your
reference:

      error 1: It seems that there is no factorcompany whose id is 1, please
check it.

      error 2: Have you try other mail format?such as soltec <at> soltec.com? It
maybe a bug. Let me find some time to check it tommorrow.

      BTW, please join the mail list, otherwise lots of users or developers
will not see your questions. You can register it here 
https://lists.sourceforge.net/lists/listinfo/web-erp-users
https://lists.sourceforge.net/lists/listinfo/web-erp-users 

      Best regards!

      Exson

Heinrich Steuber wrote:
> 
> I have upgraded from Version = '3.11.3'  to webERP v4.00RC1
> copied the old database to the new name,
> run the script:   upgrade3.11.1-4.00.sql as you so nicely instruct and now
> have a couple of errors, that are setting me back a bit:
> 
> 1. under http://.../Suppliers.php, when I try to add a new supplier :
>> Database Error : The supplier SL Steel Sales could not be added because
>> Cannot add or update a child row: a foreign key constraint fails
>> (`solacc2011`.`suppliers`, CONSTRAINT `suppliers_ibfk_4` FOREIGN KEY
>> (`factorcompanyid`) REFERENCES `factorcompanies` (`id`))
>> Database SQL Failure : The SQL that was used to insert the supplier but
>> failed was
>> INSERT INTO suppliers (supplierid, suppname, address1, address2,
>> address3, address4, telephone, fax, email, supptype, currcode,
>> suppliersince, paymentterms, bankpartics, bankref, bankact, remittance,
>> taxgroupid, factorcompanyid, lat, lng, taxref) VALUES ('SL01', 'SL Steel
>> Sales', 'Eadiestr 5', 'Windhoek', '', '', '+264 (81) 1283149', '', '',
>> '1', 'NAD', '2011-02-07', '30', '', '0', '', '1', '1', '0', '0', '0', '')
> 
> 2.    under http://.../SystemParameters.php, when I am trying to save the
> settings, even without any changes:
> 
>> ERROR Message Report : The Factory Manager Email address does not appear
>> to be valid
> the email address in question looks like this:     soltec <at> soltec.com.na
> 
> would it make sense to attach the sql-dump?
> 
> you help is very much appreciated &
> I do thank you in anticipation!
> Best regards!
> Heinrich
> 

--

-- 
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/database-corrupt-after-update-to-v4-00RC1-tp3264332p3264421.html
Sent from the web-erp-users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
The modern datacenter depends on network connectivity to access resources
and provide services. The best practices for maximizing a physical server's
connectivity to a physical network are well understood - see how these
rules translate into the virtual world? 
http://p.sf.net/sfu/oracle-sfdevnlfb
_______________________________________________
web-ERP-users mailing list
web-ERP-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/web-erp-users
ExsonQu | 7 Feb 17:21 2011
Picon

Re: database corrupt after update to v4.00RC1


and more, I'm not sure if you've already followed this instruction:

       http://www.weberp.org/HowToupgrade http://www.weberp.org/HowToupgrade 

Best regards!

Exson
--

-- 
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/database-corrupt-after-update-to-v4-00RC1-tp3264332p3264432.html
Sent from the web-erp-users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
The modern datacenter depends on network connectivity to access resources
and provide services. The best practices for maximizing a physical server's
connectivity to a physical network are well understood - see how these
rules translate into the virtual world? 
http://p.sf.net/sfu/oracle-sfdevnlfb

Gmane