General Ledger Desk

General Ledger Desk application is an Experience Designer application that enables users to maintain control and traceability of transactions that affect the general ledger. Users can track vouchers, their corresponding transactions, and any reversed vouchers. The application allows users to identify specific transactions and view related entries using voucher numbers. It also helps users monitor batch uploads through the FIM interface, streamlining search processes and error handling.

User stories

Financial accountants and other finance roles require a simple way to find vouchers and transactions in the general ledger, with enhanced search capabilities, traceability between vouchers, and efficient handling of external uploads.

M3 Business Engine configuration

To use the General Ledger Desk application, activate these tables for search functionality: FGLHED, FGLEDG, FGLINH, and FGLINF.

See the Components section for the specific configuration per component.

Application authorization

To access and run the General Ledger Desk application, you must be authorized to these M3 Business Engine functions and API transactions:


API program	API transaction	Information category	View	Notes
GLS200MI	LstVoucherLines
GLS200MI	SearchGenLedger			To ensure this API works, you must activate the FGLEDG table for search in M3 Function Search Administration.
GLS840MI	DelBatch
GLS840MI	UpdBatch
LISTMI	ListDataAsCSV	M3_LIST_FGLEDX	M3_01_01
LISTMI	ListDataAsCSV	M3_LIST_FCHACC	M3_01_01	To ensure this API works, you must activate the FCHACC table for search in M3 Function Search Administration.
LISTMI	ListDataAsCSV	M3_LIST_FGLINH	M3_01_01	To ensure this API works, you must activate the FGLINH table for search in M3 Function Search Administration.
LISTMI	ListDataAsCSV	M3_LIST_FGLINF	M3_01_01	To ensure this API works, you must activate the FGLINF table for search in M3 Function Search Administration.
LISTMI	ListDataAsCSV	M3_LIST_FGLHED	M3_01_01	To ensure this API works, you must activate the FGLHED table for search in M3 Function Search Administration.
MNS100MI	GetBasicData

Applications

The General Ledger Desk application opens or links to these Experience Designer applications:


Application	Short name
GL Transaction Details	M3GLTDET
GL Voucher Display	M3GLVOD

Limitations

The General Ledger Desk application does not support working from a blank division. You must change the division outside the application.

How to use the application

Search voucher

Use the search filters in the datagrid to find specific vouchers by using attributes and intervals. When you select a voucher, the connected voucher lines are displayed in the second datagrid. Voucher numbers are links that users can select to open the full GL Voucher Display. You can also open the full display by selecting the reversed voucher number on the line. Highlight a line in the Voucher Lines datagrid to display the transaction details in a pop‑up application. The toolbar provides several options for working with the voucher:

Subledger toolbar button: Opens 'Voucher. Display' (GLS200/A1) and runs realted option 12-'Subledger'.
Internal account entries toolbar button: Opens (GLS200/A1) and runs related option 16-'Internal Account Entries'.
Reverse toolbar button: Opens (GLS200/A1) and runs related option 18-'Reverse'.
VAT comments toolbar button: Opens (GLS200/A1) and runs related option 17-'Vat comments'.
Work with toolbar button: Opens (GLS200/B1).

Search GL transactions

General Ledger provides a full view of every recorded transaction. Use the search filters to find specific transactions by date, amount, or accounting dimension. The user can open all transaction details by selecting the Line details button in the upper-right corner to open the GL Transaction Display application. When the user select a transaction in the General Ledger datagrid, the full voucher and related transactions appear in the Complete Voucher datagrid. The user can take specific actions by selecting the Work with button, which opens 'Voucher. Display' (GLS200/B1).

FIM Interface - Batch uploads

This page contains two tabs:

Validation Errors: To identify validation errors in uploaded batches and to filter lines to find those that contain errors. You can then open H5 to correct the accounting lines. You can also update the batch to the general ledger from the datagrid.
Search: To display all uploaded batches and to search for specific ones using filters. You can update, edit, or delete batches.

Components

This table shows the specific configuration per component:


