Drilldown

Drill-Down menu details

When you choose Show me in Worksheet, a new Worksheet is added to the existing Workbook each time you choose this option.

The following columns headers are included:

• Sequence
• Account Code
• Unit Code 1- 4
• Date
• Amount (Domestic)
• Reference
• Cust/Vendor
• Invoice/Voucher
• Invoice/Vch Seq
• Check#
• Check Date
• Bank Code

When you choose Show me in Infor SyteLine form, a new Excel Window is opened to host a SyteLine form each time the drilldown option is selected.

The G/L Posted Transactions form is used when the "Actual" argument is used.

The Chart of Accounts Budget and Plan form is used when the "Budget" or "Plan" argument is used.

When you choose Configure Drill-Down, the Drill-Down Configuration window is displayed. Use this window to add one or more properties to the standard list or remove from the existing list.

To add a property, select one from the Available Column(s) and click the >(right) arrow. To remove, select a property from the Selected Column(s) and click < (left) arrow. Click the Save button to keep the changes. Use the Up and Down buttons to re-order the sequence.

Drilldown to purchase order receipt and invoice from ledger

Further drilldown is allowed from the Journal entries to the source transactions such as Purchase Order Receipt and Sales Invoice.

The Invoice/Voucher number is bold and underlined if further drilldown is allowed. You are presented with a Purchase Receipt or Invoice (depending upon the type of transactions) context menu, when you right-click on this cell.

For Purchase Receipt, these column headers are included:

• PO#
• PO Line
• PO Release
• Item
• Item Description
• Received Date
• Qty Vouchered
• Item Cost
• Extended Cost
• Voucher

For Sales Invoice, the following column headers are included:

• Invoice#
• Site
• Invoice Date
• Customer
• CO#
• Cust PO
• Item
• Co Line
• Co Rel
• Qty Invoiced
• Price
• Extended Price