- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Customize Invoice History Report
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
07-23-2010 10:08 AM
Hi all,
Below is how my current print out looks like. I would like to add a column that shows warehouse and unit of measurement next to the unit price. I'm using MAS 90 and not sure what is the correct module folder to make this addition. Thanks in advance.
0061735 INV 01/04/10 S/O 00-3000214 FLOORING, INC. 0200
ITEM CODE DESCRIPTION SHIPPED UNIT PRICE EXTENSION
TER18BS 18X18 TERRE BRASS (R/T 22.000 21.8900 481.58
INVOICE TOTAL: 481.58
0061736 INV 01/07/10 S/O 00-1000500 SUPPLY REPAIR & REMODE 9100
ITEM CODE DESCRIPTION SHIPPED UNIT PRICE EXTENSION
HMP00BE 12X12 HAMPTON-BEIGE 726.000 .5627 408.52
GMM00BE 12X12 GAMMA-BEIGE 66.000 6.1900 408.54
WIL00PE 12X12 WILLIAM-PEACH 2178.000 .5627 1,225.56
MBC00BL 12X12 MONTBLANC BLUE 1452.000 .5627 817.04
MBC00PE 12X12 MONTBLANC PEACH 198.000 6.1900 1,225.62
PHO33CC 13X13 PHOENIX COCOA (G 216.000 8.2833 1,789.19
PHO33NC 13X13 PHOENIX NOCE (GL 72.000 8.2833 596.40
PHO33BE 13X13 PHOENIX BEIGE (G 72.000 8.2833 596.40
MBC80BE 8X10 MONTBLANC BEIGE 96.000 7.9620 764.35
PHO80CC 8X10 PHOENIX COCOA (WA 1032.999 .7400 764.42
PHO80NC 8X10 PHOENIX NOCE (WAL 96.000 7.9620 764.35
0061737 INV 01/13/10 S/O 00-3000196 TILE CO., INC. 0400
ITEM CODE DESCRIPTION SHIPPED UNIT PRICE EXTENSION
GMM00BE 12X12 GAMMA-BEIGE 4.000 9.7900 39.16
INVOICE TOTAL: 39.16
Re: Customize Invoice History Report
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
07-23-2010 10:34 AM
What version of MAS? If you're on 4.1 or higher, you can create a report setting for the A/R Invoice History Report and modify the report using Crystal Reports. Obviously, you have to install Crystal Reports on your computer. Make sure you are using CR 10 with 4.1 - 4.3 and CR XI with 4.4. For 3.7-4.05, you will have to recreate the report from scratch (CR 8.5) using the ARO, ARN, and AR1 files. You may need more files if these 3 files do not contain all of the data you want on your report.
Re: Customize Invoice History Report
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
07-28-2010 03:08 PM
Version 4.0, I think this will be best for a tech to do since I don't know what are ARO, ARN, and AR1 files. Thanks for your reply.
Re: Customize Invoice History Report
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
07-29-2010 07:40 AM
I'm not sure if you are aware of this, but you are seriously out of date on your software. Do you have a reseller partner to help you upgrade?
Dawn


