Discrepancy details customer ledger vs general ledger (GL408010)
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
- 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
- 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.
- 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).