Import and Export Scenarios

Hi.  I have a import AR Payment import scenario that has both Payments and Credit Memos.  I am able to import the Payments with no issues.  The credit memo present have an error.  See the screenshotAny suggestions would be helpful.I have attached XML as wellEvan  

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?  

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?

Dear All,I want to import AR & AP opening balance with details: Customer ID/ Vendor ID, Account, Sub Account, VAT Invoice, Date, Due Date, Debit, Credit, and Amount.Is there any import template in Acumatica that fix to this requirement?Thanks in advance!Yên Chi

Has anyone been able to export Attributes on a single line?  So one line per record.  I am only able to export attributes resulting in one per line attribute.  So if I have one record with 4 attributes I get 4 lines to export per record.  Thanks 

Hello All!We are attempting to migrate from Zoho to Acumatica, and it is easy to create export files from Zoho. But I cannot figure out how to create a proper “Import Scenario” to make it work. Can anyone help me figure this out?

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? 

Version: 2021R1Hello, as many of us experience, the commerce connector will only allow 1 customer class on import.  This functionality is limiting.  So I wanted to use other fields in the customer record to update the customer class (dynamically). So the intention would be: commerce connector imports customer from Shopify with Customer Class “K2TEST”. I build a GI that looks for all records with customer class “K2TEST” I create a data provider based on the Generic Inquiry noted above. I create an import scenario that uses the data provider noted above and has logic to look at an ATTRIBUTE on the customer record and map a new customer class “K2NEWCLASS” accordingly. I then schedule the import scenario to run from a Business Event or Schedule...making it AUTOMATED.This scenario works with EXCEL as the data provider, but obviously that takes manual intervention to process.  But switching to the GI gives me the following error:  1 items have not been processed successfully. View name: BAcc

Dear All,Is it possible to import excel file (Sales orders/ Shipment/ AR Invoice) by the Import Scenario function?Or there are any way to delete multiple?Thank you for your support,Yên Chi

Quick query, I have crested a very simple import scenario to bring in project transactions with the following fields which work when I enter these manually and release  Not sure why but when I prepare and then import I get an error “The Save Button is Disabled” Any ideas on what is wrong?  

Hi Everyone, I’m trying to figure out how to use an Import Scenario to modify the Sales Order Detail section. To be more specific, when we issue a warranty with a receipt line I would like to add a not to the issue lines saying, “Please include a return label”. Since this note will appear on the pick list our warehouse team will see it and can take action.Another way I thought of and would would be happy to resolve this is to use the import scenario to add a ‘return label’ non-stock line item. We could set this to $0.00 and as long as it is an ‘issue’ it should appear on the pick list. Below is what I have so far. The problem is I get this error when it tries to run, “The last error was IN Error: Unit conversion  is missing.” Looking forward to see what everyone has to say. 

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,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 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: 

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

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!

Hi , Please assist.I need to assemble kits automatically. I have setup a business event to trigger an import Scenario. The event runs without any errors but doesn't execute the actions. I have attached a screenshot of the scenario. 

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? 

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: 

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. 

When will the Fast track snapshots for 2021 R2 be available?

items have not been processed successfully. View name:Item We keep getting this error - but no error 2 weeks ago - why?

Recently updated to 2021 R2 and had Acumatica run the script to depreciate the previous Dummy Attribute requirement that we’d needed for managing single attribute matrix items. After upgrade and Dummy Attribute script removal, existing import scenario used to assign variant and variant value to individual stock items and connect them to correct template item produces a ‘View Name: Item’ error. Import Scenario Screen (IN-ReconnectMatrixItem)Pretty straight forward - Inventory ID, Template ID, Attribute1 and 2, Attribute Value 1 and 2.Import Scenario MappingThis was set up by our VAR, and has worked without issue until this release. Data Provider SchemeExcel Sheet used for ImportThe View Name: Item error doesn’t give much indication as to what might be wrong. Here is a trace from the error: Any ideas? Is there another way to do this? Generally we add Stock Items in bulk, and then assign them to Template Items as needed before syncing those template items up to our BigCommerce site. We do

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.