For the general discussion of webERP project

ExsonQu | 1 Nov 2010 02:45

Re: webERP4.0 installation problems on windows


Hi, Opto:

            Did you install it from ver 4.0 or upgrade from other version?

            If it's a fresh install, try not to install demo.

            Best regards!

            Exson
--

-- 
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP4-0-installation-problems-on-windows-tp3021096p3021664.html
Sent from the web-erp-users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev

headers

Phil Daintree | 1 Nov 2010 07:40

Re: webERP v3.12 adding account group

This was only when I thought we had a number of different functions all 
doing the same thing ... maybe not quite - my bad

Phil

On 01/11/10 02:43, Tim Schofield wrote:
> Hi Don,
>
> The check uses a function called ContainsIllegalCharacters(). The
> check for spaces was added into this function for the contracts work,
> however it of course affects accounts groups as well which was why I
> suggested perhaps we change the way the check is done in that script.
>
> Thanks
> Tim
>
>
> On 31 October 2010 14:21, Don<don@...>  wrote:
>> Hi Exson,
>>
>> If there was a safety risk with spaces, wouldn't it affect the current
>> entries with spaces?
>>
>> BTW: my bad, I took the version number from the bottom of the screen, I
>> am working with 4.00 rc1.
>>
>> Don
>>
>> On 10/31/2010 05:47 AM, ExsonQu wrote:
>>>

(Continue reading)

headers

regproltd | 1 Nov 2010 12:54

Re: webERP4.0 installation problems on windows

