I'm a fairly new Monarch user, who's having a problem figuring something out.
I have a general ledger report that I'm trying to extract data from. Some of the records are all on one line, while others are on two lines. Here's an example:
I need to be able to capture each of the fields shown in the header, plus the Vendor number (V#) and invoice number (I#). My questions are:
ACCOUNT OPEN DEBITS CREDITS CHANGE CLOSE
JOURNAL DATE BCH ENTRY DEBITS CREDITS DESCRIPTION
DEPARTMENT: 01.6000 SAMPLE DEPARTMENT
01.6000.2000 - SAMPLE DEPARTMENT CONTRACT LABOR
0.00 61,129.96 15,540.35 45,589.61 45,589.61
GEN 10/11/06 3 2-1 550.00 ACCRUE ABC INV#323142
AP 10/17/06 2 48 80.00 V# V000003 I# 11-7 F# SYSTEM
Remit to: LINDA SMITH
AP 10/24/06 1 89 550.00 V# V000048 I# 323142 F# SYSTEM
Vendor: ABC SERVICES
AP 10/24/06 1 94 336.00 V# V000846 I# 4460 F# SYSTEM
Vendor: CBA, INC
GEN 11/07/06 3 11-1 982.00 ACCRUE CBA INV #004536
GEN 11/07/06 3 12-1 799.00 ACCRUE CBA INV #004510
GEN 11/07/06 3 15-1 603.00 ACCRUE CBA INV #004549
1. How can I capture both the GL fields and the 2-line fields at the same time?
2. How do I capture variable length fields? Notice the "I#" field, which is variable length.
3. There's a similar issue with the "Remit to:" and "Vendor:" data. They're in roughly the same spot, and I want to treat them the same when I extract the data, but they start in different positions.
Thanks for helping the "noob"!
[Edit: Found that pinned thread and was able to post the report so it looks right. Woohoo!)