Import and Export Scenarios

Hi community,I’ve added a custom data type for text files to the data provider in Acumatica. I’m looking for any insights or guidance on how the system reads text files in this context. If anyone has experience or can point me in the right direction, it would be much appreciated.

I had import AR to Import by scenario, but it has notification That “Customer ID Can't empty “ . Please give advice and Thanks so much.     

I have a list of BoMs and their revisions that I would like to archive. Seems PRETTY straight forward but I keep getting a “Document” error during my import. Error: 241 items have not been processed successfully. View name: Documents.

I am working on an import scenario to create new customers. The site has multi base currency and two branches AU and US. I’m feeding the Restrict visibility to field in the import scenario yet getting this error.    

This Import Template has been used before but i can’t figure out what it is blanking out the Product Manager field on the stock item record rather that copying over it.  my goal is to mass update this field    Below is the Import Scenario.   My Import Template has the three field required and i am getting no errors.  it just blanks out the Product Manager rather than putting in the new value.  Note: I added Description to the template because is kept asking for it even though it is not in the scenario.  

I am trying to make an import scenario to update posted cash transactions to show them as cleared with a cleared date from a file. I see where screen CA.30.30.00 allows me to manually do this process. However, I can’t make an import scenario to accomplish this. Has anyone had any success with this? Ideally we will receive a file from our bank nightly. This will run an automatic file sync and import scenario to update these records daily. So far I haven’t been able to accomplish doing any updates during an import scenario I've tested for CA.30.30.00. Any help would be greatly appreciated. I’ve attached one example of what I'm going to update for testing.If this isn’t possible, how else are people importing the cleared data automatically?  

Hello! I am trying to get my user defined fields (attributes) on business accounts to copy over to the opportunity when an opportunity is created. Any ideas on how to make this happen? Thanks in advance :)

Hello Community,I am working on a customization in Acumatica where I need to implement a new data type in Acumatica Data Provider for text files (.txt).Does anyone have experience with this or an idea of the approach? Any guidance, or documentation references would be greatly appreciated.Thank you!

We need to remove the Default Issue From location from 18,000 SKUs. I have set up an import scenario but I can’t get it to remove the value that is currently there. Here is the import scenario:When I run the scenario, it says Processed but the prior location remains. Can anyone advise?  

Hi all,Currently, my company has two branches. Previously, we had only one. My import scenario mapping is working, but after that, it continues to show an error. I checked all the branch settings in both the Customer and Customer Class, but the error still exists.My provider is a Generic Inquiry that pulls data from the Request screen (RQ301000).Pls advise me if you have any idea. Thanks in advanced.

I am trying to set up and activate customer contracts via import scenario using the import scenario below but I’m getting an error. What is missing?The contracts have already been created and I’m just trying to run the set up and activate process. 

I am trying to uncheck boxes on Item Warehouse Details that had previously been set to allow for Reorder Point input - now client wants override removed  But 0  I cannot get import scenario to remove the check - import runs with no error - but does not remove check 

Hi. I have an import scenario (attached XML) for opportunities that is tested and working perfectly for individual records. When I go to do the full import from Excel (1171 records), it only imports the first one, even if there is no error. In other words, it will import one correctly, finish running the full import (takes like 15 minutes), then says 1170 records did not import.Can anyone tell me what I am doing wrong? 

Hi Experts,I'm currently working on an import scenario where I need to select multiple order lines using the Add PO Line action on the Purchase Receipts Screen.I came across the following forum post which addresses a similar issue:[Import Scenario - Purchase Receipts - ADD PO LINE button not adding PO Line 2](Forum link)However, the solution provided seems to work only for single transaction orders. When dealing with multiple line orders, it fails to function correctly. Could someone please assist me in resolving this issue?Any assistance on this matter would be greatly appreciated.Thank you.

I am currently checking if the receipts related to a purchase order are being imported correctly using the screenshot scenario that I have also linked.However, although the receipts are being created through the scenario, they are not linked to the purchase order. Some help please :) !Thank you in advance.

I need to export inventory planning settings for stock items within a specific warehouse. I thought I was going to be able to use the stock item page but “Days of Supply” and “Inventory ID” were the only fields populated.I then attempted to export the information via the Item Warehouse Details page but was continuing to get the following error “Insufficient stack to continue executing the program safely. This can happen from having too many functions on the call stack or function on the stack using too much stack space.”I’m looking to export Inventory ID, Safety Stock, Reorder Point, Min Order Qty, Max Order Qty, Lot Size, and Days of Supply

Is there a way to include the record note when Export to Excel? 

I’m needing to update the Export to External System checkbox on inventory from TRUE to FALSE but not having much success. I have my import scenario set:When I attempt to process the import, it just throws off an error message:Not sure if I’m missing something or I have the import scenario set incorrectly. Any assistance would be appreciated.

Hello all. I am using an import scenario tied to a Business event to update Project tasks. If task A gets completed, tasks B,C and D get completed as well.  This works great except not all Projects have task B,C and D. If I run it and a task is not there it errors our.  Is there a way to suppress the error and continue? Is there a way to see if the tasks exists first and if not skip?I unchecked the “Break on” Check boxes but it still does not work.My rules for task completion are long, and creating filter/rule and scenario for each possible combination would be almost impossible. Thank you all  

Hello all,I thought it will be beneficial to share the below yesterday drove me crazy. We have configured the Inventory Code to be 20 unicode character. We imported the stock items without any issues. When we tried to import our opening inventory we started receiving some wierd errors like “the record couldn’t be imported due to an error in the next record” and this would repeat until the very last record in the import file. We tried importing through the upload button in “IN Purchase” but there we received an error that “Inventory ID can not be null” and we had no null value in the file.Long story short I did a lots of trial and error to figure out the errors all are misleading. What has happened we had “/” and “\” in our part numbers. Although we had successfuly imported them as Stock Items but the other import referencing them was failing to import. When we changed these two charcters to “-” all worked out just fine. There could be other special characters potetially causing problem

Hi Acumatica Community,I’ve set up an import scenario to handle contact records using a CSV file exported from Shopify.The goal is to either update an existing contact (based on the email) or create a new one if the contact doesn’t exist. However, I’m encountering an issue where the scenario always creates new contacts, even if a matching email with the contact exists in the system.I am using <Key: External> in the first row.  My understanding is that this is used to identify records in the system, but it does not look like the whole import is updating any existing contact at all, instead, creating new ones.Is there something wrong with how I’ve configured the <Key: External> mapping or could there be another setting or mapping I’m overlooking that might cause this issue?Any help would be really appreciated!Will 

Hi, I have a requirement to create Issues, Receipts and Warehouse Transfers using Import scenarios. How can I right the logic when there are multiple line for a particular Issue or warehouse transfer.Thanks in Advanced.

Hi,I tried to create an import scenario for the Sales Order Bulk update. Here in the Sales Orders there are some items that price need to be taken from the Sales prices setup system and there are some items that price need to be taken from the Excel. When uploading Sales Orders through the import scenario I tried to write the Logic in the import scenario as =IsNull( [Unit Price],[Transactions.CuryUnitPrice]), But the system does not take the price when creating the Sales Order if the unit price is not avaialble in the excel file. How can I solve this?Thanks in advance. 

Hello all! I am trying to import vendor payment instructions for EFT (Canadian ACH) and when I run my import scenario, the error I am getting states that “Error: Provided value does not pass validation rules defined for this field.”What I am trying to update: My import scenario :  Why is this happening and does anyone know how I can fix this? Thank you!

Hi! I am trying to import a list of prices using the import from file function on the Sales Price Worksheet screen. I received a timed out error but the screen still shows that it is executing. I checked in System Monitoring, and it says task finished, and there is no running process or request, but the Sales Prices Worksheet screen seems to suggest that it is not done yet. Can someone help clarify for me what this means? Should I cancel this or refresh the browser? Thanks!