Xenogenix Support Page

Sales Invoicing

Purchase Invoicing

  • Create Purchase Invoice
  • Who needs paying
  • Pay Purchase Invoice
  • Remittance Advice (“Email remittances when a payment is entered” and “Re-send remittances”)
  • Credit notes
  • Reconcile payment with Bank see:  Bank Reconciliation(Reconcile a Supplier Payment)
  • Netting-off Credit Notes see: Credit notes (Raise a Credit Note against a PAID invoice)
  • Debit Card purchases see: Bank Reconciliation(Reconcile a Supplier Payment without an Invoice: 1 step processing)
  • Petty Cash purchases (use Bank Rec Purchase with ‘Bank Account’ set to ‘Petty Cash’)
  • Credit Card purchases (create a Purchase Invoice for all the items in your Credit Card Statement, then use Supplier Payment to pay the card off)

Bank Reconciliation

Payroll

VAT Submission

Loans

Manual Adjustments

Basic Admin functions

 

Salesforce How To…

Hide Section - Induction informationInduction information

Introduction to Salesforce

Here are some videos to introduce you to Salesforce

Navigating around Salesforce in Lightning Navigating Salesforce Lightning

This video shows how you can use Salesforce Lightning to manage your pipeline, including the Kanban view Managing your Pipeline

List Views are a key way for you to find and organise your data Using and Editing List Views

Reports and Dashboards are a great way to visualise your data Using Reports and Dashboards

Creating reports is for more advanced users, but give a great way to analyse your data
Go to ‘Reports’ and click [New Report] to Create a report in Salesforce

Configuring your Email

You need your Email Address and a Password to log onto Outlook before doing this configuration
First, setup Salesforce to send emails through Outlook. Watch this video which shows you how to configure Salesforce to send emails through Outlook Configure Salesforce to send emails

Emails you send or receive through Outlook can be linked back into Salesforce to keep a full contact history
You first need to configure Outlook365 by logging on through your browser, and then you can use Outlook on your desktop
This video shows you each of the steps Configure Outlook to work with Salesforce

Getting Help

Click on the ? menu at the top right of the screen in Salesforce to get a summary of help available.

Google is a great place to find answers

The following is a Salesforce site that collates Lightning Videos. It should contain up-to-date videos as they become available SFDC Lightning How ToHide Section - Administration functions

Administration functions

How to add a new user

If a Member of staff leaves, don’t just update their name with a new user, set them to Inactive first.
If a new member of staff has replaced someone, deactivate the old user first to keep within your license limit. Then add a new user.
If you have an extra member of staff, you will have to contact your Account Executive at Salesforce to purchase an additional license.
This video shows you how to deactivate the old user and add a new user: Add a new user

You may also need to transfer their Accounts and/or Opportunities. Accounts can be transfered using Mass Transfer Transfer

Or you can go to the ‘Mass TEO Transfer’ tab to transfer just the Open Opportunities and Open Tasks.

Support from your Salesforce Consultant

For further support, coaching, training or configuration, please contact: Philip Meldrum at Alpha Index Tel: +44 1273 777202

STS Support Page

Sales Invoicing

Purchase Invoicing

  • Create Purchase Invoice
  • Who needs paying
  • Pay Purchase Invoice
  • Remittance Advice (“Email remittances when a payment is entered” and “Re-send remittances”)
  • Credit notes
  • Reconcile payment with Bank see:  Bank Reconciliation(Reconcile a Supplier Payment)
  • Netting-off Credit Notes see: Credit notes (Raise a Credit Note against a PAID invoice)
  • Debit Card purchases see: Bank Reconciliation(Reconcile a Supplier Payment without an Invoice: 1 step processing)
  • Petty Cash purchases (use Bank Rec Purchase with ‘Bank Account’ set to ‘Petty Cash’)
  • Credit Card purchases (create a Purchase Invoice for all the items in your Credit Card Statement, then use Supplier Payment to pay the card off)

Bank Reconciliation

Payroll

VAT Submission

Loans

Manual Adjustments

Basic Admin functions

 

Universal Mail Support Page

Sales Invoicing

