Import and Export Scenarios

When trying to import Expense Receipts, I keep getting this error message but I’m not sure what is erroring. Looking at the import scenario, it looks like its pulling the information correctly but it doesn't like something about the claimdetails. Any advice? 

Hello - I am attempting to use the attached file to import new vendors into our system. We have used this format before and have no issues. I get an error message saying “Cash Discount Sub cannot be empty (screenshot 1). However, the cash discount sub is not a required field in our import scenario. Am I doing something glaringly wrong here? Any input would be appreciated. Thanks!Attached is the file we are imported, as well as the import scenario.   

I want to update a field in the File Maintenance Screen. I have tried building an import scenario to do this, but it seems to have a hard time calling upon an already existing File so that we can update the Import File Reg. Exp.We are creating this import so that we can schedule a daily import that updates the Reg Exp to the next day. Then we can pull a file with the right date from an external source automatically.

Hello all,I have an import scenario to create SOs from quotes and there are scenarios where the same item might exist in the quote before converting to an SO. Now upon running the import, since Acumatica would find duplicate values (Item IDs), it stops the routine. Any ideas how can I allow the routine to import the duplicate Item IDs in the single order?  Kindly suggest.

I’m trying to create an import scenario to amend customer default payment method. I’ve tried using the billing tab and amending there as well as on the payment methods tab but neither working. Can anyone assist please?The payment method does already exist. 

Hi everyone,We’re getting the following error when importing timesheets for two specific employees:[SubAccountID] cannot be found in the system. Please verify whether you have proper access rights to this object. The import works for other employees.Has anyone encountered this before? Could this be related to the employees’ Subaccount, account, or payroll setup? What configuration should we check to resolve this?Thanks!

I have a client who would like Acumatica to automatically create an AP Bill using their Credit Card bank transaction file.   Has anyone accomplished something such as this? 

Hi, I am creating an import scenario for import bank transactions screen to import a csv file as my data provider. I was hoping to get answers to a couple of questions below please.In my csv file, I have a Beginning and Ending balance column which I think is wrong because you only enter them once in the UI. You don’t enter them line by line. How should I include my beginning and ending balance in my CSV file?    CSV file with Beginning and Ending Balance  In the above screenshot, the Amount column goes to positive and negative goes to disbursement. I’ve attached my import scenario. However, it is giving me an error below.    

I am working on a simple Import Scenario that was previously functioning as expected. However, I am currently unable to update a multi-select attribute through the Import Scenario.I can update and select multiple attribute values manually without any issues, but the same values are not being updated when processed through the Import Scenario. I have tested using both the Value ID and Description, but neither approach is updating the multiple selections.Could you please advise if there is a specific format or configuration required to import multiple values into a multi-select attribute? 

Hello everyone, So I want to import or upload Journal transactions by Import Scenario by transacation, but while i click “Import” there is an error “The Remove Button is Disabled”.Here is the the capture of the error notifications Here is mapping I create in Import Scenario Please help me to solve this, because when I succeed import the transactions, I need to “Remove Hold” and “Release” the transactions one by one. I really appreciate you help, thank you.

This is Classic and it’s very clear, area of the form, object,In the Modern UI you have to scroll thru a list of all Target Option and fields.And you can’t just type and let it find the field.  I would suggest not doing scenarios in the Modern UI.

Hello,I have a GI that filters out past due invoices based on how overdue they are.  Once a record appears in this GI, the business event triggers an import scenario subscriber that is meant to put the customer account on credit hold.Unfortunately, while the event history is showing success, the accounts in my test are not being updated.Can someone review the import scenario and let me know where I am going wrong?Thanks in advance.  

We recently upgraded to 2025 R2, and I attempted to export data to Excel. Although the system indicates that the operation completed successfully, the downloaded file does not appear on the screen. I also checked my Downloads folder, but the file is not there.  

I have a working import scenario that imports purchase receipt, but when there are multiple receipts for the same PO line number with different lot numbers then only the last receipt for that line is imported.Any ideas? 

