Import and Export Scenarios

Hi together, i want to import Template Items with Inventory ID Segment Settings When i import the settings will be like this:   But thats here is what i need:  I hope you cabn help me with the mapping.Thanks

I have an expense receipt upload for a client that works when I import the receipts, but after you claim the receipt, it does not allow you to mass “submit the claims”. I have no approval maps needed. I tried to create an import scenario to import them as expense claims instead but I am getting an error that states the button is disabled. Save, submit, and claim are all disabled. I want an easy way for the customer to upload the expense without having to submit each one individually. Does anyone have a solution?Thanks

Hello, I’m trying to create an import scenario that can update the kit specifications for some products. I have a generic inquiry that returns the current specifications of a stock item kit. I want to add these stock components to another kit and remove this line. The issue I run into is that there may be 3 items I want to add, yet the import scenario wants to remove the existing line for each row, but it doesn’t exist for 2 of them after the first one runs. Any way to work around this?  Business Case: We have non stock kit gift boxes we sell all year. During our busy holiday season, we pre-make a bunch of these kits and use a Stock Kit as the 1 “component”. When these premade boxes run out, I want this process to automatically change the stock components of the kit back to the individual components and not the stock kit. In this example, the 60005 SKU is a Non Stock Kit. The 40005 is the Stock Kit. In the import scenario, I want it to remove the 40005 item as a component and add these

I have a large import scenario that I need to amend, to prevent any issues while I do this I would ideally like to be able to duplicate the import scenario and then rename it to something unique so I have a backup essentially.Is this possible to do? I know I can export to XML but when importing I can’t see anyway of renaming / duplicating. 

I’m having trouble importing a group of new customers to Acumatica.  I’ve created a Data Provider for my Excel document with my customer info in it.  I’ve created an Import Scenario to import the data.  When I go to run the Import by Scenario (testing out running just the first 2 records) I get the error “2 items have not been processed successfully. View name: BAccount.”I’m at my wits end here and I’m sure there’s just something small I haven’t checked.  Can someone help me?  Here’s a screenshot of my error:I’m also attaching an .XML copy of my Import Scenario. 

In an import scenario, is it possible to add a condition on an action row, specially the <Line Number> action?Use case:In an import scenario for sales order, the data provide has a single row per sales order. Based on a value in one of the columns, sometimes we need to create 1 line item and sometimes 2 line items.The idea would be to add a condition on the second <Line Number>, something like =iif([MyVal]=1, -1,null), where the -1 adds a row, and if the condition is not met the null will ensure no rows are added.So far, I have not been successful adding any formulas in there. Not even a single Cint() formula without conditions.  

 Hello Team,I am creating an automation where the system will automatically create Purchase Receipt type Transfer Receipt and add all the SO have the same Project ID on that transaction. However seem like the import dont work, please view my setup as below:1. I create an generic inquiry list down necessary info. You can find attachment for reference  A business event with setup group record by Project ID with an aim to create only 1 Purchase Receipt if there are multiple of SO with the same Project ID. It was raised by schedule Create an Import Scenario for create Purchase Receipt type Transfer Receipt and add all SO  As the result, the system only create Purchase Receipt and cant add Transfer order.Looking for advise from you allThanks in advance

Hello community,i have been trying to import sample time cards into the system, but the scenario triggers the following error:how to resolve this?I also have attached the xml file for the scenario.

HI All!  I am attempting to design an import scenario that will create PO Return Receipts.  I am unable to successfully import when attempting the “Add PR” step.  Here are the details:I have a data provider that is a GI containing the original receipt details Here is a screenshot of the existing Import Scenario: The highlighted area is where the issue is occurring.  If I remove the <Dialog Answer> and the <Action: Add PR> (AddPOReceiptReturn) line – the import executes and creates a Return Receipt without the Receipt details If the import is executed with the lines, an error occurs but there is no error message This is the part of the entry that I am attempting to automate in the import that is failing:I appreciate any assistance or advice on how to make this import run successfully.Thanks! Michelle

Hi Acumaticites, Good morning. I have been busy building import scenarios for various transactional screens. With a little elbow grease, one can usually find some posting here with someone sharing an import scenario that is working. The reality is that many of these import scenarios are very specialized to the Acumatica implementation which they are used in. Anyways, it seems like it would be quite helpful to have a publicly shared Git repository with various “sample” import scenarios (more than the “out of the box” shared import scenarios that come with Acumatica). Of course, one would want these organized by module and screen with a description pertaining to the destination system (1 branch or many branch, ...). One would describe the usage too (e.g. initial load of a master-detail screen or an update to a master-detail screen). One could place a safe harbor note about the risks about using these shared import scenarios in production environment. Of course, one would want to mask or

Hello!Can someone please share their import scenario profile regarding checks and payment with a bill to be applied yet balanced status.I’m stuck at An error occurred during processing of the field Reference Nbr.: Error: 'Reference Nbr.' cannot be found in the system.  

Hello Guys, I hope can u help me.I want to import the "Type" Constant with a value.   

