Import and Export Scenarios

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!

I am migrating to Acumatica ERP and have lots of stock information i want to import to the Description found under the Description Tab.Is there any special way of creating the scenario

I’m working on a new project and I could use some help with the steps I need to complete.  I’m trying to automate the importing of data from an external source on a nightly basis.  Here is what I have:External system exports multiple files to an FTP location on a nightly basis. I configured a data provider to connect and sync to the remote FTP location. I wrote an import scenario to import the external file.Here is my problem.  I can successfully run the import scenario with a single file, but how do I do it for multiple?  When I perform the “File Synchronization", I end up as multiple versions (one for each new file).  How do I configure Acumatica to execute my IS nightly and to import all the new files it finds?  

I am sure I am missing something. We have a customer who sells items in a different Sales Unit to the Base Unit. We have set up the Sales UOM price in Sales Prices of Price Type Base and Synced to BigCommerce which is now showing the default price as the price on the inventory item (in terms of base units) and the Sale Price as the price from Sales Prices.This all works well when a customer is logged in to the store they see price on the item as in the price from Sales Price asd that is what they will be buying it in. However if the customer does not login the price they see on the item is the item default price which is not correct as they cannot buy it in that UOM.They want to allow prices to be visible to customers even if they are not logged in.  

Greetings, by any chance is there a formula that allows me to import invoices separated by a comma??from here: Invoice Numberto import like: 

Hi everyone, I'm trying to configure an import scenario for Payment and Application and I'm looking for a formula that once the Payment Method is selected automatically select the Cash Account. For example, once I select ACH payment Method the cash account is selected by default.  

Hello, We have Shopify connected to Acumatica. I have the Sales order entity attempt 100 syncs for sales orders before the status changes to Aborted. Sometimes our stores get really busy and the inventory can be off, so a sale takes place when the inventory doesn’t show up in Acumatica, thus the order fails to sync. The staff don’t make the adjustments for a few days, so it fails 100 times. When they finally correct it in the system, I have to manually sync the order from the Sync History screen to get the order to go through. I want to automate this process using an import scenario, but it doesn’t appear to be working. Any help is appreciated! I have the data provider set up to look for orders on the Sync history screen that are in the Aborted Status. Then I take the External ID from Shopify, select it, and try to sync. The import scenario says it runs successfully with no errors, yet nothing happens. 

HI, We are trying to run a few import scenarios one after the other. We want to import customers then customer notes then customer locationsThere are 3 separate scenarios that accomplish this. What is the best way to accomplish this? Is scheduling them via the Process Import Scenario screen the best way? Or is running them one at a time the best way? Thanks in advance! 

Need assistance on how to delete double upload AR Invoices and Memos, current status is Open.

I am looking for an import scenario that will reverse payment applications on AR Invoices, I have tried several times but unsuccessfully. Thanks

We developed import scenario for Stock Item. We need to add entry for Cross Reference as well.This works fine when we are adding new record.When we try to update entry by providing same data it update stock item without any error.But not cross reference.Import scenario is design like this. 

Hi,I created new locations in the AR module that need to be added to numerous customers. How can I do a mass upload without adding the individually? Community have always been helpful and provided detailed instructions.Thank you very much,Happy Christmas

Hello, I am looking to update my pervious import scenario to mass update wingman in the employee table. Does anyone know what the Char(1) are for the delegation of table? the two available choices are:Thank you,Kage

I had an employee leave the company who had several hundred open tasks assigned to them as the owner. This is the first time I have had to deal with this since we are relatively new to Acumatica so I was thinking there was already a system tool to do that. I didn’t find one and I was told that Assignment maps might be the way to go but I didn’t see where I could do an assignment map for task ownership. That leaves me with an import scenario.I have created the following import scenario.  Every time I try to run the import scenario I get an error that says “Error: “’Summary’ cannot be empty.”Not sure what I am doing wrong, I am just trying to change the ownership of an existing open task to a different owner. Any help on this would be greatly appreciated.I used another post in the community to try and figure it out but I am still having the issue.How create a Import Scenario to update Owner on the Task Screen CR306020

Hello JAMIS Community,I am working on a project where I need to create Power BI reports based on data from JAMIS. To facilitate this, I plan to extract specific tables from JAMIS into an SQL Server database and connect Power BI to SQL for reporting.Could you help me understand the best practices for this process? Specifically:What are the recommended methods to extract data from JAMIS into SQL Server?Does JAMIS provide direct access to the database via ODBC/JDBC, or is OData the preferred approach for exporting tables?thank you!