on 05-27-2015 12:44 PM
Dear Expert,
In standard SAP when we reverse the KZ document it generates KA document. We can also post KA document by FB01 directly & reversal of KA document is also KA.
Now the issue is how to identify payment reversal(KZ) in FBL1N report?
Regards,
Saurabh Chaplot
Hi Saurabh,
I assume that the number ranges for KA and KZ document type are different.
Lets say the number ranges are as follows;
KZ - 1900000000 to 1999999999
KA - 1100000000 to 1199999999
To find out the KA documents which are the reversals for KZ, go to table BKPF.
Give the company code, fiscal year and document type KA.
In the field BKPF-STBLG, give 19* and it will give you all the documents which are reversals for KZ document type.
Thanks and Regards
Aman Goel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
you check with the accounting entry when you reverse the document vendor will be debited so you can check with the debit balance of the vendor instead searching for the document type
hope this will help you
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.
Hi,
You can use substitution to post some comments on the header text (or other field) of payment reversal documents to distinguish.
BR//Calvin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Saurabh,
You can sort and sub-total the clearing document in FBL1N. The payment document and it reversal will have the same clearing document no.
Or you you filter posting key 25 and 35. Posting 35 is the reversal of payment posting key 25.
regards,
Jack
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Saurabh,
To make it easy, create a new document type (oba7) with an ID of your choice (may be ZK) and assign it to the KZ as a reversal document. By doing so, identifying a future reversal document is simplified. Good luck.
Regards,
Sam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What You can do is ;
IMG-->Financial Accounting (New) -->Accounts Receivable and Accounts Payable --> Vendor Accounts --> Line Items --> Display Line Items --> Define Additional Fields for Line Item Display.
Table Filed Name
BKPF XREVERSAL
BKPF XSTOV
Save it and It will Create Workbench Request.
Then In FBL1N, You will get this Two Option is in Change Layout .
You will get Reversal Indicator, like 1 , 2 .
Another Option, What i did, I am using Document RD for all reversal. So Whereever You can see RD., it mean its a reverslal.
These are the Two option, i am Using.
Regards
Shinas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
You can check the columns of Clearing documents.. if you see on the same row that the KZ document which in standard SAP has number interval start with 15000 has a clearing document of document No. 17000 which is the number interval of KA document.. this means that this document has been reversed.
Or you may refer to the below thread which will hows you how to add special fields in FBL*N report .. there are Reverse With ( Field STBLG in Table BKPF) Field you can add it to reports to shows you what is the reversed document and its reversal document no.
Regards
Mahmoud EL Nady
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.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
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.