General Ledger Controller Workspace

The general ledger controller uses the workspace to manage all General Ledger functions from a single view using the workspace, allowing access to transaction processing screens to important metrics in the management of the accounting function.

The workspace includes a graphical view of large transactions that are recorded against individual General Ledger Accounts, supporting drill down to individual transactions recorded in the system. Purchase price variances are also viewed in graphical format, again with drilldown to individual transactions by supplier.

Unapproved customer accounts are reviewed to manage progress, leading to resolution of any outstanding issues. New and unapproved supplier accounts are also managed similarly. System monitors enable the controller to view the volume of transactions within master data and transaction tables within the system.

Financial reports are viewed from the workspace, examples of which are Balance Sheet, Profit and Loss account, currency variance and costing analysis. Any additional reports generated specifically for the individual business are also added to the workspace, making a complete library for the controller to perform the role efficiently.

This workspace contains these widgets:
Widget Description
My Day Displays the current date, greeting message, and the user's icon and first name.
Purchase Price Variation Account Presents all purchase transactions for a specific account and the dates for which the transactions occurred. From the data, you can predict the purchase price variants that can either be negative or positive based on the returns, and can be taken into consideration for upcoming purchases.

Hover over a bar line to show the total purchase price with the transaction date in a tooltip. You can click a bar line to drill down. On the records page, right-click a record and select Open to perform a drillback to M3.

See M3 Information Viewer.
Large Transaction Monitor Displays general ledger accounts based on configured amount and period when the transactions occurred. From the data, you can check the volume of recorded amount for each account.

Hover over a bar line to show the account dimension and the recorded amount in a tooltip. Click a section from the chart to perform a drill down. On the records page, right-click a record and select Open to perform a drillback to M3.

See M3 Information Viewer.
On Your Radar Focuses on managing priority tasks.
This widget contains matrices that open card tasks in the Required Actions widget:
  • System monitors: Displays all predefined, standard monitors and their corresponding key result values which represent the count of all transactions made for each monitor. When you review the data, you can identify which monitors gained new information by looking at the number of key result values.
  • Unapproved customers: Displays the number of newly created customers that requires approval of entry and are tagged with status 10. When you review the data, you can view details of all the customers tagged with unapproved status and you can also drill back to the related M3 program for more details.
  • New suppliers: Displays the number of newly created supplier information that requires approval and are tagged with status 10. When you review the data, you can view details of all the suppliers which are tagged with 10- Preliminary status and you can also drill back to the related M3 program for more details.
For every card task, click Review to view a breakdown of records and identify tasks to address. Optionally, you may hide a card task by clicking the bell icon. When you review the available records, you may access these additional functionality through clicking Review or View All:
  • Select all or any records to export. Click Export to CSV.
  • Drill back into an M3 program by clicking a record with a working link.
  • Search for a particular record.

On the Required Actions widget, clicking View All provides you a single view of all records in tabular format. Whereas, clicking View snooze list enables you to show the list of hidden card tasks. From the list, you can return a hidden card task on the main widget display by clicking Unsnooze.
Quick Actions Displays all tasks that you perform frequently.
This widget shows these default tasks:
  • Update Supplier Information: Shows a list of suppliers and their corresponding details which you can update. Supplier details for this workspace are related to finance or general ledger, for example supplying values for applicable tax, VAT code, payment terms, and tolerance payment. After saving the record, a message is displayed with the supplier ID which you can click to perform a drillback to M3 where the supplier record is stored.
  • Update customer information: Shows a list of customers and their corresponding details which you can update. Customer details for this workspace are related to finance or general ledger, for example supplying values for VAT, cash discount terms, and credit limit. After saving the record, a message is displayed with the customer ID which you can click to perform a drillback to M3 where the customer record is stored.
  • Where am I working: Use this option to check in at the current location where you are working. The checked in location is updated in the user profile in 'User. Open' (MNS150).

    See Where am I working.
Important Links Provides direct access to preconfigured programs in the Infor M3 application. This widget shows default links that drill back to M3 where you can view more details.

See menu widget in the Infor OS User and Administration Documentation Library.

APIs used in the workspace widgets

This table shows the APIs used in varying widgets for this workspace:
Widget Program Transaction
On Your Radar

System Monitors

 CRS995MI LstMonitors
On Your Radar

Unapproved Customers

 CRS610MI SearchCustomer
On Your Radar

New Suppliers

 CRS620MI SearchSupplier
Quick actions

Update Supplier Information

 CRS620MI SearchSupplier
Quick actions

Update Supplier Information

 CRS620MI GetBasicData
Quick actions

Update Supplier Information

 CRS620MI UpdSupplier
Quick actions

Update Supplier Information

 MNS150MI LstUserData
Quick actions

Update Supplier Information

 CRS065MI LstDelyTerm
Quick actions

Update Supplier Information

 CRS070MI LstDelyMethod
Quick actions

Update Supplier Information

 MNS150MI GetUserData
Quick actions

Update Customer Information

 CRS610MI SearchCustomer
Quick actions

Update Customer Information

 CRS610MI GetFinancial
Quick actions

Update Customer Information

 CRS610MI ChgFinancial
Quick actions

Update Customer Information

 CRS030MI LstVat
Quick actions

Update Customer Information

 BROWSEMI LstValues
Quick actions

Update Customer Information

 CRS650MI LstByCode
Quick actions

Update Customer Information

 TXS003MI GetVATRegNoVali
Quick actions

Update Customer Information

 TXS070MI SimulateVatRegN
Quick actions

Update Customer Information

 MNS150MI GetUserData
Where am I working MNS150MI GetUserData
Where am I working CMS100MI Lst_WD_WHAMWI
Where am I working CMS250MI CheckIn
Purchase Price Variation Account GLS200MI SearchGenLedger
Large Transaction Monitor GLS200MI SearchGenLedger

Programs and sorting orders used in the workspace

The drillback functionality in some of the workspace widgets require specific configuration for filtering the correct data in Infor M3. When you perform a drillback to any program, check for the Function Search query. If the Function Search is disabled, you must create a record by specifying a combination of program, sorting order, and table for the search on 'Standard Search. Open' (CMS021/B).

This table shows the programs with their corresponding sorting order and table information all of which should be in active status:
Program Sorting order Table
GLS210 1 FGLEDG
CRS995 1 CSYMON
CRS610 1 OCUSMA
CRS620 1 CIDMAS