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.

To report this post you need to login first.

98 Comments

You must be Logged on to comment or reply to a post.

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

        (0) 
  1. 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.

    (0) 
    1. 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

      (0) 
  2. 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

    (0) 
      1. 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

        (0) 
        1. Ravi Sankar Venna 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

          (0) 
      1. Ranjeet singh

        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

        (0) 
            1. Ravi Sankar Venna 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?

              (0) 
            2. Ravi Sankar Venna 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?

              (0) 
            3. Ravi Sankar Venna 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?

              (0) 
      2. Ranjeet singh

        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

        (0) 
  3. Ramakrishnan Shanmugam

    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

    (0) 
    1. Ravi Sankar Venna 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

      (0) 
  4. 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 ??

    (0) 
    1. Ravi Sankar Venna 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

      (0) 
      1. 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..

        (0) 
        1. Ravi Sankar Venna 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

          (0) 
  5. 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.

    (0) 
  6. Rikke Schweitz

    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

    (0) 
  7. 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!

    (0) 

Leave a Reply