Import and Export Scenarios

Hi, I want to know if it’s possible to add a subcontrat in my excel report to import in acumatica? If it’s possible, can you explain me how to add this in my import scenarios.Thanks for your help Melanie  

How do I upload an import scenario? I have received an import scenario (.xml) file from another user, but do not know how to import it to our Acumatica instance.     

Hi, I'm trying to import stock items and I'm getting an error Error: 'Item Class' cannot be emptyeven though its not empty.

Can someone please assist with this error. I get this error when trying to reimport file to update changes. Please check my XML file.

I have import scenario for change orders commitments, but I can’t find a way to update selected commitment.My import scenario: Now with active checkboxes it create new change order and add to it my subcontract, but I can’t update it’s amount. May be someone know how change it for update line amount? when i try to use not selected lines- it create new line or do nothing.For example my result if I enable “Commitments” - it seems it can’t find this line from “Select Commitments” dialog and just create new lineHow I can select and update amount for the line from  “Select Commitments” dialog and not create new line?

I am updating Queue times on Released Production Orders that have approximately 10 operations each.  My import scenario is putting the order On Hold, finding the operation ID (@@), updating the Queue time, and removing the Hold.  It does this for all 10 lines on every order.Is there a way I can set the import scenario to put the order on Hold, update all the lines, then remove the hold?  Instead of Hold-update-RemoveHold 10 times?

Hi Team,I'm trying to pull data from Acumatica and use it for further processing at my backend system (similar to SAP in this case). I need to retrieve data from multiple entities like companies, projects, and employees.I successfully made API calls using Postman to fetch specific entities, like projects. However, when I attempt the same call through the Extended endpoint, I receive a 500 Internal Server Error.Could someone advise on the best approach to fetch data from multiple entities, including using the Extended endpoint?

I am writing an Import Scenario to import customer x-ref data to a stock item. To InventoryItem, our VAR added UsrUPC so we can get the UPC from the stock item record, with less logic.Ideally, I want to use the UPC and Description, if there is one in the import file, if not inherit it from the InventoryItem row.No matter what, I was getting empty fields for those two columns. So, for testing I stripped it down to just set those two columns to Item.UsrUPC and Item.Descr. Then when that works, add functionality to pull from the file.My import scenario is fully functional, except where it is pulling Item.UsrUPC and Item.Descr. Here is my import scenario: Any ideas why it is not pulling Item.Descr and Item.UsrUPC?

Hello everyone,I have the problem that I want to add several suppliers to a stock item. This works so far, but I need a way to skip empty rows in Excel.For example:I have three possible suppliers in my Excel list.Two are imported.For the third one, it throws an error because there is none, for example.  Does anyone have any idea how I can work around this?Kind regards

Hello, I am attempting to create an ACH Export to go along with the Wells Fargo Payment Manager through the batch payments screen. I found out from Acumatica that we cannot utilize the Cash Account Details, or VendorAccountDetails in an Export scenario based on the Batch Payment screen.The ticket was moved to Acumatica services, and they quoted an obscene amount to write this. Has anyone tied into WF Payment Manger? If so, would you be willing to give a little direction as to how this was accomplished?Thanks in advance!

I am trying to create an import scenario that deletes all Transaction line items in the Deferral Schedule. I keep getting the following error. I tested several different ways and I don’t know why this error is coming up. My ultimate goal is to delete all transaction table line items in the deferral schedule, then add 1 new line item, but I just want to test deleting first.  Can anyone spot something obvious that I am missing?  Note: The deferral schedule is Open and the transactions are editable.  

Hi! I’ve been looking to see if you can create an import scenario that will create sales orders and group them by ship to location. For example, if the first two three rows on the spreadsheet have the same ship to location then the system will create one order as opposed to three different ones. I’m aware you can add the order numbers to the spreadsheet but I want to avoid this if possible.

When I run my import scenario I get the famouse error “The Change ID button is disabled.” My import scenario is simple and base on https://www.augforums.com/sample-acumatica-import-scenario-stock-items-change-id/, but after modifying this import back and forward, still having that issue. Do you guys see any errors on the mapping?  

HiMy customer has many cash accounts (50+), when they add an new Entry Type I would like a business event to run an import scenario that will link the cash accounts to the new entry type. I have the business event triggered that when a new entry type is created it populates a generic inquiry and triggers the business event. The generic inquiry results are the Entry Type ID and Description.  That is working, the business event runs, and if I hard code a cash account ID in the import scenario the import updates that cash account.Where I am stuck is how do I update all the cash accounts with the new entry type?  I tried =Every in the source field (that works with export scenarios) but no luck.Thanks,  

Am I crazy? Is there really no way to schedule an export scenario? Went through a setup getting the Generic Inquiry just right, a scheduled ftp upload scheduled and that’s my stopping point?This is for a product feed csv file upload to an ftp server.

As per the above screenshot, I want to update the above highlighted allocated field through import scenario.I have wrote the below import scenario but the scenario is not working. Please help me with this issue.

I tried with the above import scenario to update the Allocated checkbox through using the import scenario. The that is not happening. Can anyone help.

We would like to export data, such as vendors or customers, to excel the exact same way we imported the records - ie. using the same data provider. Is there an easy way to flip our import scenarios to be export scenarios without rebuilding them all?Is there anything I am missing here that might make this process easier? Thank you!!

Hello Community,I have been trying to run an export scenario via GI. But the Export scenario is not able to export any data. below attached is the XML file of the GI & Export scenario.What is it that I am doing wrong? Thanks in advance.

Hello - I have created an import scenario for AR Applications and am trying to include an Entry Type but am running into a couple issues. 1) If there is no value, I get an error that a value must be entered >0. 2) If a value is entered, but there are multiple invoices per payment, then that entry type line is repeated. Is there a way to bring these in with blank values and also as 1 line per payment when there is a value? This is what I have so far:  

I have a Sales Order Invoice import scenario that does not calculate the discount for items.  I tried adding logic to recalculate the discounts, but get an error.

Hello community,I have been trying to import Non - Stock Attributes, but the system triggers the following error: The mapping:Why is the system triggering the error? What is it that i am missing?

Hello,Trying to create an import scenario with he minimum required data to start with.If I follow the steps in this scenario exactly, I can create new fixed asset records without any issues.  The import scenario says it worked and doesn’t throw any errors.  But it only creates 1 record which is wrong.  I can rerun the scenario over and over and I only have 1 record.Please note, I don't’ really know anything about fixed assets in ACU.Asset numbering is manual: Crazy results below: 

Has anyone created an import scenario for the ACA Reporting (PR207000) and be willing to share the general layout of it? I’m trying to create a basic one that populates the Section 4980H and Minimum Individual Contribution. However I keep getting an error on the Import Scenario stating - “items have not been processed successfully. View name: CompanyYearlyInformation.” Guessing it’s something minor I’m missing and don’t have much experience creating Imports from scratch. It also takes a very long time before finally erroring out. 

I have to delete notes in all recently imported non-stockitems. Does anybody have an idea how can I do it?