web-erp-users — User general webERP discussion list

Re: [webERP-users] Contracts Module

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

We would be pleased to help in refining this area.  There might be mechanisms
already existing webERP to handle some of the areas that are specific to
contracts/projects.

We will write up our thoughts with respect to projects.  We have
experimented with some project management software written in PHP that
mimics much of the functionality of MICROSOFT's PROJECT application.

One requirement is that we need to be able to ship material to the customer
creating packing slips and charging the items against the contract/project. 
Many of the items that we sell are serialized/lot numbered and we need to
track by serial/lot number.  Within the current webERP, we could possibly
set-up a customer that is the contract/project with the shipping information
being that of the customer.  Sales orders would then be created initially
outside the Contracts Module for the items and shipments/invoices made with
the charges being accrued against the contract/project.

The customer is not billed based on shipments but rather per the terms of
the contract.  We do understand how to accomplish such using webERP.

We have been experimenting with the Contract module and several of the
features described in the webERP Manual in the section Contract Costing do
not appear to have been implemented.  Specifically entering supplier
charges.

Bob Thomas



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

Re: [webERP-users] Contracts Module

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

Hi Bob,

There is no progress billing option.... what you can do is invoice 0.5 
for 50% of the contract and then 0.3 for 30% etc. The contract creation 
creates a unique item for the contract that is made up from all the 
components both stock and other stuff that is purchased for it.

I am thinking if someone is prepared to back me I would not mind getting 
stuck into beefing this contract area up quite a bit. I want to 
recongnise revenue on the basis of percentage completion, with project 
reviews and multi-stage projects with completion dates and inquiries 
from the project to see issues of materials and purchase orders etc. 
Invoicing that posts to progress billings and debtors and the turnover 
recognised on the basis of % completion doing the leg to DR progress 
billings and CR turnover.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 03/11/15 11:04, rfthomas wrote:
> We are trying to use the contracts module based on how we normally quote
> projects.
>
> We generally have a payment schedule, e.g. 50% with order, 30% upon delivery
> and 20% upon acceptance.  As part of the project there are items sold, that
> are manufactured in house or purchased and shipped to the customer.  We need
> to create shipping papers and track the shipments against the contract
> properly allocating costs to the contract.  Additionally, there is not a
> fixed markup on every item.  For some projects we must insure that the
> customer receives the previously negotiates prices for the hardware
> purchased.
>
> How can such be accomplished in webERP?  Possibly we do not understand the
> concept being used in the contracts sub-system.
>
>
> Bob Thomas
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Contracts-Module-tp4658378.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
>

[webERP-users] Contracts Module

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

We are trying to use the contracts module based on how we normally quote
projects.

We generally have a payment schedule, e.g. 50% with order, 30% upon delivery
and 20% upon acceptance.  As part of the project there are items sold, that
are manufactured in house or purchased and shipped to the customer.  We need
to create shipping papers and track the shipments against the contract
properly allocating costs to the contract.  Additionally, there is not a
fixed markup on every item.  For some projects we must insure that the
customer receives the previously negotiates prices for the hardware
purchased.

How can such be accomplished in webERP?  Possibly we do not understand the
concept being used in the contracts sub-system.


Bob Thomas



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

Re: [webERP-users] WebERP Purchase Invoice enquiry to Delivery NO. & MR

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

