By using this website, you agree to our Terms of Use (click here)
Hello,
I'm trying to import purchase orders into Acumatica and I'm running into the following error.
I can't find PO Remittance Address or Revision ID when mapping. I assume Country is the Remit to Country for the vendor. I'm starting off with just 1 record for now. Any assistance would be greatly appreciated. Thank you.
Charles
Have you checked the vendor profile record? Typically the address information should populate automatically from the vendor ID that you have populated? The system shouldn't have let you save the vendor without a country code, but I have seen it happen once or twice. The Revision ID is a field that I haven't heard of before. Is it a custom field or attribute that you have added to your system?
Thank you for your reply.
Here's some more background on my situation: I'm starting completely from scratch. I've started off by importing: customers, vendors, inventory, and chart of accounts.
One thing I noticed was I was using import scenarios for profiles, I've switched to import scenarios for transactions. I've actually successfully imported purchase orders. Instead of generating my own import scenario from scratch, I've used Acumatica's sample files titled FilesForIntegrationScenarios with just one record and started building from there.
Vendor profile record checked out. I had to include countries for the import on all vendors. I still haven't found the Revision ID yet but since it worked I'm no longer looking into it. Since I'm starting from scratch, I haven't created any custom fields or attributes yet.
Next up: Importing PO/Inventory receiving!
This forum is pretty awesome by the way. Lots of helpful and useful information. I went through 4 hours of Acumatica import scenario videos but actually learned more from here!
@charlescrf The import scenario templates that Acumatica started providing with 2019 R2 are great and are definitely a huge time saver, even if you need to add a couple of fields. The first few implementations we did we created our own (and you can copy and paste them between environments which helped), but it's nice that they are now a built in feature. All the best with your system set-up!
Hi @charlescrf,
You might want to repost this Discussion Topic in the new official Acumatica Community forums here:
https://community.acumatica.com/import-and-export-scenarios-117
Here on AUGForums.com, most of the forums will now focus on reporting, with the exception of general topics in the Everything Else (click here) forum and the AUGForums.com Real Talk Podcast (click here) where we'll continue to focus on real Acumatica customer stories (click here if you'd like to participate).
For more info about how AUGForums.com compares to the new official Acumatica Community, checkout this post:
https://www.augforums.com/augforums-com-vs-the-official-acumatica-community