Import and Export Scenarios

Setting up import scenario similar to out of the box ACU Import BOM. But I can’t seem to add the Operation ID → Operation ID line without it adding the <Key: OperationCD> field. I need the <Line Number> = -1 field, same as ACU Import BOM. What am I doing wrong here? I want to add lines for these operations, not key on them to add materials. ACU Import BOM - Out of the Box Me - unable to add Operation ID line without the Key line above. 

Hi There,I accidently uploaded opening prepayment to a wrong company under migration mode. I tried to void the wrong prepayment item by voiding the payment. However, It was voided under wrong date. So I have the open prepayment item sitting in my open AR aging report. Could you advice I can I delete the wrong open prepayment from the system? Thank you.  

Are you able to set up push notifications on failed/errors during Import Scenarios? We are looking to automatically import BOMs through an import scenario but need a way of identifying and tracking errors that occur. 

We are importing material directly into BOMs through an import scenario - with only 1 operation. The operation is backflush OFF by default.There are certain items that we are importing that we would like to get marked as Backflush ON during the import. There are attributes on these items indicating whether they should be Backflush ON or OFF.Is there any way during the import scenario that the line can reference the attribute within the inventory item to say something like Backfush → IIF(InventoryID.AttributeBACKFLUSH=True, True, False).Don’t seem to be able to look at the data within the inventory item that I’m adding to use in my IIF condition above.  

Working on import scenario that will mark lines as Backflush On within the BOM. In the BOM material, we have certain SKUs that will show up multiple times - the import scenario seems to deal with this by only updating the first occurrence. How can I modify this import scenario so that it updates each line?   

We have a BOM export that comes in this format - which we are looking to import:As you can see, the column header information starts on row 4. Can we design the data provider/import scenario to read the fourth row as the header information? Also, will the total row break the import?

I’m trying to do an Import Scenario to my INLIGHTIND Attribute which is Multi-Select Combo where I select multiple values. Below is what I have going. I tried importing as a comma separated list, but it didn’t recognize it and I added the values to different lines, but it just overwrote the first one and took the second. Ideally I can use the Value Description rather than the Value ID too. Any ideas? 

I am doing a BOM import of an Excel file which has each SKU as an individual row representing quantity of 1 (if there are 50 of item x needed, it is represented by 50 rows of item x). On the BOM, it gets reflected the same way - 50 lines with a quantity of 1. Is there a way to group these by inventory ID in the import scenario for the BOM? So it would instead show 1 line for quantity of 50? 

Here I’m trying to import the Qty as Negative value but while uploading through normal import scenario it is working fine but while uploading through business event and GI it is not working fine.  

I am trying to create an import scenario to import the Employee History line.  So that we do not have to hand enter the base data.I already created an Import Scenario to import and update the EPPositions table data.All I want to do now, is create an Import Scenario to import the “IsActive”, “PositionID”, and “StartDate” in the attached spreadsheet to the existing employee record under the Employee History tab.I am struggling creating the data provider and import scenario as it throws errors saying so many other columns need to be in the scenario, even though I do not want to update them.  (2nd spreadsheet attached show the errors on import)Does anyone have an Import Scenario for updating the Employee History that they would mind sharing as a template?Thank you!   

Importing production orders.Production Order total QTY = 10Op 10 has 4 completeOp 20 had 4 completeOp 30 has 0 completeThese fields are available as options in the import scenario.However, they have no effect when I put values in them.This makes sense since you cannot edit these values via the standard interface on Production Order Details.  However, since they are available for selection in the import scenario, I wanted to verify that I am not missing something.  Can these values be set with an import scenario? Thanks! 

Hey, I'm reaching out for guidance on creating an import file for Acumatica that encompasses both single products and variant products (similar to Parent/Child relationships in other platforms). My task involves migrating a comprehensive product catalog, which includes a mix of standard products as well as those with multiple variants. While I have experience with other e-commerce platforms like Shopify, which use specific fields for variants (such as Option 1 Title and Option 1 Value), I am new to the structure and nuances of Acumatica's import scenarios. I understand that Acumatica may handle product variants differently, and I'm aiming to grasp these differences to ensure a smooth data migration. I’m actually just looking for a Sample data file while other ecommerce platforms have them I’m finding it hard to find one for Acumatica.Additionally, if there are any specific considerations or common pitfalls to be aware of when setting up these import files in Acumatica, I would be grate

Hello all,I have abeen working on an export scenario and I have a condition that it should only export those records that have ‘AB’ as a prefix added in the batch number. How can I put up this condition? 

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?