cancel
Showing results for 
Search instead for 
Did you mean: 

Following entries missing in table T028G, bank statement is not updated.

Former Member
0 Kudos

Dear All expert,

Please help me in this regard, when i am importing the multicash format for EBS , i am getting this below error.

While importing electronic bank statement, the system determ

that not all external transactions (business transaction cod

text keys, or posting texts) were in

table T028G.

Enter the transactions in table T028G.

Afterwards, start the processing again.

Following entries missing in table T028G:

TransTyp External transaction        +- Bank Key        Bank Account       Shrt key St no MR no Text

MC       HEC                         +  HDFCCA06721     561238006721            220     4     1

Thanks & Regards

Prabin

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

hi Prabin,

The external transaction HEC  MC is not configured in your system. Please maintain the same. it should work.

thanks

Vasu

Former Member
0 Kudos

Dear Vasu,

thanks for the response.

I have maintained HEC and MC in the OT83 already.

actually i have been frequently changing external transaction in the bank file  UMSATZ.TXT, is that the reason this error is coming.

should i or should not i change the file UMSATZ.TXT frequently ? here i am little confuse .

on which field the external transaction code should be maintained, because actually now i am testing for the first time so the file which the bank is producing is only for testing. so i do not know which value should be maintained in which field in the bank file.

i got information in the SCN search that external transaction should be maintained in the column No. 34, so in the bank file it is not maintained in column No.34, even i have maintained but same error.

One more doubt is in which column in the bank file UMSATZ.TXT document number or document reference number should be maintained so that it should clear customer.

actually we initially going for only customer payment clearing , so only customer payment statement uploading and our requirement is all customer payment should clear.

so how system should clear the customer as a whole not at open item basis , because bank has told us that only customer will be credited and bank will be debited when i upload, such a way one entry will be passed for the payment but open item in the customer should be clear manually.

so how sytem will find the customer and post. even i have maitained the customer code.

So in which field, the customer code and external transaction code should be maintained, here i am very much confused.

kindly help me in this regard

thanks

Prabin

Former Member
0 Kudos

hi Prabin, It could be silly of me to suggest, but hope you have maintained both + and - config for the above.

and all the clearing instructions should be stored in Note to payee fields.

thnx.

Former Member
0 Kudos

Dear Vasu,

Thank you very much for giving suggestion.

As you know that i am clearing the customer payment only, so as per the banks instruction that it will not clear the open item stands in the customer, but only one entry is to be get generated as and when i upload the file. later on i have to clear the open item one by one manually against the payment get entered through upload of file.

entry is like that :  Bank A/C Dr.

                              to Customer A/C Cr.

now my query is  which interpretation algorithm to be selected in the configuration.

previously i was set up only - sign, now after your suggestion i made + sign against each external transaction code and previous error has gone but i am getting one new error  " ERROR : (F5 263 ) THE DIFFERENCE IS TOO LARGE FOR CLEARING"

for your kind information , i only created one customer and one invoice with the same amount which i mentioned in the file. i mean there is no difference in the amount at all.

but when i provide + sign for each external transaction code, this above error is coming.

one more thing, in the posting rule i have made setting like below , please suggest me if i am wrong:-

posting area 2 for subledger accounting

for Debit posting key 40 account symbol vtlc is assigned

for Credit posting key 50 account symbol is not assigned

and posting type 8 has taken

Thanks & regards

prabin

Marssel700
Active Contributor
0 Kudos

Prabin,

I assume your T028G request is clear. In order to define algorithm you have to define according you field for selection in the invoice.

Please check below link and define the algorithms in OT51.

Interpretation Algorithms (SAP Library - Electronic Account Statement (FI-BL))

Regards

Former Member
0 Kudos

hi Marssel

thanks for response. that issue has solved. but i am getting one error "

Customer * is not defined in company code VTXL" .

when i going through FEBA tcode then in the customer field is getting star mark but where as i provided the customer code in the note to payee field in the uploading file.

and one more query is, i am not getting any standard interpretation algorithm for finding out the customer number and post to the customer. but there is so other algorithm for document number search, reference number search, cheque number search.

my requirement is not to clear the customer open item on the basis of document number search. only customer has to credited on account with the amount which is in the multicash bank file and bank has to be debited. Later on open item is to be clear manually.

so is there any interpretation algorithm for on account posting to customer or if it is not there can i create interpretation algorithm.

how to create just tell me

thank

prabin Kumar