General Ledger Admin

General Ledger Admin is an M3 Experience Designer application that enables users to efficiently manage transactions that M3 has halted due to errors during processing. The application helps users handle work files and monitor non-transferred account entries or invoices to the general ledger. The application provides enhanced display features, improved filtering options, and better traceability of transactions, both before and after final postings. This feature enables users to identify erroneous entries, streamlining the management of the general ledger on a regular basis.

User stories

M3 Systems managers and General Ledger controllers require an efficient way to keep track of transactions that are not processed correctly by M3 to keep the accounting up to date.

M3 Business Engine configuration

This M3 Business Engine configuration is required to run the General Ledger Admin application. These tables must be activated for search:

OINVOH
ACUIVH
CINACC

See the Components section for the specific configuration per component.

Application authorization

To access and run the Experience Designer application you must be authorized to the M3 Business Engine functions and API transactions used by the application.

This table shows the functions and transactions that are used by the General Ledger Admin application:


API program	API transaction	Information category	View	Notes
MNS100MI	GetBasicData
LISTMI	ListDataAsCSV	M3_LIST_FCR040	M3_03_01
LISTMI	ListDataAsCSV	M3_LIST_FCR040	M3_01_01
LISTMI	ListDataAsCSV	M3_LIST_FCR040	M3_02_01
LISTMI	ListDataAsCSV	M3_LIST_OINVOH	M3_01_01	To ensure this API works as expected, you must activate the OINVOH table for search in M3 Function Search Administration.
LISTMI	ListDataAsCSV	M3_LIST_CINACC	M3_01_01	To ensure this API works as expected, you must activate the CINACC table for search in M3 Function Search Administration.
LISTMI	ListDataAsCSV	M3_LIST_ACUIVH	M3_01_01	To ensure this API works as expected, you must activate the ACUIVH table for search in M3 Function Search Administration.

Limitations

The drillback to the work files 'Trans Work File. Restart Erroneous Job' (GLS037) and 'Trans Work File. Restart Interupted Jobs' (GLS047) passes only the date to the program, because the job number is not transferred when leading zeros are handled incorrectly.

How to use the application

Select division

The appheader contains a field for 'Division'. Specify or browse the division field if the logged in division is blank. If the user is in any different division, the appheader displays the current user context.

Erroneous job

Filter for erroneous jobs in the header of the data grid. When you select a job, the next data grid, vouchers, is filled and displays the vouchers included in the job. If you highlight one of the vouchers, the transactions that the voucher contains are displayed in the third data grid. To update the record, use the toolbar button Edit to access 'Trans Work File. Restart Interrupted Jobs' (GLS037).

Interrupted job

Use the filter in the data grid for jobs that are interrupted during processing and should be restarted. To update the record, use the toolbar button Edit to access 'Trans Work File. Restart Erroneous Jobs' (GLS047).

Internal account entries

The data grid displays internal account entries that are not yet transferred to the General Ledger. It indicates when the flag transferred to FAM is not selected. The toolbar options enables a user to create internal account entries or transfer existing one, and edit the record in H5. A free text search box is available to locate specific records.

Edit toolbar button: Opens 'Internal Account Entry. Open' (CAS300)
Create internal account entries toolbar button: Opens 'Internal Account Entry. Create' (CAS950)
Transfer to GL toolbar button: Opens 'Internal Account Entry. Transfer to GL' (CAS960)

Customer invoices

The data grid displays invoices that have not yet been transferred to the General Ledger and have a status below 95. These invoices originate from different M3 invoice functions. The toolbar therefore provides links to transfer the invoices from their respective functions. Users can also navigate to H5 using the hyperlink on the invoice number, which displays the invoice in its originating function 'Invoice. Display' (OIS350), 'Rental Invoice. Display/Credit' (STS350), or 'Project Invoice. Display' (POS350). A free‑text search box is available to help users locate specific records.

Sales Invoices: Opens 'CO Invoice. Post-Process' (OIS196)
Service order invoices toolbar button: Opens ‘SO Invoice. Post-Process’ (SOS196)
Project Invoice toolbar button: Opens 'Project Invoice. Post-Process' (OIS196)

Maintenance invoices

The data grid displays invoices that have not yet been transferred to the General Ledger and have a status below 95. These invoices originate from the maintenance invoice function, and the toolbar provides a link to transfer these invoices. Users can also navigate to H5 using the hyperlink on the invoice number, which displays the invoice in its originating function, 'Maint Invoice. Display' (COS350). A free‑text search box is available to help users locate specific records.

