Import and Export Scenarios

I’m trying to add existing contacts to customers, my initial scenario created the contacts but didn’t assign them in the customer screen. I’m getting an error that lastname is required so it looks like the scenario is trying to create a new contact rather than add an existing one. Any advise please? 

This might be a long shot, but I am trying to create an Import Scenario to mass update stock items with Quality Control Plans. Which is part of the QMS Module.  I keep getting an error message because the system says it needs a Test or else it can’t save. When manually adding a Plan to a stock item, once the plan is selected, all tests are added as well, automatically.  It seems, either that automation does not exist when using an import scenario, or the system is trying to validate before that test loads and throws up the error.  So I added more steps to manually add the Test right after adding the Plan. But I get an even bigger error: Error: 'Item Class' cannot be empty. Error: 'Tax Category' cannot be empty. Error: 'Base Unit' cannot be empty. Error: 'Sales Unit' cannot be empty. Error: 'Purchase Unit' cannot be empty. Error: 'Posting Class' cannot be empty. Error: 'Lot/Serial Class' cannot be empty. Chat GPT says that this error means the system is trying to add a New Stock Item at

Is there a way to upload a bunch of old emails into Acumatica all at once? We have a bunch of old emails we would like logged in Acumatica, but we don’t see an option to upload them all at once.

Trying to preform a lookup in an import scenario and have it update the line that matches the SoftwareID on the BAccount. BUT instead of it creating a new line if the lookup doesn’t generate a match, I want it to do nothing and skip it. How does one bypass this functionality of it creating the new line?   

Has anyone found a way to use one of the 4 out-of-the-box Synchronization Type settings (FTP, HTTP, Shared Folder, or SFTP) to sync a file with Office 365 OneDrive? 

I trying to set up a business event to create a Purchase Order (for the return item) on Sales Orders using a business event and import scenario. Within the actions available, I see SO creation, email creation, Receipt creation, but no Purchase Order creation. Is this possible to do, or is there a different way to go about this?

One of our clients is in the process of automating their ACH batches to auto-sync to the bank’s SFTP site.I have the file sync settings saved in the data provider, but it isn’t being added as new ACH batches are generated. Is there an automated way to do this without customization and/or a business event/import scenario?I’ve attached both the export scenario and data provider for reference. Thank you in advance!

Please help me figure this out.I’m creating multiple variants across multiple templates, and I want to do it using import scenarios. I already created Template Item via import scenarios. Right now using that list template item, I want to create each of the a variant using import scenarios. First I want to check this two columnsThen Hit the create matrix item and confirmed.  Thank you . 

We are trying to do some data clean up and re-order how we build accounts/locations.We had a bunch of child accounts that we consolidated under the parent account as locations.  However, we have found a major productivity hit on updating the sales persons or other data in that Customer screen now.We have one customer that has ~1500 locations and our instance handles it fine.  This latest customer we cleaned up has almost 8000 locations and they imported by scenario into the Location field fine, but the import by scenario for the salespersons will not run through even a partial list.Before we break the customer up by state, are there any suggestions?  Max limits?

Hi Everyone,I need your help with something. Has anyone here worked on the AR Batch Payments Export scenario before? If so, could you please share the Export Scenario file or any related details that might help me set it up?I’d really appreciate your assistance.Thanks in advance!

Hi All,I am trying to build an import scenario that will create external user login (Guest accounts) for all of the contacts for each customer record.  I have a user type “unrestricted external user” and it has a linked entity to the contact record.I have created my EXCEL/CSV data provider with the Account ID, associated contacts with their email address, and the contact id (I attached some sample data that I scrubbed with fake data).When I try to execute it, I get an error...4 items have not been processed successfully. View name: UserList.I really have no clue on how to do this lol. Can anyone help me?  I have about 1500 accounts to make in just a couple of days and am totally stuck.Thank you!  

I need to have an import scenario that records the payment and applies the payment to the related invoice or invoices.  I started using the one included but I am getting the error:The system failed to commit the adjustment rows.Here is a screenshot of the application section of my import. Any help would be appreciated.Thanks...coleen

I am trying to import a SO with multiple lines. Currently the SO is being created with the multiple lines. However, if I have more than 1 SO on the CSV file to import, the import puts all the lines on one SO instead of each SO having their own lines. There was a suggestion to use 1,2,3 to enable the import to create individual SOs with the lines for each, However, I am doing that, but all the lines are still being created on one SO. See the attached Import Scenario and CSV file. What do I need to change to fix this issue? 

Good day,I could use some assistance with the review the attached Import Scenario; it worked before we upgraded to 2022R1.  The scenario creates the sale order.  However it creates only one order with all the items in it rather than create a separate order.  The file has 55 orders.  When I tested it created one big order.  I can figure out what changed after we upgraded.Have a nice day.@Evan G 

