Difference between revisions of "Sage Integration Details"

From Catalyst
Jump to: navigation, search
Line 5: Line 5:
  
 
== The Document Export Method ==
 
== The Document Export Method ==
−
=== System Settings===
+
=== System Settings ===
−
# In {{PlatinumModuleSettings|Document Exports|Data Export Settings}}, select the {{Tab|Sage}} tab.
+
Go to {{Menu|{{PlatinumModuleSettings}}|Document Exports|Data Export Settings}}
−
# Against {{DataPrompt|Enabled}}, select {{DataValue|Yes}}.
+
* Select the {{Tab|Sage}} tab.
−
#: This will set Platinum to record transaction and payment details to a log which accumulates over time, and which gets rolled over each time you use the export option, so you can export as often or as rarely as you like, and the log will contain only transactions logged in Platinum since the last export.
+
* At {{DataPrompt|Enabled}} select {{DataValue|Yes}}.
−
#Next you have three settings to specify the reports which are to be used in each case.
+
 
−
#The {{DataPrompt|Customer Report}} is required to output the customers for whom transactions have been identified.  
+
{{Note|text=Once this option has been enabled, each time you use the export option those transactions are flagged as having been exported. This ensures only new transactions are included in subsequent export files thus avoiding duplicating data.}}
−
#The {{DataPrompt|Transaction report}} is mandatory, and specifies a report generator report which dictates the layout of each line of the csv file for Transactions to be imported into Sage.
+
 
−
# Below this is the {{DataPrompt|Payment report}}. This is optional, and required only if you want to export payments from Platinum to Sage. Most customers should deal with payments entirely within Sage, but the option is here if required. The reports are also separate because generally transactions are broken down by line, and payments by centre.
+
* You have three settings to specify the reports which are to be used in each case.
−
{{Note|text=* Three system reports are issued as standard, {{DataValue|~SP}} for Customers, {{DataValue|~ST}} for Transactions, and {{DataValue|~SP}} for Payments. These may be replaced by user reports customised to meet the requirements of the customer.}}
+
** The {{DataPrompt|Customer Report}} is required to output the customers for whom transactions have been identified.  
 +
** The {{DataPrompt|Transaction report}} is mandatory, and is used to output the transactions i.e. invoices and credits.
 +
** The {{DataPrompt|Payment report}} is optional, and required only if you want to export payments from Platinum to Sage. Most customers should deal with payments entirely within Sage, but the option is here if required.  
 +
 
 +
{{Note|text=Three system reports are issued as standard; {{DataValue|~SP}} for Customers, {{DataValue|~ST}} for Transactions, and {{DataValue|~SP}} for Payments. These may be replaced by user reports customised to meet the requirements of the customer. {{SupportContact}} for advice as a customised report may be chargeable}}.
  
 
=== Exporting to Sage ===
 
=== Exporting to Sage ===
−
# {{PlatinumModuleSettings|Document Exports|Document Export Settings}} and select the {{Tab|Sage}} tab.
+
Go to {{Menu|{{PlatinumModuleSettings}}|Document Exports|Document Export Settings}} and select the {{Tab|Sage}} tab.
−
#: To put this option on a custom menu, the program to specify is {{DataValue|SXPDX99}}.
+
 
−
# The dropdown here shows the date range of transactions recorded in the Current log file, and below this previous log files. These are retained in case you need to go back to a previous period for any reason.
+
{{Note|text=To put this option on a custom menu, the program to specify is {{DataValue|SXPDX99}}.}}
−
# Select the period you require, and click on {{Button|Preview}}.
+
 
−
#: This runs the relevant report for each transaction or payment in the log, appending each one in turn to {{FilePath|SXDXSage.csv}}.
+
* The drop down menu will default to current transactions, i.e. transactions created since the last export file was created - up to yesterday's date.
−
# Once the log has been read through in its entirety, you will be shown a list box showing the contents of each line split up into columns. As the report is completely configurable, the columns are numbered rather than named. This should enable you to easily see transactions where a centre code or account reference needs to be set, and back out to make the necessary adjustments before proceeding.
+
** To view a previously exported file select the period from the dropdown menu.
−
# If you need to make changes, click {{Button|Cancel}}, and come out of the program, make your changes, and return to step 1.
+
 
−
# If the report is satisfactory, click {{Button|Confirm}}. The current Transaction log file will be renamed, appending the date range to the file name, and a new log commenced for your next export.
+
{{Warning|text=Please use caution when viewing a previous file. If you choose to create a new csv file from the data be aware that Sage will allow you to import the same transactions more than once.}}
−
# You may now proceed into Sage to import the Customer and Transaction files.
+
 
 +
* Click {{Button|Preview}}.
 +
* The transactions for the period are listed on screen. Check the data shown as these details will be loaded into Sage.
 +
