You’re offline. This is a read only version of the page.
10
I'm wondering if there is a way to mark GL transactions as "Cleared or Closed." This way when I run a detailed GL for all the transactions in an account, the ones that are cleared do not show up. This way I can put my focus on only viewing the transactions that are "Open" and truly affecting the balance in that account.
For example; If I enter two pre-paid transactions to the GL, one for 1,000 and one for 2,000. The 1,000 transaction will be journalized out of pre-paid to expense, the following two months at 500.00 each. At the end of the two months, I would like to "Clear or Close" the three transactions that net to 0 (the Debit for 1,000 and the two credits for 500.00). This transaction is no longer affecting the balance in this account. When I run a detailed GL to see the transactions in the account I will only want to see the ONE transaction for 2,000 as it's the only thing affecting the balance.
Thanks for your help.
Kind Regards,
I am a fan of the Transaction Matching feature in GP. It won't show as cleared/closed on GL reporting but if you have access to a SQL resource, a view should be able to be created that includes this type of information (and can then be created as a SmartList and/or integrate with an Excel workbook).
Searching the community forum, I found this post of a possible view that may work for you:
community.dynamics.com/.../transaction-matching-in-the-general-ledger-dynamics-gp
#1
Sohaib Cheema
665
User Group Leader
#2
Martin Dráb
595
Most Valuable Professional
#3
Yng Lih
558
Share
Report
All responses (
Answers (
