am I wrong ?

All Chart maintainers are requested to submit suitable changes / devs may update the charts in the official pkg repo.

Please be consistent with the order of the fields in the primary key as it should match the standard Charts and those that get upgraded using the sql/alter2.4.sql file.

ALTER TABLE `0_debtor_trans`
   DROP PRIMARY KEY,
   ADD PRIMARY KEY(`type`,`trans_no`,`debtor_no`);

ALTER TABLE `0_supp_trans`
   DROP PRIMARY KEY,
   ADD PRIMARY KEY(`type`,`trans_no`,`supplier_id`);

Actually, @itronics order of the key fields is better as it also is in the same order of fields in the table but the sql/alter2.4.sql and the commit are otherwise. The extension Charts too will have to be updated atleast for the supp_trans table.

The above stands fixed in my repo.

The sql/alter2.4.sql file is already updated in FA 2.4 for both debtor_trans and supp_trans tables.

All the extension Charts need to be updated.

The supp_trans table too needs to be updated accordingly with supplier_id in the place of debtor_no.

Anyway, any existing FA database can be fixed easily with following command run in phpmyadmin:

ALTER TABLE `0_debtor_trans`
   DROP PRIMARY KEY,
   ADD PRIMARY KEY(`trans_no`,`type`,`debtor_no`);

Thanks for pointing out the problem.
Janusz

/Joe

At some places the view is distorted just like in Journal Inquiry View but technically the transaction is OK.

You may call locally at my number to discuss further if you want that I am going to PM you.

In FA2.4+ if you select Accounts REceiveable Code in Account Description in Journal Entry It creates another column automatically to enter CounterParty. This works same for Accounts Payable also.

Joe