EXAC220　Suspense Journal Documents General Upload

Predefined formats can be used to upload suspense documents from Excel, CSV, and TSV files.

Operation

Set Up
Basic Operation

1. Set Up

Before uploading using this function, one needs to set up the field relationship in MAEX110 External System Profile. In MAEX110, you speficy following items:

　　・Which Excel column of the import file are corresponding fields to which fields of multibook accounting journal. For example, "Post Date" should be picked up from "Column B" in Excel

　　・ If a particular field value is always the same, you can spefici in the MAEX110 in stead of having a field in Excel. i.e. Ledger Type is always "Normal", then put "0", next to "Ledger" field.

　　・Whether to convert and import G/L account, department, biz partner, and segment codes. (If you specify "Convert", you need to set the conversion information with the corresponding master maintenance function.) **See below for more explanation

・Whether to automatically set payment information such as the due date.

　　・Whether to automatically calculate the amount (co. currency) from and rate.

Excel File (example)

External Profile Set Up Screen

To set up it: Click MAEX110 External System Profile

Select the company and Enter a name of the profile:

Note: you need to set up the profile for each company even they are the same.

Enter the Profile Name and others and Click Update to Save.

**Whether to convert and import G/L account, department, biz partner, and segment codes. (If you specify "Convert", you need to set the conversion information with the corresponding master maintenance function.)

G/L account, biz partner, department, and segment can be converted from the code on the import file and then imported into the document.
When converting biz partner code, if you set "NCC*" on the "Additional" tab of the biz partner master, all codes starting with "NCC*" in the biz partner code of the import file will be converted to this master record.
The same applies to the conversion of "Account", "Department", and "Segment".

2. Basic Operation

Once you are compete setting up the Profile, Go to EXAC220 Suspense Documents General Upload

Specify a profile you would like to choose.

Enter Start Line which is the line that the information that you would like to upload start (excluding the title lines) and click Upload button.

※ Please refer to the 【ACSP125 Update Suspense Journal】 manual for how to update, approval, posting, and delete method importing the suspense document.