Skip to Content

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.

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