#4549 is tax exempt on c_bpartner

R2.6.1
closed
5
2007-09-01
2007-08-17
Neil Gordon
No

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.

Discussion

  • Kathy Pink

    Kathy Pink - 2007-08-17
    • assigned_to: kmpink --> lfreyes
     
  • Felipe Reyes

    Felipe Reyes - 2007-08-24

    Logged In: YES
    user_id=1793135
    Originator: NO

    Reviewing...

     
  • Felipe Reyes

    Felipe Reyes - 2007-08-24
    • status: open --> pending
     
  • Felipe Reyes

    Felipe Reyes - 2007-08-24

    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).

     
  • SourceForge Robot

    • status: pending --> closed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks