Import and Export Scenarios

Seeking an example for adding multiple Packages to a shipment with each Package having multiple items o 

Im trying to import a range of Replenishment settings to Item Warehouse Details and I keep getting the below error with no other information. Ive tried lots of variations but cant seem to get this import to work?  

Hi All,We have created an import scenario for stock items—finished goods. But the style tag and the item class are not picking up correctly. The subaccount is taken as the style tag.Please see the below screen shots. Anyone know how to fix this?    Thank you!

I’m trying to build an import scenario to edit the promise date on the inventory line on a Purchase order. However, it’s not changing based on the import I built.  Attached is an XML of the import scenario.

Is there a way to configure a process for the ECO Commit Changes to BOM action? The action can be called from a Generic Inquiry or as an import scenario action.  However, because this action launches the Bill of Material screen, the import scenario doesn’t work.  Similarly, the GI action launches the BOM, but requires the user to click ‘Save’. Ideas?

Hi,We have created an import scenario to copy a BOM but have two issues:Updating the description field updates the description on the current BOM - not on the newly created BOM The scenario successfully processes one record but returns an error on the next record.Any thoughts or suggestions on how to get around these two issues would be greatly appreciated!Laura

Hi,I am trying to add a line item to an existing sales order and although the import scenario seems to process without errors, the line is not added to the sales order. What needs to be added for a line to be added to the end on the sales order?  Thank you!

Created Journal Transaction Import, with the following data: Not all the transactions got the error, only a few, i have recreated the transaction on the journal transaction screen and journal transaction was on balance with no issues. Also, i have removed the Module, added, and check for the Commit on several of the selections, but cant import all of the transactinos, only some worked. Do you see anything wrong with my import scenario? Thank you so much in advance. 

Hello Team, Is there have any possible way to change the location of file storage in acumatica?Reason is day by day database size is going bigger as I can see in database mostly file storage is occupied so for reduce this i want some solution to fix the issue.  Thanks and RegardsRushabh Shah

Is it possible to use the preferred Vendor ID and the Vendor Inventory ID as an identifier in an import scenario? For example, if we receive a file from a vendor with new item pricing, but the file uses the vendors inventory ID (which we record in the Vendor Inventory ID field of the VENDORS tab in the Stock Item), is it possible to create an import scenario to find the corresponding stock item and update the pricing based on the Vendor ID/Vendor Inventory ID?

Good day,I am struggling to update few over 1800 open sales that have the wrong unit price.   I am able to get the sales order to update however, it ADDs the two items rather than updating the existing inventory itemsIt is probably a simple changes to my import scenario.  I have already struggled for a couple of hours now.Any assistance would be greatly appreciate; these orders are going out shortly.@Evan G  

Hi - I recreated an import from my test environment and though it worked in Test, it is not working in Production and I am getting the below error message:The import created is below:  

I have a simple import scenario that I am using as a test that is being used to populate customer contact records. In the import scenario I am using the =PadLeft([PostalCode],5,’0’) to pad out any of postal codes that have a leading zero so that they will pass validation. When I run the import scenario it looks like the code isn’t even running. I am not sure if I am doing something wrong or if I am missing a small detail that is preventing the code from running. The code passes the validation test so I don’t think it is a syntax issue. I have attached the data provider, the excel spreadsheet and the import scenario. Any help would be greatly appreciated.

We are setting up an import scenario to create customer invoices with multiple invoice lines. The lines are mapped to a data provider. We want to add an additional “static” line on top of this with hardcoded value. When I try to import it, the static line just overrides the first line from my data provider. Any ideas on how to achieve this?

I'm trying to import some AP bills, but I keep getting the error message 'Supplied By Vendor ID cannot be found.' Any suggestions? Thank you!

I have an import scenario whose function is to delete all existing Customer Part Number Alternate IDs for a given stock item and customer combination, then upload the new customer part number. There are three issues with it:The big one is that it will create a stock item if one does not exist, rather than erroring.  Is this baseline import scenario functionality, or can I alter it to error instead? The second issue is that it DOES error if I attempt to upload a customer part number that is unchanged from the one I’ve just deleted, the import will error for that line.  This is not a functional issue, since nothing would change if it succeeded, but not friendly for end users. Is this something I can make nicer either with a better error message or by having the import succeed? The third issue is another minor user friendliness issue - if the item field is not populated on my import spreadsheet, that row will not be imported but the row does not get an error message.  Is it possible to ma

On the Customer document, when a new location is created I’m trying to get a business event to trigger an import scenario to add the new location and automatically assign a default salesperson to that location.I can get the import scenario to work manually, but when I add it to the business event and trigger the import scenario, the business event history shows that it successfully executed but the new location is not added to the SALESPERSONS tab.Does anyone have any suggestions regarding how to accomplish this?

Hi, Does anyone have an import scenario they have used for bringing in Features and the corresponding labels?

Good day.I am trying to import item vendor lead times into the stock item profile.See the attached.  I keep getting the below error; the one that worked was blank.Any suggestion/modifications need to the import scenario.Thank you.@Evan G  

I have recently been experiencing performance issues when uploading data files for import scenarios or import scenarios which contain data files.These are not huge files.I can upload to sharepoint and other platforms.  However, Acumatica is almost unusable for this.I’ve had others upload for me and they go right up without issue, so it seems to be me.However, as I said, I can upload the same files to other platforms like Sharepoint without any problems.I have recently moved and using a new ISP, but I am unsure why this would only be affecting Acumatica uploads.Any thoughts?

I discovered that there is a difference in behavior for import scenarios triggered by a Business Event and by the front end using the "Import By Scenario" Screen. I have an import scenario that works if I use the "Import By Scenario" screen but when applying the same Import Scenario to a "Business Event" as the data source (still pointing to the same Generic Inquiry) and triggering by schedule the behavior is different. Are there known differences between these trigger methods and what designs could cause breaking issues when used with an Business Event?

 Is anyone aware of the root cause for the following error message? 'Sales Account' cannot be empty. 'Sales Sub.' cannot be empty. 'Inventory Account' cannot be empty. 'Inventory Sub.' cannot be empty. 'COGS Account' cannot be empty. 'COGS Sub.' cannot be empty. 'PO Accrual Account' cannot be empty. 'PO Accrual Sub.' cannot be empty.  

Hello,I am currently facing an issue with importing the start and end times for appointments in Acumatica. Despite trying various time formats, Acumatica consistently defaults to 00:00:00 after each import attempt.Could anyone provide guidance on the correct format for importing time data, specifically for the start and end times in the appointment log? Any insights or examples of the correct format would be greatly appreciated.Thank you in advance for your assistance.

Trying to create a mass import scenario to change existing location IDs to new location IDs. I want to retain the history of the location so I don’t want to create new locations. In the import scenario, there isn’t an option to Change ID like there is for stock items, warehouses, etc. Once I map to the key field, is there a way to change the ID? Or is there a way to do this directly from the locations table upload feature? 

Hi, Can we trigger email notifications for Import by scenarios?