PURPOSE
This document explains how to import AP/ AR items into CS Lucas system.
WHY IS THIS IMPORTANT?
AP/ AR items are used by the system for Hedge Accounting and payment gateway.
PROCEDURE
1. From the main menu, click Back Office > Payable/ Receivable. The Account Payable/ Receivable screen is displayed as below.
2. Click Import.
3. Click Template to download the Load_APAR_Template in Excel format to your computer.
4. After the import template is successfully downloaded, open the import template.
5. Save the file and open. An Excel sheet will be opened.
6. Fill in the columns. Make sure all mandatory columns are filled, these are characterized with an (*). The explanation of the fields are as below:
| Field | Remarks |
|---|---|
| Acct Cntr* | Type in accounting centre short name. |
| Type* | Type as Payable/ Receivable. |
| ID* | Type in ID. |
| Tranx Date* | Type in the Transaction Date. |
| Vdate* | Type in the Value Date. |
| Ccy* | Type the Transaction currency. |
| Amount* | Type in the Amount. |
| Supp/Cust | Type in the supplier/ customer information. |
| Narrative | Type in trade narrative if any. |
| Book Rate* | Type in Book Rate. |
| Base Amt* | Type in Base Amount. |
7. Go back to the Import Account Payable/Receivable screen. Click Choose File. Look for the saved Load_APAR_Template.xls file.
8. Click Read. The values inputted in the Excel file will appear.
9. If there is an error, the user will be prompted with the rows to be corrected. To make corrections, go to the template to edit and upload again.
10. If there is no error, click Load. Click OK on the pop up that appears.
11. You will see the message below once successfully loaded.
12. Untick Import check box to return to Account Payable/ Receivable screen.
13. Filter Acct Cntr, Tranx From and Tranx To base on what was imported and click Refresh.
14. The imported Account Payable/Account Receivable transactions are displayed, as shown below.
15. Please note that when import additional AP/ AR items, the system will not duplicate items with same accounting centre and AP/ AR ID.
FREQUENTLY ASKED QUESTIONS
RELATED INFORMATION
Viewing Account Payable/Receivable Items
CHANGE HISTORY
0 Comments