This example describes how to import payment data into Iptor IP1 from an excel file. The template and the upload data file must be in the correct directory for the upload. Please refer to SOP Excel Upload and Download document for information on setting up network and folder details for the location of the template and import files.
- In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > Entry and then double-click Debtor Cash/Journal Entry. ARE005 Cash Entry payment selection panel appears.
- Select payment function CSH and click OK.
- Enter the header details and click OK. ARE005 Cash Entry payment detail panel appears.
- Click function Remittance. ARE005C Remainder/Remittance Entry panel appears.
- Click function Import Excel. ARE005G Import Excel panel appears.
- Enter the following information, as necessary.
| Field |
Description |
| Location |
This is the location of the excel data file as defined in ********/DE-SVR. |
| Filename |
Filename as it exists in the defined location, including the file extension. |
View available functions on this panel
| Function |
Description |
| Search |
Allows you to search for the excel file in the defined location. |
| Show excel |
Use this function to view/change the contents of the excel file before upload. |
- Enter the relevant filename or use the search facility.
| Note |
You can use Show Excel function to make any necessary changes to the excel file before the download. |
- Click OK to begin the download. ARE005C Remainder/Remittance Entry panel appears with the uploaded details
- Use Select doc function to select the documents to be paid.
- Click OK to continue to the banking details screen. ARE210 Bank reference – Charge panel is displayed. Refer to ARE210 Bank reference – Charge for details.