Component	Component details
Application header	Component ID: appHeader Purpose: Displays the main application header. M3BE data used: MNS100MI Data services used: List_DivisionInfo
DataGrid_Vouchers	Component ID: DataGrid_Vouchers Purpose: Displays a list of vouchers. M3BE data used: FGLHED Data services used: Search_Vouchers
DataGrid_VoucherLines	Component ID: DataGrid_VoucherLines Purpose: Shows voucher line items for a selected voucher. M3BE data used: GLS200MI Data services used: List_VoucherLines
DataGrid_SearchTransaction	Component ID: DataGrid_SearchTransaction Purpose: Provides a search or browse for general ledger transactions across divisions and dates. M3BE data used: GLS200MI Data services used: Search_GL_Transactions
DataGrid_CompleteVoucher	Component ID: DataGrid_CompleteVoucher Purpose: Displays complete voucher lines for a selected transaction. M3BE data used: GLS200MI Data services used: List_CompleteVoucher
DataGrid_AdditionalInfo	Component ID: DataGrid_AdditionalInfo Purpose: Shows additional GL information related to the selected complete voucher. M3BE data used: FGLEDX Data services used: List_AdditionalInformation
DataGrid_BatchHeadErrors	Component ID: DataGrid_BatchHeadErrors Purpose: Lists batch headers with validation errors. M3BE data used: GLS840MI Data services used: Search_BatchHeadError, Update_Batch_ValidationError
DataGrid_BatchAllLines	Component ID: DataGrid_BatchAllLines Purpose: Shows all batch lines for selected batch headers. M3BE data used: FGLINF Data services used: Search_BatchLinesAll
DataGrid_BatchUploadsAll	Component ID: DataGrid_BatchUploadsAll Purpose: Lists all batch uploads with actions, including read, update, and delete, to push to GL. M3BE data used: GLS840MI, FGLINH Data services used: Search_BatchHeadAll, Delete_Batch, Update_Batch

Links and bookmarks

This table shows the link and bookmark along with its purpose:


Link ID	Type	Purpose
Link_BalanceFile_appHead	M3 Bookmark	Opens 'GL Balance File. Display' (GLS215)
Link_CreateVoucher_appHead	M3 Automation	Opens 'Journal Voucher. Enter' (GLS100)
Link_Edit_BatchHeadError	M3 Automation	Opens 'FIM Interface. Manage Transactions' (GLS840)
Link_Edit_BatchLineError	M3 Automation	Opens 'FIM Interface. Open Lines' (GLS842)
Link_Edit_BatchUploadsAll	M3 Automation	Opens (GLS840)
Link_InternalAcct_Voucher	M3 Automation	Opens 'Voucher. Display' (GLS200)
Link_Reverse_Voucher	M3 Automation	Opens 'Voucher. Reverse' (GLS900)
Link_Subledger_Voucher	M3 Automation	Opens (GLS200)
Link_Upload_appHead	M3 Bookmark	Opens (GLS840)
Link_VATcomments_Voucher	M3 Automation	Opens (GLS200)
Link_WorkWith_CompleteVoucher	M3 Automation	Opens (GLS200)
Link_WorkWith_Voucher	M3 Automation	Opens (GLS200)

Dialogs

This table shows the dialogs in General Ledger Desk with their purposes:


Dialog ID	Purpose
Dialog_LineDetails_VoucherLines	Opens GL Transaction Details (M3GLTDET) application in a dialog for the selected voucher line.
Dialog_DisplayVoucher_VoucherLines	Opens GL Voucher Display (M3GLVOD) application in a dialog for the selected voucher line.
Dialog_LineDetails_GeneralLedger	Opens GL Transaction Details (M3GLTDET) application in a dialog for the selected transaction.
Dialog_DisplayVoucher_CompleteVoucher	Opens GL Voucher Display (M3GLVOD) application in a dialog for the selected voucher.

Conditional styles

This table shows the conditional styles of the components in the General Ledger Desk application:


