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

İlgili Gönderiler	Cevaplar	Görünümler
Odoo 8 Error printing all reports. error print	1 Haz 16	3455
Where do I change format of printed checks? print check	1 Mar 15	6212
How to solve printing error of sales quotation template and invoice template? error print odoo16features	0 Mar 23	2142
Studio report throws EOF error at print time error print Studio	1 Ağu 22	2117
Odoo Server Error - Warning. You have to choose a check layout. For this, go in Apps, search for 'Checks layout' and install one. Çözüldü print check errror version13	2 Tem 22	2813

Bu soru işaretlendi

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