Purchase Invoicing

  • Create Purchase Invoice
  • Who needs paying
  • Pay Purchase Invoice (using Mark as Paid & Bank Matching)
  • Credit notes
  • Reconcile payment with Bank (this will be replaced with the new Bank Reconciliation)
  • Debit Card purchases
  • Petty Cash purchases (use Bank Rec Purchase with ‘Bank Account’ set to ‘Petty Cash’)
  • Credit Card purchases (create a Purchase Invoice for all the items in your Credit Card Statement)

Bank Matching

Payroll

VAT Submission

Financial Reports & Consolidation

Manual Adjustments

Basic Admin functions

 

Installing the VAT Detail Report

 

This articles explains how to install the Sage Financials Feature Pack VAT Detail Report by Alpha Index. There are 2 steps to complete the installation:

Step 1: Install the Managed Package

The Drill Down TB is part of the Alpha Index Sage Financials Feature Pack Managed Package that you need to install.

The URL you need for V1.12 in your production instance is:

https://login.salesforce.com/packaging/installPackage.apexp?p0=04t1r000000sX44

To install on a Sandbox use:

https://test.salesforce.com/packaging/installPackage.apexp?p0=04t1r000000sX44

If you are unsure how to install Managed Apps, please check out this video


Step 2: Add the Tab to the Financials top-level tab bar

This will add ‘VAT Report’ as a top-level menu entry in Sage Financials.

You need to add the ‘VAT Report’ to ‘Selected Items’ in the ‘Financials’ App.

If you are unsure how to change ‘Selected Items’ in Saleforce Apps, check out this video, but instead of selecting ‘Drill Down TB’ choose ‘VAT Report’.

All Done

After you have run your VAT Submission (under the Tab ‘Compliance) you can choose the ‘VAT Report’ tab, select the required period and view the report.

Receipts for Sales Invoice

For payments received by cheque, BACS or bank transfer, you can use the Bank Feed and Matching feature. Or you can go to the Sales Invoice and click [Pay]

Bank Feed & Matching creates a ‘Bank Takings’ Journal Type using the Customer Receipt ‘Bank Takings Item Type’

Sales Invoice [Pay] creates a ‘Customer Receipts’ Journal Type.

Postings

Configuration

Bank Feeds & Matching require significant configuration. The ‘Customer Receipts’ Journal Type needs additional ‘Customer Receipt Types’ adding as they are not configured for BACS or Bank Transfer.

Both these methods are configured to handle foreign currency adjustments.

 

Raising a Sales Invoice

Raising a sales invoice on Sage Live.

Quick video to show you how to do it, plus details of the postings made and configuration requirements.

Video:

Postings

Configuration

The postings shown here are from the standard SageLive setup.

The actual P&L Sales account used is defined by the Sales ‘Dimension Ledger Account’ in the Product ‘Dimension Tag’

If you have more than one P&L Sales account, you will need to re-configure the posting rules.

 

Installing the Drill Down Trial Balance

 

This articles explains how to install the Sage Financials Feature Pack Drill Down TB by Alpha Index. There are 3 steps to complete the installation:

Step 1: Install the Managed Package

The Drill Down TB is part of the Alpha Index Sage Financials Feature Pack Managed Package that you need to install.

The URL you need for V1.12 in your production instance is:

https://login.salesforce.com/packaging/installPackage.apexp?p0=04t1r000000sX44

To install on a Sandbox use:

https://test.salesforce.com/packaging/installPackage.apexp?p0=04t1r000000sX44

If you are unsure how to install Managed Apps, please check out this video

Step 2: Add the Tab to the Financials top-level tab bar

This will add ‘Drill Down TB’ as a top-level menu entry in Sage Financials.

You need to add the ‘Drill Down TB’ to ‘Selected Items’ in the ‘Financials’ App.

If you are unsure how to change ‘Selected Items’ in Saleforce Apps, check out this video:

Step 3: Install the Template

Installing the Sage Financials Template will add [Drill Down] buttons to Dimensions, Tags, Transactions & Journals.

The Template you need to install is ‘aiSFDrillDownTB’

If you are unsure how to install Templates, check out this video:

All Done

Now you are ready to use the Drill Down Trial Balance. Check out this video for a quick review of the features: