web-erp-users — User general webERP discussion list

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

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

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>  



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

[webERP-users] Manually payment allocation from mysql

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

I would like to ask, when we do payment allocation from payment to customer
invoices, which are the tables being updated and how?
Because I am having a suhosin issue with my server, and the system does not
allow me to have more than 256 lines in forms or something, so I have
outstanding payments that I cannot allocate in the front end interface. 



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

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

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

Customer order items can not be entered if no sales price has been
established for a quick entry.  An SQL is displayed instead of a reasonable
error message or a warning and using a sales price of 0.0.  The SQL places
nothing for the price, just ,,  This is in 4.12.3, but probably occurs in
all versions.

Bob Thomas

P.S.: We were in rush, we didn't get a screen capture, but entered a sales
price for the item so that we could get the rush shipment out.



--
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-tp4658478.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Counter Sales

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

*Hi, *
           Please register before you post your email. Otherwise, the people
who would like to reply may miss your messages. 

           You should go to the setup module, and click Inventory Locations
Maintenance, then select your location (you can check it in the users
maintenance interface), then select the customer which you'll used as
counter sales customer.  Key in the customer's code and its branch code to
the Default Counter Sales Customer Code field and Counter Sales Branch Code
field. 

            After this setting. Then you make it work smoothly. 

               Best regards!

               Exson

shabbir wrote
> when i open Counter this error become
> ERROR Message Report : To use this script it is first necessary to define
> a cash sales customer for the location that is your default location. The
> default cash sale customer is defined under set up ->Inventory Locations
> Maintenance. The customer should be entered using the customer code and a
> valid branch code of the customer entered.
> what i do please explain in detail.. as soon as possible





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

Re: [webERP-users] Serial Numbers file upload problem with WebERP 4.11.3

[<hi...@ma...>]

Dear Partner



Mr. Hidayat is no longer join us, please contact af...@wi... for further reference.





best regards,



Management

Re: [webERP-users] Serial Numbers file upload problem with WebERP 4.12.3

[<hi...@ma...>]

Dear Partner



Mr. Hidayat is no longer join us, please contact af...@wi... for further reference.





best regards,



Management

Re: [webERP-users] Serial Numbers file upload problem with WebERP 4.12.3

[<hi...@ma...>]

Dear Partner



Mr. Hidayat is no longer join us, please contact af...@wi... for further reference.





best regards,



Management

Re: [webERP-users] Serial Numbers file upload problem with WebERP 4.12.3

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

Hi, Exson,

Thanks, you are right

its now uploading serial numbers from CSV OK 

It seems the  $rootpath was the problem, specifically the setting of the
*reports_dir*  parameter in the CONFIG table 
I moved from my old ISP to godaddy and the *reports_dir*  parameter in the
CONFIG table still contained the *database prefix*
from my old ISP. Thats why *move_uploaded_file() *function failed and
returned the error message.

Thanks Again 



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/Serial-Numbers-file-upload-problem-with-WebERP-4-12-3-tp4658471p4658473.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Serial Numbers file upload problem with WebERP 4.12.3

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

*Hi, Arwan,*

                   Is you variable $rootpath in your config.php file changed
to $RootPath?

                   Thanks and best regards!

                  Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Serial-Numbers-file-upload-problem-with-WebERP-4-12-3-tp4658471p4658472.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

[webERP-users] Serial Numbers file upload problem with WebERP 4.11.3

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

Hi 

Am having a serial numbers file upload problem with WebERP 4.12.3 that I
have just upgraded from WebERP 4.11.3

The serial numbers CSV file upload procedure while receiving a purchase
order works fine in WebERP 4.11.3  but fails in  version 4.11.3 with the
error message

*ERROR Message Report : Error moving temporary file. Please check your
configuration*

I searched the forum and found 
http://weberp-accounting.1478800.n4.nabble.com/Stock-Serial-Number-error-td3555753.html
<http://weberp-accounting.1478800.n4.nabble.com/Stock-Serial-Number-error-td3555753.html>  

