How to Import Invoices Using the Invoice and Memos Screen in Migration Mode

• Enable Migration Mode

Ensure that Migration Mode is enabled by following these steps:

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

• AR Invoice Import – Excel Sheet Guidelines

1. Refer to the prescribed AR Invoice Import Excel sheet format.
2. In Migration Mode, all imported Invoices will be created in Open status.
3. The Type field must be one of the following:
   • Invoice
   • Debit Memo
   • Credit Memo
   • Credit WO
4. The Reference Number:
   • Can be any value
   • Must be unique for each record
   • After import, the system will generate the AR Invoice Number in sequence
5. Ensure the following details are correctly populated:
   • Customer ID
   • Customer 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).

• Data Provider – ACU Import AR Invoice

• Import Scenario – ACU Import AR Invoice.

• Import by Scenario – ACU Import AR Invoice

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

• See the below Invoice and Memos Screen

Conclusion

Importing AR invoices into Acumatica through Migration Mode makes the migration process simple and organized. By following the required Excel format and using the correct Data Provider and Import Scenario, invoices can be imported accurately and efficiently. Once imported, the invoices are created in Open status and can be reviewed from the Invoice and Memos screen in Acumatica.