Import and Export Scenarios

Hello all,I have been trying to import Customer Contacts but only my last contact is getting added out of 5 of them. Below is the import scenario:FYI, when I try to search for the Contacts (CR302000) form in the Universal Search Bar, it doesnt list the screen, due to license restrictions, as its not purchased. But still I am able to access the contacts form if I click on any of the contacts from the Customers (AR303000) screen → Contacts tab.We do have the option the create a contact on the Customers screen but how shall I build an import scneario for the same? 

I’m importing into the Project Budget Forecast screen and I have it working except it is requiring an inventory id. If I put in an inventory id, it works. However, all of my other budget lines don’t have an inventory id on them (<NA>). Is there a way I can get this to work for the <NA> lines? Thanks in advance.Paige

Please help to solve this error:“Error: An error occurred during processing of the field Amount value 6500 The document is out of the balance.”   

Good day,I set this import scenario in my test system  It worked no problem creating vendors.  New vendor IDs were created (Auto Numbered).  I added a complete additional fields.  Not it give the BA can’t be blank message.Help or pointing me the right direction would greatly appreciated.See XML Attached.Thank you.Evan

Hello,My task import process is only creating one record. Leading me to believe it is overwriting the record instead of creating multiple lines. I have attached an export of my import scenario as well as a screenshot below. Is there something I am doing wrong for this process? I have interchanged Subject!Subject and Summary and the results do not differ.Thanks,Tyler

Hello all,I have been trying to update the line in one of the screens but unable to do so.I have been trying to update the End date for the second line in the below rate table,  And the import scenario: 

Has anyone ever created an Import Scenario to import payments against invoices lines. We are using Pay By Line feature and I cannot get the import scenario to work.

 "Can anyone help me resolve this error? I have created an import scenario for bills and adjustments, and I want to attach a purchase Receipt (PR) to the bill, but I'm unable to get the input. Can someone please help me solve this issue?" i have attached this pic 

We created an Import Scenario to read lockbox file and create payments and load documents. Worked fine in our test environment.Moved the same to PROD and now getting below error on the Import Scenario.The required configuration data is not entered on the XPMSetup form.  Please help me find what is XPMSetup form? Thanks,NB

We have an Import scenario for AP Bills and Adjustments to pull in large numbers of payments. But the import fails with the following error. “Field: Subaccount, Value: 605 , Error: 'Subaccount' cannot be found in the system. Please verify whether you have proper access rights to this object.”The vendor has a default Expense and Expense Sub Account set on the vendor record. We are trying to override those in this case using the import scenario and can’t without getting this error.  If the record is entered manually we can override it just fine without error. Removing the default Expense and Expense Subaccounts also allows the import to work without error, but it’s pointless to have to do that. The import scenario is very basic for importing AP Bills:My question is, has anyone experienced this and what can we do to allow the import scenario to override these account values without getting the error? 

I have created an Export Scenario that uses a GI. My GI gives me the results I need, but the Export By Scenario screen will not output any results.  I have followed the I100 course instructions, but am obviously missing something.  Any help would be much appreciated. Here’s my GIThis is my output, as expected.This is my Data ProviderThis is the export scenarioA CSV file exports with no results, only the header row.  What am I missing?  

Hi,I am creating a business event to add time card entries through an import scenario.It gives me an error which says - Employee not found in the system. It seems there is some sort of an access issue. Could anyone please help?But the employees are present in the system. I can manually add time card entries. And also I can add through a stand alone import scenario (That’s not connected with business event/automated schedule).  ==================================================== Thank you!

Hello! I would like to use Business Event Import Scenario to create a task automatically when an opportunity status changes to “Won.” I followed the steps in this article: Automatic Task Creation with Business Event and Import Scenario • Everything Else • Acumatica User Group Forums (augforums.com) but was not able to see the task get created. I think my import scenario might be wrong… any ideas?  Thanks!

