Revised: 11/15/2012
Note: In order to use the drag-n-drop feature, users must have Microsoft Excel 2003 or higher installed on the workstation that will be used to drop the entries into the Horizon>>Accounts Payable Entry program. The worksheet can be created and saved by workstations with an earlier version of Excel. The spreadsheet must be saved as format .xls or .xlsx.
In MS Excel, you must have a worksheet with the following column headings in Row 1. You may also download a sample file from ftp://ftp.horizon-is.com/documents/Downloads/Drag N Drop AP.xls
Column A: IFC
Column B: Account
Column C: Amount
Column D: Reference
Column E: Tracking1
Column F: Tracking2
Column G: Tracking3
Column H: Tracking4
Headings can be in any order
The field Reference is not mandatory
If your distribution page does not include IFC Codes you do not need to add an IFC column heading.
Account numbers can be entered as a straight number such as, 1014502000002 or with separators like, 1.01.402.00.002
The column headers Tracking1 through Tracking4 are for consumption figures. If your distribution page does not include Consumption, you do not need to add any Tracking# headings.
Consumption Type Codes are setup in the Account Type Master
The tracking columns 1-4 tie in with Item Number 1 - 4 in the Account Type Master. If the consumption tracking is in Item Number 1 then the consumption information should be entered under column heading Tracking1.
Starting in Row 2, enter your line items for your AP Distribution.
Every row should contain a distribution. Do not leave any blank rows.
Do not place documentation or calculations in rows between entries. Calculations and documentation may be placed in columns to the right of the required columns or on another sheet. Add a column heading such as "Documentation" to each column containing information you wish to save, as error messages generated by the program will overwrite columns with no header.
Drag-n-Drop only imports information from the first sheet.
If you are working in other Excel worksheets that you already have established for formulas, calculations, etc., you can copy and paste the figures from that worksheet into a template you save for Drag-N-Drop. You should use the Paste Special Command and paste Values Only.
When your worksheet is complete, save the worksheet as you normally would and close the Excel file.
Open Horizon Financials and go to Activities>>Voucher Entry.
Enter all information on the Main page as needed.
As you complete the information on the Main page and tab, you will automatically go to the Distributions screen.
Open the folder that contains your Excel files and resize the Horizon program window so that you can see the Excel file and the AP Voucher Entry screen simultaneously.
TIP: You may also leave both windows full screen, start with the folder containing your Excel file. Left click the file and hold while dragging the file down to the Start bar to the Horizon Financials button. This will cause Horizon Financials to maximize and you may drag the file to the Drop Symbol.
When the Excel file is dragged onto the AP Voucher Entry>>Distribution tab, you should see a "+" sign indicating that you can drop the file.
If you receive the error message "Errors found - please refer to spreadsheet", press OK to close. No data will be saved in AP distribution when an error is detected. Open your spreadsheet. In the first column with no header, an error message will be saved in each row in which an error was detected. Correct the spreadsheet and then try to Drag-n-Drop again.
Check that the entry is in balance in AP Voucher Entry>>Distributions. The Invoice Amount and the Applied figure should match and Remaining should be zero.
Click Save and follow the normal Edit and Posting procedure.