I have an account listing report which shows all transactions types posted to specific accounts for specific period. If I choose to include any of my control accounts, for example Trade Creditor account the report excludes all purchasing and sales documents and just shows journal entries, payments and receipts. All accounts apart from control accounts show all transactions.

 

It looks to me as if control accounts only look at Journal entry table not at purchasing and sales tables. As I restrict the journal entry table (d.TransType not in (13,14,18,19)) not to pick up purchasing and sales documents (and credit notes) from journal entry table to avoid duplications) these are not showing for control accounts.

 

Any idea why control accounts look only at Journal entry tables? How should I tell it to include these transactions for all control accounts?

 

many thanks

 

 

 

 

 

 

Is there any other way to say that for some accounts do not show transactions with transaction type 13 and 14?