Hi! using general ledger query (
http://your-url-for-weberp/SupplierInquiry.php) and after choose what
purchase order number you want for see (
http://your-url-for-weberp/GLTransInquiry.php) you could see purchase order
number , grn number and all transactions about your inputs, payments,
outputs etc. SupplierInquiry.php presents all information about some vendor
transactions.
Please let all of us know if this solve your issue.

Regards.

2015-08-11 4:46 GMT-03:00 Steven Tang <st...@sh...>:

> Hi Phil,
>
> I would like to know if there is any way to check the Purchase Invoice
> of a supplier linked with which GRN?
>
> As I remember, I asked before there is no delivery note number for good
> receive.  I think this is can be only a field to store in a good
> received and have a checking with GRN.  And now we faced another
> question, is sometime supplier asked for payment for a shipment, but
> they asking with information of shipment date (and Delivery note), but
> not Invoices Number, so it is very difficult right now to "link-up".  Or
> we must check the paper record only.  We sure there is "linked" in work
> flow because when we input Purchase Invoice, we already ticked and
> checked with Good received.  Only don't know if there is recorded in any
> place.
>
> Hope this can be add in next version.  Thanks.
>
>
> Steven Tang (鄧兆文）
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> 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] WebERP Purchase Invoice enquiry to Delivery NO. & MR

[Steven T. <st...@sh...>]

Hi Phil,

I would like to know if there is any way to check the Purchase Invoice 
of a supplier linked with which GRN?

As I remember, I asked before there is no delivery note number for good 
receive.  I think this is can be only a field to store in a good 
received and have a checking with GRN.  And now we faced another 
question, is sometime supplier asked for payment for a shipment, but 
they asking with information of shipment date (and Delivery note), but 
not Invoices Number, so it is very difficult right now to "link-up".  Or 
we must check the paper record only.  We sure there is "linked" in work 
flow because when we input Purchase Invoice, we already ticked and 
checked with Good received.  Only don't know if there is recorded in any 
place.

Hope this can be add in next version.  Thanks.


Steven Tang (鄧兆文）

Re: [webERP-users] Ask : Rent Assets Inventory with depreciation.

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

There is no rental module

Phil
Phil Daintree
+64 (0)275 567 890

> On 13/07/2015, at 7:31 am, Michael K <mic...@gm...> wrote:
> 
> How to handle/record  an Assets movement that rent-able to customers in webERP?
> ------------------------------------------------------------------------------
> Don't Limit Your Business. Reach for the Cloud.
> GigeNET's Cloud Solutions provide you with the tools and support that
> you need to offload your IT needs and focus on growing your business.
> Configured For All Businesses. Start Your Cloud Today.
> https://www.gigenetcloud.com/
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users

[webERP-users] Ask : Rent Assets Inventory with depreciation.

[Michael K <mic...@gm...>]

How to handle/record  an Assets movement that rent-able to customers in
webERP?

Re: [webERP-users] Printing an invoice instead of a credit note

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

hi. this link need password. if possible reproduce your issue on weberp.org
or somewhere for we test and understand.

2015-06-29 14:41 GMT-03:00 jeff1c1 <jco...@le...>:

> Hello,
>
> When attempting to print a credit note from Customer Transaction Inquiries,
> I am getting a copy of the invoice with the same number and not the credit
> note. For example, the following link will print invoice 30 and not credit
> memo 30
>
> http://lelyvt.com/webERP/PrintCustTrans.php?FromTransNo=30&InvOrCredit=Invoice&PrintPDF=True
> .
>
> I recently upgraded to version 4.12.3 and was not having this issue prior.
> Any help will be greatly appreciated.
>
> Thank you
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Printing-an-invoice-instead-of-a-credit-note-tp4658292.html
> Sent from the web-ERP-users mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Don't Limit Your Business. Reach for the Cloud.
> GigeNET's Cloud Solutions provide you with the tools and support that
> you need to offload your IT needs and focus on growing your business.
> Configured For All Businesses. Start Your Cloud Today.
> https://www.gigenetcloud.com/
> _______________________________________________
> 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

Re: [webERP-users] WebERP for School Management

[Deepa <dee...@li...>]

Right OpenSIS is just Student Information System and if its integrated with webERP you will get a complete system to manage your school.

Both systems are developed using PHP and MySQL so integration of these systems produce a stable system. And futher it can be integrated
with Moodle for online learning as all these implemented in Apeejay School.

From: Vinit Jindal 
Sent: Saturday, July 04, 2015 9:56 AM
To: Deepa 
Cc: WebERP - Users 
Subject: Re: [webERP-users] WebERP for School Management


Thanks Deepa,

OpenSIS looks good except its weak on financial side.  We have a private school and if possible, we would like to maintain data on Fee Collection and School Expenses in a single system rather than having two separate systems.


On 03-Jul-2015, at 7:23 pm, Deepa <dee...@li...> wrote:

for school management you can use OpenSIS.


here is online demo
http://demo.opensis.com/opensis/

for more details, please have a look at http://infobizz.in

regards
Rajeev Singh Paweria
http://infobizz.in
rs...@in...

From: Adam Morand 
Sent: Friday, July 03, 2015 5:02 PM
To: For the general discussion of webERP project ; Vinit Jindal ; WebERP - Users 
Subject: Re: [webERP-users] WebERP for School Management

Have you looked at Moodle?
-- 
Adam Morand
Ad...@Mo...



On July 3, 2015 1:20:33 AM MDT, Vinit Jindal <vin...@ya...> wrote: 
Folks,Is anyone using WebERP for School Management ??  Are there any modules for tracking Students, Courses, Attendance, Fee etc ?Thanks—Vinit Jindal------------------------------------------------------------------------------Don't Limit Your Business. Reach for the Cloud.GigeNET's Cloud Solutions provide you with the tools and support thatyou need to offload your IT needs and focus on growing your business.Configured For All Businesses. Start Your Cloud Today.https://www.gigenetcloud.com/------------------------------------------------------------------------------web-ERP-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-users

--------------------------------------------------------------------------------
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/ 


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

Re: [webERP-users] WebERP for School Management

[Vinit J. <vin...@ya...>]

Thanks Deepa,

OpenSIS looks good except its weak on financial side.  We have a private school and if possible, we would like to maintain data on Fee Collection and School Expenses in a single system rather than having two separate systems.


On 03-Jul-2015, at 7:23 pm, Deepa <dee...@li...> wrote:

for school management you can use OpenSIS.
 
 
here is online demo
http://demo.opensis.com/opensis/
 
for more details, please have a look at http://infobizz.in
 
regards
Rajeev Singh Paweria
http://infobizz.in
rs...@in...
 
From: Adam Morand
Sent: Friday, July 03, 2015 5:02 PM
To: For the general discussion of webERP project ; Vinit Jindal ; WebERP - Users
Subject: Re: [webERP-users] WebERP for School Management
 
Have you looked at Moodle?
-- 
Adam Morand
Ad...@Mo...


On July 3, 2015 1:20:33 AM MDT, Vinit Jindal <vin...@ya...> wrote:
Folks,

Is anyone using WebERP for School Management ??  Are there any modules for tracking Students, Courses, Attendance, Fee etc ?

Thanks

—
Vinit Jindal

Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/

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

------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/

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

Re: [webERP-users] WebERP for School Management

[Deepa <dee...@li...>]

for school management you can use OpenSIS.


here is online demo
http://demo.opensis.com/opensis/

for more details, please have a look at http://infobizz.in

regards
Rajeev Singh Paweria
http://infobizz.in
rs...@in...

From: Adam Morand 
Sent: Friday, July 03, 2015 5:02 PM
To: For the general discussion of webERP project ; Vinit Jindal ; WebERP - Users 
Subject: Re: [webERP-users] WebERP for School Management

Have you looked at Moodle?
-- 
Adam Morand
Ad...@Mo...



On July 3, 2015 1:20:33 AM MDT, Vinit Jindal <vin...@ya...> wrote: 
Folks,Is anyone using WebERP for School Management ??  Are there any modules for tracking Students, Courses, Attendance, Fee etc ?Thanks—Vinit Jindal------------------------------------------------------------------------------Don't Limit Your Business. Reach for the Cloud.GigeNET's Cloud Solutions provide you with the tools and support thatyou need to offload your IT needs and focus on growing your business.Configured For All Businesses. Start Your Cloud Today.https://www.gigenetcloud.com/------------------------------------------------------------------------------web-ERP-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-users

--------------------------------------------------------------------------------
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/ 


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

Re: [webERP-users] WebERP for School Management

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

Have you looked at Moodle?
-- 
Adam Morand
Ad...@Mo...


On July 3, 2015 1:20:33 AM MDT, Vinit Jindal <vin...@ya...> wrote:
>Folks,
>
>Is anyone using WebERP for School Management ??  Are there any modules
>for tracking Students, Courses, Attendance, Fee etc ?
>
>Thanks
>
>—
>Vinit Jindal
>------------------------------------------------------------------------------
>Don't Limit Your Business. Reach for the Cloud.
>GigeNET's Cloud Solutions provide you with the tools and support that
>you need to offload your IT needs and focus on growing your business.
>Configured For All Businesses. Start Your Cloud Today.
>https://www.gigenetcloud.com/
>_______________________________________________
>web-ERP-users mailing list
>web...@li...
>https://lists.sourceforge.net/lists/listinfo/web-erp-users

[webERP-users] WebERP for School Management

[Vinit J. <vin...@ya...>]

Folks,

Is anyone using WebERP for School Management ??  Are there any modules for tracking Students, Courses, Attendance, Fee etc ?

Thanks

—
Vinit Jindal

[webERP-users] Printing an invoice instead of a credit note

[jeff1c1 <jco...@le...>]

Hello,

When attempting to print a credit note from Customer Transaction Inquiries,
I am getting a copy of the invoice with the same number and not the credit
note. For example, the following link will print invoice 30 and not credit
memo 30
http://lelyvt.com/webERP/PrintCustTrans.php?FromTransNo=30&InvOrCredit=Invoice&PrintPDF=True.

I recently upgraded to version 4.12.3 and was not having this issue prior.
Any help will be greatly appreciated.

Thank you



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Printing-an-invoice-instead-of-a-credit-note-tp4658292.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Help required

[Harshad A M <amh...@gm...>]

Dear All,

 

I got solution from forum and issue resolved. While creating salesman I did not change the current flat to YES. Once I changed to YES, issue got resolved.

 

Thanks

 

Harshad

 

From: Harshad Alissan [mailto:amh...@gm...] 
Sent: Saturday, June 27, 2015 12:57 PM
To: web...@li...
Subject: Help required

 

Today I have downloaded Weberp 4.12.3. After adding a customer when I try to create customer branch, system is giving error "ERROR Message Report : There are no sales people defined as yet - customer branches must be allocated to a sales person. Please use the link below to define at least one sales person". I have created salesperson, but there is no option in the screen to enter the salesperson. Screen Shot attached.

 

Regards

 

Harshad



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

[webERP-users] Help required

[Harshad A. <amh...@gm...>]

Today I have downloaded Weberp 4.12.3. After adding a customer when I try
to create customer branch, system is giving error "ERROR Message Report :
There are no sales people defined as yet - customer branches must be
allocated to a sales person. Please use the link below to define at least
one sales person". I have created salesperson, but there is no option in
the screen to enter the salesperson. Screen Shot attached.

Regards

Harshad

Re: [webERP-users] Special discount for one customer

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

Hi Warren,

As you point out an item can be in only one discount category - so it is 
appropriate to group like items into small discount categories - 
creating matrix for each category.
Yes a price list/sales type for the customer using the same prices ... 
but now able to pick up the new discount matrix discount is the trick. 
It doesn't matter  that you don't need the quantity break feature - you 
just set this to 1.

Phil

Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 
http://www.logicworks.co.nz
On 10/06/15 11:57, Warren Olds wrote:
> We have a new customer with an agreed discount that is different from our standard arrangement. They will need to be able to purchase all of our products with a 50% discount (as opposed to the standard 40%). I've looked at the page on the wiki but I'm sorry it's not clear how to set this up. The page suggests that it's possible to create a discount category and then add products to it, but upon trying it doesn't appear possible for a product to be assigned two discount categories? I might be mistaken?
>
> Perhaps one way to explain it is to provide the required discount matrix:
>
> Sales Type: Consignment
> Discount Category: SD
> Quantity Break: 1
> Discount Rate %: 30
>
> Sales Type: Trade
> Discount Category: SD
> Quantity Break: 1
> Discount Rate %: 40
>
> Sales Type: Trade
> Discount Category: FD
> Quantity Break: 1
> Discount Rate %: 50
>
> Is this possible?
> The only other workaround I can see is to create a new price list specific to that customer, e.g. Trade50. The prices would be the same (as Trade) but it provide a way to target the 50% discount for that customer in the Discount matrix without modifying the Discount category. The only issue I can see is that I would need to setup a new price list for each product?
>
> It's perhaps worth adding that we don't apply discounts based on quantity ordered. All our products have a standard price (the recommended retail) with individual customers set at agreed discount levels from that: 0%, 30%, 40%, 50% etc.
>
> Any help appreciated!
>
>   \\
>    warren
>

[webERP-users] Special discount for one customer

[Warren O. <to...@wa...>]

We have a new customer with an agreed discount that is different from our standard arrangement. They will need to be able to purchase all of our products with a 50% discount (as opposed to the standard 40%). I've looked at the page on the wiki but I'm sorry it's not clear how to set this up. The page suggests that it's possible to create a discount category and then add products to it, but upon trying it doesn't appear possible for a product to be assigned two discount categories? I might be mistaken?

Perhaps one way to explain it is to provide the required discount matrix:

Sales Type: Consignment
Discount Category: SD
Quantity Break: 1
Discount Rate %: 30

Sales Type: Trade
Discount Category: SD
Quantity Break: 1
Discount Rate %: 40

Sales Type: Trade
Discount Category: FD
Quantity Break: 1
Discount Rate %: 50

Is this possible?
The only other workaround I can see is to create a new price list specific to that customer, e.g. Trade50. The prices would be the same (as Trade) but it provide a way to target the 50% discount for that customer in the Discount matrix without modifying the Discount category. The only issue I can see is that I would need to setup a new price list for each product?

It's perhaps worth adding that we don't apply discounts based on quantity ordered. All our products have a standard price (the recommended retail) with individual customers set at agreed discount levels from that: 0%, 30%, 40%, 50% etc.

Any help appreciated!

 \\
  warren

-- 

Warren Olds

+64 (0)  9 376 9016
+64 (0) 21 896 937 <-- new number !
w3...@wa...
http://www.warrenolds.com
http://www.studioahoy.com

Re: [webERP-users] Problem with ENTER CUSTOMER PAYMENTS

[Regal R. <reg...@gm...>]

In the cust details, you have to stipulate the billing currency for that customer.

Hope that helps
Russ
sent from phone by Russell of Regal 2904503

-----Original Message-----
From: Arwan <r1g...@gm...>
Date: Tue, 2 Jun 2015 04:55:37 
To: <web...@li...>
Reply-To: For the general discussion of webERP project
	<web...@li...>
Subject: Re: [webERP-users] Problem with ENTER CUSTOMER PAYMENTS

Hi,

Thanks for responding,

I have just seen Tim's email.... copy below
I still don't understand what he means by the "currency of the transaction"
I an assuming the transactions are those in debtortrans table but then I can
not identify
a field in debtortrans table that determines which currency that transaction
is in.   
The only difference between local currency transactions and USD transactions
is
that the field rate is 1 for local currency and 0.110245 (usd rate) for USD
customers.

So I don't understand how to go about setting the currency of the
transaction to the 
currency of the customer as Tim suggests 

Thanks in advance

Arwan 


========================================================
Tim Schofield <tim...@gm...>
May 30 (3 days ago)
to me, ExsonQu
Am pretty sure this has nothing to do with the $ sign in the code. The
currency of the transaction must be set to the currency of the
customers account (presumably USD in this case) before you do the
search.

Tim



-----
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/Problem-with-ENTER-CUSTOMER-PAYMENTS-tp4658263p4658267.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

Re: [webERP-users] Problem with ENTER CUSTOMER PAYMENTS

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

Hi,

Thanks for responding,

I have just seen Tim's email.... copy below
I still don't understand what he means by the "currency of the transaction"
I an assuming the transactions are those in debtortrans table but then I can
not identify
a field in debtortrans table that determines which currency that transaction
is in.   
The only difference between local currency transactions and USD transactions
is
that the field rate is 1 for local currency and 0.110245 (usd rate) for USD
customers.

So I don't understand how to go about setting the currency of the
transaction to the 
currency of the customer as Tim suggests 

Thanks in advance

Arwan 


========================================================
Tim Schofield <tim...@gm...>
May 30 (3 days ago)
to me, ExsonQu
Am pretty sure this has nothing to do with the $ sign in the code. The
currency of the transaction must be set to the currency of the
customers account (presumably USD in this case) before you do the
search.

Tim



-----
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/Problem-with-ENTER-CUSTOMER-PAYMENTS-tp4658263p4658267.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Problem with ENTER CUSTOMER PAYMENTS

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

*Hi, Arwan,*

       You may have received Tim's email. Is it what he said that you choose
the wrong currency of the transaction? 

       Best regards!

      Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Problem-with-ENTER-CUSTOMER-PAYMENTS-tp4658263p4658266.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Problem with ENTER CUSTOMER PAYMENTS

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

Hi Exson,

Thanks for responding 

The user is using version 4.11.3 and created 6 new USD customers for already
existing customers with customer codes (debtrono)  like MTFCL$,TTFCL$, MTF$,
KAPTF$, KTFCLTD$, KTFL$

Then entered sales orders for each of them. Now payments have come and  in
RECEIVERBLES → ENTER CUSTOMER PAYMENTS the USD customers can not be
retrieved.

When the user enters the customer code in the search, it gives the error
message above.  When all the fields I.e name, customer code, invoice Number
are left blank and then click SEARCH NOW , it show the whole list of
customers EXCLUDING the ones with $ sign in debtorno field. 

I used  anywhereindb.php to find which tables contain transactions for the $
sign customers and found 

TABLE                      FIELD
audittrail	                querystring
custbranch	        debtorno
custbranch	        custbranch
debtorsmaster 	        debtorno
debtortrans  	        debtorno
debtortrans  	        branchcode
gltrans	                narrative
salesanalysis	       cust
salesanalysis	       custbranch
salesorders	       debtorno
stockmoves 	       branchcode

All the transactions the system creates for the transactions entered for
those ($ sign in debtorno) customers are in the system and I can see them
via phpmyadmin.  

So it tried changing customer code and branch code for one of the customers 

e.g from MTFCL$ to USDMTFCL this worked OK then when I searched again for
USDMTFCL  using phpmyadmin and anywhereindb.php, I find all the transactions
that were previously for  MTFCL$ have all been correctly changed to 
USDMTFCL

BUT the problem persists the customer USDMTFCL can not be retrieved by
RECEIVERBLES → ENTER CUSTOMER PAYMENTS  customer search and does not appear
in the list when SEARCH NOW is clicked. 

Note: I have uploaded the users data from version 4.11.3 to my current
version 4.12.3 and the problem is the same. 

What would I need to change in the CustomerReceipt.php search code to make
it retrieve those customers either before or after changing the customer and
branch codes, if they are the problem ?   

SelectCustomer.php is able to retrieve both customers with and without $ in
debtorno

Thanks in advanced

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/Problem-with-ENTER-CUSTOMER-PAYMENTS-tp4658263p4658265.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Problem with ENTER CUSTOMER PAYMENTS

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

*Hi, Arwan,*

              Is the customer searchable in Search Customer interface?

              Best regards!

              Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Problem-with-ENTER-CUSTOMER-PAYMENTS-tp4658263p4658264.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

[webERP-users] Problem with ENTER CUSTOMER PAYMENTS

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

Hi,

Am using weberp 4.12.3
a user needed to invoice the same customers both in local currency and USD
so they created 2 customers, 
one for local currency and one for USD

For the USD customers they wrongly created the customer code (debtorno) with
a $ in it  e.g XYZ$

Apparently the system allows that and also allows sales orders to be entered
for those customers with $ in their 
customer code.

The problem is that now when they receive a payment and go to:

 RECEIVERBLES → ENTER CUSTOMER PAYMENTS

and try to select the customer making the payment, the error is displayed : 

No customer records contain the selected text - please alter your search
criteria and try again

I can see the customer in debtorsmaster, custbranch and debtortrans tables
via phpmyadmin

even after I use Z_ChangeCustomerCode.php and Z_ChangeBranchCode.php on a
customer then check the db, 
the customer is there with the new changed code in debtorsmaster, custbranch
and debtortrans but can still not be 
retrieved the customer via :

RECEIVERBLES → ENTER CUSTOMER PAYMENTS

any ideas what could be wrong


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/Problem-with-ENTER-CUSTOMER-PAYMENTS-tp4658263.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Same query repeated inside a loop

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

Hi Tom,

Thanks for this - I have committed your change.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 26/05/15 01:30, Tom Barry wrote:
> Dear all, I am doing some investigations on webERP. I notice that in 
> SupplierInquiry.php at line 285 an sql statement is executed to find 
> if the user has authority to put an item on hold. This sql is repeated 
> for every line in the inquiry, although obviously the user is the same 
> for every line. This should really be taken outside the loop.
>
> Tom
>
>
> ------------------------------------------------------------------------------
> One dashboard for servers and applications across Physical-Virtual-Cloud
> Widest out-of-the-box monitoring support with 50+ applications
> Performance metrics, stats and reports that give you Actionable Insights
> Deep dive visibility with transaction tracing using APM Insight.
> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
>
>
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users