Has anyone picked up on this for you yet?
If not is there any chance of posting a sample layout and explanation of the problem for people to see in the open forum? It may be that someone can spot a solution to the problem and refer you to a previous thread which could give you the information you need.
Edit to observe that Bruce and I must have been parallel posting.
I could email the small report if I could be helped.
Bruce and Grant,
Thank you for your reply, I am out of my office and at a client's for the week; therefore am on a "foreign" computer.
Please respond and tell me how to "post" the sample. I have one with me.
I have also read Grant's earlier reply to a similar question in February and have not had the chance to use RSPLIT and LSPLIT.
Thank you for your help.
I just use Monarch (or use Notepad) to copy to the clipboard, then open this site , then paste the data from the clipboard.
If you have to worry about the report columns lining up use the code box-button. (below)
[size="1"][ April 05, 2005, 03:40 PM: Message edited by: Bruce Reed ][/size]
Grant and Bruce,
Thank you for your interest. here is the report
BANK CODE 001 CASH- BANK OF DENVER
CHECK CHECK REMIT-TO NAME INVOICE INVOICE VOUCH# P.O.-NO AMOUNT DISCOUNT CHECK
NO DATE VENDOR-# NO DATE PAID TAKEN AMOUNT
17472 01/13/99 KCXTR KC'S X-TRA 208845 12/15/98 8808 106.99 .00 106.99
COMPUTER CHECK BILLING VENDOR: E-R EURO-RAILS MODEL IMPORTERS LTD
CHECK TOTALS: 106.99 .00 106.99
17473 01/13/99 LGB LGB OF AMERICA 119039 12/14/98 8311 105.88 .00 105.88
CHECK TOTALS: 105.88 .00 105.88
17474 01/13/99 MARKL MARKLIN INC 86141 12/14/98 8444 115.64 .00 115.64
86142 12/14/98 8445 97.02 .00 97.02
86143 12/14/98 8446 146.22 .00 146.22
86146 12/14/98 8449 328.30 .00 328.30
CHECK TOTALS: 687.18 .00 687.18
This looks like a straight forward report. What is not working?
If this was my report I would take the cheque details as the detail line with tthe amount paid, veoucher #, invoice date, and invoice #. Then use append the cheque # Cheque date, and vendor name & number. You could try & get the cheque total, but you can use the summary in Monarch to show.
Let us know if this helps.
"What is not working?" Probably me! I will try this this afternoon. I would classify myself as a 4 on a Monarch ability scale. My problem was that I could not get individual invoices to appear with their check numbers. But I will work on this this afternoon.
Thank you for your quick reply.
It worked fine your way. I think my early tries were in the vein of one line-one template. Your way uses the same line but two different templates. I was not able to apply the "Check Totals" as a template attached to the check number but seem to be successful in subtotalling inv amounts to check. This of course can be done in Excel also.
thank you for your most excellent help. I don't know what I would do without the support of the experts on the Forum. Bravo!