Mark Transactions as "Cleared or Closed"

(0) Share

Report

Posted on by GPGUY2022

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,

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Suggested answer

Lisa at AonC.com 572 on at

Like (1)

Report

RE: Mark Transactions as "Cleared or Closed"

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