Import and Export Scenarios

Hello,I am attempting to load BOMs.  All works well unless there are multiple materials on an operation.  Then it throws an error on the additional materials in the operation.  I am working with a VERY short data set to get this working but cannot move past this.  I started with the standard BOM import scenario. 

I am attempting to import a list of new contacts from an excel sheet yet when I run the import despite the import showing as Successful none of the contacts “processed” in the import show up in the All contacts GI. Is there something wrong with How I have this Mapped?  

When doing an Import Scenario creating Contacts is there a way to make sure it does not create Duplicates if the Contact already exists?

Trying to make a Import Scenario that deletes old, outdated Sales orders.  When I run the Import, i get the following message:What is a View Name: Document error?  I’m assuming it is something tired to the refernce for the Key item Order.Type and Order.Nbr, but not sure what the fix is.Also, is there any good training out there on Import Scenarios?

Hi,I am trying to set up an automation where, once a day, all opportunities with their stage set to Won will automatically have the Close As Won button triggered to change the status to Won and close it off.I am testing this in an Import Scenario and I received the following error. I have pasted the error at the bottom so it can be copied if needed.Is there a way to resolve this error? Let me know if you need any other information.Kind regards,Andrew   The document cannot be saved because the OpportunityAddressID (Opportunity Address) field in the database record that corresponds to this document is corrupted. Please try to save the document again. In case the issue remains, contact your Acumatica support provider for the assistance.

I’m trying to import around 20 to 50 items with different weights and lot codes into a Purchase Receipt. I seem to be blocked at the Lot Code Splits. I have included a screenshot of my Import Scenarios and my XML file. Am I able to adjust my Import Scenarios to include Line Splits for lot codes? 

Hi everyone, I’m attempting an import scenario to complete all tasks on a list of projects using the button below. This needed because we need to clean up old data and complete the tasks without having a list of all tasks.   I created the scenario shown below (XML attached), which seems like it should work.  But I get the error below:  Thoughts anyone? Thanks in advance. 

I am looking to create an Import Scenario that will import Users and assign them multiple roles. A user on the template may be assigned 1 role or 8 roles. I need all associated roles imported without using User Types since most users will have different roles assigned. How can I import users and have them assign multiple roles? I am able to import them and have it assign 1 role, but more than 1 it doesn’t assign any. User Import Scenario 

I am having an issue where only the first line or second line of my import scenario is attaching to my case and not both.   

I’ve imported various Excel spreadsheets of data (Customers, Vendors, Inventory Items etc.) but am having an issue when trying to import some finished goods. I can’t see anything obviously wrong with the import but I keep getting the error below. Any ideas on what could be causing this? 

Hi everyone, I feel like this probably has an easy answer but I cannot find it anywhere. I have looked through the screens and the help files. Our customer is importing GL transactions through the GL file. This last one they sent failed. We realized it is because, on the import file, the transactions are not ordered by the transaction ID anymore. When the import scenario goes to import, it fails because it is only seeing part of the transaction (since the other part is farther down in the file). Is there any way to set in the import scenario that when the file is prepared, it rearranges the order of lines by the transaction ID number assigned to it?

I’m trying to make certain acvtivities billable in the Employee Time Acvtivites screen.My import scenario is throwing the error that the employee is not found.   Any advice would be welcome

Hey everybody,Is there a possibility to import the description of stock items via Excel with line breaks? It seems that the import scenario doesn’t take the line breaks from excel into account… Any help is greatly appreciated! :) 

Has anyone used One Drive to store their Acumatica Attachments / Uploads / Images?If not, which one are you using? 

Hi All, I am attempting to do an import that I know I have done before, but is not working currently! I have an existing open Sales Order (Status  = Open). On that order I want to populate the owner field. The keys being the order type and order number. I also added customer as I have had experiences in the past where for some reason, it throws an error is not there. Anyone have any thoughts?! Starting to go a little insane looking at it!  

Hi,We have a client who is using an external software for their Scale solution. Each day, they upload a file through an import scenario to upload the individual invoices through the Sales Order screen as we need to keep the same document ID when creating the invoice in Acumatica. I’ve create attributes within the SO header section to keep track of important information and we need to have those attribute to transfer over to the invoice document. During our test phase, I did create a Generic Inquiry to pull the Invoice ID and the attributes and a Business Event to do an import scenario to import the attribute values when the Sales Order have been invoiced. The business event was working without issues. Now that we have gone Live with Acumatica, the attributes are not importing in the Invoice document because the business event is giving the following error. “The last error was CustomerID cannot be blank.”. The weird part is, it will work when I execute each record individually within th

I am trying to use an import scenario to update the Project Cost Budget > Auto Complete check box to be =’TRUE’  It keeps erroring saying Project Task cannot be found in the system.  But they are all there.  I suspect there’s something wrong with my scenario but can’t figure it out.   

Our trucks don’t want to wait while we pull goods from our bins, so we pre-stage the loads on our shipping dock. Pick, Pack, and Ship allows us to move the goods for a shipment, but we pre-stage before the shipment is generated. How would we go about this with quantity/item validations like we have in Pick, Pack, and Ship? Ideally this would take in a sales order number, then we could choose the bins and transfer the goods. RIght now we’re using Scan & Transfer, but there is nothing guaranteeing that the team picked all the itmes or the correct qty of items for pre-staging. We only catch this at Shipment generation when we notice an item is missing or is shorted. Thanks! Edit: Wrong sub-forum, no idea how to move this, sorry.

 My simple, first Import by Scenario import fails but there is no error message.  I’m not sure where to look. Where do I look? Thanks, Tom

Hi all. I am currently working on a scenario to remove a specific product from the Related Items tab. Although I have developed a method that successfully deletes a line, it unfortunately only removes the top line and does not allow for specification based on the Inventory ID. The product in question is associated with multiple products and appears on various lines within these entries. Any help on this would be appreciated. Thanks 

Is it possible to delete irrelevant UoM conversions at the stock item level? Some of our stock items have a huge list of possible UoMs that are not relevant to that particular stock item.Thanks! 

I see that there are a couple of topics out there for importing activities to various record types.I’ve tried to follow the examples given, but I’m still running into an error. Along with the activity, I want to include the related document (which is an opportunity in this situation).This is the error that I’m getting:  This is my import scenario (I’ll attach the xml at the bottom):  Any help is appreciated!

I am looking to see if it is possible to create an excel export for ACH batch payments and get it to export an excel file instead an txt file. Thank you.   

Hello!I want to create a journal transaction by using the import scenarios of business event. To this I use a Generic Inquiry. Generic Inquiry only provides information about the credit entry, and the information for debit entry is fixed.  I tried to get the journal transaction created in different ways but it only create debit leg of the transaction. Then I thought to go with the journal vouchers, but the issue is the credit and debit entries should go for two different branches and journal vouchers does not facilitate that. Can someone help me with this?Best Regards Amanda 

Hello all,I recently import a change in the names of the Inventory IDs. So the thing is I have 2 Items(3026) with same IDs but in different classes (A & B).1. 3026 - Class A2. 3026 - Class BAnd I had to import the change in the Inventory IDs (eg: S3026) for Class B which was imported perfectly fine, validated on the Stock items screen.But when I saw the PO created for both these items, the PO is now showing the change in the IDs for Item belonging from Class A too. How can I now resolve this?