What you want ?

AutoCount- Advanced Drill Down

Introduction to AutoCount Advanced Drill Down

Advanced Drill Down is a critical feature in business management software that allows users to navigate from general information to detailed data points within sales and purchase documents. It enables users to access source documents directly, view flow structures, and explore associated records such as quotations, orders, and invoices. The primary purpose of the Drill Down feature is to enhance visibility and streamline access to interconnected documents, minimizing manual searches and improving operational efficiency.

Drill Down functionality is commonly implemented in Sales and Purchase modules as well as within financial reports, such as Outstanding A/R Invoice Reports. This guide will provide an in-depth exploration of how Drill Down works, its implementation in various modules, common challenges, and strategies to maximize its utility.

Benefits of Using Drill Down in Sales and Purchase Documents

  • Enhanced Navigation Efficiency

    Drill Down simplifies navigation by linking related documents, enabling users to switch between them effortlessly.

  • Increased Data Visibility

    Users can view the flow of transactions, making it easier to track document origins and dependencies.

  • Improved Decision Making

    With quick access to relevant documents, decision-makers can gather comprehensive insights without the need to toggle between multiple screens.

  • Reduced Time to Locate Information

    Drill Down minimizes the time spent searching for specific documents or data points, leading to greater productivity.

  • Error Reduction

    By allowing users to trace document trails, Drill Down helps identify and prevent errors in document handling and data entry.

Understanding Drill Down Functionality

Drill Down is more than just a navigation tool; it’s a comprehensive way to view and interact with related documents. It connects various types of information and provides a clear view of how documents are interlinked. The following are the primary types of Drill Down functions:

  • How Drill Down Works?

    Drill Down typically starts from a "parent" document and allows the user to navigate to related "child" documents. For example, in a Sales Order, the user might drill down to view the original Sales Quotation or linked Delivery Orders. Each of these documents can then be explored further, creating a chain of related records that can be accessed quickly.

  • Types of Drill Down Functions Available

View Flow Navigation

Offers a visual representation of document relationships, showing how a single document flows through different stages (e.g., from quotation to order to invoice).

View Flow Navigation

Offers a visual representation of document relationships, showing how a single document flows through different stages (e.g., from quotation to order to invoice).

Inquiry Screen Navigation

Allows users to drill down within report forms, accessing detailed views directly from summary data.

Report Form Navigation

Facilitates direct navigation within report screens, making it easy to switch between data summaries and detailed document views.

  • Key Features of Drill Down in View Flow

    The View Flow feature provides a graphical depiction of document flow. It typically highlights the source document and its dependent documents, such as:

Sales Orders linked to Quotations

Sales Orders linked to Quotations

Purchase Orders linked to Purchase Requisitions

Invoices linked to Delivery Notes

Users can select any document in the View Flow to view it directly, making this tool invaluable for understanding the progression of a sales or purchase transaction.

Implementing Drill Down in Sales Documents

1. Navigating Sales > Quotation

To implement Drill Down in Sales Documents, navigate to the Sales module and select Quotation. Here’s how to use Drill Down effectively:

Advanced Drill Down-Sales Quotation

a. Select the Quotation Document

  • Choose a document from the list and click on “View Flow”.
Advanced Drill Down-Select the Quotation Document

b. Access Related Documents

  • In the View Flow, the Quotation will be shown as the “Source Document”. You can select any related document, such as a Sales Order or Invoice, to view its details.
Advanced Drill Down-Access Related Documents

2. Using View Flow to Access Related Documents

The View Flow not only shows the relationship between documents but also provides direct access to each one. If a Sales Order is created based on a Quotation, selecting it will redirect you to the Sales Order screen, where you can view order details, item descriptions, and customer information.

Advanced Drill Down-Using View Flow to Access Related Documents

3. Redirecting to Source Documents

Source Documents are the original documents from which other records are derived. For instance, a Delivery Note created from a Sales Order can be traced back to its source Sales Order using Drill Down. This helps in verifying data accuracy and ensuring that the flow of documents is consistent.

Using Drill Down in Purchase Documents

1. Overview of Drill Down in Purchase Orders

In the Purchase module, Drill Down functions similarly to the Sales module. It allows users to navigate through Purchase Quotations, Purchase Orders, and linked receipts or invoices. For example, starting from a Purchase Order, a user can access related Purchase Requisitions or Supplier Invoices.

2. Viewing Source Documents in Purchase Quotations

