To set up an Excel Statement
Click System Admin, Setup, Excel Statement Library
Right-click the Grey area of the window and select Modify
Right-click again and select Create Record
Type a Code. This can be any name.
If required, type a Description.
Select the header format.
If required, type Notes. Now the Statement has been created, to add the columns in:
On the Columns tab, right-click and select Add/Remove Columns
Select the check boxes on the columns you wish to have on the Excel statement.
Click OK
Check the columns are in the correct order. To change the order, check you are in Modify Mode. In the display order field, click the number and type the corresponding number.
If you're emailing these statements out, to create an email template, click the Email tab
Type the subject
Type the Body. If you want this to reference account numbers, to find the code, right-click and select View available tags.
To define this Excel Statement as the default, go back to the toolbar and click System Admin, Setup
Within this screen, select Company Details, click the Sales tab and then click the Statements Tab
To define the default Excel statement, click the 3 dots, ellipsis icon and select the statement you have just set up.
To creating the routing for your customers
Find your customer within Safe
Click the Routing Tab
Make sure you're in Modify mode
Right-click and select Create Record
Set Address to All
Set Document Applicability to Excel Statements
Set the Send By column to either Email if you would like email it to customers, or Manual if you would like the statement to go within the Documents tab, but NOT emailed.
To make sure your Excel statements send
Navigate to your customers.
In the top half, right-click and select Produce Statement
Use the drop-down and select Distribution
Select Send By to All
Select Emails from to who you would like.
Optional steps:
If a customer wanted an custom excel statement, you can override the company level excel statement by doing the following:
Navigate to the customer
Click the Customer Tab
Click the Settings Tab
On the right near Excel Statements click the 3 dots, ellipsis icon and select the custom statement for the customer.
If you would like your logo on the Excel Statement:
Go back to the toolbar and click System Admin, Setup
Navigate to Pathnames
Click the Binoculars icon and search for path name 331.
Type the filename for the logo, for example CompanyLogo.jpg. You need to make sure the logo is saved in the following path:
\\YourServerName\Safe\Financials\images\Logos