Drilldown

Functions SLGL, SLNGL, SLGLBAL, SLNGLBAL, SLGLTRAN and SLNGLTRAN have the drilldown feature enabled. This feature enables you to navigate into informative accounting journals.

Either use the Drilldown menu option or right-click in the cell and choose either:

  • Drilldown: What makes up this number? OR
  • Drilldown: Show me in an Infor CloudSuite form

New worksheet details

When you choose Show me in a new 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

SyteLine form details

When you choose "Show me in a 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.

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