ERROR in check the transfer information of a supplier paid invoice

[Steven (Shiu Fat)]

Hi,

There is an error as following come out when I click in the supplier > Supplier Account Inquiry > View Payment of a paid supplier invoice.

Payment Allocation for Supplier: 'HG' and Invoice: '62538'

Database Error :
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT suppallocs.transid_allocfrom FROM supptrans, suppall

Database SQL Failure : The SQL that failed was
SELECT supptrans.supplierno, supptrans.suppreference, supptrans.trandate, supptrans.alloc FROM supptrans WHERE supptrans.id IN (SELECT suppallocs.transid_allocfrom FROM supptrans, suppallocs WHERE supptrans.supplierno = 'HG' AND supptrans.suppreference = '62538' AND supptrans.id = suppallocs.transid_allocto)

Thanks



-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users

[emdeex]

Steven,

I can't recreate this error on my system.  Can you check your webERP
version.  Also check that the payment has been allocated to an
existing invoice.

regards,
Murray

On Tue, Oct 7, 2008 at 3:58 PM, steven <steven@...> wrote:

> Hi,
>
> There is an error as following come out when I click in the supplier >
> Supplier Account Inquiry > View Payment of a paid supplier invoice.
>
> Payment Allocation for Supplier: 'HG' and Invoice: '62538'
>
> Database Error :
> You have an error in your SQL syntax. Check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'SELECT
> suppallocs.transid_allocfrom FROM supptrans, suppall
>
> Database SQL Failure : The SQL that failed was
> SELECT supptrans.supplierno, supptrans.suppreference, supptrans.trandate,
> supptrans.alloc FROM supptrans WHERE supptrans.id IN (SELECT
> suppallocs.transid_allocfrom FROM supptrans, suppallocs WHERE
> supptrans.supplierno = 'HG' AND supptrans.suppreference = '62538' AND
> supptrans.id = suppallocs.transid_allocto)
>
> Thanks
>
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users

[paweriars]

    Heya,how are you doing recently ? I would like to introduce you a very good company which i knew.Their website is  www.trailblazer917.com   .They can offer you all kinds of electronical products which you need like laptops ,gps ,TV LCD,cell phones,ps3,MP3/4,motorcycles  etc........Please take some time to have a check ,there must be somethings you 'd like to purchase .
Their contact email: trailblazer917@....  MSN: trailblazer.916@...TEL:  0086+135 2231 7720
Hope you have a good mood in shopping from their company !
Regards

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users