web-erp-users — User general webERP discussion list

Re: [webERP-users] Report Builder not working

[rfthomas <rf...@as...>]

Than-you for the workaround.  It did work more reasonably in earlier releases
of weberp.  I don't have multiple versions installed so it is difficult to
determine when this function broke.

Bob



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Report-Builder-not-working-tp4658540p4658554.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Report Builder not working

[R2-G <r2g...@gm...>]

Hi,

Am using WebERP 4.12.3  report builder and noticed the same issue of
inability to select fields at the 
*Report/Form - Field Setup*

I had to click on the empty field where the fields should appear and
manually key in the required field and it worked
fine. before I could do the same by just double clicking the required field
from the selection box that appears.


Hope this helps


R2-g






--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Report-Builder-not-working-tp4658540p4658552.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

[webERP-users] Cheque Number not being stored in GLTRANS table

[R2-G <r2g...@gm...>]

Hi,

Am using webERP 4.12.3 on a system that has been live and working well since
December 2013 
I have just discovered that the system has all along not been storing cheque
numbers in the *gltrans*
table *chequeno* field. Upon looking at the *gltrans* table via phpmyadmin,
the chequeno field is 0 for
all transactions even though the user has always entered cheque numbers for
all payments made 
via  *Bank Account Payments Entry* and *Enter a Payment to, or Receipt from
the Supplier*.

I searched this list and the forum and found other post regarding this same
issue but no solutions to the problem

Any ideas on how to solve this will be greatly appreciated 

Thanks in advance


R2-G

   



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Cheque-Number-not-being-stored-in-GLTRANS-table-tp4658551.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Problem with my first Credit

[<ph...@lo...>]

Hi Terry

Have you got a tax category for Freight set up?
Sadly this is a limitiation and was hard coded...

Phil

On 2016-03-08 17:15, Terry Porter wrote:
> Database Error 1452 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
> ASSISTANCE: The debtor transaction taxes records could not be inserted
> because
> Cannot add or update a child row: a foreign key constraint fails
> (`expert_wifi`.`debtortranstaxes`, CONSTRAINT
> `debtortranstaxes_ibfk_1` FOREIGN KEY (`taxauthid`) REFERENCES
> `taxauthorities` (`taxid`))
> DATABASE SQL FAILURE : The following SQL to insert the debtor
> transaction taxes record was used
> INSERT INTO debtortranstaxes( debtortransid, taxauthid, taxamount)
> VALUES('349', '', '0')
> 
> DATABASE ROLLBACK DUE TO ERROR ABOVE : Rolling Back Transaction OK
> 
> webERP version 4.12.3
> 
> I was trying to credit a invoice (my first ever credit attempt) using
> the shipping cost credit entry. I get the same error if I try and
> credit using a Item line.
> 
> Anyone have any advice ?
> 
> --
> 
> Best Regards
> Terry Porter <te...@tj...>
> 
>  [1]
> 
> Links:
> ------
> [1] http://expert-wifi.com
> 
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140
> 
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users

[webERP-users] Problem with my first Credit

[Terry P. <te...@tj...>]

*Database Error 1452* : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
ASSISTANCE: The debtor transaction taxes records could not be inserted
because
Cannot add or update a child row: a foreign key constraint fails
(`expert_wifi`.`debtortranstaxes`, CONSTRAINT `debtortranstaxes_ibfk_1`
FOREIGN KEY (`taxauthid`) REFERENCES `taxauthorities` (`taxid`))
*Database SQL Failure* : The following SQL to insert the debtor transaction
taxes record was used
INSERT INTO debtortranstaxes( debtortransid, taxauthid, taxamount)
VALUES('349', '', '0')
*Database Rollback Due to Error Above* : Rolling Back Transaction OK



webERP version 4.12.3

I was trying to credit a invoice (my first ever credit attempt) using the
shipping cost credit entry. I get the same error if I try and credit using
a Item line.

Anyone have any advice ?


-- 
Best Regards
Terry Porter <te...@tj...>



<http://expert-wifi.com>

Re: [webERP-users] Report Builder not working

[ExsonQu <hex...@gm...>]

*Hi, Bob,*
              It's not broken. You have to select it with another method. I
think a remark should be added to this screen. But I've forgot it now. 
              Best regards!

              Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Report-Builder-not-working-tp4658540p4658544.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Problems with Credit Notes

[ExsonQu <hex...@gm...>]

*Hi, Bob,*
                 I've received it.  I have a rough check but still not pin
out the problem. I'll reply to you when I get this result this week.

                Thanks and best regards!

                Exson
                 
                 



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Problems-with-Credit-Notes-tp4658527p4658543.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

