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.