cancel
Showing results for 
Search instead for 
Did you mean: 

Automatic Clearing_F.13_Error_Account not entered in table TF123

former_member214904
Participant
0 Kudos

Dear Expats

To clear the vendor through automatic clearing T code F.13

We are getting below error.

Account was selected but is not entered in table TF123.

Pls. give us the feedback to solve the issue.

Regards

Tarek

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Tarek,

Please maintain additional rules for automatic clearing for account type K in OB74.

You can also use F-44 for vendor manual clearing.

Regards,

Kalim

former_member214904
Participant
0 Kudos

Dear Mr. Kalim

Do we update the account number in OB74?

Regards

Tarek

Former Member
0 Kudos

Hi Tarek,

Please maintain From acct - to account 1-999999999 for account type K in existing line.

Or Maintain a new account type K  from account to account 1-9999999999.

Hope this will resolve your issue.

Regards,

Kalim

former_member214904
Participant
0 Kudos

Dear Mr. Kalim

We have add the vendor number range in OB74.

During test run no error

but during PRD run below error is showing

Regards

Tarek

Former Member
0 Kudos

Hi Tarek,

I guess this is due to wrong input value in F.13.

Are you getting open item documents number during test run?

Regards,

Kalim

former_member214904
Participant
0 Kudos

Dear Mr. Kalim

No i am not getting any open item document number info during test run.

Regards

Tarek

Former Member
0 Kudos

Hi Tarek,

The F.13 program does not clear below lines.

  • Noted items
  • Statistical postings and certain special G/L transactions relating to bills of exchange
  • Down payments can only be cleared if down payment clearing items of the same amount have already been posted.
  • items with withholding tax entries

Please check your documents.

Regards,

Kalim

Answers (1)

Answers (1)

ravi_89
Participant
0 Kudos

Hi Tarek,

Please let me know the document type you are trying to clear?
In the above screen print I see document type "AB" and "RE" are they special GL transactions?

Regards,
Ravi Kumar Sinha

former_member214904
Participant
0 Kudos

Hi Ravi

After setting the range we have observed that this automatic clearing will clear the amount, which are same and matched or have below step.

1) Invoice amount BDT 50,000/-

2) Advance amount BDT 40,000/-

3) Rest payment BDT 10,000/-

(Mention by Mr. Kalim also)

But during year end closing time. User have no time to clear one by one vendor or customer by using F-44 or F-32. (if they have huge number of customer and vendor)

They want to clear advance with invoice and make the balance in one side of balance sheet not in the two side.

Can we do any thing in F.13 to clear all items of Advance with invoice and make residual amount either advance or payable or receivable?

Regards

Tarek H Chy