Skip to main content

Cash Receipt Journal Transaction Detail

CASH RECEIPT JOURNAL TRANSCTION DETAIL

There is a new report in General Ledger – Reports – Reports that will help you determine where a cash receipt journal transaction is posted along with giving you the details of all journal transactions selected in the POST CASH to GL process that make up a Cash Receipt found in the General Ledger.

First Scenario – You have a cash receipt either from A/R cash receipt entry or a POS Batch that you cannot figure out what new journal transaction it has been rolled into through the Post Cash to GL Process:

  1. Go to Accounts Receivable – Cash Receipts – Cash Receipt Journal or Daily Cash Report.  Run the report for the date the cash receipt was taken and ADD to the Report Main JT ID. This will give you the Journal Transaction ID that the original cash receipt entry created.

Cash Receipt Journal:

Image

Image

Image

Daily Cash Report:

Image

Image

Image

  1. Now go the General Ledger – Reports – Reports – F6 and select DM.GL.CASH.JT.DETAIL (This is a new report with v30).   When a cash receipt journal transaction is posted through the POST CASH to GL process it creates a new type of record called a JT,CJ and writes this ID on the original journal transaction as a JOURNAL ID.   So in order to find the JOURNAL ID you need to modify the Specific Values of this report to look like this:

Image

You need to replace Journal ID with just ID (cash receipt Journal Transaction ID) make it “equal to” the JT ID from the Cash Receipts report of the Daily Cash Report above.   Run the report and this will give you the new JOURNAL ID that was created through the POST CASH to GL process:

Image

  1. Now to see all of the other Journal Transactions that were selected to make up the new Journal ID, you need to close the report and bring it back up again and this time all you need to do is enter the JOURNAL ID from the report is #2 into the specific values and run it:

Image

Image

Second Scenario:   You have a journal transaction in you General Ledger or Bank Reconciliation that you need to find out all transactions that are posted to it.  

  1. Go to GL Inquiry to find the Journal Id that is posted to the GL Account.

Image

  1. Using the Journal ID found in the Document Column of the GL Inquiry grid – bring up the report in General Ledger – Reports – Reports – F6 DM.GL.CASH.JT.DETAIL – and enter the Journal Id in the Specific Values and run the report:

Image

Image

If questions or issues please contact [email protected]