Hello Microsoft Team,

in Table 15 "G/L Account" exists the Field "Gen. Posting Type" for a few versions now but it was never really used.
My idea would be to add this Field as an addition to the other Table Filter in the "No." Fields of Documents
(e. g. Sales Line or Purchase Line). This can deny users to take an accounts they aren't allowed to use in the first place.

Of course this must be applied to all Documents where you can choose a G/L Account.
The field currently has those three options to choose from: " ,Purchase,Sale". Adding "Purchase and Sales" as a new option can be useful as well.

In the end the Table Relation of Sales Line No. would look like this:
... if ("Type"=const("G/L Account"),"System-Created Entry"=const(false)) "G/L Account"
where ("Direct Posting"=const(true),
"Account Type"=const(Posting),
"Blocked"=const(false),
"Gen. Posting Type"=filter("Sale"|"Purchase and Sales")) else...

This could help us a lot during our Extension Development due to the fact that we can't edit Table Filters or extend LookUp Triggers at all and we "simply" cannot replace a "No." Field easily in ALL Receipts.
Also adding a new Table Relation would not solve this problem because our Condition would be the same as the one from BC Standard and we found out that the first Table Filter which meets the requirements of the conditions will be used.

Best Regards

Jonas