Here is a Vendor sample Acumatica Import Scenario with Installation Instructions.
Click here for a listing of other Sample Acumatica Import Scenarios
Screen: FINANCE -> Accounts Payable -> Work Area -> MANAGE -> Vendors (AP303000)
Fields Imported
- Vendor ID
- Vendor Name
- General Info -> FINANCIAL SETTINGS -> Vendor Class
- General Info -> MAIN CONTACT -> Company Name
- General Info -> MAIN CONTACT -> Attention
- General Info -> MAIN CONTACT -> Email
- General Info -> MAIN CONTACT -> Web
- General Info -> MAIN CONTACT -> Phone 1
- General Info -> MAIN CONTACT -> Phone 2
- General Info -> MAIN CONTACT -> Fax
- General Info -> MAIN CONTACT -> Account Ref. #
- General Info -> MAIN CONTACT -> Parent Account
- General Info -> MAIN ADDRESS -> Address Line 1
- General Info -> MAIN ADDRESS -> Address Line 2
- General Info -> MAIN ADDRESS -> City
- General Info -> MAIN ADDRESS -> Country
- General Info -> MAIN ADDRESS -> State
- General Info -> MAIN ADDRESS -> Postal Code
- Payment Settings -> DEFAULT PAYMENT SETTINGS -> Payment Method
- GL Accounts -> AP Account
- GL Accounts -> AP Sub
- GL Accounts -> Expense Account
- GL Accounts -> Expense Sub
- GL Accounts -> Cash Discount Account
- GL Accounts -> Cash Discount Sub
Files (see Installation Instructions post for how to install)
- Vendors Data Provider.xlsx (contains one row of sample data from the SalesDemo company)
- 0 Vendors Data Provider.xml
- 0 Vendors Import Scenario.xml
Installation Instructions
- On the SYSTEM -> Integration -> MANAGE -> Data Providers (SM206015) screen,
import the 0 Vendors Data Provider.xml file
using the Import from XML option on the paperclip icon pictured below - The Schema tab should now look like this
- Upload the Vendors Data Provider.xlsx file using the FILES, BROWSE and UPLOAD buttons in the upper right-hand corner of the screen
- On the SYSTEM -> Integration -> MANAGE -> Import Scenarios (SM206025) screen,
import the 0 Vendors Import Scenario.xml file
using the Import from XML option on the paperclip icon pictured below - Your screen should now look like the screenshot on the top of this post
- On the SYSTEM -> Integration -> PROCESS -> Import by Scenario (SM206036) screen,
select 0 Vendors Import Scenario and click the PREPARE button
- Acumatica will bring the data from the Excel file into the grid on the Prepared Data tab. You know it’s finished when you get the green checkmark on the top of the screen.
- From this point forward, Acumatica will be using the data in the grid on the Prepared Data tab to do the import. It doesn’t go back and “talk” to Excel. So, you can change the data in the grid if you want and this will be the data that gets used for the import.
- Now we need to actually do the import. Before you do this, I recommend taking a Snapshot backup of Acumatica so you’ll have something to roll back to if you don’t like the results.
- Also, note that only the records that have Active checked and Processed unchecked will be imported. The other ones will be ignored by the import.
- To import, click the IMPORT button
- When it’s finished, you’ll get a green checkmark on the top of the screen if there were no errors and the Processed column will be checked for all records that imported successfully.
- If you get a red checkmark on the top of the screen, it means that you got an error on one of the records. Just look for the record that has a message in the Error column. You can hover over the message to see the full error message.
Note: If you have any issues with this sample import scenario, please leave a comment at the bottom of this post.