Difference between revisions of "Sage Integration Details"
From Catalyst
Jeremy Shave (talk | contribs) |
|||
| Line 1: | Line 1: | ||
== Summary == | == Summary == | ||
| − | This article explains how to export | + | This article explains how to export the sales invoices and credits from Platinum, and then import them into Sage. |
| − | {{Note|Receipts are NOT imported; they are paid manually (into | + | {{Note|Receipts are NOT imported; they are paid manually (into Sage) using the End of Day takings report printed from Platinum.}} |
| − | {{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. They are available by contacting the Sales Department on 0116 230 1500}} |
== Platinum == | == Platinum == | ||
| − | + | Go into "Sage Exports" menu. | |
| − | *Run the below | + | * Run the reports below for the date range required. |
{{Note|title=Care|text= | {{Note|title=Care|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 "Sage Customers - Platinum Expt" | + | * Run the "Sage Customers - Platinum Expt" |
| − | *Run the "Sage Invoice V/Sale - Check" | + | * Run the "Sage Invoice V/Sale - Check" |
| − | *Run the "Sage Invoice V/Sale - Actual" | + | * Run the "Sage Invoice V/Sale - Actual" |
| − | *Run the "Sage Invoice Stock - Check" | + | * Run the "Sage Invoice Stock - Check" |
| − | *Run the "Sage Invoice Stock - Actual" | + | * Run the "Sage Invoice Stock - Actual" |
| − | + | Go into "End of Day" menu. | |
| − | *Run the | + | * Run the End of Day takings reports. |
== Sage == | == Sage == | ||
=== Customer Details === | === Customer Details === | ||
| − | *Click the {{Button|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 {{FilePath|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 | + | {{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.}} |
=== Stock Invoices/Credits === | === Stock Invoices/Credits === | ||
| − | *Click the {{Button|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 " | + | * Change the "Look in" to the P: Drive. |
| − | *Double | + | * 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 {{Button|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 " | + | * Change the "Look in" to P: Drive. |
| − | *Double click {{FilePath|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. |
| − | |||
| − | |||
{{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 13:13, 18 August 2008
Contents
Summary
This article explains how to export the sales invoices and credits from Platinum, and then import them into Sage.
 | Receipts are NOT imported; they are paid manually (into Sage) using the End of Day takings report printed from Platinum. |
| The reports are not installed as standard. They are available by contacting the Sales Department on 0116 230 1500 |
Platinum
Go into "Sage Exports" menu.
- Run the reports below for 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"
Go into "End of Day" menu.
- Run the End of Day takings reports.
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 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".
- 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.
