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.
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
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”
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 4: You can add more fields like address lines for vendors, contact details etc. After that Save the changes.
Step 5: Now the report will be generated with updated fields. You can also save different headers for different layouts also.
Regards….
Hi Vasu Deva,
Thanks for the blog..
Regards,
Gurunath
Very Informative. Many Thanks.
Best Regards,
Naresh K.
Hi Vasu Dev,
Really it is very good blog.
Regards
Sattaiah Gundu
Good one
Hi Vasu,
Really helpful, good blog.
Hey Vasu,
Thanks for informing us about this feature which i was not aware of ..!!
Regards,
Sudhakar
Great Document Vasu. Its very useful.
Regards
Neeraj
Hi Vasu,
Nice Sharing Specially Different headers for different layouts is very usefull.
Regards,
Asim Raza
Hello Mr. VasuDev
Ur document is very useful n informative.
Regds,
Satendra Singh Sikarwar
Good one
The Document is very informative. Thanks for putting this across.
Regards
Sanil Bhandari
Thank you all for the appreciation, its really encouraging.
Hi Vasu,
Many thanks for such an informative Blog.
Keep up the good work.
Best of luck.
Regards
Eugene
Thanks Ranu for the Comments. 🙂
Hi Vasu
It is very good, and also informative
Thanks with Best Regards
Ramesh
Thanks a lot for the comments Ramesh... 🙂
Beautiful data.... My Peer problem solved .We were about to change whole Customer master data to get displayed in FBL5N
thanks Raju. good to know it was helpful.
Hi Vasu,
This is really very helpful...and informative
Regards,
Lingesh.N
thanks for the comments Lingesh. 🙂
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
Thanks for sharing such hidden things.
Hello,
Thank you very much.
all the best Erwin
Indeed it is nice..
Thank you for sharing this info...
Cheers,
Rithin
Dear vasu,
This is a nice blog...
Regards,
Shyam
Dear Vasu
Very informative
Regards
Pius
Hi Vasu
Nice job.
Best Regards.
Jandoval Nascimento
Hi Vasu,
Good work. Useful tips for most commonly used reports.
Regards
KIM Khan
Hi Vasu,
Thanks, Its really good one. 🙂
Thanks & Regards
Krishnan
Muito bom. Obrigado por compartilhar.
Hi
Is it possible to add the posting date range to header row if I select all items on selection screen/?
Hi Vasu,
Tks
Best of luck.
Regards
Sim
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?