How to add net due date as selection criteria in Line Item Reports?
There is always a requirement to get the line items between a due date when executing FBL1N and FBL5N. But, surprisingly, this is not available either in the dynamic selection or the selection screen. Screen shot of FBL1N is shown below (before making the trick). However, a small trick will fetch the “Net Due Date” field as one of the selection parameters on the above mentioned transaction codes. This would help the users to get the open items which are due between certain net due dates.
You are required to visit SU3 in order to change your user parameters.
Go to “Parameters” Tab and scroll down further to enter the last line. Please enter FIT_DUE_DATE_SEL as the parameter ID and parameter
value as “X”.
After entering, please press “X” on your key board. Then the screen should look appear as follows:
Click on Save Button in order to save the changes.
Now please go to FBL1N or FBL5N and check the selection screen.
Now, you will see the “Net Due Date” field as one of the “Selection Parameter” on FBL1N and FBL5N.
In simple excellent..
Thanks...
Thanks Jaymin.
Hi Ravi Sir,
we are trying update the net due fields in FBL1N but its not happening
as you have mention above method still no luck can you please advice us .
Regards
Hidyath
Hi Hidyath,
You can go to Tcode FB00 and then go to tab line items and select " Selection by due date"
Hi Hidyath,
This is not to update the due date fields.
This is to get the selection parameters option on line items report.
Alternatively, you could also follow the suggestion given by Ramnik Ruprai
Kind Regards,
Ravi
Good Ravi,
This simple trick will help users to get Net due date on selection screen.
Kind Regards,
Prasad
Thank you Prasad 🙂 much appreciated your comments.
Kind Regards,
Ravi
Thanks Ravi.
Good one Ravi. thanks for sharing.
Thanks Vausdev 🙂
Good Ravi
thanks for information
Thanks Diwa.
Thanks Ravi...
Knowledge is divine
Satya...
Thanks Satya 🙂
Hi Ravi,
Thanks for the information.
The other way to activate net due date field is
FB00 > Line Items > Selection by Due date.
Rgds
Murali. N
Thanks Murali for the update and sharing. 🙂
Kind Regards,
Ravi
Ravi,
Thanks for sharing. Its really helpful.
Regards
Veenu
Hi Murali,
Thanks for the information.
Best of Luck. 🙂
Regards
Eugene
Valuable Information. Many Thanks.
Best Regards,
Naresh K.
Thanks Naresh. 🙂
Best Regards,
Ravi
Thanks Naresh
Regards
Nakul
Awesome..
Cheers!!
Irene
Thanks Irene
Hello Ravi!
Many thanks for valueable information.
thanks for coaching lesson to the "SAP youngsters" like me. 🙂
all the best Erwin
thanks for the valueable information.
regards,
Vijay
Good document Ravi!
Thanku so much for a wonderful trick Ravi Sankar. Didnt knew that we can change the selection parameters just by adding a new user parameter.
Just to add, we can also use parameter IVFIDISPLAY to display MM and FI document number together during MIRO Posting.
Hello,
Thank you.
Until now never heared abbout IVFIDISPLAY.
Anyway excellent hint, found further information on WIKI page.
thank you,
all the best Erwin
Ravi,
other options is transaction FB00, in tab "Line Items":
- mark "Selection by Due Date".
Net due date is visible now.
Hearty Congratulations Ravi Sankar Venna SCN Topic Leader 2012-2013. Kudos on your outstanding accomplishment.
Best Regards,
Naresh K.
Thank you Naresh, much appreciated your constant encouragement.
I sincerely thank you for your wishes.
Kind Regards,
Ravi
Hi,
Really its simple and superb method ,thanks a lot for 🙂
regards
RK
Thanks Rajesh, much appreciated.
Thanks for sharing this unique solution, which is actually also very simple to deliver.
Regards,
Charmaine Martin
Thanks Charmaine for your comments.
Kind Regards,
Ravi
Hi
Simple and good trick it will help end users ...........:) 🙂
Regards
Praveen P C
Thanks Praveen 🙂
You are excellent Ravi 🙂
Thanks Rouissi 🙂
Hi Ravi,
I think you are spending a lot on forums rather than your personal life. New learners are always thankful to your posts and blogs.
Keep sharing!!!
BR, Srinivas Salpala
Ha ha ha ha. I am yet to start my new contracting, hence finding more time to be on SCN.
Hope I carries the same way in future. 🙂
Kind Regards,
Ravi
That sounds great Ravi.... Many of our forum-mates remember you and Ajay Maheshwari for your exceptional contribution. To my knowledge you both really love to share whatever you know.
I have seen many people with brilliant knowledge, but sharing knowledge needs lot of patience like both of you!!!
BR, Srinivas Salpala
Thanks Srinivas, it is really pleasure receive such honest comments.
I admire your contributions in CO area, keep up your high spirits. 🙂
Congrats for achieving Top Contributor Award, well done. 🙂
Kind Regards,
Ravi
Hi Ravi,
Yeah....Mr Srinivas is right......this is very helpful to New learners like me...we always thanks to your posts and Blogs....
Regards,
Lingesh.
Thanks Lingesh, much appreciated your comments. 🙂
Kind Regards,
Ravi
Hi Ravi,
Its really good we tried in FBL5N when we gave net due date and we select the all open items to pull the reports its showing along with clearing document number also can you please advice us ,we want to view only net due date report not with clearing documents
thanks
Hi,
when we are using FBL5N T code when we click open items with net due date system is pulling along clearing document please help Ravi.
thanks
Hi Rajesh,
I do not get how you are getting clearing document number for an open item. Please only select the open items on the selection screen, open items never will have a clearing document number. Have you done any residual payments?
Hi,
Even we are confused how its possible .
Hi Rajesh,
I do not get how you are getting clearing document number for an open item. Please only select the open items on the selection screen, open items never will have a clearing document number. Have you done any residual payments?
Hi Rajesh,
I do not get how you are getting clearing document number for an open item. Please only select the open items on the selection screen, open items never will have a clearing document number. Have you done any residual payments?
Hi Ravi,
Its really good we tried in FBL5N when we gave net due date and we select the all open items to pull the reports its showing along with clearing document number also can you please advice us ,we want to view only net due date report not with clearing documents
thanks
Hi Ravi,
its very useful,,,, thanq.. you very much
Regards:
KiranReddy
Thank you Kiran, much appreciated your comments.
Kind Regards,
Ravi
Whenever you come with a document ,replies or even Comments it will be awesome....May be its also one of that.............Thanks for sharing it too 🙂 🙂
Thanks Manjunatha for your comments. 🙂
Best Regards,
Ravi
Hi Ravi,
Really very very useful information for people like us. Now a days I am eagerly looking for the article done by you. As requested by me on yesterday please keep sharing your knowledge for us. Also if possible please share me the link if you have for
Integration between FI-MM & FI-SD
Validation & Substitution
Regards,
Ramakrishnan
Hi Rama,
Thanks for your comments.
If you search in with the above words, there are number of documents with screen shots. Due to forum rules, I cannot give the links related outside SCN. I am sure you will find good documents on this subjects.
Best Regards,
Ravi
very good information bass
Thanks Soma Sundhar 🙂
Hello Ravi,
Thank you very much. Very useful!
Regards,
Leelendra
Thank you Leelendra.
Kind Regards,
Ravi
Hi Ravi,
Thanks a lot for such a valuable info. 🙂
Waiting for more from you. 🙂
Best of luck. 🙂
Regards
Eugene
Thank you Eugene 🙂
Kind Regards,
Ravi
Excellent Info
Regards
Sanil Bhandari
Thanks Sanil 🙂
Kind Regards,
Ravi
Hidden treasure 😉 ..... Your presentation is good....
Hello Ravi
So nice and useful info.
Thanks for sharing.
Regards
Sampath
Good one Ravi. Short n simple 🙂
SAP always has depths to go n explore...
Thanks,
Vinod.
Thanks Ravi for your valuable inputs 🙂 🙂 🙂
Regards,
Rajendra
Thanks Ravi for sharing the document.
Can we list down the benefits of the same ??
I could list down one of the same as :
1) while doing the payment run using F110, we have an option of checking what all is due between "posted upto date" and "next payment run date" for Vendors as well as customer
Theoretically it could help us to plan our cash flows too.
What else could be the benefits of having Net Due date in selection screen ??
Hi Sapan,
The main purpose of net due date on vendor line items is, you can identify the cash outflows and forecast the cash outlay for future periods / days.
Best Regards,
Ravi
Thanks Ravi..
One more query, as this setting is at user level..
Is there any way that we can implement this setting for all the users for a particular company code or any other criteria
I think We need to consult the Security consultant for the same..
Hi Sapan,
If the it is required for everybody in your company, then security team should be able to copy the parameters to all the users by using SU10.
Regards,
Ravi
Hi Ravi,
Good information shared by you.
It helps users to perform their activities fast.
It is good to know,I am planning to implement this setting for my client
Thank you very much sir. it's very simply and Excellent information.
Thanks & Regards,
Sreehari.
Simple and useful trick!!
Thanks Ravi
Thanks Ajay.
Kind Regards,
Ravi
Hi Ravi,
thats great, txs a lot.
Best regtards, Christian
Simply Awsm... Tnx... 🙂
Hi Ravi sir,
thank you for your valuable information and we have another way to get Net due date selection criteria in reports
Go To FB00 T.Code
Go To Line items Tab
Select Selection bye Due Date
Save--> Enter
Now Go To FBL1N/5N we can see the Net due date selection cafeterias.
Thanks & Regards,
Sreehari.
Though both of the ways result in the same output, this is more simpler and functional in nature. Nice tip Sreehari !
Hi Sreehari,
I have tried this and it is working fine. Thanks for sharing.
Regards,
Lakshmi S
Thanks Ravi for sharing the useful tip.
Thanks Sreehari, I tried your suggestion and it worked.
Regards
Ram Vusirikala
Hi Ravi,
Valuable document shared. thanks for sharing.
Srinu. 🙂
Hi Ravi,
Nice technique! Thanks for sharing.
Best Regards,
Lakshmi S
Good info. Thanks.
Hi Ravi.
This is so usefull. Thank you so much.
But I would really love to add document reference to my selection to. I know i kan find it in the dynamic selection, but I use it all the time, and it would be so easy to have it rigth in the front as a selection. Is it posible, and how?
Hope to heare from you soon.
Best
Rikke
Thank you very much. Each time I learn something new in SCN. Simply would like to say without o SCN, mentors' and experts, i would not have learned SAP FI with passion. Thanks Ravi.. Learned something new today!
Thank you so much sir, Very nice one many users liked it. Thanks for sharing your thoughts.
Thanks,
Chandra B