Selecting 'Transfer to GL' opens 'Maint Invoice. Post-Process' (COS196).

Components

This table shows the key components of the General Ledger Admin application:


Component	Component details
Application header	Component ID: appHeader Purpose: Displays the main application header. M3BE data used: MNS100MI Data services used: List_DivisionInfo
DataGrid_MaintenanceInvoices	Component ID: DataGrid_MaintenanceInvoices Purpose: Lists maintenance invoices that have not been transferred to the General Ledger and displays invoice, date, and status columns, along with a toolbar action for transferring the invoices. M3BE data used: ACUIVH Data services used: Search_MaintInvoices
DataGrid_CustomerInvoices	Component ID: DataGrid_CustomerInvoices Purpose: Lists customer invoices that have not been transferred to the General Ledger and displays invoice, date, and status columns, along with transfer actions for Sales, Service, and Project. M3BE data used: OINVOH Data services used: Search_CustomerInvoices
DataGrid_InternalAccountEntry	Component ID: DataGrid_InternalAccountEntry Purpose: Lists internal account entries that have not been transferred to the General Ledger and provides actions to edit, create, or transfer the entries. M3BE data used: CINACC Data services used: Search_InternalAccountEntry
DataGrid_InterruptedJobs	Component ID: DataGrid_InterruptedJobs Purpose: Shows interrupted jobs. M3BE data used: GLS047 Data services used: List_InterruptedJobs
DataGrid_ErroneousJob	Component ID: DataGrid_ErroneousJob Purpose: Shows erroneous jobs. M3BE data used: GLS037 Data services used: List_ErroneousJob
DataGrid_ErroneousVouchers	Component ID: DataGrid_ErroneousVouchers Purpose: Lists erroneous vouchers. M3BE data used: GLS037 Data services used: List_ErroneousVouchers
DataGrid_ErroneousTransactions	Component ID: DataGrid_ErroneousTransactions Purpose: Displays erroneous voucher lines and transactions. M3BE data used: GLS037 Data services used: List_ErroneousTransactions

Links and bookmarks

This table shows the available links and bookmarks in the application, including their types and the functions they open:


Link ID	Type	Purpose
Link_BalanceFile	M3 Bookmark	Opens 'GL Balance File. Display' (GLS215)
Link_CreateVoucher	M3 Automation	Opens 'Journal Voucher. Enter' (GLS100)
Link_ErroroneousJobs	M3 Automation	Opens 'Trans Work File. Restart Erroneous Jobs' (GLS037)
Link_InternalEntry_CreateAccountEntries	M3 Automation	Opens 'Internal Account Entry. Create' (CAS950)
Link_InternalEntry_Edit	M3 Automation	Opens 'Internal Account Entry. Open' (CAS300)
Link_InternalEntry_Transfer	M3 Automation	Opens 'Internal Account Entry. Transfer to GL' (CAS960)
Link_InterruptedJob	M3 Bookmark	Opens 'Trans Work File. Restart Interupted Jobs' (GLS047)
Link_TransferMaintInvoice	M3 Automation	Opens 'Maint Invoice. Post-process' (COS196)
Link_TransferProjectInvoice	M3 Automation	Opens 'Project Invoice. Post-process' (POS196)
Link_TransferSalesInvoice	M3 Automation	Opens 'CO Invoice. Post-process' (OIS196)
Link_TransferServiceInvoice	M3 Automation	Opens 'SO Invoice. Post-process' (SOS196)

Conditional styles

This table shows the styling conditions applied to each components in the General Ledger Admin application:


