Drillback in Infor Ming.le
If Application Studio is running in Infor Ming.le, you can define an action which drills back to the application on which Application Studio is reporting. For example, if you are reporting on ERP LN, clicking a Sales Order ID in an Application Studio report would open the Sales Order view in ERP LN; displaying details of the selected Sales Order.
An example of the syntax of a Drillback in Infor Ming.le action is given in 'Drillback in Infor Ming.le.'
See Drillback in Infor Ming.le.
The Drillback in Infor Ming.le action has no effect if Application Studio is not running in Infor Ming.le. To provide alternative report navigation in case Infor Ming.le is not present, you can define a second action type, such as a jump. If Infor Ming.le is not present, the Drillback action is ignored and the alternative action is triggered.
There are 75 predefined views. They have been defined for use with these products:
- ERP LN
- SyteLine
- EAM
- Adage
- XM
- SunSystems
Not all views are available for all products.
See Drillback View IDs supported by product.
The Drillback in Infor Ming.le action has four mandatory parameters:
- Logical ID: The ID of the core application within Infor Ming.le.
- View ID: Specifies the type of screen which will be opened in Infor Ming.le.
- Accounting Entity
- ID1: Provides the context of the drillback.
Some View ID parameters have up to 6 further IDs, which are optional. You can use them to add further context to a drillback.
For example, if you use the ChartOfAccountView View ID, you must specify its ID 1 (Accounting Chart ID). But, optionally, you can also specify its ID 2 - NaturalAccount.
The Location parameter is also optional.
This table lists the View IDs, their ID 1s and any optional IDs available for the view:
| View ID | ID 1 - Mandatory | Optional IDs | |
|---|---|---|---|
| AdjustmentOrderView | AdjustmentOrderNumber | ||
| ChartOfAccountView | Accounting Chart ID | ||
| ID 2 | NaturalAccount | ||
| CustomerView | CustomerId | ||
| DepartmentView | DepartmentId | ||
| EmployeeView | EmployeeId | ||
| GLMovementView | PostingKey | ||
| ID 2 | NaturalAccount | ||
| ID 3 | PeriodID | ||
| ID 4 | Year | ||
| ID 5 | BookType | ||
| ID 6 | BookInstanceID | ||
| ID 7 | BookCurrency | ||
| InventoryView | Item | ||
| ID 2 | Warehouse | ||
| ID 3 | CurrentDate | ||
| InvoiceLineView | InvoiceNumber | ||
| ID 2 | InvoiceLineNumber | ||
| InvoiceView | InvoiceNumber | ||
| ItemView | Item | ||
| OpportunityView | SalesLeadId | ||
| PayableView | PayableDocumentId | ||
| ProductionOperationView | ProductionOrder | ||
| ID 2 | ProductionOperationID | ||
| ProductionOrderView | ProductionOrder | ||
| PurchaseContractLineView | PurchaseContract | ||
| ID 2 | PurchaseContractLineNumber | ||
| PurchaseContractView | PurchaseContract | ||
| PurchaseInvoiceView | InvoiceNumber | ||
| ID 2 | InvoiceLineNumber | ||
| PurchaseInvoiceLineView | InvoiceNumber | ||
| PurchaseOrderLineView | PurchaseOrder | ||
| PurchaseOrderLineNumber | |||
| PurchaseOrderView | PurchaseOrder | ||
| QuoteView | QuoteId | ||
| ReceiptLinesView | Receipt | ||
| ID 2 | ReceiptLineNumber | ||
| ReceiptView | Receipt | ||
| ReceivableView | ReceivableDocumentId | ||
| RequestForQuotationView | RFQId | ||
| RequisitionView | Requisition | ||
| SalesOrderLineView | SalesOrder | ||
| ID 2 | SalesOrderLineNumber | ||
| SalesOrderView | SalesOrder | ||
| ID 2 | SalesOrderLineNumber | ||
| ShipmentLinesView | ShipmentNumber | ||
| ID 2 | ShipmentLineNumber | ||
| SupplierView | Supplier | ||
| TerritoryView | TerritoryId | ||
| WarehouseView | Warehouse | ||
| MaintenanceOrderView | WorkOrderID | ||
| AssetMasterView | AssetID | ||
| LocationView | Location ID | ||
| ID 2 | LocationType | ||
| ShipToPartyView | ShipToPartyID | ||
| ShipFromPartyView | ShipFromPartyID | ||
| CarrierPartyView | CarrierParty | ||
| OpportunityLineView | OpportunityID | ||
| ID 2 | LineNumber | ||
| QuoteLineView | QuoteId | ||
| ID 2 | LineNumber | ||
| RequestForQuotationLineView | RFQId | ||
| ID 2 | LineNumber | ||
| RequisitionLineView | Requisition | ||
| ID 2 | RequisitionLine | ||
| BillToPartyView | BillToPartyID | ||
| RemitToPartyView | RemitToPartyID | ||
| PayFromPartyView | PayFromPartyID | ||
| ProjectView | ProjectID | ||
| ActivityView | ProjectID | ||
| ID 2 | ProjectPlanID | ||
| ID 3 | PlanActivityID | ||
| MilestoneView | ProjectID | ||
| ID 2 | ProjectPlanID | ||
| ID 3 | PlanActivityID | ||
| ID 4 | PlanActivityType | ||
| BidView | ProjectID | ||
| ID 2 | ProjectBidBidID | ||
| ID 3 | VersionID | ||
| EstimateLineView | ProjectID | ||
| ID 2 | EstimateVersionID | ||
| ID 3 | EstimateLineNumber | ||
| ProjectLaborBudgetView | ProjectID | ||
| ID 2 | ProjectPlanID | ||
| ID 3 | ProjectActivityID | ||
| ID 4 | BudgetDetailID | ||
| ProjectInstallmentView | ProjectID | ||
| ID 2 | ProjectPlanID | ||
| ID 3 | ProjectActivityID | ||
| ID 4 | RevenueDetailID | ||
| SalesInvoiceLineView | SalesInvoiceID | ||
| ID 2 | SalesInvoiceLineNumber | ||
| ProjectManagerView | PersonID | ||
| ProjectBalanceView | ProjectID | ||
| ProjectPeriodBalance | ProjectID | ||
| DocumentReferenceView | DocumentReferenceID | ||
| ShipmentView | ShipmentNumber | ||
| ProjectMonitoringView | ProjectID | ||
| ProjectPerformanceView | ProjectID | ||
| InventoryCountView | OrderNumber | ||
| ID 2 | LineNumber | ||
| InventoryCountLineView | OrderNumber | ||
| ID 2 | LineNumber | ||
| JournalView | JournalNumber | ||
| AnalysisCodeView | Code | ||
| ID 2 | Dimension | ||
| AddressView | AddressCode | ||
| FailedPostingView | Account | ||
| ID 2 | JournalNumber | ||
| ContactsView | ContactCode | ||
| InventoryReceiptNoteEntryView | ReceiptNoteReference | ||
| BankDetailsView | BankDetailsCode | ||
| BankSubCode | |||
| EmployeeRolesView | RoleCode | ||
| CurrencyDailyRateView | CurrencyCodeFrom | ||
| ID 2 | CurrencyCodeTo | ||
| ID 3 | FromDate | ||
| ID 4 | ToDate | ||
| CurrencyPeriodRateView | CurrencyCodeFrom | ||
| ID 2 | CurrencyCodeTo | ||
| ID 3 | FromPeriod | ||
| ID 4 | ToPeriod | ||
| HeldJournalView | JournalHeldReference | ||
| AuthJournalView | AuthorisationSetReference | ||
| AuthPaymentView | PaymentAuthorisationSetReference | ||