#51 R2.5.1: Reverse Allocation

R2.5.1
closed
5
2004-04-29
2004-04-20
Jorg Janke
No

(applies also to 2.5.0x)
When you reverse a payment allocation, you get the
error message:
org.compiere.model.MAllocation
Message: setValue - Column not updateable - IsActive -
NewValue=false - OldValue=true

--
Reversal de-activates (not deletes) the current
allocation for audit purposes.
The Dictionary does not allow this.

Discussion

  • Jorg Janke

    Jorg Janke - 2004-04-20

    Logged In: YES
    user_id=87038

    Fix:
    In System Admin, Window Table/Column search: C_Allocation
    in Tab Column seach: IsActive
    Set "Updateable" flag.

    Alternative:
    SQL> UPDATE AD_Column Set IsUpdateable='Y' WHERE
    AD_Column_ID=4877 AND IsUpdateable<>'Y';

     
  • Jorg Janke

    Jorg Janke - 2004-04-22

    Logged In: YES
    user_id=87038

    The bug is that certain flags are not updated/checked
    correctly.

    Additional corrections:
    db/database/Functions/C_Payment_Allocated.sql
    db/database/Functions/C_Payment_Available.sql
    db/database/Functions/C_Invoice_Open.sql
    db/database/Functions/C_Invoice_Paid.sql
    db/database/Triggers/C_Allocation_Trg.sql

    Correcting flags:
    db/maintain/Maintenance/C_Invoice_Check.sql
    db/maintain/Maintenance/C_Payment_Check.sql
    db/maintain/Maintenance/C_BPartner_Check.sql

    Corrections in org.compiere.odel.MAllocation.sql are cosmetic.

     
  • Jorg Janke

    Jorg Janke - 2004-04-22
    • labels: --> Database.data
    • milestone: --> R2.5.1
    • assigned_to: nobody --> jjanke
     
  • Jorg Janke

    Jorg Janke - 2004-04-22

    Logged In: YES
    user_id=87038

    Instead of applying the single files, you can use the attached
    combined script:

    sqlplus compiere/password @reverseAllocationPatch.sql

     
  • Jorg Janke

    Jorg Janke - 2004-04-29
    • status: open --> closed
     

Log in to post a comment.

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

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks