#4394 Statement of Accounts error

R2.6.0
closed
nobody
None
5
2007-04-20
2007-04-16
No

GW 2.6.0c 2007-02-08

Hello,

See attached error when running the statement of accounts.

The problem comes from a foreign key constrain in T_reportstatement (FK545_8192_3001) as the balance line tries to insert a line with Fact_Acct_ID=0, that does not exists in Fact_Acct.

One solution is to drop the foreign key as it is for T_trialbalance. (ALTER TABLE T_reportstatement DROP CONSTRAINT FK545_8192_3001;).

Stephan,
Sodexis.

Discussion

  • Stephan Keller

    Stephan Keller - 2007-04-16

    error.txt

     
  • Kathy Pink

    Kathy Pink - 2007-04-16

    Logged In: YES
    user_id=329831
    Originator: NO

    please verify in the current release as there we some FK issues in the c version
    Thanks

     
  • Kathy Pink

    Kathy Pink - 2007-04-16
    • status: open --> pending
     
  • Kathy Pink

    Kathy Pink - 2007-04-16

    Logged In: YES
    user_id=329831
    Originator: NO

    *** Status set to PENDING *** If the issue solved, please CLOSE
    this request - otherwise set the status back to OPEN (we only
    check OPEN items). If there is no reaction within a week, the
    system will automatically CLOSE it. To speed up response time,
    you may want to consider a support agreement.
    ***

     
  • Kathy Pink

    Kathy Pink - 2007-04-16

    Logged In: YES
    user_id=329831
    Originator: NO

    please verify in the current release as there we some FK issues in the c version
    Thanks

     
  • Kathy Pink

    Kathy Pink - 2007-04-16

    Logged In: YES
    user_id=329831
    Originator: NO

    *** Status set to PENDING *** If the issue solved, please CLOSE
    this request - otherwise set the status back to OPEN (we only
    check OPEN items). If there is no reaction within a week, the
    system will automatically CLOSE it. To speed up response time,
    you may want to consider a support agreement.
    ***

     
  • Stephan Keller

    Stephan Keller - 2007-04-20

    Logged In: YES
    user_id=1617011
    Originator: YES

    Kathy,

    yes, the problem is not there anymore in the nightly build.

    Thanks,
    Stephan.

     
  • Stephan Keller

    Stephan Keller - 2007-04-20
    • status: pending --> closed
     

Log in to post a comment.

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

Sign up for the SourceForge newsletter:





No, thanks