Skip to Content
Author's profile photo Ravi Sankar Venna

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.

File1.png

You are required to visit SU3 in order to change your user parameters.

File2.png

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:

File3.png

Click on Save Button in order to save the changes.

Now please go to FBL1N or FBL5N and check the selection screen.

File4.png

File5.png

Now, you will see the “Net Due Date” field as one of the “Selection Parameter” on FBL1N and FBL5N.

Assigned Tags

      99 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      In simple excellent..

      Thanks...

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Jaymin.

      Author's profile photo Hidyath pasha
      Hidyath pasha

      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

      Author's profile photo Ramnik Ruprai
      Ramnik Ruprai

      Hi Hidyath,

      You can go to Tcode FB00 and then go to tab line items and select " Selection by due date"

      Capture11.JPG

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      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

      Author's profile photo Prasad Tatikonda
      Prasad Tatikonda

      Good Ravi,

      This simple trick will help users to get Net due date on selection screen.

      Kind Regards,

      Prasad

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thank you Prasad 🙂 much appreciated your comments.

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Thanks Ravi.

      Author's profile photo Former Member
      Former Member

      Good one Ravi. thanks for sharing.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Vausdev 🙂

      Author's profile photo Diwa p
      Diwa p

      Good Ravi

      thanks for information

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Diwa.

      Author's profile photo Former Member
      Former Member

      Thanks Ravi...

      Knowledge is divine

      Satya...

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Satya 🙂

      Author's profile photo Murali Babu Nallamothu
      Murali Babu Nallamothu

      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Murali for the update and sharing. 🙂

      Kind Regards,

      Ravi

      Author's profile photo veenu gulati
      veenu gulati

      Ravi,

      Thanks for sharing. Its really helpful.

      Regards

      Veenu

      Author's profile photo Ranu Eugene
      Ranu Eugene

      Hi Murali,

      Thanks for the information.

      Best of Luck. 🙂

      Regards

      Eugene

      Author's profile photo Former Member
      Former Member

      Valuable Information. Many Thanks.

      Best Regards,

      Naresh K.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Naresh. 🙂

      Best Regards,

      Ravi

      Author's profile photo Nakula Charan Das
      Nakula Charan Das

      Thanks Naresh

      Regards

      Nakul

      Author's profile photo Former Member
      Former Member

      Awesome..

      Cheers!!

      Irene

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Irene

      Author's profile photo Erwin Leitner
      Erwin Leitner

      Hello Ravi!

      Many thanks for valueable information.

      thanks for coaching lesson to the "SAP youngsters" like me. 🙂

      all the best Erwin

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author
      Thanks Erwin much appreciated your comments.
      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author
      Thanks Vijay.
      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author
      Thanks Vijay.
      Author's profile photo Former Member
      Former Member

      thanks for the valueable information.

      regards,

      Vijay

      Author's profile photo Eduardo Rezende
      Eduardo Rezende

      Good document Ravi!

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author
      Thanks Eduardo
      Author's profile photo Ramnik Ruprai
      Ramnik Ruprai

      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.

      Author's profile photo Erwin Leitner
      Erwin Leitner

      Hello,

      Thank you.

      Until now never heared abbout IVFIDISPLAY.

      Anyway excellent hint, found further information on WIKI page.

      thank you,

      all the best Erwin

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author
      Thanks Erwin for your comments.
      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author
      Thanks Ramnik for the tip. 😉
      Author's profile photo Former Member
      Former Member

      Ravi,

      other options is transaction FB00, in tab "Line Items":

      - mark "Selection by Due Date".

      Net due date is visible now.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author
      Thanks Claudio
      Author's profile photo Former Member
      Former Member

      Hearty Congratulations Ravi Sankar Venna SCN Topic Leader 2012-2013. Kudos on your outstanding accomplishment.

      Best Regards,

      Naresh K.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thank you Naresh, much appreciated your constant encouragement.

      I sincerely thank you for your wishes.

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Hi,

      Really its simple  and superb method ,thanks a lot for 🙂

      regards

      RK

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Rajesh, much appreciated.

      Author's profile photo Charmaine Martin
      Charmaine Martin

      Thanks for sharing this unique solution, which is actually also very simple to deliver.

      Regards,

      Charmaine Martin

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Charmaine for your comments.

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Hi

      Simple and good trick it will help end users ...........:) 🙂

      Regards

      Praveen P C

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Praveen 🙂

      Author's profile photo Former Member
      Former Member

      You are excellent Ravi 🙂

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Rouissi 🙂

      Author's profile photo Srinivas Salpala
      Srinivas Salpala

      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      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

      Author's profile photo Srinivas Salpala
      Srinivas Salpala

      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      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

      Author's profile photo NARRA LINGESH
      NARRA LINGESH

      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.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Lingesh, much appreciated your comments. 🙂

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author
      Open items will not have cleared items and clearing document numbers how uou sre getting
      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      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?

      Author's profile photo Former Member
      Former Member

      Hi,

      Even we are confused how its possible .

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      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?

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      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?

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Former Member
      Former Member

      Hi Ravi,

                        its very useful,,,, thanq.. you very much

      Regards:

      KiranReddy

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thank you Kiran, much appreciated your comments.

      Kind Regards,

      Ravi

      Author's profile photo Manjunatha Kanakuppi
      Manjunatha Kanakuppi

      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 🙂 🙂

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Manjunatha for your comments. 🙂

      Best Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      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

      Author's profile photo Former Member
      Former Member

      very good information bass

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Soma Sundhar 🙂

      Author's profile photo Former Member
      Former Member

      Hello Ravi,

      Thank you very much. Very useful!

      Regards,

      Leelendra

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thank you Leelendra.

      Kind Regards,

      Ravi

      Author's profile photo Ranu Eugene
      Ranu Eugene

      Hi Ravi,

      Thanks a lot for such a valuable info. 🙂

      Waiting for more from you. 🙂

      Best of luck. 🙂

      Regards

      Eugene

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thank you Eugene 🙂

      Kind Regards,

      Ravi

      Author's profile photo Sanil Bhandari
      Sanil Bhandari

      Excellent Info

      Regards

      Sanil Bhandari

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Sanil 🙂

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Hidden treasure 😉 ..... Your presentation is good....

      Author's profile photo Sampat Kumkar
      Sampat Kumkar

      Hello Ravi

      So nice and useful info.

      Thanks for sharing.

      Regards

      Sampath

      Author's profile photo Vinod Vemuru
      Vinod Vemuru

      Good one Ravi. Short n simple 🙂

      SAP always has depths to go n explore...

      Thanks,

      Vinod.

      Author's profile photo Former Member
      Former Member

      Thanks Ravi for your valuable inputs 🙂 🙂 🙂

      Regards,

      Rajendra

      Author's profile photo Sapan Agarwal
      Sapan Agarwal

      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 ??

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      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

      Author's profile photo Sapan Agarwal
      Sapan Agarwal

      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..

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      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

      Author's profile photo Manohar Gowri Shankar
      Manohar Gowri Shankar

      Hi Ravi,

      Good information shared by you.

      It helps users to perform their activities fast.

      Author's profile photo Sapan Agarwal
      Sapan Agarwal

      It is good to know,I am planning to implement this setting for my client

      Author's profile photo sreehari tokala
      sreehari tokala

      Thank you very much sir. it's very simply and Excellent information.

      Thanks & Regards,

      Sreehari.

      Author's profile photo Ajay Maheshwari SAP Trainer
      Ajay Maheshwari SAP Trainer

      Simple and useful trick!!

      Thanks Ravi

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Ajay.

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Hi Ravi,

      thats great, txs a lot.

      Best regtards, Christian

      Author's profile photo YOGESH KSHATRIYA
      YOGESH KSHATRIYA

      Simply Awsm... Tnx... 🙂

      Author's profile photo sreehari tokala
      sreehari tokala

      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.

      Author's profile photo Former Member
      Former Member

      Though both of the ways result in the same output, this is more simpler and functional in nature. Nice tip Sreehari !

      Author's profile photo Lakshmi Sama
      Lakshmi Sama

      Hi Sreehari,

      I have tried this and it is working fine. Thanks for sharing.

      Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      Thanks Ravi for sharing the useful tip.

      Thanks Sreehari, I tried your suggestion and it worked. 

      Regards

      Ram Vusirikala

      Author's profile photo Srinu S
      Srinu S

      Hi Ravi,

      Valuable document shared. thanks for sharing.

      Srinu. 🙂

      Author's profile photo Lakshmi Sama
      Lakshmi Sama

      Hi Ravi,

      Nice technique! Thanks for sharing.

      Best Regards,

      Lakshmi S

      Author's profile photo Michael Turner
      Michael Turner

      Good info.   Thanks.

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Raj A
      Raj A

      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!

      Author's profile photo Former Member
      Former Member

      Thank you so much sir, Very nice one many users liked it. Thanks for sharing your thoughts.

       

      Thanks,

      Chandra B