Import and Export Scenarios

Hi all,I need to create an import using the Close Production Orders screen.  The file upload in the Import Scenario will contain the Order Number and other details about all the completed prod orders.  Our process on closing the production orders is if it is completed by >= 14 days.Any help appreciated.Cheers,Laura 

Hi all, i have import scenario. I Have some action which use data from address tab. When i debug this, i saw that Site_Address.Current is null. But my project have this data. Project.Current is not null. Have you any ideas?

Good day,I wrote the attached WO Import Scenario.  It is said it processed without issue.  However, it not producing the write off document from the scenario.  I think it has to do with the selection/process action not working.Any assistance would be greatly appreciated.Thank you.Evan

I cannot seem to resolve the error ‘The Submit button is disabled’.If the Submit action is removed, the time card Save creates and saves the time card as expected.I have tried many options in the scenario to continue to Submit without any luck (different flags, different Submit action, etc.). Any suggestions on how to resolve? Attaching the XML also. 

Hello everyone,We recently upgraded to 2025 R2 and one of our Import Scenarios is now throwing errors.  Here is the main one:  The Import Scenario is Deleting the Salesperson from each location in preparation for adding the new person in a second scenario.I went to the Customer and every aspect is filled out correctly.  Nothing in the error message is empty for the Customer.  Do we need to add all of those fields now to each Import Scenario???  I have attached the file to this post.  

We are trying to import the PI inventory counts from excel and receiving an error.  Steps takenExport the list with the Excel button. Enter the Physical Quantities in the the column for Physical Quantities in the excel.  Save excel and click upload.  There is only the one column to update.  Expected this to be “easy”Dont know how to find the Trace in the error message to try to identify the error. 

Hi,I am working on import purchase order receipt type transfer receipt which is triggered by record change on Business Event. But, I can’t apply field locations of receipt lines with the same value, just line nbr 1 is applied. I don’t know if there is something wrong with my import mapping.  

We have a client who is using a third-party timecard and payroll system which utilizes Alpha-based employee IDs in these systems.  We also need to import time card data into Acumatica, but our employees are numerically assigned and have limited 7-character codes due to the BIZACCT segmented key setting.  For this reason we are using “Substitution Lists” to cross-reference the Timecard’s employee identifier with the Employee ID in Acumatica.  We are storing the timecard system’s employee ID using External Ref Nbr field in the Employee screen.In order to keep our substitution list up to date, we’re using the Employee GI as a data provider to update the GI using an import scenario.  Knowing that the substitution list will error if we try using the “=1” code for new lines, we’re using the @@OriginalValue constant to define the row key and mapping it to the Native Field [SubstitutionValues.OriginalValue].  The expectation is that the import will locate the Original Value in the grid, if it

Hi,I have a list of dropship orders in a csv (downloaded from a 3rd party app) that contains everything I need to create a Sales Order with an import scenario, except our customer’s details. If all the orders in the spreadsheet are for the same customer how do you recommend I proceed?could add column to spreadsheet - but want to avoid that manual step.  Could write something in Excel to ask for the customer and create a new csv, but this is the 2020s. hard code the customer id into the import scenario - possible but there are many of these and that creates a burden on maintaining the scenarios (if one for each customer). Is there a way to ask the user to choose a customer as part of running the scenario? Can the import scenario link to a Generic inquiry that could be filtered to the correct customer? Any other ideas? Thanks in advanceSimon

Hello,Need some clarification as I'm bit confused on the backup process. Noob question.So as I understand the relation between Tenant and Company(with or without Branches) is 1:nSo if in a given scenario there are 10 companies in a Tenant and all I want is to take a backup of one single company within that Tenant then do I have to backup and restore the whole Tenant (what I see as the only option) or is there another way to only backup single company to test a scenario. Please share if there is any way to do this else seems like this should be a new added option in the backup process.Thanks

Can anyone tell me where I can find a description of the json objects for importing data via api?

When importing a Shopify Sales order, I would like the item description to be transferred to the sales order item that corresponds to the language stored in the customer. A corresponding translation for the item description is available.If you enter a sales order manually, it works, but not when importing.Does anyone know if and how this can work?Thanks in advance.

