Import and Export Scenarios
Discussions Import and Export Scenatios
- 200 Topics
- 803 Replies
Requirement: We have an Import Scenario to import project transactions. The Sub Account value needs to be assigned from the default cost sub account set for each project. As part of the import source file, we have the project ID in the source file. Then for the that Project ID, I want the system to populate the sub-account from the default Cost Sub Account set on the project in Acumatica. Is this doable?
This is for the initial data migration. Sales Orders have been imported and Purchases order have been imported. I am having difficulty linking the SO to the PO with an import scenario. I see that on the import scenario for Sales Orders>Order Summary is the action <Link PO> . I haven’t been able to to properly use this action. I have tried adding the action <Select> and then save, but I am missing something.
I’m attempting to update all employees Default WCC Codes with an import but while building my import scenario, it doesn't give me an option as to which “Use Class Default Value” to uncheck or choose. On my attachment, the left side shows what I’m attempting to update and the right shows my import scenario thus far.. Any ideas?
Just to preface, I am self-teaching on Import Scenarios for the most part, and I don’t have a lot of experience with them yet. This is around the third Import Scenario I have built from scratch, and it has one complicated part I am really having trouble getting right. Now on to the problem:I have some Stock Items that I want to make default a certain vendor. The vendor is already on the Stock Items, I just want to use Import Scenarios to check the default box for that specific vendor. There are multiple vendors on these items, so I need the Import Scenario to choose the line that vendor is already on and check that lines box for the default. I have set it up a ton of different ways, and I can get it to check the box, but it always checks the box on the first vendor in the list. Alternatively, the way I have it set up at the moment is giving an error about adding a duplicate line. Screen shots below. If any other info would help just let me know. Stock Item Vendor List: I have cut the e
Hello,I need to use an import scenario to add contacts to existing vendors.I am only adding “LAST NAME” and “EMAIL ADDRESS” for each vendor contact.My import scenario into the Contacts screen works without error.However, only the last contact in my data provider is actually added into Acumatica.I believe this has to do with the lines at the beginning with the (-1) that Acumatica normally adds automatically when you create a new import scenario. It did not add those lines when I created this import scenario.Again, the import scenario says it processed all records and shows no errors. However, only the last contact shows in Acumatica.
Hi @vkumar, moving to a new thread. These are new SOs. 2 of the orders will have multiple items, other 2 will have 1 item. it looks like the ones with 1 items go through fine, the SO that are supposed to have 2 only go through with 1 item not both.attached is the import scenario again and a screenshot of the error.
What methods are you using to update the data attached to an import scenario data provider? I have a client that needs to repeat an import scenario to create requisitions. The data source is an Excel spreadsheet and will change quite often as they start purchasing material for a project. I also will have multiple users running the import scenario and I am trying to figure out how to avoid them stepping on or replacing each others information.
Hello Everyone,I was wondering if it is possible to call up an action to save an attribute to a stock item on an export scenario (rather than an import scenario). The idea is that I would run the export scenario, it would flag the attribute on the stock item and then export the stock items. Has anyone else tried this? I have not been able to get this to work thus far.This is what the top of my export scenario looks like:
I am having this error on Import for POs, trying my best but still error is there. I have a few “=iif([PO Line Status]='Canceled', TRUE, NULL)” that may be causing this issue, but according to me those are correct.Let me know if somebody have had this issue before, or maybe I need to open ticket.Thank you community.
Hello,I’m attempting to update pricing on existing stock items only. We have discrepancies in our Inventory IDs and instead of creating a bunch of duplicates the company only wants to update the stock items where a match is found. Is this possible using import scenarios? I’m having trouble finding documentation that supports this. Edit: Furthermore, I would love to be able to identify the records which are not found to be corrected. So maybe that is an alternative avenue. Thank you in advance
Dear All,I try to import fixed assets by using template FA303000 from Import by Scenario but the Accumulated Depreciation Field and Last Depr. Period on Balance Tab didn't show anything of the imported data.Screenshot of Import by Scenario:Screenshot of fixed asset: Thank you very much!
When you enter a new revision name on an existing BOM it would create a new revision under the same BOM ID and would copy all the details from the BOM and original revision.I am trying to do this through an import scenario so i can upload many new revisions under an existing BOM ID.So the way i set up the import was starting by @@BOM ID so it knows not to create a new BOM, rather look for the exisating BOM and i passed in a new Revision name.So it actually worked, it created a new revision under the existing BOM ID, but it didnt copy the BOM details, it created an empty BOM.Does anyone know what i need to add to my import to also copy the details?
We are on site at a large client who asked us to import their credit card profile ids for Repay. Repay has gone to great lengths to help and Zac has been tireless but we ultimately hit a wall.Our current scenario works perfectly for exactly 1 record. When we run the scenario, all the records are shown as imported successfully, but only the last one is actually saved. It almost seems like we need a pause to allow the Repay integration to catch up. Does such a command exist?
We had an import scenario that worked in an older version of Acumatica that was used to import large volumes of projects into the system and automatically create and activate the projects. In the older import scenario we used to force a “False” into the Hold field to trigger the activation.With the upgrade to 2021R1 and the addition of the Workflow Automation, the old import no longer works as the Hold button is gone.I have tried using both of the options below, but I get the same error on both of them.Target Object Field/Action Name Project Summary <Action: Activate Project> (Activate) Project Summary <Action: Activate Project> (Activate@Action) Error: Object reference no set to an instance of an object.If I deactivate the line in my import scenario, the projects are created just fine, but they are “in planning.” The error only comes when I try to activate them. I’ve also tried updating the status field directly in the import scenario but that does nothing.Wha
Hello Everyone,We have to exclude void payments in the batch payment screen export scenario. We have added source restriction but still void payment is included in the ACH file.How can we exclude void payment on the ACH export file? Can anyone suggest the approach?Thanks,
Hello Everyone,I am working on a SO Import and ideally I would like to have the least amount of lines possible on the sales order. For instance, let’s say my data provider has 8 lines for a cheeseburger, is it possible to combine those 8 lines into one?For instance combine the asparagus and cheeseburger lines into one:
I’m working on an Import Scenario that will update a sales order’s user-defined attribute.The simplified process will go as followed:Identify the order by Type and Number Open or Re-Open the order (QT requires the Re-Open) Set the attribute Return the order it starting stateSteps 3 and 4 need to be conditional and I haven’t found any documentation on how to do that. For instance, step 3 would need something like: IIf(=[Document.OrderType] = ‘QT’, <Action: Open Order> (OpenOrder), <Action: Re-Open Order> (ReopenOrder)As a work-a-round I am thinking about using Target Restrictions to limit the data to a single condition, i.e., QT and Completed or QT and Canceled. That way I can set the Mapping fields and change them each time to match the current conditon. I’m really trying to avoid this since it will be fairly manual.
Has anyone been successful in adding the Vendor.AcctReferenceNbr to the NACHA ACH export scenario? I have managed to add the addendum section to the export file but cannot get this field to populate. Below is my current configuration in the export scenario.
Hello everyone,I am trying to create an import scenario to bring in a sales order and create a prepayment on that sales order. I am able to bring in the SO just fine however the prepayment does not seem to be working. Has anyone been able to import with this button?The error that I get is: Here is how I have my import lined up:
I am working on the ACH Payment export and keep getting a few errors. From what I can tell, this is probably because the default export scenario uses some older table names. I went through and fixed a few that I saw but the others I am not sure how to correct since the fields aren’t available in the internal fields list. Below are some of the main errors I am seeing. Does anyone have any thoughts?
Good day team, I have a import scenario that is working correctly, but it will give the error “4 items have not been processed successfully. View name: Document.” after the first record is imported sucesfully (I am testing with 5 Sales Order to import). On the Trace is giving the error “Failed to find record in TaxZoneZip for the given zip code: 43537” but if I add the Tax Category code for No Tax it will error out and not give any information. Part1 I hope maybe somebody can help me with this issue, as I see nothing wrong, and the testing with the Tax Category only made things worst.Note: If I import the scenario 5 times it will complete sucessfully, as it only does one line per import process, not the five. Thank you.
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.