Neal Matthews
27th November 2003, 17:10
Hello,

When attempting to use balance sheet account "0200" in session Maintain Purchase Invoice Transactions we are getting a message "Account should not be a customer / supplier control account".

We did briefly have another 0200 account setup as a control account in one of our other companies (now deleted) but tfgld008 is not shared and neither is tfacp001.

Can anyone with the code tell me where this session is looking when it validates the ledger account and why it would think that it is a control account.

Cheers
Neal Matthews
Intier Automotive - IT Support Analyst

Neal Matthews
27th November 2003, 17:29
Posted this and within 30 secs find the problem.

Somehow the field tfgls008.nosu Number of times used as a control account had been updated.

Set to zero and session then allowed us to use 0200.

Still like to know how this happened though.

Cheers
Neal

Hitesh Shah
28th November 2003, 08:22
Changing this is not a good solution if it is really used in tfacp0110m000 / tfacp0111s000 . It can lead to control account checklist difference.

It (nosu) is reset to zero when all such references are eliminated.

Neal Matthews
28th November 2003, 11:43
Fair point but in company 002 account 0200 is a balance sheet account so I'm not entirely sure how the field was updated.

When we need to set up 0200 in company 005 again I will try to find out how the table in company 002 is being updated.

Regards
Neal

Hitesh Shah
29th November 2003, 09:17
This account has to be Balance sheet only .

When u make an account a control account / advance payment / unallocated payment / anticipated payment account in tfacp0111s000 , this field is incremented and vice versa when u remove this account.