Component	Condition name	Target field	Condition	Styling
DataGrid_MaintenanceInvoices	Condition_VSN6AB	IHIVAM	IHIVAM=IHIVAM	Text color: #0066D4 - blue Text weight: normal Icon: dollar-bill Icon color: blue Background color: #E6F1FD - light blue
DataGrid_MaintenanceInvoices	Condition_BIJUTH	IHVONO	IHVONO=0	Text color: #BB5500 - orange/brown Text weight: normal Icon: alert Icon color: orange/brown Background color: #FEF2E5 - light orange
DataGrid_MaintenanceInvoices	Condition_EHQL3U	IHEXIN	IHEXIN=IHEXIN	Text weight: normal Icon: launch Icon color: #0066D4 - blue
DataGrid_MaintenanceInvoices	Condition_S4VVT6	IHAIIS	IHAIIS≤90	Text color: #0066D4 - blue Text weight: normal Icon: info Icon color: blue
DataGrid_CustomerInvoices	Condition_XXS8W7	UHVONO	UHVONO=0	Text color: #BB5500 - orange/brown Text weight: normal Icon: info Icon color: orange/brown Background color: #FEF2E5 - light orange
DataGrid_CustomerInvoices	Condition_YDFJPN	UHIVAM	UHIVAM=UHIVAM	Text color: #0066D4 - blue Text weight: normal Icon: dollar-bill Icon color: blue Background color: #E6F1FD - light blue
DataGrid_CustomerInvoices	Condition_K9W2AS	UHEXIN	UHORIG=1	Text weight: normal Icon: launch Icon color: #0066D4 - blue
DataGrid_CustomerInvoices	Condition_K9W2AS	UHEXIN	UHORIG=0	Text weight: normal Icon: launch Icon color: #0066D4 - blue
DataGrid_CustomerInvoices	Condition_K9W2AS	UHEXIN	UHORIG=2	Text weight: normal Icon: launch Icon color: #0066D4 - blue
DataGrid_CustomerInvoices	Condition_C8WRE8	UHINST	UHINST=UHINST	Text color: #0066D4 - blue Text weight: normal Icon: info Icon color: blue
DataGrid_InternalAccountEntry	Condition_IO7SC5	EZTFAM	EZTFAM=EZTFAM	Text color: #BB5500 - orange/brown Text weight: normal Icon: alert Icon color: orange/brown Background color: #FEF2E5 - light orange
DataGrid_InternalAccountEntry	Condition_Q27HQE	EZACAM	EZACAM=EZACAM	Text color: #0066D4 - blue Text weight: normal Icon: dollar-bill Icon color: blue Background color: #E6F1FD - light blue
DataGrid_InterruptedJobs	Condition_OT5GFS	ACSTCF	ACSTCF=0	Text color: #BB5500 - orange/brown Text weight: normal Icon: alert Icon color: orange/brown Background color: #FEF2E5 - light orange
DataGrid_InterruptedJobs	Condition_OT5GF5	ACSTCF	ACSTCF=9	Text color: #BB5500 - orange/brown Text weight: normal Icon: alert Icon color: orange/brown Background color: #FEF2E5 - light orange
DataGrid_InterruptedJobs	Condition_EALVRL	ACRGDT	ACRGDT=ACRGDT	Text color: #0066D4 - blue Text weight: normal Icon: calendar Icon color: blue
DataGrid_InterruptedJobs	Condition_M8SQOM	ACCHID	ACCHID=ACCHID	Text color: #0066D4 - blue Text weight: normal Icon: user Icon color: blue
DataGrid_ErroneousJob	Condition_IOCP4I	ACSTCF	ACSTCF=ACSTCF	Text color: #C31014 - red Text weight: normal Icon: error Icon color: red Background color: #FBE7E8 - light pink
DataGrid_ErroneousJob	Condition_C5F4M6	ACCHID	ACCHID=ACCHID	Text color: #0066D4 - blue Text weight: normal Icon: user Icon color: blue
DataGrid_ErroneousJob	Condition_R0RCW3	ACRGDT	ACRGDT=ACRGDT	Text color: #0066D4 - blue Text weight: normal Icon: calendar Icon color: blue
DataGrid_ErroneousVouchers	Condition_FDXRDO	ACERRV	ACERRV=1	Text color: #DA1217 - red Text weight: normal Icon: error Icon color: #DA1217 - red
DataGrid_ErroneousVouchers	Condition_FDXRD2	ACERRV	ACERRV=2	Text color: #DA1217 - red Text weight: normal Icon: error Icon color: #DA1217 - red
DataGrid_ErroneousVouchers	Condition_IQE76U	ACCHID	ACCHID=ACCHID	Text color: #0066D4 - blue Text weight: bold Icon color: var(--mp-conditional-styles-icon-color)
DataGrid_ErroneousTransactions	Condition_HIVBE4	ACERRF	ACERRF≠0	Text color: #C31014 - red Text weight: normal Icon: error Icon color: red Background color: #FBE7E8 - light pink
DataGrid_ErroneousTransactions	Condition_VJ1P9H	ACACAM	ACACAM=ACACAM	Text color: #0066D4 - blue Text weight: normal Icon: dollar-bill Icon color: blue Background color: #E6F1FD - light blue