aging report📊 aged accounts payable report📋in business central🪩 | business central

Hi Viewers,
aging report📊 aged accounts payable report📋in business central🪩 | business central #gomstechtalks
This channel is dedicated to research aspirants and all who wish to learn technologies with easy examples and exercises. I will be uploading at least three videos every week. You can leave the expected topics which you wish to know in the comment.
Checkout your favorite playlist
==================================================================================
Important tutorials and videos (Playlist) that you should not miss
==================================================================================
1. Research: • PhD Course details, Ph...
2. SCI/Scopus/Annexure-I/WoS/UGC care indexed journals
• SCI, Scopus, Annexure-...
3. Weka Tutorial:
• Weka Tutorial
4. Tableau Prep Builder: • What is Tableau Prep |...
5. ETL Data Integration: Talend:
• What is ETL? well Expl...
6. AL Programming - Microsoft Dynamics 365 Business Central (AL Programming): • AL Programming for abs...
7. Web Designing for Kids:
• Simple sign-in form in...
8. Tableau Desktop: • Learn Tableau Basic Ca...
9. Python Interview Questions: • What is Negative index...
10. GraphPad Prism Statistical Tool: • Introduction to GraphP...
11. R and Rattle GUI for statistics and Research: • Introduction to R and ...
12. Minitab Statistical Tool: • How to download, insta...
13. Online teaching tool for teachers, professors and online mentors: • Best online Whiteboard...
14. Skill-up yourself: • How to become a google...
======================================================================
Social media:
Blog: draft.blogger....
GitHub: github.com/Gom...
LinkedIn profile: / gomathisri
Instagram profile: @goms_tech_talks
Facebook profile: / goms.techtalks
Website: sites.google.c...
======================================================================
Happy learning

[@pspol3273]

Thanks for sharing video helpful for functional consultant

[@gomstechtalks]

Glad. Welcome

[@mothercensured]

Thank you for this video! It's a good explanation but I don't really think that this video belongs to the Technical Consultant PlayList, in my opinion this is more for Functional Consultants.

[@gomstechtalks]

I appreciate your feedback and perspective on the video! Thank your for your support

[@jeffersonsumbobo4167]

That's a great explanation. Thank you so much. Please I will kindly want to know, how to customize my Aged account receivable report to include any notes that are added against invoices.

[@gomstechtalks]

To customize your Aged Accounts Receivable report in Dynamics 365 Business Central to include notes added against invoices, you'll need to modify the report layout. Here's how you can do it: Access Report Layouts: First, navigate to the Report Layouts page in Business Central. You can do this by searching for 'Report Layouts' in the search bar. Select the Report: Find the Aged Accounts Receivable report in the list of reports. Its report ID might vary based on your specific setup, so you may need to identify the correct report based on its name or ID. Edit the Layout: Once you've located the report, you will need to modify its layout. This can be done in two ways: Using Built-in Layout Designer: If the report uses a built-in layout, you can edit it directly within Business Central. This is more user-friendly but offers limited customization options. Using an External Tool: If the report uses a custom layout (like an RDLC or Word layout), you'll need to download the layout and edit it using an external tool like Visual Studio (for RDLC) or Microsoft Word. Add the Notes Field: In the report layout, you will need to add a field that pulls data from the notes added against invoices. This requires identifying the correct table and field in the Business Central database that stores these notes. Binding the Field: Ensure the new field is correctly bound to the data source. This involves linking it to the specific table and field where the notes are stored. Testing and Deployment: After modifying the layout, upload it back to Business Central if you used an external tool. Test the report to ensure it displays the notes as expected. Make any necessary adjustments. Permission and Security: Ensure that the users who need to access this customized report have the necessary permissions. Also, consider the security implications of displaying invoice notes in the report.

[@AbhishekSingh-nt6xb]

Very helpful video

[@gomstechtalks]

Glad you think so!

[@kramtiabir6402]

Thank you for your efforts, your videos are useful and very well explained. I would appreciate if you could prepare more content on RDLC reports, resources are very limited in this regard.

[@gomstechtalks]

Glad. Sure

[@GustavoYsaya]

Thank you for these videos, one question if I add a column like Vendor Posting Group how do I modify the Excel procedure to include the new column in the excel layout

[@gomstechtalks]

You have to extend the corresponding objects related to the reports.

[@RohitKumar-ub5bn]

Thanks ma'am. 👍

[@gomstechtalks]

Welcome.

[@AbhishekSingh-nt6xb]

If a customer has one sale order and if against that sales order there are more than one item number how can we group that item so that we can add all quantities and print the sum in one field against that item no

[@gomstechtalks]

To group the items and add their quantities in one field against the item number, you can use the "Group By" function in your sales order management software. This will allow you to group the items based on their item numbers and then sum up their quantities to display the total quantity in one field. Alternatively, you can use a spreadsheet program like Microsoft Excel to import your sales order data and use the "SUMIF" function to add up the quantities for each item number. This will allow you to create a new column where you can print the sum of all quantities against each item number. I hope this helps!