Prophet / AttachePro to Mercury or Saturn Data Conversion

Converting data from Prophet or AttachePro to Accredo Saturn or Accredo Mercury is non-destructive (read only).

Exclusive access to the Prophet data during conversion is required.

Run the Conversion

1. Install Accredo and create a Company to convert into.
2. Backup Prophet data.
3. File recover Prophet data.
4. Print an error report to provide a record to compare with error reports from the new Accredo Company.
5. Copy the conversion tool Prophet2Saturn.exe or Prophet2Mercury.exe to the Server. The conversion tools are available in Additional Downloads on the Accredo Website. Save the conversion tool to the Desktop or the AccredoSaturn or AccredoMercury folder.
6. Double click the Prophet2Saturn.exe or Prophet2Mercury.exe file to open the conversion tool.
7. Select the Prophet path and Company, and select the Accredo path and Company. Existing data in the Accredo Company will be overwritten, provided the module exists in the Prophet data.
8. Select conversion Options - see below, then click Run. The conversion has two phases:
   • Preparation phase - sets the periods and years and identifies the Current Period for each module.
   • Conversion phase - converts the data into the prepared periods and years.
9. A sound plays when the conversion is complete, and the title bar flashes with “Completed - Company Name”. When all Companies are converted, close the conversion dialog.
10. Open the new Accredo System. For each Company, ensure the Current Period for each module is correct. If not, contact Accredo Support.
11. Once the Current Period is correct for each module, in each Company backup Accredo data.
12. Perform a file recovery and fix any Chart Of Accounts errors.
13. Print an error report and compare it with the error report for the original Prophet data

Note: Do not do any setup in the company prior to conversion as the data is re-initialised during conversion. Data may be converted into a demonstration system.

Conversion Options

The converter attempts to set these when the source data is selected.

GL Codes

Specify how Prophet GL codes are to be converted.

The defaults are:

• Prophet Prefix becomes Accredo Branch in Saturn.
• Prophet Account Number becomes Accredo Account Number 
• Prophet Suffix becomes Accredo Sub-account Number
• Prophet Account Codes are padded with zeroes to fit the Accredo format

Alternatively a GL mapping file may be selected, file format is csv:

IC Codes

Select which Prophet code to map to the Accredo Stock Group Code.

AP Codes

Select which Prophet code to map to the Accredo Branch Code (Converting to Saturn only).

FA Codes

Select which Prophet Fixed Asset Books to convert.

Currency

The converter detects the currency codes used in the source Prophet Data and attempts to map them to the ISO currency codes used in Accredo.

Issues on the Error Report

Last Year, Current Year and Current Period figures are calculated and recovered in Accredo based on actual transactions. If any history has been deleted in Prophet or if Masterfiles were deleted at End Of Period, this can change the Last Year Balances, and possibly the Current Year Balances if Full Year transactions were not retained. Prophet does not store Last Year transactions in the GL. Accredo re-calculates balances based on transactions so last year balances will be zero. This information will appear in the error report to provide Accredo data integrity.

If the Prophet data contains unallocated transactions which were posted to a month other than 0, the file recovery will re-assign these balances to the period the transaction is in. The account balance will still be correct but the ageing will differ. Accredo is an Open Period System without "Post To Month" on transactions. You simply enter a transaction in the correct period.

Discuss errors or warnings with Accredo Support. Provide a backup of the Prophet data files, and Accredo Support can provide a quote for modifying the conversion process or fixing the data. Print Data Integrity Reports for each Company and compare them with reports from Prophet.

Sales Analysis

Accredo Sales Analysis works from the Invoice and Order history, unlike Prophet which stores analysis history separately.