Which is the exact same issue am having and Phil responds as below:

/Hi Jorrie,
I have figured out the error in this script and have updated in SVN -
you can download the latest with fix in it by browsing the svn getting
the file includes/InputSerialItemsFile.php
Phil 
/
The file *includes/InputSerialItemsFile.php* in version *4.12.3* is
identical to the one in in *4.11.3 * according to an online diff I used.

InputSerialItemsFile.php LINE 108 below is the condition that fails

if
(!move_uploaded_file($_FILES['ImportFile']['tmp_name'],$_SESSION['CurImportFile']['tmp_name']))


any Help greatly appreciated 


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/Serial-Numbers-file-upload-problem-with-WebERP-4-11-3-tp4658471.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] best practice for paying salary staff and subcontractor labour?

[<hi...@ma...>]

Dear Partner



Mr. Hidayat is no longer join us, please contact af...@wi... for further reference.





best regards,



Management

Re: [webERP-users] best practice for paying salary staff and subcontractor labour?

[<hi...@ma...>]

Dear Partner



Mr. Hidayat is no longer join us, please contact af...@wi... for further reference.





best regards,



Management

Re: [webERP-users] best practice for paying salary staff and subcontractor labour?

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

*Hi, Adam,*

             There are no HR labor module in webERP currently. And there is
no such kind of add-on in my opinion.

             Thanks and best regards!

             Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Shipping-Address-Label-printing-tp4658444p4658466.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

[webERP-users] best practice for paying salary staff and subcontractor labour?

[<ad...@mo...>]

hello,

is there a best practice for paying salary staff and subcontractor labour?

I see a lot of references to additional modules and such; but I am very 
curious to know if the group has a recommended add-on to deal with 
employees and subcontractors in general

cheers,

Adam

Re: [webERP-users] is there a manual on one page?

[Andrew C. <an...@co...>]

There is a PDF manual on Sourceforge:

http://sourceforge.net/projects/web-erp/files/?source=navbar

Andy.

-----Original Message-----
From: ad...@mo... [mailto:ad...@mo...] 
Sent: 08 January 2016 18:29
To: For the general discussion of webERP project
<web...@li...>
Subject: [webERP-users] is there a manual on one page?

http://www.weberp.org/weberp/doc/Manual/ManualContents.php

it references Display Checked to view on one page

but I have no checkboxes
is there some other link for everything on one page?




----------------------------------------------------------------------------
--
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=267308311&iu=/4140
_______________________________________________
web-ERP-users mailing list
web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-users


-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2016.0.7294 / Virus Database: 4489/11355 - Release Date: 01/08/16

Re: [webERP-users] is there a manual on one page?

[<hi...@ma...>]

Dear Partner



Mr. Hidayat is no longer join us, please contact af...@wi... for further reference.





best regards,



Management

[webERP-users] is there a manual on one page?

[<ad...@mo...>]

http://www.weberp.org/weberp/doc/Manual/ManualContents.php

it references Display Checked to view on one page

but I have no checkboxes
is there some other link for everything on one page?

Re: [webERP-users] Error Message when crediting Invoice with credit_invoice.php

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

Now OK

I found the solution on below link

http://www.weberp.org/forum/showthread.p...uthorities

jhm12698
RE: Credit_Invoice.php Issue
I somewhat figured out the problem. The calculationorder in the
taxgrouptaxes was set to 0. Even when I went into TaxGroups.php and updated
the order as 1 it stayed at zero in the table. Once I added another Assigned
Tax Group, updated the order and then deleted one did it set the
calculationorder to 1. Having an order of 0 doesn't appear to affect
creating an invoice but does when creating a credit. 



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Error-Message-when-crediting-Invoice-with-credit-invoice-php-tp4658446p4658449.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Error Message when crediting Invoice with credit_invoice.php

[<hi...@ma...>]

Dear Partner



Mr. Hidayat is no longer join us, please contact af...@wi... for further reference.





best regards,



Management

Re: [webERP-users] Error Message when crediting Invoice with credit_invoice.php

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

