weberp-users — WebERP Users mailing list

[Weberp-users] Reverse Shipping costs

[Brian M. <br...@do...>]

I have looked for a solution on this and have not found one.

I recently had an employee receive alot of product from a vendor, he
entered the shipping cost of the product from the vendor to my freight
forwarder.  However, he then invoiced and closed the shipment before
entering the invoice from my freight forwarder to my physical plant.

Is there any way to reverse this?  I would like to include those costs in
the shipment so it will add the 2nd shipping cost to the cost of our
product.

Thanks

Re: [Weberp-users] Modifying a customer invoice and or cancelling an order

[Brian M. <br...@do...>]

Hi Daniel,

Once you create an invoice I do not believe you can modify it.  What I
normally do is credit the invoice, it will then come back up as an open
sales order and you can modify it or delete it there and re-invoice it.

On Wed, Jul 27, 2011 at 9:52 PM, Daniel Brewer <db...@se...>wrote:

> Hello does anyone know if you can modify a customer invoice after its been
> "processed" from a sales order?
>
> Lets say the order or payment details have changed since it was first
> produced and a change needs to be made. It appears that it doesn't support
> this..
>
> Any help would be most appreciated..
>
> --
> Daniel Brewer
> Enterprise Architect
> Sentric
>
> Mobile: 0431221002
> Landline: 03 9038 8860
>
>
>
>
> ------------------------------------------------------------------------------
> Got Input?   Slashdot Needs You.
> Take our quick survey online.  Come on, we don't ask for help often.
> Plus, you'll get a chance to win $100 to spend on ThinkGeek.
> http://p.sf.net/sfu/slashdot-survey
> _______________________________________________
> Weberp-users mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/weberp-users
>
>


-- 
Brian May
506.8862.9162 (Cell)
506.2293.6375 (Office)

[Weberp-users] Modifying a customer invoice and or cancelling an order

[Daniel B. <db...@se...>]

Hello does anyone know if you can modify a customer invoice after its been
"processed" from a sales order?

Lets say the order or payment details have changed since it was first
produced and a change needs to be made. It appears that it doesn't support
this..

Any help would be most appreciated..

-- 
Daniel Brewer
Enterprise Architect
Sentric

Mobile: 0431221002
Landline: 03 9038 8860

[Weberp-users] question about adding customer branch input form

[Daniel B. <db...@se...>]

Can anyone tell me what the "Forward date after" data field is for?

Does this specify a date to apply to delivery times?

Regards,

-- 
Daniel Brewer
Enterprise Architect
Sentric

Mobile: 0431221002
Landline: 03 9038 8860

[Weberp-users] Problem with ConfirmDispatch_invoice.php

[Daniel B. <db...@se...>]

We are experiencing a problem with ConfirmDispatch_Invoice.php when having
created an order and processing the invoice.

There is a column titled "Total Excl Tax" and you would expect to find the
tax amount in the column to its right, titled "Tax Amount", but it remains
empty.

If you then apply a charge for freight in the text box labelled "Charge
Freight Cost inc Tax" and update the page to incorporate it into the total
the tax columns remain empty.

The totals carry through to the invoice amount correctly, but tax splits are
not shown. Is this a bug or is there a configuration item I may be unaware
of?

This is quite an important feature for what we are considering.

-- 
Daniel Brewer
Enterprise Architect
Sentric

Mobile: 0431221002
Landline: 03 9038 8860

[Weberp-users] Question about tax item in

[Daniel B. <db...@se...>]

We are experiencing a problem with ConfirmDispatch_Invoice.php when having
created an order and processing the invoice.

There is a column titled "Total Excl Tax" and you would expect to find the
tax amount in the column to its right, titled "Tax Amount", but it remains
empty.

If you then apply a charge for freight in the text box labelled "Charge
Freight Cost inc Tax" and update the page to incorporate it into the total
the tax columns remain empty.

The totals carry through to the invoice amount correctly, but tax splits are
not shown. Is this a bug or is there a configuration item I may be unaware
of?

This is quite an important feature for what we are considering.

Regards,

-- 
Daniel Brewer
Enterprise Architect
Sentric

Mobile: 0431221002
Landline: 03 9038 8860

[Weberp-users] new file releae 4.04.4

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

I rolled up a new release yesterday with all the latest bug fixes in.

Phil
Phil Daintree
Logicworks Ltd
http://wwww.logicworks.co.nz
+64 275 567890

[Weberp-users] EmailCustTrans.php

[Daniel B. <db...@se...>]

I put in this quick fix for the EmailCustTrans.php file

$SQL = "SELECT email
FROM custbranch INNER JOIN debtortrans
ON custbranch.debtorno= debtortrans.debtorno
AND custbranch.branchcode=debtortrans.branchcode
WHERE debtortrans.type=$TypeCode
AND debtortrans.transno=".$_GET['FromTransNo'];

-- 
Daniel Brewer
Enterprise Architect
Sentric

Mobile: 0431221002
Landline: 03 9038 8860

[Weberp-users] problem with EmailCustTrans.php

[Daniel B. <db...@se...>]

*
Hello I have had a problem with this script. Is there a known fix for the
php connecting the transno value to the sql statement?

Database SQL Failure* : The SQL that failed was
SELECT email FROM custbranch INNER JOIN debtortrans ON custbranch.debtorno=
debtortrans.debtorno AND custbranch.branchcode=debtortrans.branchcode WHERE
debtortrans.type=11 AND debtortrans.transno=

-- 
Daniel Brewer
Enterprise Architect
Sentric

Mobile: 0431221002
Landline: 03 9038 8860

[Weberp-users] custom attributes

[Daniel B. <db...@se...>]

Hello, I am a new user to WebERP and I, through the company I work for hope
to contribute greatly to the community and developers of this fine product.

I had a question to anyone if they knew of any way to add custom fields to
either items, customers or suppliers?

Kind Regards,

-- 
Daniel Brewer
Enterprise Architect
Sentric

Mobile: 0431221002
Landline: 03 9038 8860

[Weberp-users] Problem Adding Purchase Order

[Daniel B. <db...@se...>]

Hello has anyone had a problem creating a Purchase Order from an order? I
get the following error message. The purchaseorderdetails table does not
have a kgs column..

*Database Error* : One of the purchase order detail records could not be
inserted into the database because
Unknown column 'kgs' in 'field list'

I have used the online demo system and my own hosted application and can't
get past this..

Any help would be well appreciated.

-- 
Daniel Brewer
Enterprise Architect
Sentric

Mobile: 0431221002
Landline: 03 9038 8860

[Weberp-users] webERP v4.0.1 Released

[Otandeka S. P. <sot...@gm...>]

Hi All,

This is to announce the release of webERP v4.0.1.

This release contains a good number of bug fixes and updates but most
importantly, the database upgrade system that needed
some more panel beating to make it work properly.

You can download this from https://sourceforge.net/projects/weberp/ or
https://launchpad.net/web-erp
and of course don't miss visiting
http://wiki.web-erp.org/index.php?title=Main_Page, the wiki that has been
put up and updated with the most
recent changes that are being added to the application.

We welcome more developers, testers and users on board and yes, lets share
knowledge in the spirit of open source and make webERP the ultimate ERP
package.

Thanks,
Peter.

[Weberp-users] Can't update page security through PageSecurity.php

[Joe Z. <oss...@gm...>]

Tim,
I just downloaded your weberp4.0RC-3,and tried to update some page security
setting through PageSecurity.php,but didn't succeeded.
For example,I set up AR for token 1,2,3,11,so by default,under
PageSecurity.php,
If I understand correctly,under token 3,it manages  the following 29 pages:
AddCustomerContacts.php
AddCustomerNotes.php
AddCustomerTypeNotes.php
Areas.php
CreditItemsControlled.php
CreditStatus.php
Credit_Invoice.php
CustomerAllocations.php
CustomerBranches.php
CustomerInquiry.php
CustomerReceipt.php
Customers.php
geocode.php
GeocodeSetup.php
geocode_genxml_customers.php
geocode_genxml_suppliers.php
geo_displaymap_customers.php
geo_displaymap_suppliers.php
PDFBankingSummary.php
PDFChequeListing.php
PDFCustTransListing.php
PDFDeliveryDifferences.php
PDFDIFOT.php
PDFOrdersInvoiced.php
PDFOrderStatus.php
PDFStockTransListing.php
PDFSuppTransListing.php
SelectCreditItems.php
StockSerialItemResearch.php

Now just for test purpose,if I would like to assign the following pages to
Account Payable:
SelectCreditItems.php
CustomerReceipt.php

After I click "update Security Level" button,The above pages should belong
to Accounts Payable,but It didn't change anything,so basically I couldn't
freely update the page security level.And I logged out as admin,and login as
AR clerk,the above pages still display there...
Could you give me some hint on how to use it?

Thanks and have a wonderful day!

Joe

Re: [Weberp-users] Welcome

[Otandeka S. P. <sot...@gm...>]

Read you loud and clear.

On Mon, Jan 10, 2011 at 4:30 PM, Tim Schofield <ti...@we...> wrote:

> Welcome to the webERP mailing lists
>
> Thanks
> Tim
>
>
> --
> WebERP Africa Ltd
> +447710427049
> +256752963327
> +255784602561
> www.weberpafrica.com
>
>
> ------------------------------------------------------------------------------
> Gaining the trust of online customers is vital for the success of any
> company
> that requires sensitive data to be transmitted over the Web.   Learn how to
> best implement a security strategy that keeps consumers' information secure
> and instills the confidence they need to proceed with transactions.
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> Weberp-users mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/weberp-users
>

[Weberp-users] Welcome

[Tim S. <ti...@we...>]

Welcome to the webERP mailing lists

Thanks
Tim


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