Discrepancy details customer ledger vs general ledger (GL408010)

This topic provides information about the elements in this window in Visma Net, such as fields, field values, buttons, and check boxes.

It will only show documents that cause the discrepancies.

You will only be able to process not-released and not-posted batches in this window. All other discrepancies must be corrected by manually posting the missing transactions.

For other discrepancies, please contact Visma support, who will assist you in correcting the transactions.

The window toolbar

Button	Description
Release/post	By clicking Release/post, you will release marked documents. Only documents with the error message Not released in General ledger or Not posted in General ledger will be processed. The button is only active if you have selected the Discrepancy category Unposted/Unreleased.
Hide/Unhide	A button for hiding/unhiding selected lines. This is used for discrepancy lines that have been corrected.
Set reconciled period	A button for updating the reconciled period, used to suggest the From period. This period is found in General ledger preferences - Discrepancy settings, Reconciled financial period.

Release/post

By clicking Release/post, you will release marked documents. Only documents with the error message Not released in General ledger or Not posted in General ledger will be processed.

The button is only active if you have selected the Discrepancy category Unposted/Unreleased.

Hide/Unhide

A button for hiding/unhiding selected lines. This is used for discrepancy lines that have been corrected.

Set reconciled period

A button for updating the reconciled period, used to suggest the From period. This period is found in General ledger preferences - Discrepancy settings, Reconciled financial period.

The top part

Field	Description
Company	Filter on Company. The column is only visible if you have activated multi-branch.
Branch	Filter on Branch. The column is only visible if you have activated multi-branch.
Discrepancy category	Filtering different categories of discrepancies. UnPosted/Unreleased [1,2,21] Manually entered [22] GL Transactions do not exist [0] AR Transactions do not exist [20,22] Amount mismatch [3,4,5,6] Other work spaces [22] Different branches [23] Reversed batch [24] Deleted documents [25] [NN] The numbers correspond with the Discrepancy category (in the top part), see information in the Discrepancy column in the table.
Include hidden lines	Selecting this checkbox will display previously hidden transactions, and you will be able to unhide the documents again.
From period	Filter on From period. The period is suggested from Reconciled financial period in General ledger preferences and, if that is empty, it will suggest the first open period from Financial periods.
To period	Filter on To period.
Account	Filter on Account. You can only select accounts defined as Control account module for customers and suppliers.
Customer	Filter on Customer. Select the customer you wish to filter upon.
Sum Customer ledger	Sum based on the selected tab for Customer ledger documents.
Sum General ledger	Sum based on the selected tab for the General ledger documents.
Sum discrepancies	Sum based on the selected tab for discrepancies between the Customer ledger and the General ledger documents.

The table

This table will adjust which columns are visible, depending on the Discrepancy category selected in the Top part, to reduce the display of empty columns.

Column	Description
Note	This is the Note from the transaction. If the line contains a General ledger transaction, it will be the note you see or can edit and if the line only contains a Customer transaction, it will be the invoice note that will shown and can be edited.
Selected	The selection column for lines you want to hide/unhide or release/post.
Hidden	A check box that, when selected, indicates that the transaction is hidden. To hide or unhide, you can select the line and click the Hide/Unhide button. You hide transactions when you have found a matching correction transaction, so you do not need to check them again.
Discrepancy	Discrepancy types: The General ledger transaction does not exist. The General ledger transaction is not released. The General ledger transaction is not posted. The Currency ID does not match. The Currency rate does not match. The invoice ledger currency sum does not match. General ledger currency sum. The invoice ledger amount does not match General ledger amount. The Branch ID does not match. The invoice does not exist. The invoice has not been released. The General ledger transaction is directly entered. The General ledger account is used in another module. [99] the number exists in the database text, so it can be used in Generic queries
Discrepancy amount	The difference between Customer ledger amount and General ledger amount. (General ledger amount - Customer ledger amount)
Currency discrepancy amount	The difference between Customer ledger amount and General ledger amount in currency.
Branch, Customer ledger	The branch for the Customer ledger document. This document is found in the Financial setting section in customer documents.
Transaction type, Customer ledger	The transaction type of the customer document.
Ref. no, Customer ledger	The reference number of the customer document.
Amount, Customer ledger	The total amount for the customer document.
Adjustment amount, Customer ledger	Currency gain or loss amount.
Currency, Customer ledger	The currency of the customer document.
Currency rate, Customer ledger	The currency rate for the customer document.
Currency amount, Customer ledger	The total amount in currency for the customer document.
Workspace	The workspace for the voucher line in the General ledger, if the general ledger transaction is missing, it will display Customer ledger.
Transaction type, General ledger	The Transaction type for the voucher line in the General ledger.
Ref. no, General ledger	The Reference number for the voucher line in the General ledger.
Branch, General ledger	The Branch for the voucher line in the General ledger.
General ledger, batch number	The Batch no. for the voucher line in the General ledger.
Currency amount, General ledger	The Currency amount for the voucher line in the General ledger.
Amount, General ledger	The Amount for the voucher line.
Account number	The Account number for the transaction.
Account description	The Account name for the account.
Period, customer	Financial period for the customer document.
Period, General ledger	Financial period for the General ledger transactions.
AR Created	The date when the customer document was created.
AR Created by Screen ID	The window where the customer document was created. The screen ID will tell you what window the document was created in. (00000000 = created by API).
AR Last modified by screen ID	The window where the customer document was last edited. The screen ID will tell you what window the document was modified in. (00000000 = created by API).
GL Created	The date when the General ledger transaction was created.
Created by window ID General ledger	The window where the GL Batch was created. The screen ID will tell you what window the document was created in. (00000000 = created by API).
GL Last modified by screen ID	The window where the customer document was last edited. The screen ID will tell you what window the document was modified in. (00000000 = created by API).