Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Visitor
sont
Posts: 4
Registered: 01-21-2010
0

Customize Invoice History Report

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
                                                                  ------------
                                                                                                 INVOICE TOTAL:    9,360.39

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

Super Contributor
Posts: 1,462
Registered: 11-03-2008
0

Re: Customize Invoice History Report

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.

Visitor
sont
Posts: 4
Registered: 01-21-2010
0

Re: Customize Invoice History Report

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.

Super Contributor
DFeller
Posts: 2,944
Registered: 10-28-2008
0

Re: Customize Invoice History Report

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