Skip to Content
Author's profile photo Former Member

Customizing Header rows in Standard reports like FBL1N, FBL3N & FBL5N

Hi All, This is a small attempt at helping to change the header rows in above standard reports.

Its a very minor change but ignored many a times. Hope this will be helpful to the new guys in FICO.

By default the report will show the output like below for open items in FBL1N. Here you will not have information like the report generation date or open items date which based on which the report is generated. These are important information for any financial information if you print the data or send out to someone.

fbl1n_1.JPG

There is a option to customize this to business needs. For ex to include report generation date and Open item as of date, please follow below steps.

Step 1. Go to settings > Layout > Current header rows

step1.JPG

Step 2: Insert new lines wherever required and update the label name like in this case “Report generated date:” and “Open item as of date”

step2.JPG

Under Gen. Variables you can see the various options available. In our case its date of Output.

Step 3: Add text for Open items as of date and this will be a characteristics relate variable. A lot of options will be available here.

Step 3.JPG

Step 4: You can add more fields like address lines for vendors, contact details etc. After that Save the changes.

step4.JPG

Step 5: Now the report will be generated with updated fields. You can also save different headers for different layouts also.

last step.JPG

Regards….

Assigned Tags

      33 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Gurunath Kumar Dadamu
      Gurunath Kumar Dadamu

      Hi Vasu Deva,

      Thanks for the blog..

      Regards,

      Gurunath

      Author's profile photo Former Member
      Former Member

      Very Informative. Many Thanks.

      Best Regards,

      Naresh K.

      Author's profile photo Sattaiah Gundu
      Sattaiah Gundu

      Hi Vasu Dev,

      Really it is very good blog.

      Regards

      Sattaiah Gundu

      Author's profile photo Godavari SAP
      Godavari SAP

      Good one

      Author's profile photo anju e v
      anju e v

      Hi Vasu,

      Really helpful, good blog.

      Author's profile photo sudhakar k
      sudhakar k

      Hey Vasu,

      Thanks for informing us about this feature which i was not aware of ..!!

      Regards,

      Sudhakar

      Author's profile photo Former Member
      Former Member

      Great Document Vasu. Its very useful.

      Regards

      Neeraj

      Author's profile photo Former Member
      Former Member

      Hi Vasu,

      Nice Sharing Specially  Different headers for different layouts is very usefull.

      Regards,

      Asim Raza

      Author's profile photo Former Member
      Former Member

      Hello Mr. VasuDev

      Ur document is very useful n informative.

      Regds,

      Satendra Singh Sikarwar

      Author's profile photo RAHEEM BAKSH
      RAHEEM BAKSH

      Good one

      Author's profile photo Sanil Bhandari
      Sanil Bhandari

      The Document is very informative. Thanks for putting this across.

      Regards

      Sanil Bhandari

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you all for the appreciation, its really encouraging.

      Author's profile photo Ranu Eugene
      Ranu Eugene

      Hi Vasu,

      Many thanks for such an informative Blog.

      Keep up the good work.

      Best of luck.

      Regards

      Eugene

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Ranu for the Comments. 🙂

      Author's profile photo Ramesh ganapathy
      Ramesh ganapathy

      Hi Vasu

      It is very good, and also informative

      Thanks with Best Regards

      Ramesh

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks a lot for the comments Ramesh... 🙂

      Author's profile photo raju M
      raju M

      Beautiful data.... My Peer problem solved .We were about to change whole Customer master data to get displayed in FBL5N

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      thanks Raju. good to know it was helpful.

      Author's profile photo NARRA LINGESH
      NARRA LINGESH

      Hi Vasu,

      This is really very helpful...and informative

      Regards,

      Lingesh.N

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      thanks for the comments Lingesh. 🙂

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama

      Hi Vasu,

      Good doc and got an opportunity to learn an unknown thing. Thanks for sharing your knowledge. Keep Sharing your knowledge.

      Best Regards,

      Lakshmi S

      Author's profile photo YOGESH KSHATRIYA
      YOGESH KSHATRIYA

      Thanks for sharing such hidden things.

      Author's profile photo Erwin Leitner
      Erwin Leitner

      Hello,

      Thank you very much.

      all the best Erwin

      Author's profile photo Rithin Shah
      Rithin Shah

      Indeed it is nice..

      Thank you for sharing this info...

      Cheers,

      Rithin

      Author's profile photo Former Member
      Former Member

      Dear vasu,

      This is a nice blog...

      Regards,

      Shyam

      Author's profile photo Former Member
      Former Member

      Dear Vasu

      Very informative

      Regards

      Pius

      Author's profile photo Former Member
      Former Member

      Hi Vasu

      Nice job.

      Best Regards.

      Jandoval Nascimento

      Author's profile photo Consultant Khan
      Consultant Khan

      Hi Vasu,

      Good work. Useful tips for most commonly used reports.

      Regards

      KIM Khan

      Author's profile photo Santhanakrishnan Arumugam
      Santhanakrishnan Arumugam

      Hi Vasu,

      Thanks, Its really good one. 🙂

      Thanks & Regards

      Krishnan

      Author's profile photo Former Member
      Former Member

      Muito bom. Obrigado por compartilhar.

      Author's profile photo Former Member
      Former Member

      Hi

      Is it possible to add the posting date range to header row if I select all items on selection screen/?

      Author's profile photo Sim Chen
      Sim Chen

      Hi Vasu,

      Tks

      Best of luck.

      Regards

      Sim

      Author's profile photo Eduardo Zavarize Schmidt
      Eduardo Zavarize Schmidt

      Thank you very much for the information!

       

      I'd like to define my FBL1N like the picture below, the header information distributed by vendor name, vendor code, company and location, can you help me?