Hi, I have some data that I’m trying to import into the Note section on Stock items. I have used and am familiar with the approach when you have multiple lines to add the CStr(‘\r\n’) in between the data elements to get the data to look correctly formatted.  The situation I’m having trouble with is that I am being given a note field in an excel spreadsheet where the actual data already has the \r\n within the data.  If I just map to that field and create the note, the \r\n seem to be ignored and it’s just one long note with no formatting.  Is there some trick or adjustment I have to make in the source data or import scenario to get the data imported in the formatted multi line way I want?  The data is variable, it could have 2 lines of data or 20, so I’m thinking trying to break apart the actual data elements into separate cells wouldn’t be an option. Thanks  Bob

I am trying to update the backflush flag on production detail. I am close but something is off….  It throws the following errorsany ideas?

Hi All,Wanted to get some help on figuring out why my automation schedule is not firing as intended. We are using the schedule to trigger a business event, triggering daily every 5 minutes. It basically checks an existing GI for any records and triggers and import against the return. As you can see from the screenshot, last executed date was on 6/20/2025, it is 7/4/2025 today.I’ve tried manually triggering the import, and it works perfectly.  

Hi!I am trying to create an import scenario that will create a shipment in acumatica.  i had tested this out before and managed to get it to work with one line but it’s not working with multiple lines (pretty sure i broke how to do it for one line too 😅).the import scenario attached creates the shipment but it doesn’t add the lines to the shipment and save.  I have actions to confirm and prepare invoice too but at this point, i am just trying to select the lines and save the the shipment. here’s the add order screen with what it looks like when i manually try to process this shipment, however, i cant seem to get the import scenario to select all the lines i appreciate your help in advance!

Hi AllI am using Acumatica version Build 2024.114. I have written an Import scenario to import Template Items. I want to apply a validation on Template ID field i.e. if the value being imported already exist as a Template ID, the row is not imported. Is it possible? Any help appreciated.Below is the screenshot of my import scenario.  

I created an import scenario to mass create refunds in the AR payments and applications page. The actual creation of the refund has worked but I was also attempting to pair the refund with a SO of the CM type that is already created. Below is the error I am getting: This is my import scenario (XML is also attached)  

I am trying to automate the creation of a Sales Order and Shipment, I have a GI with the lot serial information and the customer linked to that item, and a business event to trigger when I want it to. I would like for a Sales Order to be created for the same item, and the lot serial shipped so that all that we have to do is invoice the customer. I am using an import scenario and a business event to get this to happen, but I am stuck on literally the first thing.  I keep getting the error of ‘Customer ID cannot be empty’ and everything I have tried will not fill in the customer for some reason?  I haven’t even been able to test the rest of the import scenario because I can’t get past the customer. Here is my import scenario, is there something I am doing wrong on the first line? Why is it not able to get the customer filled in?  

Hey community,I have a scenario where my file would be imported via ftp. Everyday one single file will be imported but the name of the file would be in the following format: file-import-<datetime>So in this file name <datetime> is variable. So will acumatica import the same file into the same import scenario with the variation in the ending name of the file? if no then what are the possible ways? Is there any option to define an expression or maybe just before the import it changes the file name and then import it ? 

Does anyone have experience accessing the following internal field while importing?CurrentDocument.CuryUnbilledOrderTotalI need access to it because I want to remove a cancelled order line, get the new unbilled $ amount, and then enter that number into the “applied to order”I BELIEVE I can’t simply do math on what I am removing, as there’s an external tax calculation that needs to happen after removing the line and saving the order  

Create Shipment import scenario was working in 23R1 but gets an error in 24R1. The error message is “Another process has added the 'SOShipmentCarrierData' record. Your changes will be lost.” The Add Order function works in the UI but I have tried everything to get an import scenario to work to no avail. Here is what my current scenario looks like: Any Ideas would be appreciated.

Good day Team,I am trying to push the current period to all bills imported into the Bills and Adjusment screen, The import scenario is suppose to set to import bills into the Bills and Adjusment Screen, I am having some of the bills been set with the Correct Period and other dot not workThe import scenario is using the Post Period to be: =Right('0' + CStr(Month(Today())), 2) + CStr(Year(Today())) also, tried with the ‘-’ =Right('0' + CStr(Month(Today())), 2) + ‘-’ + CStr(Year(Today())), with the Comit Set to true and the Ignore Error set to true as well, I get some mix resultsResults: With The data from the import being: Somehow the import for bill number 6 is good, but import for 5 and 7 is not working giving the error the 04-2025 and 05-2025 period is locked, also, the other June bills, instead of defaulting to 07-2025, is setting to be 06-2025 as the period is still available. Any help will be awesome. Thank you!

Hi,I tried to export a scenario for stock item and I am getting a issue. I have defined conversions on stock item , but when I prepare for stock item export scenario , it is fetching the conversion which is not define on stock item. ( the conversion is also not define on  item class, unit conversion as well)The conversions which are define on stock item is getting fetching along with the conversion which has not been define .Please anyone has solution or suggestion for this.??

We are on 2024 R2, has anyone noticed that the ascending or descending selection is no longer available in the columns option selection.