Hello good afternoon communityI am importing customers and vendors through the import scenario, there are approximately 16,000 customers and about 4,000 vendors, many of them are customer/vendor at the same time.When I do this I get an error saying that I cannot have the same customer and vendor ID during the import. These customers/vendors have the same ID. since they are the same.Is there a configuration that allows it? Is there a way to import them by import scenario? because there are about 950 customers/vendors that exist with this condition. I hope you can help me since it is impossible to create them one by one manually.I am driving Acumatica version 2023R2I look forward to your help and thank you in advance.Vanessa.

Hello! We currently have the “centralized period management” option enabled in our environment, however would prefer to have the option to close individually at different times of the month instead. Our problem with this is we have 55 Companies and it would be very time consuming, especially since they will all be closed by the same person. Is there a way to create an import scenario for this instead?

Hello! I’ve tried all sorts of combinations to achieve this.Summary: under certain conditions, run Business Event / Import Scenario to update Opportunity from Open to Close as Won and set the Reason code to a specific value.I am able to get the status updated to Won. Also, when looking at the CRM tab, it appears that the Reason has been set. However, it is blank in the GI results and in the DAC.The Reason is available when updating to Close as Won manually.I’ve tried both of these options: RESULTS:  

Hi, I am attempting to create an import scenario that populates attributes at the line level for purchase receipts. My import scenario is adding the correct inventory id, quantity, etc. but doesn’t populate the attribute value. What am I missing? 

Hi,My customer is using an XML file from a 3rd party to update PO container records (AcuContainer). The issue we have is that there are records that don’t exist in the system, how do we DISABLE record creation so it will only UPDATE existing records? Thanks

I am trying to update scheduled AR invoices detailed lines. They do have inventory IDs. Some have 3-5 detail lines. Having trouble getting the import scenario started. Testing multiple ideas.

I’m looking to prepare and import an import scenario every morning at 3:00AM. It looks like all of the help topics for this are older versions of Acumatica. I’m in 25R1I suspect it’s a business event but none of the actions types seem to fit a specific schedule/time scenario. Thanks!

I would like to do two things with one scenario, but I cannot get it to work for multiple records. The first record works fine, but all the others error with the message “The system failed to commit the Items Row”. We have multiple discount sequences “5” and “10” within a code “SALE”, which mark items as 5% or 10% off; nothing complicated. Some items got put into the 5 sequence that should have gone into the 10 and I would like to use an import scenario to remove them from one and add them to the other. Yes, I can do this as two different scenarios, but it seems like something that should be manageable all at once. It seems straightforward enough: go to one sequence, lookup the item with @@InventoryID and remove it, then go to the second sequence (same discount code) and add it. Oddly, it wasn’t working when I had a ‘<Line Number> = -1’ action to add the item to the second sequence. I can’t reset the InventoryID key in the second sequence; it just merges with the first key line.T

Hi everyone,I’m working on an import scenario for the Shipments screen (SO302000) to upload serial numbers on the Line Details screen.Right now, my scenario finds the shipment and uploads the serial numbers — but all serial numbers are ending up on the first shipment line, regardless of which item they belong to.What is the proper way to configure this import scenario,   

This should be easy but just can’t figure it out. How do I initiate a full database export of my acumatica instnace? 

i have an issue ..only the header of the shipment is imported without lines.Any help please ! Attached you could find the scenario.Version : Version 21.2.2303.133 [21.213.0038]Thx in advance.

Hi All, I have a scenario where GL journals have to be exported and imported in another ERP system. after the export we would like to mark these lines as being imported so they can be obvious on a GI. I can’t work out how to get the import scenario work using the same key module, batchnumber and line numbers. any hint would be much appreciated. What am I missing here ? error is not telling me muchThank you 

Hello guys, i am trying to import customers through import scenario and i am getting the following error “Please confirm if you want to update current customer settings with the customer class defaults. Otherwise, original settings will be preserved”please help me how to solve this error. thanksplease find the attached screenshot.