How to Enable Net Due Date and put a Count on Number of Items in FBL1N and FBL5N Transaction Code?

Introduction

Most of the SAP Customers use SAP to deal with Vendors and Customers. In order to check Vendor Balance and Customer Balance Transaction Code FBL1N and FBL5N is used regularly. This blog will cover the steps we can use to  Enable Net Due Date and put a Count on Number of Items in FBL1N and FBL5N Transaction Code.

Here are some other Blogs for these heavily used Transaction Code

How you can reduce some Clicks in FBL5N Transaction Code for Customer Balance

How you can reduce some Clicks in FBL1N Transaction Code for Vendor Balance?

How to Default Layout in FBL1N, FBL5N, FBL3N and FAGLL03 Transaction Code?

How to Add Payment Amount Field in FBL1N Transaction Code and how to Display the Technical Field name in Layout for better Search Capability

Solution

First we go to Transaction Code FBL1N.

Now we run with below parameters

In the Output we can see the Net Due Date. We would love to add this date in the Selection screen in order to filter Outstanding Payments

Now go to SU3 Transaction Code and add this Parameters Id FIT_DUE_DATE_SEL and put Value X and Hit Save

Now let us go to Transaction Code FBL1N. Wala the Net Due Date shows in the Selection Screen. This solution will reflect in FBL5N for Customers also.

Now we want to default the number of entries in both these Transaction Codes. We put a value of 333

Now we go to the following Transaction Code FBL5N.

Below you can see the count default to 333.

Conclusion

The above blog can be used in both SAP ECC and SAP S/4HANA

Below is the Video Version

Video Link for net due Date