How to Import Bills Using the Bills and Adjustment Screen in Migration Mode

• Enable Migration Mode

Ensure that Migration Mode is enabled by following these steps:

1. Navigate to Payables
2. Go to Preferences
3. Open Accounts Payable Preferences
4. Enable Migration Mode
5. Click Save

• AP Bills Import – Excel Sheet Guidelines

1. Refer to the prescribed AP Bills Import Excel sheet format.
2. In Migration Mode, all imported bills will be created in Open status.
3. The Type field must be one of the following:
   • Bill
   • Debit Adjustment
   • Credit Adjustment
4. The Reference Number:
   • Can be any value
   • Must be unique for each record
   • After import, the system will generate the AP Bill Number in sequence
5. Ensure the following details are correctly populated:
   • Vendor ID
   • Vendor Reference (Invoice Number)
   • Currency, Currency Rate Type, and Currency Rate (if applicable)
6. The Balance Amount and Document Amount must be the same.
7. Provide the appropriate Account and Subaccount details.
8. Enter the Terms Code (based on which the system will calculate the Due Date).
   • Also include the Cash Discount Date, if applicable.

• Data Provider – ACU Import AP Bills

• ) Import Scenario – ACU Import AP Bills.

• Import by Scenario – ACU Import AP Bills

1. Click the Prepare button to validate the data.
2. Click the Import button to upload the file.
3. The bills will be generated in Open status.

• F) See the below Bills and Adjustments Screen