Orders MAS

Order Items

---

View required for this screen

 create view [dbo].[v_so_salesorderhistoryheader]
 as
 select a.*, CONVERT(varchar, a.OrderDate,101) as ct_orderdate
 , CONVERT(varchar, a.DateCreated,101) as fmt_datecreated
 , CONVERT(varchar, a.DateUpdated,101) as fmt_dateupdated
 , CONVERT(varchar, a.AuthorizationDate,101) as fmt_authorizationdate
 from so_salesorderhistoryheader a 

---

Order Summary

• Printing

There are 3 print options. 1. Print the on screen page

2. Print using Crystal Reports

3. Print the MAS pdf invoice (this is the default)

To turn on print using Crystal Reports you must configure the following settings

   <add key="MASUseCrystal" value="True"/>
   <add key="MASInvoiceReportPath" value="C:\Program Files (x86)\Sage\CRM\CRM\WWWRoot\Reports\Sales\MASInvoice.rpt"/>
   <add key="PDFPath" value="C:\temp"/>
   <add key="MASserver1" value="localhost\CRMSQLEXPRESS"/>
   <add key="MASdbname1" value="MAS_MMM"/>
   <add key="MASdbuser1" value="sa"/>
   <add key="MASpwd1" value="password"/>

• MASUseCrystal - This turns on the Crystal option
• MASInvoiceReportPath - This is the path to the report on the server
• PDFPath - This is the folder that will hold the PDF file when created and before is is downloaded (it is deleted once downloaded)
• MASserver1- The name of the server
• MASdbname1- The database name
• MASdbuser1- The db user name
• MASpwd1- The db user password

The Crystal report should have a parameter called "salesorderno" that is a string type and static.

You can request a sample report from us also.