on 01-16-2008 9:30 PM
We use F.27 to print out monthly account statements. However, we don't want the paper copy if the balance is $0.00. How can I block the printing of those statements?
Help would be greatly appreciated and points will be awarded for best AND helpful answers.
Bryan,
What type of Correspondence you are using. Ex: SAP06 which is Account Statement
If you are using any of them you need to specify the Variant for the Program which is attached to that Correspondence
for Standard SAP06 the program attached to that is RFKORD10 you need to create a variant with Balance in local Currency field <>0 this way it will pick only accounts where Account balance is not zero. but by doing this you will miss few accounts where there may be a transactions in period but balance is zero. If you intend to skip them then its fine.
Complete configuration will be available in SPRO--> Financial Accounting Global Settings --> Correspondence .
Thanks
Sivaram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Sivaram!
It looks like we're using the Correspondence type Y0013 with print program RFKORD11. When I drill down to the level you specified in SPRO and click on Create Report Variants for Correspondence, I can see the line for "Balance in local currency". I'm assuming that I would add an E (excluding) EQ (values equal to) from=0.
The point you brought up about statements that had activity on them but still had $0.00 balance is very good. I've sent the question to the people requesting the change. If they say that they do want those few accounts that had activity resulting in $0.00 balance, but don't want the inactive ones with a $0.00 balance, how would I specify that? Looking down the list a bit further, I saw the option of "Statement also w/o items" had an X in the in the "frm" field. Is that the correct field to change? Would it still show statements that had a balance greater than $0.00 but hadn't had any activity in that period?
Bryan,
1. About Statements with transactions and zero balance, if you want to exclude those you need to select option not equal to 0 ( not exclude 0). If you wan them too then you dont have to do any thing system will default include them. Try playing with different settings by running the report manually using SE38 or System>Services>reporting tab from any screen.
2. About Statements also w/o items field, if you check this mark system will print statements for all the customers irrespective of there transactions/balances.
Thanks
Sivaram
I may have confused myself, or I may just not understand how SPRO works. I changed the Balances to any that are not equal to $0.00 and saved it, but when I run the report through F.27, I still have both the zero and non-zero balances being printed out.
I did notice that when I got back into the "Create Report Variants for Correspondence", that the program in the text box had changed from RFKORD11 to RFKORK00. There are Y0013 Variants for both, but the one for RFKORD11 has many more options than the Y0013 for RFKORK00 and the one for RFKORK00 doesn't have the option of "Balance in local currency".
If I run RFKORD11 via SE38, I get the Balance option, but I'm not having any luck getting it to respond the way I expect. If I tell it to exclude balances greater than 0, it only shows the $0.00 statements (it does what I told it to do as a test, but I actually want the opposite of this). If I change it to exclude balances less than 1, it shows both zero and non-zero balance statements. If I tell it to select balances greater than 0, it still shows both types.
Am I missing something fundamental?
This is apparently a known issue with the programs RFKORD10 and RFKORD11. SAP Note 999507 covers this behavior. It says that "there is no check against the 'Balance in local currency' selection if no items were found". The solution is to import the support package SAPKH60008 for SAP_APPL.
Thanks for at least getting me into the correct area, Sivaram!
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.