Possible To Trap in one Model

[Nick Osdale-Popa]

I don't see an option to attach files, so I'll use what's available.
Below are two types of reporting on Vendor Invoices.
Report 1 is for over $250
Report 2, under.

I can easily trap the Invoice "header": Vendor, dates, etc.
I have a Footer Template for Report 1 to trap Job/Phase/Cost Code.
Obviously, this template does not work for Report 2.

Since these lines are Line Numbers, there could be more than 1 line under each header. I only need Line 1. (Though I guess a filter can fix that)
Will it be possible to create a model that will trap both scenarios?

RUN DATE 07/16/02 14:50:36 COINS ACCOUNTS PAYABLE MODULE PAGE 1
BIGBIG COMPANY UNPOSTED VENDOR INVOICE LIST
BATCH: TW0715E SORTED BY ENTRY
FOR ALL USER IDS

VENDOR VENDOR NAME INVOICE INV DATE DUE DATE CO DIV APP PAYABLES DISC
FISC DT DISC DT ACCOUNT AMT


8048 XXXXXVENDORNAMEXXXXXXXXXXX 806501 07/09/02 09/07/02 1 1 Y 20100 6.54 AMOUNT: 326.88
XXXXXADDRESSXXXXXXXXXXXXXX P/O 01153-229 07/31/02 08/10/02 SALES TAX: 0.00
XXXXXADDRESSXXXXXXXXXXXXXX C/O 0000 FREIGHT: 0.00
XXXXXCITYSTZIPXXXXXXXXXXXX DOCUMENT ID: INVOICE AMOUNT: 326.88


INVOICE LINE: 1 TAX/DIR PAY: N N P/O LINE: 1
JOB: 11.111 TAX JURIS: LA QTY ORDERED: 30.00
PHASE: PH CO/DIV/CTR: 1 1 1 QTY RECEIVED: 30.00
COST CODE: CSCD G/L ACCOUNT: 15010 QTY PREV INV: 0.00
CATEGORY: MA QTY INVOICED: 30.000 AMT PREV INV: 0.00





<<<2nd Report>>>

RUN DATE 07/16/02 14:50:57 COINS ACCOUNTS PAYABLE MODULE PAGE 1
BIGBIG COMPANY UNPOSTED VENDOR INVOICE LIST
BATCH: TW0715F SORTED BY ENTRY
FOR ALL USER IDS

VENDOR VENDOR NAME INVOICE INV DATE DUE DATE CO DIV APP PAYABLES DISC
FISC DT DISC DT ACCOUNT AMT


8048 XXXXXVENDORNAMEXXXXXXXXXXX 806501 07/08/02 09/06/02 1 1 Y 20100 0.25 AMOUNT: 12.69
XXXXXADDRESSXXXXXXXXXXXXXX 07/31/02 08/10/02 SALES TAX: 0.00
XXXXXADDRESSXXXXXXXXXXXXXX 20002-195 FREIGHT: 0.00
XXXXXCITYSTZIPXXXXXXXXXXXX DOCUMENT ID: INVOICE AMOUNT: 12.69

COST INST DIR TAX USE TAX G/L
LINE JOB PH CODE CAT QUANT TAX PAY JURIS AMOUNT CO DIV CTR ACCOUNT QUANTITY UNIT COST AMOUNT
1 11.111 PH CSCD MA 0.00 N N LA 0.00 1 1 1 15010 0.000 0.00000 12.69

[ July 22, 2002, 06:56 PM: Message edited by: Nick Osdale-Popa ]

[Mike Urbonas]

Hi Nick, we are not ignoring you, honest! :D

I looked at your reports. Odd how the report > $250 and < $250 have such different display format for the detail data...

Although it MAY be possible to generate one mightily complex single model to get the data from both reports despite the different layouts, I suggest the benefit does not justify the effort.

Instead I suggest simply creating one model for each report and append the results to the same Excel or Access file. Of course if you would like to then open that Excel or Access file in Monarch Pro, you can do that too smile.gif

Mike

[Nick Osdale-Popa]

Thanks. I did determine it was easier to use 2 models. Both <250 and >250 information does get printed to the same report, so I am using 2 passes, 1 for each model.
Since almost all my Monarch usage is through Excel (or Access) via OLE the process is hidden from the user. My default VBA Class that I use for Monarch had to be slightly tweaked. Actually not so much the Class, as the routine that uses the Class.
Thanks again! ;)