🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

New to Trapping and Organizing

Altair Forum User

I am having trouble visualizing what I need to do with the structure of this particular document. In this attachment, I have a series of transactions with multiple lines. I would like to sort the transactions by account number, but maintain the grouping of the transactions. For example, I would like to find all transactions involving account #1505 (you can see one on 10/7/2014 and another on 10/18/2014). When I sort by account number, it separates the line from its total transaction record.

Is there a way to trap and group this information so I can sort these multi-line transactions?

Thank you for any suggestions!

------------------------------
Meagan Smith
Staff Investigator
Dawson Forensic Analytics, PLLC
Lubbock TX
806-239-7865
------------------------------

Monarch Journal Question for Forum.png

Find more posts tagged with

English

Monarch

Accepted answers

All comments

CPorthouse

A couple of questions:

What version number and type of Monarch are you using (Classic or Data Prep Studio)?
Is there any consistency in how you can identify when your memo and account number jump to the following line?

I am going to assume this comes from a text based document (PDF, txt, etc.) where you need to create a template (or two) since you mentioned trapping, but if that is not the case, let us know. I would start off with a detail template that captures the main record:

Memo
Account #
Account
Debit
Credit

For the detail, I would trap on the 4 digits of the account number at a minimum. Since we only see a small sample of your data, you may need to change that.

Notice I have left out the Date, Transaction Type, Num, and Name. I would create an append template to capture those fields. The main rule for an append template is that the data has to occur above or ON a detail record. The trap for the append template would at a minimum be the date (NN/NN/NNNN). You can also include another field for AP/AR that would capture the Accounts Payable/Accounts Receivable name if needed.

Hope this helps.

------------------------------
Chris Porthouse
Senior Implementation & Integration Engineer
Altair
------------------------------
-------------------------------------------
Original Message:
Sent: 06-14-2019 12:23 PM
From: Meagan Smith
Subject: New to Trapping and Organizing

I am having trouble visualizing what I need to do with the structure of this particular document. In this attachment, I have a series of transactions with multiple lines. I would like to sort the transactions by account number, but maintain the grouping of the transactions. For example, I would like to find all transactions involving account #1505 (you can see one on 10/7/2014 and another on 10/18/2014). When I sort by account number, it separates the line from its total transaction record.

Is there a way to trap and group this information so I can sort these multi-line transactions?

Thank you for any suggestions!

------------------------------
Meagan Smith
Staff Investigator
Dawson Forensic Analytics, PLLC
Lubbock TX
806-239-7865
------------------------------
"

Altair Forum User

A couple of questions:
What version number and type of Monarch are you using (Classic or Data Prep Studio)?

Is there any consistency in how you can identify when your memo and account number jump to the following line?

I am going to assume this comes from a text based document (PDF, txt, etc.) where you need to create a template (or two) since you mentioned trapping, but if that is not the case, let us know. I would start off with a detail template that captures the main record:
Memo

Account #

Account

Debit

Credit

For the detail, I would trap on the 4 digits of the account number at a minimum. Since we only see a small sample of your data, you may need to change that.

Notice I have left out the Date, Transaction Type, Num, and Name. I would create an append template to capture those fields. The main rule for an append template is that the data has to occur above or ON a detail record. The trap for the append template would at a minimum be the date (NN/NN/NNNN). You can also include another field for AP/AR that would capture the Accounts Payable/Accounts Receivable name if needed.

Hope this helps.

------------------------------
Chris Porthouse
Senior Implementation & Integration Engineer
Altair
------------------------------
-------------------------------------------
Original Message:
Sent: 06-14-2019 12:23 PM
From: Meagan Smith
Subject: New to Trapping and Organizing

I am having trouble visualizing what I need to do with the structure of this particular document. In this attachment, I have a series of transactions with multiple lines. I would like to sort the transactions by account number, but maintain the grouping of the transactions. For example, I would like to find all transactions involving account #1505 (you can see one on 10/7/2014 and another on 10/18/2014). When I sort by account number, it separates the line from its total transaction record.

Is there a way to trap and group this information so I can sort these multi-line transactions?

Thank you for any suggestions!

------------------------------
Meagan Smith
Staff Investigator
Dawson Forensic Analytics, PLLC
Lubbock TX
806-239-7865
------------------------------
"

Thank you for these suggestions! I think I have been approaching the append feature incorrectly, and this will help me reorganize. I am using DataPrep Studio. This comes from a PDF file and I am trying to create a template that makes it easy to search through transactions. The issue is I need the Memo lines/Account Numbers to stay grouped together. When I get the data into a table and sort by account name or number, it separates it from the full transaction record. For example, transaction number 274 is divided into 3 different accounts. I want to be able to sort by information within the account numbers, while keeping the lines grouped with their original transactions. Unfortunately, there are many inconsistencies with how the data is originally formatted (each line doesn't have an account number, some don't have memos, etc.) Ultimately, what I need may not be possible with the data presented this way.

------------------------------
Meagan Smith
Staff Investigator
Dawson Forensic Analytics, PLLC
Lubbock TX
806-239-7865
------------------------------
-------------------------------------------
Original Message:
Sent: 06-15-2019 07:46 AM
From: Chris Porthouse
Subject: New to Trapping and Organizing

A couple of questions:

What version number and type of Monarch are you using (Classic or Data Prep Studio)?
Is there any consistency in how you can identify when your memo and account number jump to the following line?

Memo
Account #
Account
Debit
Credit

For the detail, I would trap on the 4 digits of the account number at a minimum. Since we only see a small sample of your data, you may need to change that.

Notice I have left out the Date, Transaction Type, Num, and Name. I would create an append template to capture those fields. The main rule for an append template is that the data has to occur above or ON a detail record. The trap for the append template would at a minimum be the date (NN/NN/NNNN). You can also include another field for AP/AR that would capture the Accounts Payable/Accounts Receivable name if needed.

Hope this helps.

------------------------------
Chris Porthouse
Senior Implementation & Integration Engineer
Altair
------------------------------

Original Message:
Sent: 06-14-2019 12:23 PM
From: Meagan Smith
Subject: New to Trapping and Organizing

I am having trouble visualizing what I need to do with the structure of this particular document. In this attachment, I have a series of transactions with multiple lines. I would like to sort the transactions by account number, but maintain the grouping of the transactions. For example, I would like to find all transactions involving account #1505 (you can see one on 10/7/2014 and another on 10/18/2014). When I sort by account number, it separates the line from its total transaction record.

Is there a way to trap and group this information so I can sort these multi-line transactions?

Thank you for any suggestions!

------------------------------
Meagan Smith
Staff Investigator
Dawson Forensic Analytics, PLLC
Lubbock TX
806-239-7865
------------------------------
"