Difference between revisions of "Sage Integration Details"

From Catalyst
Jump to: navigation, search
m
Line 1: Line 1:
==Summary==
+
== Summary ==
 
This article explains how to export/import the sales invoices and credits from Platinum, into Sage.
 
This article explains how to export/import the sales invoices and credits from Platinum, into Sage.
  
 
{{Note|Receipts are NOT imported; they are paid manually (into sage) using the End of Day takings report printed from Platinum.}}
 
{{Note|Receipts are NOT imported; they are paid manually (into sage) using the End of Day takings report printed from Platinum.}}
  
==Platinum==
+
== Platinum ==
 +
Get into "Sage Exports" menu.
 +
*Run the below reports between the date range required.
  
*Get into “Sage Exports” menu
+
{{Note|title=Care|text=
Run the below reports between 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!}}
  
{{Note|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 Customers – Platinum Expt”
+
Get into "End of Day" menu
*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”
 
 
 
Get into “End of Day” menu
 
 
*Run the end of day takings
 
*Run the end of day takings
  
==Sage==
+
== Sage ==
===Customer Details===
+
=== Customer Details ===
*Click the {{KeyPress|File}} drop down menu
+
*Click the {{Button|File}} drop down menu.
*Choose “Import”
+
*Choose "Import".
*Choose “Customer Records” -> “Run”
+
*Choose "Customer Records" -> "Run".
*Change the “look in” to the P: Drive
+
*Change the "look in" to the P: Drive.
*Double click {{KeyPress|SAGE_CUST.CSV}}
+
*Double click {{FilePath|SAGE_CUST.CSV}}.
 
This will import all the customer accounts information into Sage.
 
This will import all the customer accounts information into Sage.
  
 
{{Note|Please ensure for existing sage customer records 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.}}
 
{{Note|Please ensure for existing sage customer records 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===
+
=== Stock Invoices/Credits ===
*Click the {{KeyPress|File}} drop down menu
+
*Click the {{Button|File}} drop down menu.
*Choose “Import”
+
*Choose "Import".
*Choose “Audit Trial Transactions” -> “Run”
+
*Choose "Audit Trial Transactions" -> "Run".
*Change the “look in” to the P: Drive
+
*Change the "look in" to the P: Drive.
*Double Click {{KeyPress|SAGE_STOCK_IMP.CSV}}
+
*Double Click {{FilePath|SAGE_STOCK_IMP.CSV}}.
This will import all the Stock transactions into Sage
+
This will import all the Stock transactions into Sage.
  
===Vehicle Invoices/Credits===
+
=== Vehicle Invoices/Credits ===
*Click the {{KeyPress|File}} drop down menu
+
*Click the {{Button|File}} drop down menu.
*Choose “Import”
+
*Choose "Import".
*Choose “Audit Trial Transactions” -> “Run”
+
*Choose "Audit Trial Transactions" -> "Run".
*Change the “look in” to P: Drive
+
*Change the "look in" to P: Drive.
*Double click {{KeyPress|SAGE_VS_IMP.CSV}}
+
*Double click {{FilePath|SAGE_VS_IMP.CSV}}
 
This will import all the Vehicle Sales transactions into Sage.
 
This will import all the Vehicle Sales transactions into Sage.
  
 
=== Posting the Receipts ===
 
=== Posting the Receipts ===
*Using the ‘End of Day’ report pay off the imported transactions to the correct bank.
+
*Using the "End of Day" report pay off the imported transactions to the correct bank.
  
 
{{Note|The reports are not installed as standard are available by contacting the Sales Department on 0116 230 1500}}
 
{{Note|The reports are not installed as standard are available by contacting the Sales Department on 0116 230 1500}}
 
 
  
 
{{Guide}}{{KB_Tags|Accounts, Sage, Export, Import}}{{KB_SL}}{{ZN_Admin}}
 
{{Guide}}{{KB_Tags|Accounts, Sage, Export, Import}}{{KB_SL}}{{ZN_Admin}}

Revision as of 09:57, 13 August 2008

Summary

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

Receipts are NOT imported; they are paid manually (into sage) using the End of Day takings report printed from Platinum.

Platinum

Get into "Sage Exports" menu.

  • Run the below reports between the date range required.
Care: 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"

Get into "End of Day" menu

  • Run the end of day takings

Sage

Customer Details

  • Click the [File] drop down menu.
  • Choose "Import".
  • Choose "Customer Records" -> "Run".
  • Change the "look in" to the P: Drive.
  • Double click 'SAGE_CUST.CSV'.

This will import all the customer accounts information into Sage.

Please ensure for existing sage customer records 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".
  • Choose "Audit Trial Transactions" -> "Run".
  • Change the "look in" to the P: Drive.
  • Double Click 'SAGE_STOCK_IMP.CSV'.

This will import all the Stock transactions into Sage.

Vehicle Invoices/Credits

  • Click the [File] drop down menu.
  • Choose "Import".
  • Choose "Audit Trial 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 Receipts

  • Using the "End of Day" report pay off the imported transactions to the correct bank.
The reports are not installed as standard are available by contacting the Sales Department on 0116 230 1500


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