When viewing a Purchase Quotation, you can use the View Flow feature to see all downstream documents, such as:

  • Purchase Orders created based on the Quotation.
  • Supplier Invoices linked to the Purchase Order.

3. Navigating Purchase Order Reports

Within Purchase Order Reports, Drill Down makes it easy to access detailed information. For instance, selecting a specific order in the report and drilling down will display the Purchase Requisition it originated from, allowing users to validate the order’s origins.

Drill Down Function in the Inquiry Screen

1. Accessing Inquiry Screen in A/R

Navigate to the A/R module and select Outstanding A/R Invoice Report. This report displays all pending invoices, and Drill Down is integrated to provide document details directly from the report.

Advanced Drill Down-Accessing Inquiry Screen in AR

2. Performing Inquiry in Outstanding A/R Invoice Report

  • Select Date and Click on Inquiry: Choose a specific date range for outstanding invoices and click “Inquiry”. A list of invoices will be displayed in the report column.
Advanced Drill Down-elect Date and Click on Inquiry
  • Drill Down to View Invoices: Select any row in the report to view the associated invoice. This direct navigation reduces the time spent searching for specific documents.
Advanced Drill Down-View Invoices

3. Viewing Invoices through Drill Down

Once the invoice list is displayed, you can use Drill Down to preview or access each invoice’s details. This feature is beneficial for finance teams who need to verify payment statuses or reconcile accounts.

Advanced Drill Down-Viewing Invoices through Drill Down

Setting Up Access Rights for Drill Down

1. Navigating to Access Rights Maintenance

To ensure the Drill Down feature is available to authorized personnel, navigate to General Maintenance > Access Rights Maintenance. Here, you can define who can use Drill Down in both Sales and Purchase modules.

Advanced Drill Down-Access Rights Maintenance

2. Configuring Access for Sales Documents

  • Search for “Drill Down” in Sales Documents.
  • Set permissions for each user or user group.
  • Ensure that only authorized personnel can view and modify source documents.
Advanced Drill Down-Sales Documents

3. Configuring Access for Purchase Documents

  • Search for “Drill Down” in Purchase Modules.
  • Configure access rights to allow document preview and View Flow navigation.
  • Regularly review permissions to maintain data security.
Advanced Drill Down-Purchase Documents

Drill Down in Report Form

1. Exploring Drill Down in A/R Invoice Reports

Drill Down is integrated into many financial reports, including the Outstanding A/R Invoice Report. Users can drill down from a high-level view to individual invoices, providing quick access to document specifics.

2. Using the “Preview” Button in Report Forms

The Preview button is available in many report forms, allowing users to view a document without fully opening it. This feature speeds up document review and helps identify discrepancies quickly.

Advanced Drill Down-“Preview” Button in Report Forms
Advanced Drill Down-“Preview” Button in Report Forms (2)

3. Accessing Detailed Document Data

Drill Down ensures that every related document, from quotations to invoices, can be accessed directly, offering a complete picture of the transaction flow.

Advanced Drill Down-Accessing Detailed Document Data

Streamline Your Accounting Process

Find the Perfect Plan to Optimize Your Business Finances

Discover Plans

Conclusion

The Advanced Drill Down feature is a powerful tool that improves navigation, data visibility, and document management across Sales and Purchase modules. By configuring access rights, training users, and implementing best practices, businesses can maximize the utility of this feature to streamline operations and enhance decision-making.

FAQs

The Drill Down function allows users to navigate through linked documents, moving from a high-level overview to detailed information. This feature is useful for tracking document origins, viewing dependencies, and gaining a complete understanding of a transaction’s flow.

Drill Down is typically available in Sales and Purchase modules and in various reports, such as the Outstanding A/R Invoice Report. However, availability may depend on the system configuration and user permissions.

To configure user access rights, navigate to General Maintenance > Access Rights Maintenance. Search for the “Drill Down” function, and assign permissions based on document type (e.g., Sales or Purchase). Ensure that only authorized personnel have access.

This error usually occurs when you don’t have the necessary permissions. Contact your system administrator to review and update your access rights for the specific document type or module.

Simply open the document (e.g., a Sales Order) and click on the “View Flow” button. In the View Flow screen, select any linked document to view it instantly. This will redirect you to the chosen document, allowing you to access its details.

If a source document is not visible, check the View Flow to see if it’s linked correctly. If it’s missing, it may be due to broken linkages or permissions. Re-check the document path and confirm you have access rights to view it.

Table Of Content