on 08-17-2010 6:57 AM
Dear All,
While executing Tcode F-58 (Payment With Printout ...) , it's printing cheks with chek no and other payment details and generates Payment Document.
Now in Payment Document , Assignment filed it's updating some no. like 20100811....
Insted of this no. , i want to update Chek No.
Is it possible. If yes , pl suggest me how to do it.
Regards
Swati
Hi,
Check Printing is a Standard process by using F-58 for creating payment document. FBZ5 is for printing Old Check and Payment document already created,.
Now, the issue which you are facing is due to PAYR not getting updated when you are posting from F-58 and the Code where u are fecthing the Details is returning sy-subrc EQ 4.(you cna check this in Debug)
The Solution for this is as below.:
When a program is called there exist a Perform and it is called in 3 Different ways is driver program (RFFOUS_C).
PERFORM scheckinfo_speichern using 1.
PERFORM scheckinfo_speichern using 2.
PERFORM scheckinfo_speichern using 3.
If you go through it, you will come to know that PAYR is getting updated after this perform and where as you will find the OPEN_FORM, WRITE_FORM and other required SAP script program is already written above it. Hence the Check no is not update and not displayed in output.
You have to copy the Standar program (which u might have done) in that Include name RFFORI01.
Change the Sequence of SAP Script window calling program after this perform. you would see the Check Number prineted in you output.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Access SPRO>Financial Accounting (New)>General Ledger Accounting (New)>Master Data>Line Items-->Define Special Fields for Line Item Display
Here add PAYR table and CHECF filed. With this the line item display populates the check number in FBL3n.
For populating this for Vendor and customers you need to add the same at the respective fileds.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Swati,
The payment document does not store the cheque number. The cheque details are stored in the table PAYR while other details of the document is stored in BKPF,BSEG,BSIS,etc. PAYR table is linked with the BSEG through Company Code, Document No.,etc.
Since payment document doesn't store the cheque no. the Assignment field of the document gets filled up with the sort key of the Bank A/c GL which is in your case might be document or posting date.
Since there is a need to have the cheque number in Assignment field for BRS purposes, it can be done through executing program RFCHKU00 (T code FCHU) which gives option to transfer the cheque no. to some target fields.
Hope it will be helpful for your understanding.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Swati,
If you have posted a payment document through F-58 and you want to check the check number against the same then goto Document display enter the payment document number and then goto enviornment and check information.
You can see the check number here if a number exists over here then the same will get updated in the Assignment Field through T-Code FCHU.
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Run tcode FCHU.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
WHile FCHU, it's giving error
No check which could be assigned to a document was found
Message no. FS321
I have given input of Company Code , House Bank, Account Id, Chek Number, Document No. and Assignment (as a target field)
Anything else do i have to give.
I am giving correct chek no. i.e i can see in chek register (FCHN)
But in FCHU, it;s giving error
Regards
Swati
This is the posting date coming due to the sort key assigned to the gl master.
There is no sort key for check no., so you need to put that manually in F-58 processing or have to write a substitution in OBBH.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
FCHU allocates the check numbers only when the check number allocation has not already carried out. For eg. manual checks, whose reference is not in the Payment document. If you have already created the reference (in your case, it is true) from transactions like F-58, this program cannot allocate.
The check should be allocable in the check lot for this program to work.
We had done this allocation of check number in Assignment field before but it was long back and I dont remember exactly what we did. I'll post once I remember.
Ravi.
Hello Gaurav,
I know how to use Substitution defination. But here , i want to add new table with New fields.
i.e Chek No. filed (Field name is CHECT) from Table PAYR. So how to Add table and Filed in OBBH.
In OBBH , It's giving three table like BKPF, BSEG, SYST and giving respective fiedls from table.
Now i want field of chek no (CHECT) from table PAYR. So it should give me table in OBBH.
How to add table in OBBH
Regards
Swati
Hello Gaurav,
I know how to use Substitution defination. But here , i want to add new table with New fields.
i.e Chek No. filed (Field name is CHECT) from Table PAYR. So how to Add table and Filed in OBBH.
In OBBH , It's giving three table like BKPF, BSEG, SYST and giving respective fiedls from table.
Now i want field of chek no (CHECT) from table PAYR. So it should give me table in OBBH.
How to add table in OBBH
Regards
Swati
Hi,
You can write the substitution as below:-
Step 1:-
Go to transaction GGB1 and create the substitution step at line item level in Financial Accounting as below:-
Pre Requisits:-
BKPF-TCODE = 'F-28'.
Substitution:-
Create a exit code using user exit.
For this take the help of ABAPer and create a copy of the program RGGBS000 and code your logic to pick from PAYR here and assign to the application area GBLS in view V_T80D via transaction code SM30.
Step 2:-
Please also check that this validation has active status (Status=1) at line line item level (level 2) for your company code in transaction OBBH.
Regards,
Gaurav
User | Count |
---|---|
92 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
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.