[webERP-users] Report Builder not working

[rfthomas <rf...@as...>]

We had written several reports in earlier versions of webERP that no longer
function in V4.12.3  The problem range from inifinte loops in the Apache
Webserver implying a problem in the php code or loops in the database
queries (I/O and CPU cycles in MYSQL) or I/O buffer overflows.

Not all reports are failing.

Assuming that there were issues with the reports, we attempted to write some
new reports using the report builder.  We can only get to screen where
fields are selected for display.  At that point a popup box is displayed
from which a field may be selected.  The pop up is placed in an unusual
location and we can't get any field selected.  Basically the Report Builder
is broken.

Is this problem unique to us?

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Report-Builder-not-working-tp4658540.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Problems with Credit Notes

[rfthomas <rf...@as...>]

Exson,

Did you receive the database?

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Problems-with-Credit-Notes-tp4658527p4658539.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Problems with Credit Notes

[ExsonQu <hex...@gm...>]

*Hi, Bob,*

           I'll contact you when I return back to my office at later of this
week.

          Best regards!

         Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Problems-with-Credit-Notes-tp4658527p4658531.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Problems with Credit Notes

[rfthomas <rf...@as...>]

Exson,

We receive no error messages when we invoice the customer.  We have been
using webERP for a number of years and the software has been upgraded with
each formal release.  What should we check to see if there is a problem with
the database?

I can supply a copy of our database and and example for testing.

Thank you,
Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Problems-with-Credit-Notes-tp4658527p4658529.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Problems with Credit Notes

[ExsonQu <hex...@gm...>]

*Hi, Bob,*

                It seems like a tax parameters setting problem. Is any error
messages appeared when you issue a invoice?
                Best regards!

                Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Problems-with-Credit-Notes-tp4658527p4658528.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

[webERP-users] Problems with Credit Notes

[rfthomas <rf...@as...>]

We have run into a number of problems attempting to handle customer returns
via credit notes.

1) In SelectCreditItems.php on the initial screen in the "Enter text in the
customer name:" field the first time entry always fails to find the
customer.  After the screen repaints (second entry) being passed:

SelectCreditItems.php?identifier=1456418363

in the URL, the customer search works finding the entered customer.

2) If in the screen displaying the details we press update, the following is
displayed:

Warning: Creating default object from empty value in
/ast$www/000000/weberp/SelectCreditItems.php on line 574

Warning: Creating default object from empty value in
/ast$www/000000/weberp/SelectCreditItems.php on line 598

when after pressing update, we press "process credit note" the following
error message is displayed:

Database Error 1062 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
ASSISTANCE: Taxes and rates applicable to this credit note line item could
not be inserted because
Duplicate entry '6170-0' for key 'PRIMARY'
Database SQL Failure : The following SQL to insert the stock movement tax
detail records was used
INSERT INTO stockmovestaxes (stkmoveno, taxauthid, taxrate,
taxcalculationorder, taxontax) VALUES ('6170', '', '0', '', '')
Database Rollback Due to Error Above : Rolling Back Transaction OK

4) If instead or pressing update, we just press "process credit note" the
credit note is created but the following messages are displayed:

Warning: Creating default object from empty value in
/ast$www/000000/weberp/SelectCreditItems.php on line 574

Warning: Creating default object from empty value in
/ast$www/000000/weberp/SelectCreditItems.php on line 598

We are running 4.12.3

Any help correcting these issues would be appreciated.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Problems-with-Credit-Notes-tp4658527.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

[webERP-users] How to right justify numbers in report builder tool

[Arwan <r1g...@gm...>]

Hi,

Am using WebERP 4.12.3 to create report a report with the output defined as
below

<http://weberp-accounting.1478800.n4.nabble.com/file/n4658526/format.png> 

and the output I get is as below (numbers left justified)

<http://weberp-accounting.1478800.n4.nabble.com/file/n4658526/left-numbers.png> 

How can I format the output as below (numbers right justified)

<http://weberp-accounting.1478800.n4.nabble.com/file/n4658526/right-numbers.png> 

Thanks in advance


Arwan




-----
WebTech Resources
Nairobi Kenya
+254 724659244
Email  :in...@we...  
WEB  :weberp.co.ke

--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/How-to-right-justify-numbers-in-report-builder-tool-tp4658526.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

[webERP-users] can you give me the link or contact of few companies using this WEBERP,

[mab8913 <mab...@gm...>]

can you give me the link or contact of few companies using this WEBERP,
because i selected  WEBERP as my Final year project of bachelors degree , so
my supervisor is asking me the two or three specific companies using WEBERP,
i shall be very thankful to you.
waiting for response