One of the import scenarios that we run has been producing a “divide by 0” error for some, but not all, of the processed lines. I’m not a 100% sure, but I believe the formula is the thing causing the issue. However, I don’t see any division equations in the formula. Could there be something else causing this issue? The equation: “=IIf( [POReceiptLine.PONbr]=Null, Concat(CStr(Left( [POReceiptLine.VendorID_Segment1],7 )),'-',CStr([POReceiptLine.ReceiptNbr]),'-',CStr([POReceiptLine.LotSerialNbr])), Concat(CStr(Left( [POReceiptLine.VendorID_Segment1],7 )),'-',CStr([POReceiptLine.PONbr]),'-',CStr([POReceiptLine.LotSerialNbr])) )” The Import Scenario.   

We are trying to get product images to display on the mobile app (Warehouse Management > Item Lookup) in 25R2 but have not been successful. It is not working like it did in 25R1. In 25R1, if you upload an image to the Files area, it will show up on the Attributes tab, and it will display on the mobile app. In the Item Lookup, if you click the paperclip icon, you will see a thumbnail (and you can load a larger image if necessary).This same behavior is not working in 25R2. Acumatica moved the image upload from the Attributes tab to the Description tab as discussed here: Apparently, this change has caused the image display issue on the mobile app.Furthermore, we have not been able to capture images using the camera on a mobile device. We have tried both iPhone and Google Pixel. In multiple tests, we were not able to upload images to a stock item via the Item Lookup utility. We can take a picture and upload it, but it results in the error: “Error uploading file.” Again this works fine i

HI,I am trying to approve the document sales order. I have added my self in approval map. But still it says you are not authorized to approve. Can anyone guide me please which permissions I am missing? I am system admin too. i want to approve it using import scenario after this error resolved.

I am fairly new to import scenarios, at least in building them from scratch. I am importing Equipment records.  I can select multiple records to import and it will show successful with no errors, but will only import the last record on the list. I am probably missing something simple. We are on 25R1.101 below is my import scenario 

Hi everyone,I’m trying to update the Shipping Rule field (ShipComplete) for each Sales Order line (SOLine) in Acumatica.Here’s what I’ve tried so far: Mass Update through Generic Inquiry: I created a GI including the ShipComplete field and enabled Mass Update. However, the update doesn’t seem to apply to the records. Import Scenario: I created an import scenario mapped to the Sales Orders (SO301000) screen. When I use LineNbr = -1 (Deactivated), it only updates the first line of the sales order. If I activate LineNbr, It is giving error as Unit Conversion is missing. My goal is to update the Shipping Rule for each SOLine (e.g., set “Back Order Allowed”) without manually editing each order.Has anyone successfully updated line-level fields in SOLine via Import Scenario or found a working approach?Do I need to use a different matching field or configuration to get each line updated correctly?Any guidance or examples would be greatly appreciated!Thanks, 

Good day,I know it is probably something simple.  I am reusing the ACU AP import scenarios.  The error is the Document Out of Balance.  It is not.  I have used this before but this issue is new to me.  Attached is the XML.  Is there a new Balance Check box that needs to be unchecked?  The more try things the more confused I get.Any suggestions.  Thank you.  @grillevan 

Hi All,Here is my superficially simple question. For an import scenario that I have with the Item Warehouse Details screen, IN204500, I am getting this error: Field: Default Issue From, Value: M      , Error: 'Default Issue From' cannot be found in the system. Can you modify my import scenario so that it does not throw an error and properly loads a record to the item warehouse details screen? Our warehouse locations have 4 segments (1 char, 2 char, 2 char, 2 char)Here is a screenshot of the import scenario:     I have attached the import scenario as well.

Hi Team, I’m trying to update multiple Vendor IDs in Acumatica 25R1 using an Import Scenario. The Import Scenario itself runs fine when tested manually, but I cannot get it to work in bulk. My main challenge is that the Generic Inquiry I created is not showing up as a source in the Import Scenario. Since the Vendor screen works off the Vendor DAC, I expected the GI to be selectable, but it remains unavailable. I also noticed that Import Scenario as a subscriber in Business Events is disabled for the Vendor screen. Has anyone found a working method to bulk update Vendor IDs or use a GI as a data source for this in 25R1?  

Good day,I know something is wrong with my Business event/export scenario.  The processing schedule works.  I get an email with a file attachment.  The issue it is first fille; the original data.  However, on subsequent run, i get the same file not an updated exported file..  I am not getting new file with updated rows.  The export is being processed on schedule and the results are updated.  The email is being sent on schedule; email received.  The only issue the file is old.  How do get the new file attached?  I added this to my business event this morning.  Who knows if this work?Everything works except the export file is old; the same file sent during testing.Any ideas, assistance would be much appreciated.Evan 

Has anyone added address validation to a sales order import scenario?Out client overrides Ship To Address on a majority of their sales orders (by choice) but we would like to build in address validation as part of the import (if no address modification needed the order comes in and ship to address marked as validated, if address modification is needed then we want to fail the order import) Thank you,Greg

On the “Bill of Material” screen, I am looking to mass import by operation ID/work center, along with all the corresponding steps so I don’t have to manually enter the same instructions on each BOMID.