#4549 is tax exempt on c_bpartner

[Neil Gordon]

on the table c_bpartner, istaxexempt is nullable, and the default was not set to "N" as it should have been, on 2.6.1.

when quick-creating a record, this causes the istaxexempt column to have a null, then not allowing this field to be updated in future.

[Felipe Reyes]

Logged In: YES
user_id=1793135
Originator: NO

Reviewing...

[Felipe Reyes]

Logged In: YES
user_id=1793135
Originator: NO

At the database level, the column istaxexempt has a default value in my 2.6.1 instance...

Could you run this query in your instance?
select owner, table_name, nullable, data_default
from dba_tab_columns
where table_name = 'C_BPARTNER'
AND column_name = 'ISTAXEXEMPT';

select istaxexempt, count(*)
from c_bpartner
GROUP BY istaxExempt

[SourceForge Robot]

Logged In: YES
user_id=1312539
Originator: NO

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 7 days (the time period specified by
the administrator of this Tracker).