GW 2.6.0c 2007-02-08
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;).
Log in to post a comment.