Import and Export Scenarios

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!

Hi,We have a client that wants to import A/R Invoices and Payments into Acumatica using files that have pipe delimited txt, csv, txt, or dat extensions and also export data from Acumatica using the same file extensions. Is this possible? Any help or reference guides would be great.Thanks,Frances   

I have an inquiry that shows all Bills who need to have the Pay by Line box checked (next I am doing Invoices and Memos). I have a business event that triggers off an import scenario every time a new qualifying record is created. Below is my import, it shows that it runs successfully in the event history, but the PAY BY LINE box is never checked like I need. Anyone know what I may be missing??? I have tried setting the checkbox value to:=’1’=1=’True’=True Nothing seems to stick. The history says it accessed the proper document, but nothing is ever changed. Thanks for the help!

I have a business event that has a subscriber that is an Import Scenario.  The GI that the Business Event uses has a few formulas in the results grid.  When designing the import scenario, all you can see for GI result grid lines that are formulas is something like “=[POReceiptLine_Formula5b2e0f32d4304e46852164172e23dab5]”.  Other than trial and error, does anyone know how to tell what the result grid line is?For example, the business event creates an inventory adjustment based on a GI that looks at PO Receipt Lines.  I have several formulas in the GI results grid.  One formula is multiplying the ReceiptQty by an attribute, and I gave it a Caption of “Ext. Cost”.  However, when I go into the business event subscriber’s import scenario to map that GI results grid line to the Adjustment’s Extended Cost field I don’t see “Ext Cost”, I just see the formula ID’s. I know I could put the formula in the Import Scenario, but if something in the formula needs to be modified I want to do it by mod

I'm trying to import employees but I get the following error: this Import Scenarios: 

Hi All, I have looked at the existing topics here for GL Journal upload as well as the out of box ACU Import GL Transactions. none of these has helped me to load my data. I have uploaded the sample of data I am trying to upload. it loads the first line but fails at the second line I also have no explanation on why it does what it does. I had to move things around until it posts Debit side for my Inventory account and credit to GRNI ( po Accrual or Goods receipt not invoiced) Appreciate your help and insight on this. Thanks Ghazal 

I am building an Export scenario based on Invoices and Memos.I am able to successfully select and include the Item Description field in my export. I would like to use a LEFT() function to select only the left 40 characters, but I am struggling to figure out the DAC prefix for this field or I do not have the proper syntax.When I look at the SYMappingField, it shows me that the “Object” name is Transactions, but when I add that to my function, it does not validate.What is the best way to determine a field’s DAC ?OR, am I having a syntax issue?=Left( [Transactions.InventoryID!Descr], 40)  

Good day CommunityI have to change a number of records to adjust depreciation so I created an import scenario. The import goes through without any errors but the result is pure garbage and only 1 record has a value. I’m sure it is the scenario setup (incorrect fields) but I can’t seem to fid the problem. Can anyone help? Many thanks

Good day.I am having the strangest thing happening.  I have 7K work centers to update.  I am testing the attached import scenario.  I ran the below together; One was perfect.  The other only partly updated and missed a work center.Attached is the XML.  What could be wrong.  I tried to add a line number; that screwed up everything with updating the wrong Work center.Any thoughts.Thank you.Evan  

I am attempting to, via import scenario, create template items and create all their matrix items. I need to create hundreds if not thousands of template items. When assigning attributes to Item Classes and then assigning those item classes to the Template, all attributes are set as “Active” for that template item by default when creating the item. I want to set the checkbox in the header of that column to FALSE so that it ideally unchecks all attributes and then allows me to go set the appropriate attributes to TRUE again through import scenario.Attributes from Template ItemHow can I set the header column checkbox to FALSE and thus uncheck all attributes via import scenario. I don’t want to create 100s if not thousands of item classes just to use with the appropriate attributes. Some attributes in an item class don’t apply to all template items so I need to pick and choose which attributes apply to which template items. 

Hi, how do I export all the stock item description tab content for all my stock items that has a description content? Not the item description on top.   

HI, I am trying to create an Import scenario to load Activity Notes in Cases (cr306000) I loaded the IS from here: But I an getting a message that the Activities$Attach_RefNote action cannot be found. I deactivated the fields that I do not need. Here is an image of the import scenario, Any assistance is appreciated. Bill