Hi All, I am creating an import scenario for sales orders and after a lot of troubleshooting I was able to get to the end of it without any errors, however after importing my data I saw that Line Description is coming up as blank.I believe that is because of the highlighted info on the screenshot below where I set it to Null. However I don’t know how else to get the data that I need to be in the false statement.My if statement is supposed to bring the item description from my import file if the item id is “!” (exclamation mark) otherwise, just use the description that the system uses based on the inventory id. Essentially, in this situation, the “!” is a comment item, so it should change as per the import file, otherwise it’s an actual stock item, thus should use the description set in Acumatica.I tried looking into the internal fields but could not find the name of the field to bring it up, if it is that simple.Does anybody have an idea? Thanks!Clauber  

Hello, I am trying to update Vendors. When I try to import it, it pops up with an error saying “The key cannot be updated at this time. Try to save your previous changes first.”.Here in my mapAnd the errorThere are no errors showing up on the lines of the import.What could be causing this? Thanks!

I made an import scenario that creates production orders. Is it possible to have it release the production order in the same import scenario? I added “Release Order” to this import scenario and it will error and say “The Release Order button is disabled”. It seems to me that it needs to wait a moment after creation before it becomes available but I dont see a “Wait” or “Sleep” option in there. Am I missing something in my import scenario to make it work? Or do I need to have a separate import scenario to release them after they have all been created? I am using 2024R1 build 24.112.0026. 

I'm trying to set up an import by connecting to an Amazon S3 bucket via SFTP. However, I keep encountering an error stating that the openssh key type is not supported.The key was uploaded to the Encryption Certificates screen as a text file. The File Synchronization was configured with the SFTP details to connect to the Amazon S3 folder.  I tried ssh-rsa and ecdsa key formats but Acumatica rejected both. I am able to access it with no problems using FileZilla, but I am not sure how to configure it in Acumatica. I couldn't find any Acumatica documentation on configuring SFTP or what file transfer policies are supported.Has anyone successfully configured SFTP in Acumatica?

We are going live with Acumatica and in the process of loading Closed Invoices for Historical Data load.We have migration mode ON. All our financial periods are closed and only 10-2024 is Open.When we import Jan-24 invoices, Post Period is defaulted to 01-2024 and the import scenario throws error that The 01-2024 financial period is closed. We hard coded post period in the Import Scenario to 10-2024 and still the same error. Acumatica is defaulting Post period to be same as Invoice Date. Are we missing a setting? We do not want to Open the financial periods.  

Hi Everyone,Can you please help me to resolve the below issue?  

Hello, i am trying to update multiple field values using a business event action attached to a GI. My Import Scenario has all necessary fields, but my business event won’t work.I always get the following error and we can’t see why he would need this. The Formula for “Type” returns the Shortcode for Dropship - so just DP.  I created:Generic Inquiry Data Provider (Business Events) Import Scenario Business EventAny ideas? We are clueless.

I am trying to create a CSV export with a fixed header line that has two fields and detail lines that have 4 fields. Is this possible from an export scenario? How can I format the data provider/export scenario to accomplish this?I am trying to achieve the format below 

How do I use an import scenario to allocate inventory on sales orders that has not been previously allocated? Recently started using auto allocation on sales orders but there are still many that are open that have not been allocated. This is messing up the inventory count. Is there a way via import scenario to allocate all unallocated inventory on sales orders. 

I would like to add Item Cost to an Export Scenario that is based on the Invoices and Memos screen.I do not see a field that looks like it would hold an item’s “cost” value.How can I add the invoiced item’s cost to my Export Scenario??

I have an import scenario that is giving me the error “ Order Type cannot be empty.” I have modeled this after others that we have run in the past. Any thoughts would be appreciated. 

Below is an import scenario that I am attempting to use to delete unwanted UoMs in our item classes. I used a similar import scenario that has worked for me in the past, but it was used to delete UoMs from stock items. When I attempt to import I get the following error:390 items have not been processed successfully. View name: itemclass.I then attempted to change my key from Class ID to Class Description and got the same error.Thanks!