Has anyone had any success in updating product availability to Amazon for multi locations? For example we have an East and West coast warehouse. We have Amazon setup with these two locations and specific shipping templates. However we have been unsuccessful in updating inventory in Amazon from Acumatica to account what is in each location accordingly. Amazon telling us this can be done, but no one seeks to know how in Acumatica

I did have an import scenario that worked and then the upgrade to 2026 R1 appears to have broken it. 

Hello all,I have been trying to import document discounts for my Sales orders, however unable to do so: The errorI have been testing to import for one order that has 4 lines.is there anything that I’m missing?

When I do this in the Customer Payment Method, I get an error.   To explain further, I created an Import Scenario to Mass Update the Customer’s Payment Method as seen below but the IsDefault field is unchecked. 

I’ve imported Employee records to the Employees EP2030PL screen with an Active history record.  I could use help creating an Import Scenario to create the PR203000 Employee Payroll Settings record. I’ve tried the out-of-the-box Import Scenario, Import Employees for new EmployeesPayroll without success.  I’m using version 2026 R1.It seems the Insert Action in the  Import Scenario does not open the Create Employee Payroll settings dialog, or the Create button isn’t getting clicked.Any suggestions will be greatly appreciated. 

Trying to import Production Orders and the first row went in, now the rest will not. Any tips?  

I’m hoping someone can confirm something for me.  I’m working on an import scenario to update PO Lines.  The source is a GI that brings back POLine records that meet the criteria that I want to update.  The data includes the PO Type, PO Number, and PO Line Number.I first tried using <Line Number> (turning off the automatic <Line Number> = -1, of course).  If I use this, to get somewhat reliable results I have to subtract 1 from the line number in the GI.  But then when I hit a PO that has had a line deleted (I used one that had only one line, but it was Line 2 because the original Line 1 was deleted), I can’t select the line.If I use @@LineNbr, I can use the exact line from the GI.What I’m thinking (and this is probably one of those “Duh, didn’t you know that?” things)--<Line Number> references what line in the details grid to load.  The actual Line Number value on the line doesn’t matter--in my scenario above with the lone Line 2, if I set the <Line Number> val

We are currently using the DocuSign integration, however, we find the workflow and click requirements to be extremely tedious and excessive. We are using it to send out rental contracts (through the Sales Order screen and form) to be signed by our customers. The form we send to be signed changes very little between customers, yet we still have to manually edit every form being sent through DocuSign to place the signature lines and initial lines on the document. There is apparently no way to create a template? It takes as long, or longer in some cases, to prepare the DocuSign document than it does to prepare the Sales Order. It should take almost no clicks or time to prepare the document for signature. It should be, at most, a toggle button to say “Send DocuSign” or “Require Signature” or something along those lines. A copy of the “signed” document does NOT get attached to the Sales Order automatically and there is no way to track the DocuSign envelope status from within Acumatica. It a

Hello I am required to create a new customer location while creating the customer through Import Scenario.  I can see there is an action naming, ‘Add Location’ but it seems not working.  Can someone please let help me on this? Thank You!

Our bank offers a product from FIS (a common vendor for the banking industry) called Integrated Payables. We send them a file that contains a line with the recipient’s name, address, and optionally their routing and account number and a list of invoices we are paying.This tool simplifies payments by automatically converting to ACH, mailed paper check, or virtual credit card using the information they keep on file. This is basically an automated version of a consumer “Bill Pay” service that most banks offer.This tool expects to receive data in a CSV-like format, but unfortunately it is not a direct CSV export or NACHA file so I’m struggling on where to start with an export scenario. Additionally, I would like to avoid having a customization developed if there’s any way to do this natively or with an ISV soluition that already exists.There are 3 classifications of lines:Summary field that contains the information about the account we are paying FROM. This is largely static and always at

Hi, I am trying to import AP bills. The AP Bills are tied to a PO Receipt. As well as the vendor, I have the PO number & PO Receipt Line number. I am having an issue with trying to select the Add PO Receipt Line in the Scenario. The Document is being created but nothing else is happening.(If in migration mode, you cannot use the Add PO Receipt button) Does anyone have any solutions/ideas for getting this to work?Thank you in advance!Bill