on 12-09-2014 7:42 AM
Hi Expert,
i have EBRS confing but while run FF_5 getting error, see the step one by one
Testing
Here I have Bank details statement for the same as well MT940.
Now MT940 Bank statement
Now , while reconciliation through FF_5 getting error
Kindly help where i have done miss in config.
kind regards
Pranav Kr. Gupta
Hi,
Share the screen shot of the error message.
Regards,
Mukthar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes sir,
I have defined Posting Rule for Deposit Check 1001 and issued for 1002, but here i have taken only 1001 , we dont have issued check that's why i assign Posting rule 1001 with External Transaction type based on MT940 i.e FMSCM
:61:1409240924CR70000,00FMSCM128075//
See the screen shot below
And assign the transaction type MT940
kindly help sir,
Thanks
Pranav Kr. Gupta
Hi ,
if you see your FEBA system is pickingSAW external transaction type and in your another SCreen where you have define the external transtion type I canot see SAW.
So please define all posibble External transaction and mapped them with Posting rules . Bank will give list of posting poosting
You need to defined them all .
Hi ,
If you see in Your screen shot if FEBA you have transaction SAW and i can see in your defination of Transaction type you havenot define that SAW transaction . Please define that full list of esternal transatcion type given bye bank
More or less its look that you have created these External Transaction . Please ask your Bank they should Provide you .
and there are lots of good docuemnt on SCN to help you in Config of bank statement .
many Thanks
You only mapped to + what about -
if tomorrow there is a payment made with these external transaction, you should also map them to - and give the relevant posting rules against it. Otherwise, it would show as unallocated.
Create Y+ and Y- type posting rules for allocated and map the as follows:
UNALLOCATED | + | Y+ | 0 000: No interpretation | 0 Dummy entry - not assignable | |
UNALLOCATED | - | Y- | 0 000: No interpretation | 0 Dummy entry - not assignable |
Sir,
In FEBA based on MT940 format External transaction was given in statement
20:14092500001
:25:102102000006439
:28C:00002/1
:60F:C140924INR3755539,98
:61:1409240924CR10000,00FMSCM135250//
:86:SAWAI MADHOPUR :- CASH RECEIPT AABCE5025H
:61:1409240924CR70000,00FMSCM128075//
:86:PUNE-HADAPSAR :- CASH RECEIPT AABCE5025H
:61:1409240924CR3000,00FMSCM55957//
:86:P H BODAS MIRAJ BRANCH :- CASH RECEIPT AABCE5025H
:61:1409240924CR10000,00FMSCM123053//
:86:EB04903 JAMSHEDPUR-SAKCHI BRANCH :- CASH RECEIPT AABCE5025H
:61:1409240924CR18000,00FMSCM106229//
:86:RAIGAD - KARJAT :- CASH RECEIPT AABCE5025H
:61:1409240924CR5000,00FTRF0009718711//
:86:INET/0898104000019390To102102000006439/ 74550905
i m also confuse in External transaction type why system pick SAW which is reflected in MT940 format statement , while i have only one External transaction type as you seen in statement i.e FMSCM.
Kindly let me knw .
Thanks
Ptranav kr. Gupta
I can clearly see your external transactions are wrong.
For example it should be only four digits which is FMSC
should not be FMSCM.
It should only be four digits mentioned in the 61 line.
Furthermore you should also map it to + posting rule as well as - posting rule.
Please make the said changes it should work.
Der Ravi sir,
Even i maintain the same for Deposit and issued check, i ve made the two posting rule i.e 1001 for Check deposit and 1002 for Check issued ,
see the screen shot below.
same message coming after execute FF_5
first giving the waring information wen i press enter
Now above screen last time after correct the External Transaction based on MT940 statement.
as u said 4 digit FMSC and given Posting Rule for both 1001 + and 1002 -..
kindly help.
Kind regards
Pranav Kr. Gupta
Hi,
Your format is MT940 unstructured. Since the program is picking external transaction code in row :86:, I think you are launching the program with parameter S (SWIFT MT940 with field 86 structured).
You should use I (SWIFT MT940 international format (field 86 unstructured)).
The external transaction codes will be picked from row :61: (FMSC, FTRF, ...)
Dear Henri Sir,
Thanks problem resolve but few items still open i am doing one by one through FEBA after select the item system automatiaclly goes for open item processing, see the screen shot
ANd posted document FBL3N Main Bank Account. screen shot
Kindly advice wht should i do next for resolve the same ,
Kind regards
Pranav Kr. Gupta
Thanks Ravi sir,
problem resolved now.
yes just now i checked the Customer Invoice was not there that's why system didnt find any relevent against Payment clearing account as well Customer Invoice ,
but i don knw the marks point n all. anyways from my side you and Henri sir has has given the relevent answer.
Thanks a lott...
Kind regards
Pranav Kr. Gupta
Hi Mary,
There are number of documents posted on SCN around this area.
Hopefully, the following link would be helpful to you.
Hi Mary,
In which system are trying to load this statement? Is it Production or Quality?
You are trying to load the same statement, that is the reason system is not allowing you to load again as a precautionary check.
You can delete the bank statement by using the program RFEBKA96 in SE38 (you need to uncheck other bank statement and only select this bank statement). Otherwise, there is a chance to delete other statement.
This would only delete sub-ledger bank statement, but not the GL postings already made.
However, this would allow you to reload the statement again in FF_5
HI Pranava,
We are unable to see the error details so requesting you to please post the error details.
Thanks & Regards,
Lakshmi S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
102 | |
12 | |
11 | |
6 | |
6 | |
4 | |
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.