** If the customer account already exists in your Sage system, please make sure you specify the Sage Account Code in the Customer [[Creating a New Customer/Supplier#Entering Basic Account Information|Reference]] field within Platinum.
 +
** You may also need to ensure that your [[How do I Create a Sales or Purchase Centre?|Sales Centres]] link to [[How do I Create a Nominal Code?|Nominal Codes]] that reflect the Nominal Codes you are using in Sage. Alternatively specify the Sage Nominal Code in the {{DataPrompt|Revenue}} field of your Sales Centres. Your report may be configured to output this field as your Sage Nominal Code ({{SupportContact}} if you are unsure how your system has been configured).
 +
 
 +
* If you need to make changes to the data shown, e.g. to amend the customer reference field, click {{Button|Cancel}}. Make your changes and repeat the steps above.
 +
* If the report is satisfactory, click {{Button|Confirm}}.  
 +
** The relevant files will be created within the {{DataValue|Export}} folder within your company data folder e.g. {{DataValue|SXCO1}}.
 +
** Typically two files are created: {{DataValue|CUS.CSV}} - containing customers and {{DataValue|SXDXSAGE.CSV}} - containing transactions.
 +
** The transactions will also be logged as having been exported to prevent them being included in the next export.
 +
 
 +
* You may now proceed into Sage to import the Customer and Transaction files.
  
 
{{Warning|text=* '''WARNING''' - It is '''VITAL''' that the {{FilePath|SXDXSage.csv}} file is only imported '''ONCE'''. If the import is run with the same file more than once, the transactions can be duplicated. This can be avoided by '''deleting''' or archiving the previously imported file.}}
 
{{Warning|text=* '''WARNING''' - It is '''VITAL''' that the {{FilePath|SXDXSage.csv}} file is only imported '''ONCE'''. If the import is run with the same file more than once, the transactions can be duplicated. This can be avoided by '''deleting''' or archiving the previously imported file.}}
 +
 +
{{Note|text=The first time you import transactions into Sage you will need to create a file mapping. This matches your file to the relevant fields in Sage e.g. customer code, date, document number etc. Please {{SupportContact}} for assistance with your first Sage Import. Once the files have been mapped you should not need to repeat the process unless you update or reinstall Sage.}}
 +
 +
==== Import Customer Details ====
 +
* Click the {{Button|File}} drop down menu.
 +
* Choose {{DataValue|Import}}.
 +
* Make sure no other copies of Sage are open. Choose whether you need to backup your Sage data.
 +
* Choose {{DataValue|Customer Records}}
 +
* Click {{DataValue|Next}}.
 +
* Ensure {{DataValue|.csv}} is checked.
 +
* Browse for your file.
 +
** Change the {{DataPrompt|look in}} to the P: Drive.
 +
** Double click {{FilePath|CUS.CSV}}.
 +
* Click {{DataValue|Next}}.
 +
* The {{DataValue|Customer Record Map}} should be selected, if you have previously mapped the file (see above).
 +
* Click {{DataValue|Next}}.
 +
* Check the summary information then click {{DataValue|Import}} or {{DataValue|Finish}}.
 +
* Click {{DataValue|Close}}.
 +
This will import all the customer accounts information into Sage.
 +
If there are any errors, these will be reported in the information pane.
 +
 +
{{Note|Please ensure for existing Sage customer records that you enter the Sage account code into the reference field on the Platinum Customer record; this will prevent the account being created twice in Sage.}}
 +
 +
==== Import Transaction File ====
 +
* Repeat the steos above selecting {{DataValue|Audit Trail Transactions}} as the import type.
 +
* Click {{DataValue|Next}}.
 +
* Ensure {{DataValue|.csv}} is checked.
 +
* Browse for your file.
 +
* Change the {{DataPrompt|look in}} to the P: Drive.
 +
* Double click {{FilePath|SXDXSAGE.CSV}}.
 +
* Click {{DataValue|Next}}.
 +
* The {{DataValue|Audit Trail Transactions Map}} should be selected, if you have previously mapped the file (see above).
 +
* Click {{DataValue|Next}}.
 +
* Click {{DataValue|Finish}}.
 +
This will import all the invoices and credits into Sage.
  
 
== The Report Generator / Custom Menu Method ==
 
== The Report Generator / Custom Menu Method ==
Line 32: Line 83:
  
 
=== More Information ===
 
=== More Information ===
−
{{Warning|text=
+
{{Warning|text=* '''Receipts''' - These are '''not''' imported; you must enter these manually into Sage using the End of Day takings report printed from Platinum.}}
−
* '''Receipts''' - These are '''not''' imported; they are paid manually (into Sage) using the End of Day takings report printed from Platinum.}}
 
  
−
{{Note|text=
+
{{Note|text=The reports are not installed as standard. Please {{SalesContact}} for further details.}}
−
* The reports are not installed as standard. Please {{SalesContact}} for further details.
 
−
}}
 
  
 
=== Platinum ===
 
=== Platinum ===
Line 43: Line 91:
 
* Run the reports below for the date range required.  
 
* Run the reports below for the date range required.  
  
−
{{Warning|text=
+
{{Warning|text='''Be careful''' - Sage will let you import transactions twice, so you must ensure the date range has not already been updated!}}
−
'''Be careful''' - Sage will let you import transactions twice, so you must ensure the date range has not already been updated!}}
 
  
 
* Run the {{DataValue|Sage Customers - Platinum Expt}}
 
* Run the {{DataValue|Sage Customers - Platinum Expt}}
Line 118: Line 165:
 
* [[Recommended Accounting Routines]]
 
* [[Recommended Accounting Routines]]
  
−
{{KB_Tags|Accounts, Sage, Export, Import}}
+
{{KB_Tags|Accounts, Sage, Export, Import, hub, document hub}}
 
{{KB_SL}}{{ZN_Admin}}{{Guide}}{{ZN_Accounts}}
 
{{KB_SL}}{{ZN_Admin}}{{Guide}}{{ZN_Accounts}}

Revision as of 22:04, 24 April 2018

Summary

We have two methods for exporting transactions from Platinum to Sage. Using the Document Export - Sage options, which should be suitable in most cases; and using the Report Generator and custom menus, which are used by older clients and may be needed on new installations with more specialised requirements.

You will need the Document Export module in either case to allow access to the relevant Report Generator variables. Please Contact your Platinum dealer or our sales team on 0116 230 1500 or by using our website sales contact page for more information.

The Document Export Method

System Settings

Go to " " Reports & Settings Maintenance Options System Administrator Module Settings" Document Exports Data Export Settings"

  • Select the [Sage] tab.
  • At "Enabled" select 'Yes'.
Once this option has been enabled, each time you use the export option those transactions are flagged as having been exported. This ensures only new transactions are included in subsequent export files thus avoiding duplicating data.
  • You have three settings to specify the reports which are to be used in each case.
    • The "Customer Report" is required to output the customers for whom transactions have been identified.
    • The "Transaction report" is mandatory, and is used to output the transactions i.e. invoices and credits.
    • The "Payment report" is optional, and required only if you want to export payments from Platinum to Sage. Most customers should deal with payments entirely within Sage, but the option is here if required.
Three system reports are issued as standard; '~SP' for Customers, '~ST' for Transactions, and '~SP' for Payments. These may be replaced by user reports customised to meet the requirements of the customer. Contact your Platinum dealer or our support team on 0116 230 1500 or by using our website support contact page for advice as a customised report may be chargeable

.

Exporting to Sage

Go to " " Reports & Settings Maintenance Options System Administrator Module Settings" Document Exports Document Export Settings" and select the [Sage] tab.

To put this option on a custom menu, the program to specify is 'SXPDX99'.
  • The drop down menu will default to current transactions, i.e. transactions created since the last export file was created - up to yesterday's date.
    • To view a previously exported file select the period from the dropdown menu.
Please use caution when viewing a previous file. If you choose to create a new csv file from the data be aware that Sage will allow you to import the same transactions more than once.
  • Click [Preview].
  • The transactions for the period are listed on screen. Check the data shown as these details will be loaded into Sage.
    • If the customer account already exists in your Sage system, please make sure you specify the Sage Account Code in the Customer Reference field within Platinum.
    • You may also need to ensure that your Sales Centres link to Nominal Codes that reflect the Nominal Codes you are using in Sage. Alternatively specify the Sage Nominal Code in the "Revenue" field of your Sales Centres. Your report may be configured to output this field as your Sage Nominal Code (Contact your Platinum dealer or our support team on 0116 230 1500 or by using our website support contact page if you are unsure how your system has been configured).
  • If you need to make changes to the data shown, e.g. to amend the customer reference field, click [Cancel]. Make your changes and repeat the steps above.
  • If the report is satisfactory, click [Confirm].
    • The relevant files will be created within the 'Export' folder within your company data folder e.g. 'SXCO1'.
    • Typically two files are created: 'CUS.CSV' - containing customers and 'SXDXSAGE.CSV' - containing transactions.
    • The transactions will also be logged as having been exported to prevent them being included in the next export.
  • You may now proceed into Sage to import the Customer and Transaction files.
  • WARNING - It is VITAL that the 'SXDXSage.csv' file is only imported ONCE. If the import is run with the same file more than once, the transactions can be duplicated. This can be avoided by deleting or archiving the previously imported file.
The first time you import transactions into Sage you will need to create a file mapping. This matches your file to the relevant fields in Sage e.g. customer code, date, document number etc. Please Contact your Platinum dealer or our support team on 0116 230 1500 or by using our website support contact page for assistance with your first Sage Import. Once the files have been mapped you should not need to repeat the process unless you update or reinstall Sage.

Import Customer Details

  • Click the [File] drop down menu.
  • Choose 'Import'.
  • Make sure no other copies of Sage are open. Choose whether you need to backup your Sage data.
  • Choose 'Customer Records'
  • Click 'Next'.
  • Ensure '.csv' is checked.
  • Browse for your file.
    • Change the "look in" to the P: Drive.
    • Double click 'CUS.CSV'.
  • Click 'Next'.
  • The 'Customer Record Map' should be selected, if you have previously mapped the file (see above).
  • Click 'Next'.
  • Check the summary information then click 'Import' or 'Finish'.
  • Click 'Close'.

This will import all the customer accounts information into Sage. If there are any errors, these will be reported in the information pane.

Please ensure for existing Sage customer records that you enter the Sage account code into the reference field on the Platinum Customer record; this will prevent the account being created twice in Sage.

Import Transaction File

  • Repeat the steos above selecting 'Audit Trail Transactions' as the import type.
  • Click 'Next'.
  • Ensure '.csv' is checked.
  • Browse for your file.
  • Change the "look in" to the P: Drive.
  • Double click 'SXDXSAGE.CSV'.
  • Click 'Next'.
  • The 'Audit Trail Transactions Map' should be selected, if you have previously mapped the file (see above).
  • Click 'Next'.
  • Click 'Finish'.

This will import all the invoices and credits into Sage.

The Report Generator / Custom Menu Method

This article explains how to export the sales invoices and credits from Platinum, and then import them into Sage.

More Information
  • Receipts - These are not imported; you must enter these manually into Sage using the End of Day takings report printed from Platinum.
The reports are not installed as standard. Please Contact your Platinum dealer or our sales team on 0116 230 1500 or by using our website sales contact page for further details.

Platinum

Go into " Sage Exports" menu.

  • Run the reports below for the date range required.
Be careful - Sage will let you import transactions twice, so you must ensure the date range has not already been updated!
  • Run the 'Sage Customers - Platinum Expt'
  • Run the 'Sage Invoice V/Sale - Check'
  • Run the 'Sage Invoice V/Sale - Actual'
  • Run the 'Sage Invoice Stock - Check'
  • Run the 'Sage Invoice Stock - Actual'
  • Run the 'Sage Payments - Actual'

Go into " End of Day" menu.

  • Run the End of Day takings reports.

Sage

Customer Details

  • Click the [File] drop down menu.
  • Choose 'Import'.
  • Click 'Yes'.
  • Click 'Next'.
  • Choose 'Customer Records'
  • Click 'Next'.
  • Ensure '.csv' is checked.
  • Browse for your file.
  • Change the "look in" to the P: Drive.
  • Double click 'SAGE_CUST.CSV'.
  • Click 'Next'.
  • Click 'Load Map'.
  • Select 'Customer Record Map'.
  • Click 'Next'.
  • Click 'Finish'.
  • Click 'Close'.

This will import all the customer accounts information into Sage. If there are any errors, these will be reported in the information pane.

Please ensure for existing Sage customer records that you enter the Sage account code into the reference field on the Platinum Customer record; this will prevent the account being created twice in Sage.

Stock Invoices/Credits

  • Click the [File] drop down menu.
  • Choose 'Import'.
  • Click 'Yes'.
  • Click 'Next'.
  • Choose 'Audit Trail Transactions'.
  • Click 'Next'.
  • Ensure '.csv' is checked.
  • Browse for your file.
  • Change the "look in" to the P: Drive.
  • Double click 'SAGE_STOCK_IMP.CSV'.
  • Click 'Next'.
  • Click 'Load Map'.
  • Select 'Audit Trail Transactions'.
  • Click 'Next'.
  • Click 'Finish'.

This will import all the Stock transactions into Sage.

Vehicle Invoices/Credits

  • Click the [File] drop down menu.
  • Choose 'Import'.
  • Choose 'Audit Trail Transactions' -> 'Run'.
  • Change the "Look in" to P: Drive.
  • Double click 'SAGE_VS_IMP.CSV'

This will import all the Vehicle Sales transactions into Sage.

Posting the Payments

  • Click the [File] drop down menu.
  • Choose 'Import'.
  • Choose 'Audit Trail Transactions' -> 'Run'.
  • Change the "Look in" to P: Drive.
  • Double click 'SAGE_PAY_IMP.CSV'
  • Use the 'End of Day' report to check all the payments have been processed and that they have been allocated to the correct payment centre.

See also


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
Accounts, Sage, Export, Import, hub, document hub
Retrieved from "https://www.catalyst-uk-support.com/kb/index.php?title=Sage_Integration_Details&oldid=28828"