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 2 print options. 1. Print the on screen page 2. Print using Crystal Reports

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.