Can't print checks: psycopg2.errors.InvalidTextRepresentation: invalid input syntax for type bigint: "61,969.40"

Question

All of a sudden, Users are reporting an issue each time they select checks to print for a check run.
Any ideas?

Ray Carnes (ray) · Accepted Answer

One of the Payments has a check number of 61,969.40.
It could be a Customer Payment, Vendor Payment, Internal Transfer - it doesn't need to be a check.
Find it with this Filter:
image [2]
If you are an Odoo.sh [1]  or Odoo On Premise Customer, use the following SQL to fix it:
update account_payment set check_number = Null where id = <id_of_the_payment>;

[1] http://Odoo.sh
[2] /web/image/77936147-f5c7b51c/image.png?access_token=583fdda8-2300-40a7-98a7-8012a16f3ae9

Related Posts	Replies	Views
Odoo 8 Error printing all reports. error print	1 Jun 16	3723
Where do I change format of printed checks? print check	1 Mar 15	6394
How to solve printing error of sales quotation template and invoice template? error print odoo16features	0 Mar 23	2373
Studio report throws EOF error at print time error print Studio	1 Aug 22	2405
Odoo Server Error - Warning. You have to choose a check layout. For this, go in Apps, search for 'Checks layout' and install one. Solved print check errror version13	2 Jul 22	2992

This question has been flagged

Enjoying the discussion? Don't just read, join in!