Regards



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/can-you-give-me-the-link-or-contact-of-few-companies-using-this-WEBERP-tp4658511.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] for which type of companies WEBERP is suitable ?

[gilberto d. s. a. <gs...@gm...>]

make your testes on weberp.org on teste environment and use manual there
are lots a very useful informations there.

2016-02-17 18:35 GMT-02:00 muhammad Abdullah <mab...@gm...>:

> for which type of companies WEBERP is suitable ?  , i want to use this erp
> but i am in  doubt,, kindly give me suggestions
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>


-- 
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil

[webERP-users] for which type of companies WEBERP is suitable ?

[muhammad A. <mab...@gm...>]

for which type of companies WEBERP is suitable ?  , i want to use this erp
but i am in  doubt,, kindly give me suggestions

[webERP-users] Handling Asset purchased by company director with his own money

[Arwan <r1g...@gm...>]

Hi,

I would like to confirm or get a better solution for a situation where  a
director goes and purchases an asset for the company and pays with their own
money.

In the chart of accounts, there is a liability account* 2430 LOANS FROM
DIRECTORS*
this account is used to book transactions where  directors spend there own
money on behalf of the company. So the amount a director spends reflects as
a loan from the director.

There is a supplier named *GENERAL* that is used to book transactions with
different suppliers who are not needed to be created as individual suppliers
as they are only one-time suppliers.

For a situation where a director has gone and purchased a car for the
company and paid with their own money, this is how am handling it now:

1.   go to *MAIN-MENU → ASSET MANAGER  → ADD A NEW ASSET* and enter the
purchased cars details

2. go to *MAIN-MENU → PAYABLES → SELECT SUPPLIER → ENTER SUPPLIER INVOICE*
and click on the *FIXED ASSET* button, select the car from dropdown list and
enter the cost then *BACK TO INVOICE ENTRY*, then complete the invoice entry
for the supplier named *GENERAL*.

3.  go to  *MAIN-MENU → GENERAL LEDGER → JOURNAL ENTRY* and enter the
following journal for the cost of the car.

DEBIT    –  A/c 2100 ACCOUNTS PAYABLE 
CREDIT –  A/c 2430 LOANS FROM DIRECTORS

4. go to  *MAIN-MENU → PAYABLES → SELECT SUPPLIER → ENTER A SUPPLIERS CREDIT
NOTE* for the supplier named *GENERAL* for the cost of the car. This is to
remove the cost of the car from that supplier.

Is this a correct way to do it ? Is there a better way ?

Thanks in advance.

Arwan



-----
WebTech Resources
Nairobi Kenya
+254 724659244
Email  :in...@we...  
WEB  :weberp.co.ke

--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Handling-Asset-purchased-by-company-director-with-his-own-money-tp4658508.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

[webERP-users] Handling Asset purchased by director company with his own money

[Arwan <r1g...@gm...>]

Hi,

I would like to confirm or get a better solution for a situation where  a
director goes and purchases an asset for the company and pays with their own
money.

In the chart of accounts, there is a liability account* 2430 LOANS FROM
DIRECTORS*
this account is used to book transactions where  directors spend there own
money on behalf of the company. So the amount a director spends reflects as
a loan from the director.

There is a supplier named *GENERAL* that is used to book transactions with
different suppliers who are not needed to be created as individual suppliers
as they are only one-time suppliers.

For a situation where a director has gone and purchased a car for the
company and paid with their own money, this is how am handling it now:

1.   go to *MAIN-MENU → ASSET MANAGER  → ADD A NEW ASSET* and enter the
purchased cars details

2. go to *MAIN-MENU → PAYABLES → SELECT SUPPLIER → ENTER SUPPLIER INVOICE*
and click on the *FIXED ASSET* button, select the car from dropdown list and
enter the cost then *BACK TO INVOICE ENTRY*, then complete the invoice entry
for the supplier named *GENERAL*.

3.  go to  *MAIN-MENU → GENERAL LEDGER → JOURNAL ENTRY* and enter the
following journal for the cost of the car.

DEBIT    –  A/c 2100 ACCOUNTS PAYABLE 
CREDIT –  A/c 2430 LOANS FROM DIRECTORS

4. go to  *MAIN-MENU → PAYABLES → SELECT SUPPLIER → ENTER A SUPPLIERS CREDIT
NOTE* for the supplier named *GENERAL* for the cost of the car. This is to
remove the cost of the car from that supplier.

Is this a correct way to do it ? Is there a better way ?

Thanks in advance.

Arwan



