Error in SQL query, when you try to make a payment without select an invoice

[Nhomar - Vauxoo]

When try to add a payment in:

Finantial management > Voucher Entries > Select all aoptons here.
Then....

In the lines, you try to make a payment in advance "without invoice related", give an error in SQL query.

[Nhomar - Vauxoo (nhomar)]

Modules intalled:

account_voucher
account_voucher_payment
account_voucher_workflow

[Stephane Wirtel (OpenERP) (stephane-openerp)]

What's the sql error ? or query ?

Have you tried with the --debug argument on the command line of the server ?

Can you provide the query and the params ?

Thank you

[Nhomar - Vauxoo (nhomar)]

Of Course

I attach all the log file:

Look the error begin in line : 932 a end in Line: 1008

[Jay Vora (Serpent Consulting Services) (jayvora)]

Fixed by revision 4193 <email address hidden>.

These modules really need some good testing and analysis.

Thanks.

[Nhomar - Vauxoo (nhomar)]

We are using them.....

We are agree with you, but they are really needed, OpenERP needs a form like
this to receive the money....
Only Account_Voucher is not enough.

Nhomar

2010/1/21 Jay (Open ERP) <email address hidden>

> Fixed by revision 4193 <email address hidden>.
>
> These modules really need some good testing and analysis.
>
> Thanks.
>
>
> ** Changed in: openobject-addons
> Status: Confirmed => Fix Released
>
> --
> Error in SQL query, when you try to make a payment without select an
> invoice
> https://bugs.launchpad.net/bugs/510181
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in OpenObject Addons Modules: Fix Released
>
> Bug description:
> When try to add a payment in:
>
> Finantial management > Voucher Entries > Select all aoptons here.
> Then....
>
> In the lines, you try to make a payment in advance "without invoice
> related", give an error in SQL query.
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/openobject-addons/+bug/510181/+subscribe
>

--
Saludos Cordiales

Nhomar G. Hernandez M.
[phone]
[phone]
[phone] ext 124
[phone]
Web-Blog: http://geronimo.com.ve
Servicios IT: http://openerp.netquatro.com
Linux-Counter: 467724
Correos:
<email address hidden>
<email address hidden>

[Nhomar - Vauxoo (nhomar)]

 Question:

.... did you apply my diff????, or apply other changes????

2010/1/21 Jay (Open ERP) <email address hidden>

> Fixed by revision 4193 <email address hidden>.
>
> These modules really need some good testing and analysis.
>
> Thanks.
>
>
> ** Changed in: openobject-addons
> Status: Confirmed => Fix Released
>
> --
> Error in SQL query, when you try to make a payment without select an
> invoice
> https://bugs.launchpad.net/bugs/510181
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in OpenObject Addons Modules: Fix Released
>
> Bug description:
> When try to add a payment in:
>
> Finantial management > Voucher Entries > Select all aoptons here.
> Then....
>
> In the lines, you try to make a payment in advance "without invoice
> related", give an error in SQL query.
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/openobject-addons/+bug/510181/+subscribe
>

--
Saludos Cordiales

Nhomar G. Hernandez M.
[phone]
[phone]
[phone] ext 124
[phone]
Web-Blog: http://geronimo.com.ve
Servicios IT: http://openerp.netquatro.com
Linux-Counter: 467724
Correos:
<email address hidden>
<email address hidden>

[Jay Vora (Serpent Consulting Services) (jayvora)]

Yes Nhomar,

You are right, but these modules need improvemnts.

I had to check other bugs too and solved them with this one. so, its not fully your patch.

Thanks.

[Nhomar - Vauxoo (nhomar)]

Ok...

I know about the improvements, we are working on them too, if you can tell what are the improvements that you think this needs we can help with development, We have some Ideas, and most of all, the Banking Cheks Control, and IMHO this behaviour needs to be there. The point where you receive or make them!.

I will make a blueprint!

Nhomar

[Jay Vora (Serpent Consulting Services) (jayvora)]

Thank you for the blueprint.

We will work towards making the module generic. We will appreciate your inputs.

Thank you for your feedback.