Hi exson
I too got problems which somehow seems solved in windows however each new attempt on my test pc I deleted the
weberp and weberp demo dbs in the sqlyog and the weberp folders in the htdocs of apache (www in easyphp5.2)
so the installation page would come up.
It finally worked when I dlded the most recent 3.11.4 and 4.0 from sourceforge then installed the 3 which
loaded only the demo tables not the weberp.
I had looked at the files b4 install and saw a z_upgrade3.11 to 3.12 and the version at the logo after install
said 3.12 so I assume this script ran.
Tim advised that we comment off line 374 in install save and then it installed on (note install gave error
then followed tim's advice then install page came up again and it worked.
>From what I saw, no new table was added and used the same demo from the 3.12
I am going to try on another standalone pc mon or tue and will report.
I really hope this helps

Russell
Sent from my BlackBerry® device from Digicel

-----Original Message-----
From: ExsonQu <hexinfans@...>
Date: Sun, 31 Oct 2010 18:45:19 
To: <web-erp-users@...>
Reply-To: For the general discussion of webERP project
	<web-erp-users@...>
Subject: Re: [webERP-users] webERP4.0 installation problems on windows

Hi, Opto:

            Did you install it from ver 4.0 or upgrade from other version?

            If it's a fresh install, try not to install demo.

(Continue reading)

headers

ExsonQu | 1 Nov 2010 14:22

Re: webERP4.0 installation problems on windows


Hi, Russell:

          I've installed RC4.0 in win7 with AppServ. There is nothing wrong.
Everything goes well during installation.

          What I did just do NOT check the demo database. Since I've
installed this version before, I encountered same problem as what you said. 

          What I've learned from previous installation is to leave the jpg
logo as is. Do not add a logo to the system. Since the scripts will add one
itself if we do not specify one.

          Best regards!

          Exson

          
--

-- 
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP4-0-installation-problems-on-windows-tp3021096p3022130.html
Sent from the web-erp-users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev

headers

Stuart Sheldon | 1 Nov 2010 17:20

Re: Email Invoice Broken?


Hi Exson,

Well, Any attempt to generate a PDF results in:

FPDF error: Unable to find pointer to xref table

Let me know what further tests you would like to see us try.

Stu

On 10/31/2010 04:17 PM, ExsonQu wrote:
> 
> Hi, Stu:
> 
>              I think the bug has been fixed.  Please check the attached
> file.
> 
>             Best regards!
> 
>             Exson 
> http://weberp-accounting.1478800.n4.nabble.com/file/n3021585/PrintCustTransPortrait.php
> PrintCustTransPortrait.php 
> 
>  

--

-- 
Every year is getting shorter, never seem to find the time
Plans that either come to naught or half a page of scribbled lines
Hanging on in quiet desperation is the english way

(Continue reading)

headers

Phil Daintree | 1 Nov 2010 21:50

Re: Email Invoice Broken?

Hi Stu

You got me confused - if you are using 4.0rc1 then an FPDF error should not be possible as FPDF is no longer
installed with wbeERP. Are you sure it is not a TCPDF error the new pdf (utf-8 capable) class we are using? Or
perhaps you are using an old version?

Phil

Phil Daintree
Logic Works Ltd - 0275 567890

-----Original Message-----
From: Stuart Sheldon <stu@...>
Date: Mon, 01 Nov 2010 09:20:01 
To: For the general discussion of webERP project<web-erp-users@...>
Reply-To: For the general discussion of webERP project
	<web-erp-users@...>
Subject: Re: [webERP-users] Email Invoice Broken?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Hi Exson,

Well, Any attempt to generate a PDF results in:

FPDF error: Unable to find pointer to xref table

Let me know what further tests you would like to see us try.

(Continue reading)

headers

ExsonQu | 2 Nov 2010 00:29

Re: Email Invoice Broken?


Hi, Phil:

          There is a bug in 3.11.4 for mailing customer invoice. I'm trying
to fix it.

          Best regards!

          Exson
--

-- 
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Email-Invoice-Broken-tp2994541p3022974.html
Sent from the web-erp-users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev

headers

ExsonQu | 2 Nov 2010 00:40

Re: Email Invoice Broken?


Hi, Stu:

            It seems that the pdf report was not founded. 

           Would you like to try to go to Setup ---> Configuration
Setting---->The directory where reports are stored: pdf_append.

          And I'm not sure if you have other pdf files except invoice to
attach. Since I have not such kinds of file in my system, so I didn't revise
this part of scripts and no test for it. 

          Hope it's helpful!

          Best regards!

          Exson
--

-- 
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Email-Invoice-Broken-tp2994541p3022983.html
Sent from the web-erp-users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev

headers

Poul Bjerre-Jensen | 3 Nov 2010 20:01

(no subject)

I really like the upgrades in v4. Are there any plans to include minimum order quantity in the purchasing
data? 

Poul 
Sent from my iPad
------------------------------------------------------------------------------
Achieve Improved Network Security with IP and DNS Reputation.
Defend against bad network traffic, including botnets, malware, 
phishing sites, and compromised hosts - saving your company time, 
money, and embarrassment.   Learn More! 
http://p.sf.net/sfu/hpdev2dev-nov

headers

RL | 3 Nov 2010 22:44

AgedDebtors.php

Hello you guys, I noticed that if I enter a invoice lets say 100usd and a deposit of 100usd fro customer001 but I do not assign it, why is that when I run the AgedDebtors.php page I don't see those records, as far as I understand while those records are not assigned it should be in that report.

I belive is on this query:
SELECT debtorsmaster.debtorno,
                    debtorsmaster.name,
                    currencies.currency,
                    paymentterms.terms,
                    debtorsmaster.creditlimit,
                    holdreasons.dissallowinvoices,
                    holdreasons.reasondescription,
            SUM(debtortrans.ovamount +
                debtortrans.ovgst +
                debtortrans.ovfreight +
                debtortrans.ovdiscount -
                debtortrans.alloc) AS balance,
            SUM(
                CASE WHEN (paymentterms.daysbeforedue > 0)
                    THEN
                        CASE WHEN TO_DAYS(Now()) - TO_DAYS(debtortrans.trandate) >= paymentterms.daysbeforedue
                        THEN debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount - debtortrans.alloc
                        ELSE 0 END
                    ELSE
                        CASE WHEN (TO_DAYS(Now()) - TO_DAYS(DATE_ADD(DATE_ADD(debtortrans.trandate," . INTERVAL('1', 'MONTH') . ")," . INTERVAL('(paymentterms.dayinfollowingmonth - DAYOFMONTH(debtortrans.trandate))', 'DAY') . ")) >= 0)
                        THEN debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount - debtortrans.alloc
                        ELSE 0 END
                END
            ) AS due,
            SUM(
                CASE WHEN (paymentterms.daysbeforedue > 0)
                    THEN
                        CASE WHEN TO_DAYS(Now()) - TO_DAYS(debtortrans.trandate) > paymentterms.daysbeforedue
                        AND TO_DAYS(Now()) - TO_DAYS(debtortrans.trandate) >= (paymentterms.daysbeforedue + " . $_SESSION['PastDueDays1'] . ")
                        THEN debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount - debtortrans.alloc ELSE 0 END
                    ELSE
                        CASE WHEN (TO_DAYS(Now()) - TO_DAYS(DATE_ADD(DATE_ADD(debtortrans.trandate, " . INTERVAL('1', 'MONTH') . "), " . INTERVAL('(paymentterms.dayinfollowingmonth - DAYOFMONTH(debtortrans.trandate))', 'DAY') . ")) >= " . $_SESSION['PastDueDays1'] . ")
                        THEN debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount - debtortrans.alloc
                    ELSE 0 END
                END
            ) AS overdue1,
            SUM(
                CASE WHEN (paymentterms.daysbeforedue > 0)
                    THEN
                        CASE WHEN TO_DAYS(Now()) - TO_DAYS(debtortrans.trandate) > paymentterms.daysbeforedue
                        AND TO_DAYS(Now()) - TO_DAYS(debtortrans.trandate) >= (paymentterms.daysbeforedue + " . $_SESSION['PastDueDays2'] . ")
                        THEN debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount - debtortrans.alloc
                        ELSE 0 END
                    ELSE
                        CASE WHEN (TO_DAYS(Now()) - TO_DAYS(DATE_ADD(DATE_ADD(debtortrans.trandate, " . INTERVAL('1', 'MONTH') . "), " . INTERVAL('(paymentterms.dayinfollowingmonth - DAYOFMONTH(debtortrans.trandate))', 'DAY') . ")) >= ".$_SESSION['PastDueDays2'] . ")
                        THEN debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount - debtortrans.alloc
                    ELSE 0 END
                END
            ) AS overdue2
        FROM debtorsmaster,
        paymentterms,
        holdreasons,
        currencies,
        debtortrans
        WHERE debtorsmaster.paymentterms = paymentterms.termsindicator
        AND debtorsmaster.currcode = currencies.currabrev
        AND debtorsmaster.holdreason = holdreasons.reasoncode
        AND debtorsmaster.debtorno = debtortrans.debtorno
        AND holdreasons.dissallowinvoices=1
        AND debtorsmaster.debtorno >= '" . $_POST['FromCriteria'] . "'
        AND debtorsmaster.debtorno <= '" . $_POST['ToCriteria'] . "'
        AND debtorsmaster.currcode ='" . $_POST['Currency'] . "'
        $SalesLimit
        GROUP BY debtorsmaster.debtorno,
        debtorsmaster.name,
        currencies.currency,
        paymentterms.terms,
        paymentterms.daysbeforedue,
        paymentterms.dayinfollowingmonth,
        debtorsmaster.creditlimit,
        holdreasons.dissallowinvoices,
        holdreasons.reasondescription
        HAVING Sum(
            debtortrans.ovamount +
            debtortrans.ovgst +
            debtortrans.ovfreight +
            debtortrans.ovdiscount -
            debtortrans.alloc
        ) <>0

specifically in the Having, any thoughts?

Best Regards

------------------------------------------------------------------------------
The Next 800 Companies to Lead America's Growth: New Video Whitepaper
David G. Thomson, author of the best-selling book "Blueprint to a 
Billion" shares his insights and actions to help propel your 
business during the next growth cycle. Listen Now!
http://p.sf.net/sfu/SAP-dev2dev

_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users

10	May 2013
25	April 2013
12	March 2013
13	February 2013
29	January 2013
49	December 2012
86	November 2012
47	October 2012
90	September 2012
64	August 2012
99	July 2012
72	June 2012
16	May 2012
81	April 2012
163	March 2012
154	February 2012
134	January 2012
169	December 2011
279	November 2011
99	October 2011
116	September 2011
181	August 2011
112	July 2011
109	June 2011
142	May 2011
140	April 2011
190	March 2011
146	February 2011
96	January 2011
63	December 2010
120	November 2010
90	October 2010
39	September 2010
75	August 2010
107	July 2010
237	June 2010
88	May 2010
131	April 2010
127	March 2010
76	February 2010
127	January 2010
207	December 2009
65	November 2009
74	October 2009
143	September 2009
144	August 2009
273	July 2009
159	June 2009
143	May 2009
245	April 2009
369	March 2009
218	February 2009
197	January 2009
89	December 2008
90	November 2008
160	October 2008
139	September 2008
149	August 2008
125	July 2008
110	June 2008
100	May 2008
73	April 2008
168	March 2008
67	February 2008
106	January 2008
23	December 2007
44	November 2007
113	October 2007

Mon	Tue	Wed	Thu	Fri	Sat	Sun

1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30