more info...

Crediting the same invoice on the old 4.11.3 version works OK 



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Error-Message-when-crediting-Invoice-with-credit-invoice-php-tp4658446p4658447.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

[webERP-users] Error Message when crediting Invoice with credit_invoice.php

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

Am using WebERP 4.12.3 which I have just upgraded from 4.11.3 just days ago

when trying to credit an invoice that was created before the upgrade was
done I get

the following error massage

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
(`simpliu8_snke`.`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*('1301', '', '-26336')*
Database Rollback Due to Error Above : Rolling Back Transaction OK

in the insert statement, the value for taxauthid is empty which seem to be
the cause of the problem

INSERT INTO debtortranstaxes( debtortransid, taxauthid, taxamount)
VALUES*('1301', '', '-26336')*

How can I rectify this ?

Thanks in advance


R2-g





--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Error-Message-when-crediting-Invoice-with-credit-invoice-php-tp4658446.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Shipping Address Label printing

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

Hi, Terry,

          Thank you for sharing!

          Best regards!
 
          Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Shipping-Address-Label-printing-tp4658444p4658445.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

[webERP-users] Shipping Address Label printing

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

Hi Phil, and All,

Some time ago, I made up a  program to print shipping address labels from
the webERP database (to suit my own needs). My blog of the process is
located at my advert/junk free website below for anyone who is interested:-

http://portertech.org/bb/viewtopic.php?f=22&t=52&p=58&sid=45ac99604ad3706ba2eee338527dc22a#p58

This post is only to mention that I have altered it slightly  to use the
customer postal address if the street address is not to be used for
shipping:-

Note, my program is written in Perl and requires Unix admin level skills to
deploy, so it's not for everyone, however its licensed under the GPL, and
is freely downloadable.

Summary of how to use the program

   - configure five items in the config section at the top of "
   find-client-shipping-details.pl". These are the details of your Mysql
   database and working directory etc.
   - run "find-client-shipping-details.pl" in a xterm
   - enter the Customer Branch ID number when asked
   - "find-client-shipping-details.pl" then queries your WebERP Mysql
   database using the Customer Branch ID number and fetches the customer name,
   phone number address data etc. It does this read-only and doesn't affect
   the integrity of your database
   - the details will be printed on the xterm
   - A Lyx window will pop up, click the icon with two large eyeballs
   (print preview), then a XPDF (or your default PDF viewer) window will open
   and display what the printed sheet will look like, if it's correct, click
   print and your shipping sddress label will then be printed ready for you
   attach to your customer shipment carton etc.
   - Note 1: all customer shipping data is converted to CAPS for printing
   clarity
   - Note 2: in the webERP "Add/Modify/Delete Customer Branches" menu,
   there are two address entry areas, 1) Street Address and 2) Postal Address.
   If Postal Address 1 has data then Postal Address 1 - Postal Address 5
   fields are used, if not, then Street Address 1 - Street Address 5 are used
   in the printed label. This is because if your customer doesn't want goods
   shipped to his street address, then he will want it shipped to his postal
   address instead. It will be one or the other


Cheers
Terry

<http://expert-wifi.com>

[webERP-users] REMOVE ME!

[Department <acc...@hi...>]

Re: [webERP-users] Enter a partial Phone Number problem

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

Hi Exson,
Awesome, that fixed the problem, many thanks for the speedy resolution,
much appreciated :)

Cheers
Terry

On Wed, Dec 9, 2015 at 6:40 PM, ExsonQu <hex...@gm...> wrote:

> *Hi, Terry,*
>
>
>              Thank you for your report!
>
>              It's a bug due to an extra blank space. I've fixed in the
> trunk. You can download the file attached.
>
>             Thanks and best regards!
>
>             Exson
>              SelectCustomer.zip
> <
> http://weberp-accounting.1478800.n4.nabble.com/file/n4658441/SelectCustomer.zip
> >
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Enter-a-partial-Phone-Number-problem-tp4658440p4658441.html
> Sent from the web-ERP-users mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>