on 08-28-2013 8:59 AM
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
hi Prabin,
The external transaction HEC MC is not configured in your system. Please maintain the same. it should work.
thanks
Vasu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
hi Marssel
thanks for response. that issue has solved. but i am getting one error "
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
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.