-----
WebTech Resources
Nairobi Kenya
+254 724659244
Email  :in...@we...  
WEB  :weberp.co.ke

--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Handling-Asset-purchased-by-director-company-with-his-own-money-tp4658507.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Printing Sales Order Confirmation

[rfthomas <rf...@as...>]

We have made the following changes to enable printing a customer order
confirmation:

Edited SelectSalesOrder.php to add a Confirm column and option when viewing
outstanding sales orders.
Hacked existing scripts and provided new names:
PDFCustOrderConfPortrait.php is a new script that must be added to the
scripts table.
includes/PDFCustOrderConfPortraitPageHeader.inc

PDFCustOrderConfPortraitPageHeader.inc
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658496/PDFCustOrderConfPortraitPageHeader.inc>  
PDFCustOrderConfPortrait.php
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658496/PDFCustOrderConfPortrait.php>  
SelectSalesOrder.php
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658496/SelectSalesOrder.php>  

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Printing-Sales-Order-Confirmation-tp4658494p4658496.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

[webERP-users] Printing Sales Order Confirmation

[rfthomas <rf...@as...>]

We have very complicated sales orders and need to provide customers with a
confirmation of the sales orders especially to reflect customer requested
cahnges.  The quotation can be printed, but once it becomes a sales/customer
order the only options are to print the dispatch note or the invoice.

We need to be able to print the sales order as an option to "Outstanding
Sales Orders/Quotations".  It would appear that the changes would involve
the following scripts:

SelectSalesOrder.php
PDFQuotationPortrait.php
PDFQuotation.php

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Printing-Sales-Order-Confirmation-tp4658494.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Customer Order fails with SQL error if no sales price is set for item

[ExsonQu <hex...@gm...>]

*Hi, Bob,*

             I've checked it in webERP4.12.3 with a fresh installation.
There is no any strange problem found. Would you give more details?

             Thanks and best regards!

             Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Customer-Order-fails-with-SQL-error-if-no-sales-price-is-set-for-item-tp4658478p4658492.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Manually payment allocation from mysql

[ExsonQu <hex...@gm...>]

*Hi, Ronwong,*
      
                  The automatic allocation script is not suitable for your
case. It allocate the amount according to date sequence. And it is very
error prone to modify database manually. Your case need to revise the script
to add a page separator to find the specified invoice to allocated to. 
                  Thanks and best regards!

                  Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Manually-payment-allocation-from-mysql-tp4658481p4658490.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Manually payment allocation from mysql

[ronwong <ro...@rw...>]

My payments are same transaction. Let me take a look at the file. I am still on 4.09, I hope there is no change.

Basically I have a lot of payments that I was lazy to allocate, and now when I want to allocated I cant because the list exceeded a threshold... this is purely my server issue.

So if I have a payment RCP1234 say, and it should be against invoice 2345 for customer 123, is there is specific way to recognize the transactins and the specific fields to update or check off? I will check the file.

From: ExsonQu [via webERP accounting] [mailto:ml-...@n4...]
Sent: Wednesday, 3 February 2016 8:53 AM
To: Ronald Wong <ro...@rw...>
Subject: Re: Manually payment allocation from mysql

Hi, Ronwong,

             It's is a little difficult to explain in short.
             It'll update the debtortrans table, custallocns,gltrans if different currency involved.
             It's a new relation build between data(different transaction) in debtortrans table and it is recorded in custallocns. Phil has provided an Z_AutoCustomerAllocations.php before.
            I've attached here you can check if it is solved you problem.

            Thanks and best regards!

            Exson
            Z_AutoCustomerAllocations.php<http://weberp-accounting.1478800.n4.nabble.com/file/n4658485/Z_AutoCustomerAllocations.php>
________________________________
If you reply to this email, your message will be added to the discussion below:
http://weberp-accounting.1478800.n4.nabble.com/Manually-payment-allocation-from-mysql-tp4658481p4658485.html
To unsubscribe from Manually payment allocation from mysql, click here<http://weberp-accounting.1478800.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658481&code=cm9uYWxkQHJ3cHJpbmNlLmNvbXw0NjU4NDgxfDE4NTY2Mzc3OTU=>.
NAML<http://weberp-accounting.1478800.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>




--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Manually-payment-allocation-from-mysql-tp4658481p4658487.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Customer Order fails with SQL error if no sales price is set for item

[ExsonQu <hex...@gm...>]

*Hi, Bob,*

            Thank you for your report!

             I'll check it today. 

            Thanks and best regards!

            Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Customer-Order-fails-with-SQL-error-if-no-sales-price-is-set-for-item-tp4658478p4658486.html
Sent from the web-ERP-users mailing list archive at Nabble.com.