Dear Norma
There are some standard rules of thumb to successfully import batches into Adagio Ledger. The following are tips that we have received from Dealers who are familiar with Paymate (as we can only provide support for Adagio).
- All accounts and departments must be set up exactly the same in Paymate as they are in Adagio Ledger.
- You can only export posted payroll from Paymate. The figures for export are taken from employee history. You can export any time frame that you want and if required you can export by department or pay group. (They suggest leaving the groups to include blank that way you are sure of getting everything.)
In addition to this:
1. This may obvious, but make sure both the Account and Department (if used) are filled in on the Paymate "Accounts and Departments" screen for EVERY Paymate account that will be exported.
2. Check that ?Adagio Accounting (single currency)? is selected as the export type in Paymate.
3. In Adagio Ledger, source codes display as "GL- 4" or "GL-PR" but are really stored as "GL 4" and "GLPR" so they must be entered that way in the Source Code box in Paymate. Note the space before the "4" - it is needed if there is only one character in the second segment of the source code. (And, of course, double check that the source code is already defined in Ledger.)
4. It is surprisingly easy to select the wrong file and therefore get an import failure. One way to avoid this is to use Windows' cut and paste. Highlight the complete export filename and path in Paymate and press CTRL-C, then highlight the import filename and path in Adagio Ledger and press CTRL-V. Sounds silly, but at least you cannot mis-type it.
(For best results, you may want to export the file as .csv format, not .txt - which is the default in Paymate.)
------------------------
If that advice has all checked out, then we can go further on the Adagio side, but I am not sure what you mean by your 'options are not the same'? Not the same as what?
In Adagio Ledger, you want to import the batch as 'Detail Only'. From the main 'File Information' tab in the Adagio Import screen, make sure the path and filename are the same as what you exported from Paymate.
You should be able to use the default Adagio Import Template for Details Only to import your Paymate batch successfully. In the 'Import Field Selection' tab, you can then select 'Save as' to save this template as your new Paymate default. It contains all the fields you need:
Record Type
Entry Number
Fiscal Date
Fiscal Period
Account Code
Department Code
Source Code
Reference
Transaction Date
Description
Amount
In this screen when you select each field on the right Import file fields, you can see it's properties in the bottom section of this screen. Your import file fields should match what is defined here.
Hope this helps.