Component	Condition name	Target field	Condition	Styling
DataGrid_Vouchers	Condition_LSJ936	EGVONO	EGVONO=EGVONO	Text color: #0066D4 - blue Text weight: normal Icon: launch Icon color: #0066D4 - blue
DataGrid_Vouchers	Condition_Y9MHMM	EGVOTP	EGVOTP=0	Text color: #0066D4 - blue Text weight: normal Icon: tag Icon color: #0066D4 - blue
DataGrid_Vouchers	Condition_Y9MHM1	EGVOTP	EGVOTP=1	Text color: #0066D4 - blue Text weight: normal Icon: tag Icon color: #0066D4 - blue Background color: #E6F1FD - very light blue
DataGrid_Vouchers	Condition_Y9MHM2	EGVOTP	EGVOTP=2	Text color: #0066D4 - blue Text weight: normal Icon: tag Icon color: #0066D4 - blue Background color: #E6F1FD - very light blue
DataGrid_Vouchers	Condition_H4H8W1	EGREVO	EGREVO≠0	Text color: #0066D4 - blue Text weight: normal Icon: undo Icon color: #0066D4 - blue Background color: #E6F1FD - very light blue
DataGrid_Vouchers	Condition_BCKMY9	EGREVO	EGREVO=0	Text weight: normal Icon color: var(--mp-conditional-styles-icon-color)
DataGrid_Vouchers	Condition_BCKMY9	EGREYR	EGREYR=0	Text weight: normal Icon color: var(--mp-conditional-styles-icon-color)
DataGrid_Vouchers	Condition_Y9MHM3	EGVOTP	EGVOTP=3	Text color: #0066D4 - blue Text weight: normal Icon: tag Icon color: #0066D4 - blue Background color: #E6F1FD - very light blue
DataGrid_Vouchers	Condition_Y9MHM4	EGVOTP	EGVOTP=4	Text color: #0066D4 - blue Text weight: normal Icon: tag Icon color: #0066D4 - blue Background color: #E6F1FD - very light blue
DataGrid_VoucherLines	Condition_VVB24D	ACAM	ACAM=ACAM	Text color: #0066D4 - blue Text weight: normal Icon: dollar-bill Icon color: #0066D4 - blue Background color: #E6F1FD - very light blue
DataGrid_BatchHeadErrors	Condition_HeaderError	FHINHE	FHINHE=1	Text color: #DA1217 - red Text weight: normal Icon: error Icon color: #DA1217 - red
DataGrid_BatchHeadErrors	Condition_HeaderError	FHINLE	FHINLE=1	Text color: #DA1217 - red Text weight: normal Icon: error Icon color: #DA1217 - red
DataGrid_BatchHeadErrors	Condition_DCQWO8	FHSTAT	FHSTAT=13	Text color: #C31014 - dark red Text weight: normal Icon: alert Icon color: #C31014 - dark red Background color: #FBE7E8 - light pink
DataGrid_BatchHeadErrors	Condition_HeaderError	FHINHE	FHINHE=0	Text color: #1C7F49 - dark green Text weight: normal Icon: apply-rule Icon color: #1C7F49 - dark green
DataGrid_BatchHeadErrors	Condition_HeaderError	FHINLE	FHINLE=0	Text color: #1C7F49 - dark green Text weight: normal Icon: apply-rule Icon color: #1C7F49 - dark green
DataGrid_BatchHeadErrors	Condition_W93016	FHRGDT	FHRGDT=FHRGDT	Text color: #0066D4 - blue Text weight: normal Icon: calendar Icon color: #0066D4 - blue
DataGrid_BatchAllLines	Condition_Y36IP8	FFINLE	FFINLE=1	Text color: #DA1217 - red Text weight: normal Icon: error Icon color: #DA1217 - red
DataGrid_BatchAllLines	Condition_Y36IP8	FFINLE	FFINLE=0	Text color: #1C7f49 - dark green Text weight: normal Icon: apply-rule Icon color: #1C7f49 - dark green
DataGrid_BatchAllLines	Condition_EQYB1J	FFCUAM	FFCUAM=FFCUAM	Text color: #0066D4 - blue Text weight: normal Icon: dollar-bill Icon color: #0066D4 - blue Background color: #E6F1FD - very light blue
DataGrid_SearchTransaction	Condition_A9M10K	ACAM	ACAM=ACAM	Text color: #0066D4 - blue Text weight: normal Icon: dollar-bill Icon color: #0066D4 - blue Background color: #E6F1FD - very light blue
DataGrid_SearchTransaction	Condition_GRPHD1	VOTP	VOTP=0	Text color: #0066D4 - blue Text weight: normal Icon: tag Icon color: #0066D4 - blue
DataGrid_SearchTransaction	Condition_GRPHD2	VOTP	VOTP=1	Text color: #0066D4 - blue Text weight: normal Icon: tag Icon color: #0066D4 - blue Background color: #E6F1FD - very light blue
DataGrid_SearchTransaction	Condition_GRPHD2	VOTP	VOTP=2	Text color: #0066D4 - blue Text weight: normal Icon: tag Icon color: #0066D4 - blue Background color: #E6F1FD - very light blue
DataGrid_SearchTransaction	Condition_IR35VU	VONO	VONO=VONO	Text color: #0066D4 - blue Text weight: normal Icon: launch Icon color: #0066D4 - blue
DataGrid_SearchTransaction	Condition_GRPHD2	VOTP	VOTP=3	Text color: #0066D4 - blue Text weight: normal Icon: tag Icon color: #0066D4 - blue Background color: #E6F1FD - very light blue
DataGrid_SearchTransaction	Condition_GRPHD2	VOTP	VOTP=4	Text color: #0066D4 - blue Text weight: normal Icon: tag Icon color: #0066D4 - blue Background color: #E6F1FD - very light blue
DataGrid_CompleteVoucher	Condition_RSKEGC	ACAM	ACAM=ACAM	Text color: #0066D4 - blue Text weight: normal Icon: dollar-bill Icon color: #0066D4 - blue Background color: #E6F1FD - very light blue
DataGrid_CompleteVoucher	Condition_QI341A	VONO	VONO=VONO	Text color: #0066D4 - blue Text weight: normal Icon: document Icon color: #0066D4 - blue
DataGrid_BatchUploadsAll	Condition_10	FHSTAT	FHSTAT=10	Text color: #0066D4 - blue Text weight: normal Icon: info Icon color: #0066D4 - blue
DataGrid_BatchUploadsAll	Condition_Status20	FHSTAT	FHSTAT=20	Text color: #1C7F49 - dark green Text weight: normal Icon: apply-rule Icon color: #1C7F49 - dark green Background color: #EBF9F1 - very light green
DataGrid_BatchUploadsAll	Condition_Status13	FHSTAT	FHSTAT=13	Text color: #C31014 - dark red Text weight: normal Icon: alert Icon color: #C31014 - dark red Background color: #FBE7E8 - light pink
DataGrid_BatchUploadsAll	Condition_Status14	FHSTAT	FHSTAT=14	Text color: #0054B1 - deep blue Text weight: normal Icon: check Icon color: #0066D4 - blue Background color: #BEDCFA - light blue
DataGrid_BatchUploadsAll	Condition_PNPKTY	FHINHE	FHINHE=1	Text color: #DA1217 - red Text weight: normal Icon: error Icon color: #DA1217 - red
DataGrid_BatchUploadsAll	Condition_PNPKTP	FHINLE	FHINLE=1	Text color: #DA1217 - red Text weight: normal Icon: error Icon color: #DA1217 - red
DataGrid_BatchUploadsAll	Condition_PNPKTY	FHINHE	FHINHE=0	Text color: #1C7F49 - dark green Text weight: normal Icon: apply-rule Icon color: #1C7F49 - dark green
DataGrid_BatchUploadsAll	Condition_PNPKTP	FHINLE	FHINLE=0	Text color: #1C7F49 - dark green Text weight: normal Icon: apply-rule Icon color: #1C7F49 - dark green
DataGrid_BatchUploadsAll	Condition_VEAHOU	FHRGDT	FHRGDT=FHRGDT	Text color: #0066D4 - blue Text weight: normal Icon: calendar Icon color: #0066D4 - blue
DataGrid_BatchAllLines	Condition_Y36IP8	FFINLE	FFINLE=1	Text color: #DA1217 - red Text weight: normal Icon: error Icon color: #DA1217 - red
DataGrid_BatchAllLines	Condition_Y36IP8	FFINLE	FFINLE=0	Text color: #1C7f49 - dark green Text weight: normal Icon: apply-rule Icon color: #1C7f49 - dark green
DataGrid_BatchAllLines	Condition_EQYB1J	FFCUAM	FFCUAM=FFCUAM	Text color: #0066D4 - blue Text weight: normal Icon: dollar-bill Icon color: #0066D4 - blue Background color: #E6F1FD - very light blue