Import and Export Scenarios

Hey everyone!I have an issue with an Export Scenario. I am trying to Export Sales Orders to Salesforce, and it’s so close to working but I am still struggling with the the Details of the Order.  I currently have a Source Restrction to limit the export to just one order while I’m testing. This one order, has six products on the details. When I Prepare the export however, Acumatica is showing a row for each Detail row. On this order with six products, I can see six prepared rows. The issue is that Salesforce is thinking I’m trying to update just that field, and it’s only displaying the details for the very last row (the last one sent to SFDC)Is there anyway to concatenate all the all the details on one row for export?Attached is my Scenario. I’d really appreciate any help with this, I’ve been stuck on this a few weeks.  One order, six rows. One for each Detail Row. 

Hi,I need help understanding how to setup the following scenario and if it’s possible.Our company had an import scenario setup to generate a BOM from an excel file.  This excel file was supplied already filtered for a specific order.To facilitate automatic imports, we are looking to utilize a SQL Data Provider.  We can successfully access the View in the SQL database and import the BOM.  However the view contains all orders from an external system and not the filtered data found in the excel file.  Is it possible to create an SQL import scenario where it connects to a SQL View but filters the data based on a dynamic parameter? For example, let’s say we have 4 orders and want to utilize import scenarios.  Is it possible to accomplish the following from the one BOM Import Scenario?Order #1 → BOM Import Scenario - SQL → Filter SQL View by Order 1Order #2 → BOM Import Scenario - SQL → Filter SQL View by Order 2Order #3 → BOM Import Scenario - SQL → Filter SQL View by Order 3Order #4 → BOM

Hello,I am trying to take a little bit of a shortcut here to see if anyone has had success or could refer me to how they made a workaround to run import scenarios in sequence. For instance- new BOM/item- I have a multi-tab spreadsheet- first tab is the mfg item, second is the components, and the third is the bom itself. Right now you must run them separately.I figure between business events and perhaps customization that there has to be a way to do this with relatively low effort. Rather than reinventing the wheel, seeing if I can get some ideas. 

I have a need to update all of my inventory and customers for the incoming integration of Avalara. I can do this either via an Import Scenario or using the General Inquiry feature Update All.What are the advantages / disadvantages of doing one over the other?Import Scenario may have better error reporting for any that may fail.Generic Inquiry: Update All advantage would be a much quicker and easier solution, not having to build the import scenarios or export all of the needed data to use with the import scenario.Currently using Acumatica 2022 R2, for reference.

Experimenting with importing BOM Steps but unable to get anything to populate. Not sure what I’m doing wrong.Just trying to populate a single line in Steps like this, after I’ve added the material (or before - but within same scenario): 

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