Overview
Using the Sales Pad Excel Sales Document report, along with an Excel spreadsheet containing merge fields, you can create an Excel spreadsheet report for an existing sales document. Merge fields will insert predefined information from the sales document into the spreadsheet report. You can create more than one Excel spreadsheet with different levels of detail, and select from those files to choose the level of detail displayed on the printed sales document.
Security
Excel Sales Document must be enabled in the Security Editor. Print Report
- If Invoice Reports, Order Reports, Quote Reports, or Return Reports are not blank ( enabling all), the Excel Sales Document report must be added to the list of reports that can be used under the applicable sub- setting( s).
Setup
First, create an Excel file template, much like you would create a template for a Printed Report. This template can include the company logo and standard wording that will apply to all printed documents using this template. It must contain merge fields that will pull information specific to each sales document onto the report. Place the desired merge fields from the list below into the appropriate areas of the template. Here is a list of merge fields that can be used:
|
Excel Value |
|
Sales Document Value |
|
<invoice_no> |
= |
Sales_ Doc_ num |
|
<quote_no> |
= |
Sales_ Doc_ num |
|
<today> |
= |
Current Date |
|
<expiration_date> |
= |
Document Date |
|
<customer_name> |
= |
Customer Name |
|
<contact_name> |
= |
Contact Person |
|
<customer_phone> |
= |
Ship To Phone 1 |
|
<HDR: CUSTNMBR> |
= |
Customer Number |
|
<HDR: DOCDATE> |
= |
Document Date |
|
<HDR: SLPRSNID> |
= |
Sales Person Id |
|
<HDR: SHIPMTHD> |
= |
Shipping Method ID |
|
<HDR: PYMTRMID> |
= |
Payment Terms |
|
<HDR: CSTPONBR> |
= |
Customer PO Number |
|
<HDR: COMMENT_1> |
= |
Comment |
|
<HDR: NOTES> |
= |
Notes |
|
<contact_name> |
= |
Customer Ship To Contact Person |
|
<customer_contact> |
= |
Customer Ship To Contact Person |
|
<invoice_date> |
= |
Document Date |
|
<customer_email> |
= |
Customer Card Email Address |
|
<bill_to> |
= |
Sales Document Bill To Address |
|
<ship_to> |
= |
Sales Document Ship To Address |
|
<subtotal> |
= |
Sales Document Subtotal |
|
<freight> |
= |
Sales Document Freight |
|
<tax> |
= |
Sales Document Tax |
|
<total> |
= |
Sales Document Total |
|
<doc_contact> |
= |
Contact |
|
<doc_email> |
= |
Document Shipping Email Address |
|
<doc_phone> |
= |
Phone |
|
<doc_bill_to> |
= |
Bill To |
|
<doc_ship_to> |
= |
Ship To |
Line Items:
|
<line: qty_ord> |
= |
Quantity Ordered |
|
<line: qty_shipped> |
= |
Quantity Shipped |
|
<line: item_no> |
= |
Item Number |
|
<line: item_desc> |
= |
Item Description |
|
<line: unit_price> |
= |
Unit Price |
|
<line: sell_price> |
= |
Sell Price |
|
<line: extended_price> |
= |
Extended Price |
|
<line: ext_price> |
= |
Extended Price |
|
<line: serial_no> |
= |
Serial Number |
Usage
To print the report,
- In Sales Pad, open a sales document and click Print
- Select Excel Sales Document from the list of Available Reports
- Click Print or Preview. You will be prompted to open the Excel spreadsheet.
Note: Sales Pad will open any . xls file and will merge with only the first worksheet in the file - Select the file and click Open. Any merge fields will be replaced with the corresponding information from the open sales document
- You can now modify the spreadsheet and print, fax, or email it as needed
Note: Due to limitations in Microsoft, the max transfer for any field is 255 .
SalesPad Support
Comments