Import and Export Scenarios

Hi everybody! I was working on this Import Scenario but I’m stuck on how add data to the “Product Workgroup and Product Manager” column.I tried it to activate the “Override Product Manager” so i can added them, but maybe I’m missing something.Thank you for your help AcuCommunity!

Hello Acumatica Community,I'm currently facing an issue with exporting the Acumatica Company Tree using Export Scenarios. Whenever I click on the "PREPARE" button on the Export by Scenarios screen, the system takes around 3-4 minutes to load and eventually displays a "Session Expired. Please reload the page" message. This error prevents me from successfully exporting the tree structure.Here are the steps I've followed:Configured the export scenario settings as required. Went to Export by Scenarios and Clicked on the "PREPARE" button to initiate the export process. Waited for several minutes until the error message appeared, indicating a session expiration. And system showed no data.I have tried this process multiple times, but the issue persists. It seems to be specifically related to Export Scenarios Data mapping error.I would greatly appreciate any insights, suggestions, or guidance from the community on how to resolve this issue and successfully export the Company tree using Export

I have a use case where I want to copy the value of a custom field on the SOOrder (UsrICOrigCustomerID) to the description field on the SOOrder (OrderDesc). This would only be on a particular order type (IC). Is this possible through a Business Event? 

I’m looking to remove the phone number from the customer screen via import scenario. I know how to override it, but how do I remove it? 

Building an import scenario to delete tax impact on POs - not sure which field to use on import scenario. I need to:Delete the Tax ID Remove Hold SaveHere is my current import scenario:    

Importing records like sales orders or POs.The Inventory ID MAY be valid.However, it may not be a valid inventory ID.Is there a formula or anything that checks for this, then allows you to set a default value if the one provided is invalid?Thanks!

Hello, Is Acumatica able to export to an Azure storage blob (specifically using ADLS Gen 2)? Information on whether this can be done and how would be greatly appreciated! Thanks!

Hi all, I’m trying to create an import scenario to change the ship via when an order includes an alcoholic item. I’ve created a GI to catch all the orders with the targeted items, and then have a business event setup to run every time a record is inserted into this GI. The business event then runs the import scenario. It says it’s running without errors, but the sales order ship via’s are not changing. And also, it looks like the business event is running multiple times instead of just once per record? Anyone know what I might be missing? Thanks! 

Creating an import scenario to mass update the detail section line of a group of invoices. I seem to be adding a new line rather than updating the existing one. Here’s my import scenario which is adding a new line and updating to account 40005 instead of updating the existing line. 

I am trying to create an import that will change the options on the dialog box called “Load Documents” on the AR Payments and Applications screen. I found the load options on the import and the action to select the load documents button.  However I can not find the dialog that would allow to select load Has anyone been able to import to this dialog box and load it ?  Thank you.  

Hi, I am currently trying to mass update an attribute on our project tasks, I ran a file of about 5,000 tasks, and half of them worked. Below is a screenshot of the error and the import scenario. Error: Import Scenario: Thank you,KT

We are having an issue with a business event that is supposed to update an attribute on Invoices (user-defined field).The attribute is a selector which is linked to the list of salespeople. We want to update the attribute field on invoices with the default salesperson from the invoice. So, to get it to work, we set up a business event and a schedule.However, the schedule errors out:  Please advice.  Thank you!

Hi!  I would like to upload in bulk a list of Stock Items from multiple Vendors so we can easily create POs and our buyers do not have to individually add these stock items.  I’ve tried using the import function in Vendor Price Worksheets and Vendor Inventory with no success.  I’m trying again in the Import Scenarios option, but I keep getting stuck on the Provider field.  What option should I be using?   

I have an import scenario to create sales orders from a file where I’m trying to replace special characters like 'é' and á with e and a, respectively. I’ve tried using the Replace() function but it is still populating those fields with ‘??’ instead of those replacement characters. Any idea if this is even possible with import scenarios?Example - this formula: Results in this: Where the first name from the file is José and Acumatica doesn’t seem to know what to do with that special character from the data provider.

Hi everyone,I am using Import Scenario to create Item Classes with Multiple Attributes, and this Import Scenario works: But we need those attributes to be as variant so we define each attribute category as “Variant”.  But after Preparing and Importing, it fails with the error: Can you please help how to set a multiple attribute with variant as category for Item Classes in Import Scenario? Thank you so muchPS: Some records we are importing has single attribute, others has 2, 3 or more

Where am I going wrong ?Attached is my simple 2 field Import Scenario: ContactID and OwnerID (ie. EmployeeID). Process used: Data Providers → Import Contacts from ExcelAttach Input File (attached) Reload Parameters Schema Fill Schema Objects Activate Fill Schema Fields Toggle Acitvation (To Clear All) Manually set ContactID and OwnerID (Only)    Import Scenario → Import Contacts from ExcelI get this error Any help would be greatly appreciated.Thank you

My customer just upgraded to 2022 R2.  We did not make any changes to their import scenario but now when records are imported every other record is missing the inventory ID and is going to the wrong GL account?  We re-built the import scenario but it is still happening.  Any idea why this would happen?

We are having issues with our import working in real time importing contacts from HubSpot into Acumatica.  I changed the Polling from 60 seconds to 300 seconds and then I restarted the HubSpot SyncWhen I restarted the Contact Import changed from “No Polling” to how you see it below. This Polling function is why the record didn’t come in. I made a new record in HubSpot and it came in after the 5 minute mark. The Last RealTime Attempt field is queuing when processing occurs.I have no idea what made it go from “no polling” to polling. I’m not sure why Leads wouldn’t also be in a Poll status. Why is the Lead still in a (No polling) state and how do we change that?    And how and why did it even go into no polling state? 

I want to create an export scenario which includes order summary and line details. Is this possible?  I created an export scenario (XML attached), however it doesn’t work correctly. 

Hi,I need create a user which i want he have access to only two G.I. in the 37 total G.I. of the system, how to acheive this?I created an user who i gived ODATA role + NewRole(who have view setting in Acces by screen on these two GI). But it’s don’t work.Thanks

Hi,When importing Excel sheet into Acumatica, is it a must that the field in that excel spreadsheet be the same as those fields in  Acumatica?Am tying to import sales prospects in an excel sheet  to opportunities screen but it’s not getting through.Kindly advise, 

Hello,Importing production orders in 3 steps.1 scenario creates production order2 scenario adds operationlast scenario is to add material to the existing operations.Does anyone have a working model they can share? 

Hello,I’m trying to Import a Customer List using the out of the box import scenario.  I’m getting a “BAccount” error with the below details.  The import scenario is attached below as well.  What do I need to add or change?  Thank you!  

Hi, I am trying to import open sales order data by using the Import by Scenario in Acumatica. I am getting the error “‘CustomerID’ cannot be empty”.The CustomerID field has the Customer ID numbers, it is the column highlighted in red on the attachment.Does anyone know what may be causing this error? It is not triggering the error for a few orders listed in the second screenshot.