Import and Export Scenarios

The following import scenario stops after successfully importing one record. I would appreciate any help troubleshooting. 

Hello all,I have been trying to import some data using the following mapping:  But when i try to import it displays the following error: Log trace: 

Hello Commuity,I have been trying to export Gl transactions but not been able to. below is the mapping for the same:When I run the Export by Scenario, none of the records are prepared to be exported. What is it that I am doing incorrect?Thanks in advance.

Working an import scenario for BOM details which include both header BOM information and materials on the BOM within the same Excel. The Excel file is set up which row type 0 including header information and row type 4-8 including the materials on the BOM.   How do I set up the import scenario so I populate the header level information (for example the BOM description) based on information sitting within the row for TYP = 0.  I’ve tried some IF statements but not achieving what I need.

I’m using the default out-of-the-box AP bills import scenario. When I try to import more than 1 record, the first record imports successfully, but the next one fails with this error:If i import 1 at a time, it works. I have the key fields mapped.I have attached the import scenario. What change needs to be made to import more than 1 at a time? Thank you in advance for your help!

Hello. I am importing some stock items to the Acumatica sandbox, and I get the error code "Item." I double-checked everything, and nothing looks wrong with the mapping and import. Below is a screenshot of mapping and import: Could you please tell me what is wrong here?ImportMapping  

After we upgrade the acumatica form 2022 to 2023 r1 we encounter this problem, A lot of order from Bigcommerce are not flowing in Acumatica because of the error “The system failed to commit the Taxes row.”  

Is it possible to have a flag in the import file, to change the Activation status on file import? Lets say I have a master spreadsheet of Employees (or users) and everytime before importing it I would select which ones are Active and which ones are not. In this case I wont need to manipulate the data on the Import scenario screen. Thanks.  

Hi All , Do any one have ACH Export Scenario for Balanced File with Flat File Specs Similar to EDI / Can guide on  how to create Export File Format with Flat File Specs for ACH ?

I have created an import scenario to create employee time activities for an excel spreadsheet.  The spreadsheet contains the employee ID, the from and until weeks for the header (this is contained on each line, so the detail knows which employee and week the record should be created under) and then the date, project, project task, labor item, hours,  and description for the activity itself.  When trying to import multiple records, it only creates one activity and errors on the others, or it doesn’t create the activity, but doesn’t error.  If you go one by one and activate and import one line at a time it correctly creates all the activities.  What am I missing to allow all the lines to get created with one import as opposed to importing each line separately? 

When creating an import scenario in our expense claims, 3 out of 27 employees are not being recognized and it is saying, “Error: ‘Claimed By’ cannot be found in the system.”However, there is nothing different with these employees that we can see (2 are senior management in the same department and workgroup, but 1 is a front-line hourly employee in a category where the other 3 similar employees are fine) but we’re new enough to Acumatica that this is really confusing us. Any suggestions of what to look for? 

Seeking an example for adding multiple Packages to a shipment with each Package having multiple items o 

Im trying to import a range of Replenishment settings to Item Warehouse Details and I keep getting the below error with no other information. Ive tried lots of variations but cant seem to get this import to work?  

Hi All,We have created an import scenario for stock items—finished goods. But the style tag and the item class are not picking up correctly. The subaccount is taken as the style tag.Please see the below screen shots. Anyone know how to fix this?    Thank you!

I’m trying to build an import scenario to edit the promise date on the inventory line on a Purchase order. However, it’s not changing based on the import I built.  Attached is an XML of the import scenario.

Is there a way to configure a process for the ECO Commit Changes to BOM action? The action can be called from a Generic Inquiry or as an import scenario action.  However, because this action launches the Bill of Material screen, the import scenario doesn’t work.  Similarly, the GI action launches the BOM, but requires the user to click ‘Save’. Ideas?

Hi,We have created an import scenario to copy a BOM but have two issues:Updating the description field updates the description on the current BOM - not on the newly created BOM The scenario successfully processes one record but returns an error on the next record.Any thoughts or suggestions on how to get around these two issues would be greatly appreciated!Laura

Hi,I am trying to add a line item to an existing sales order and although the import scenario seems to process without errors, the line is not added to the sales order. What needs to be added for a line to be added to the end on the sales order?  Thank you!

Created Journal Transaction Import, with the following data: Not all the transactions got the error, only a few, i have recreated the transaction on the journal transaction screen and journal transaction was on balance with no issues. Also, i have removed the Module, added, and check for the Commit on several of the selections, but cant import all of the transactinos, only some worked. Do you see anything wrong with my import scenario? Thank you so much in advance. 

Hello Team, Is there have any possible way to change the location of file storage in acumatica?Reason is day by day database size is going bigger as I can see in database mostly file storage is occupied so for reduce this i want some solution to fix the issue.  Thanks and RegardsRushabh Shah

Is it possible to use the preferred Vendor ID and the Vendor Inventory ID as an identifier in an import scenario? For example, if we receive a file from a vendor with new item pricing, but the file uses the vendors inventory ID (which we record in the Vendor Inventory ID field of the VENDORS tab in the Stock Item), is it possible to create an import scenario to find the corresponding stock item and update the pricing based on the Vendor ID/Vendor Inventory ID?

Good day,I am struggling to update few over 1800 open sales that have the wrong unit price.   I am able to get the sales order to update however, it ADDs the two items rather than updating the existing inventory itemsIt is probably a simple changes to my import scenario.  I have already struggled for a couple of hours now.Any assistance would be greatly appreciate; these orders are going out shortly.@Evan G  

Hi - I recreated an import from my test environment and though it worked in Test, it is not working in Production and I am getting the below error message:The import created is below:  

I have a simple import scenario that I am using as a test that is being used to populate customer contact records. In the import scenario I am using the =PadLeft([PostalCode],5,’0’) to pad out any of postal codes that have a leading zero so that they will pass validation. When I run the import scenario it looks like the code isn’t even running. I am not sure if I am doing something wrong or if I am missing a small detail that is preventing the code from running. The code passes the validation test so I don’t think it is a syntax issue. I have attached the data provider, the excel spreadsheet and the import scenario. Any help would be greatly appreciated.

We are setting up an import scenario to create customer invoices with multiple invoice lines. The lines are mapped to a data provider. We want to add an additional “static” line on top of this with hardcoded value. When I try to import it, the static line just overrides the first line from my data provider. Any ideas on how to achieve this?