Import and Export Scenarios

I’m working on an Import Scenario that will update a sales order’s user-defined attribute.The simplified process will go as followed:Identify the order by Type and Number Open or Re-Open the order (QT requires the Re-Open) Set the attribute Return the order it starting stateSteps 3 and 4 need to be conditional and I haven’t found any documentation on how to do that. For instance, step 3 would need something like: IIf(=[Document.OrderType] = ‘QT’, <Action: Open Order> (OpenOrder), <Action: Re-Open Order> (ReopenOrder)As a work-a-round I am thinking about using Target Restrictions to limit the data to a single condition, i.e., QT and Completed or QT and Canceled. That way I can set the Mapping fields and change them each time to match the current conditon. I’m really trying to avoid this since it will be fairly manual. 

Hey, team - I know very little about configuring export scenarios.  I’ve got a client on 24R2 using the Export AP Payment to ACH v2 scenario.  No modifications have been made to it; everything is out of the box.  The output ends with hundreds of 9’s.  Where in the ES is this part dictated?  TIA.  

Hello-The mission is to use business event to trigger an import scenario subscriber to create AP Bills. The business event will be triggered on a schedule, the source screen is a Generic Inquiry containing fields that is required for an AP Bill creation. The bill ref. nbr is auto generating. We want to create bills based on vendor ID. Meaning if each line record in the GI has the same vendor, then they should all be imported under the same vendor in the same bill. Currently, my business event is firing, and it is creating a bill. But it is creating one bill per each line on the generic inquiry. I want one bill per vendor. This is the import scenario, salesPersonID field on the GI is the field we want to use as vendor on AP Bill.  

I’m trying to create an import scenario that will trigger the “Create Quote” button on the opportunity record.I’ve tried placing the dialoges in a few different spots and using opportunity summary for the <Dialog Answer>. No luck yet.Thanks for the help,Matt 

Hello! I am reviewing the Import Scenario “ACU Import AP Bills”. When we manually print a check in Acumatica, it automatically finds the next “payment ref.” # in the sequence for the cash account/payment type and adds that into the  Payment Ref. cell. I was wondering if (for our AP Bill Import Scenario), instead of manually inputting the “Payment Ref.”, is there a way to have Acumatica autogenerate it based on the existing sequence? 

I have only project ID and TaskCD. How to import task by TaskCD?

Does anyone have a working Import Scenario to create a service order from a sales order? When the ‘Create Service Order’ action is executed through the UI, it redirects to the Service Order screen and the user has to press the Save button.  An import scenario that starts on the Service Order screen can populate the dialog box options but cannot press save. Another approach it to create a Service Order starting on the Service Order screen, but in this case there doesn’t seem to be any option in the User Interface to identify the source of the service order, which needs to be linked back to the Sales Order.  Even on a new Service Order, these fields are not editable.  The only way that I can find to create the linkage is using the ‘Create Service Order’ action from the Sales Order.I have reviewed several threads including this

Hello,I am trying to use an import scenario to import our initial inventory test tenant.Does someone have a .xlm import I could use as a template.Thanks

Is there a way to bulk download saved PDF invoices?

Hi,My customer is using an XML file from a 3rd party to update PO container records (AcuContainer). The issue we have is that there are records that don’t exist in the system, how do we DISABLE record creation so it will only UPDATE existing records? Thanks

Hi, I am attempting to create an import scenario that populates attributes at the line level for purchase receipts. My import scenario is adding the correct inventory id, quantity, etc. but doesn’t populate the attribute value. What am I missing? 

Hi Community,I am gathering information regarding importing subcontract balances into Acumatica. I would like to get your input on this topic Do you use the Acumatica standard Subcontract import scenarios for importing subcontract balances? When importing subcontract balances, how do you update subcontract Billed Quantity and Amount? Is it through a customization? Do you import AP bills with unreleased retainage, change orders, compliance records linked to the subcontract? What are the difficulties you currently face in importing subcontracts information into Acumatica?Your responses will greatly help our engineering team in building the right solution. 

I have an issue importing Sales Orders when the Contact name (e.g. John Doe) is associated with multiple Business Accounts. I’ve tried the following with following results: Works if the Contact name is associated only with the BA related to the SO importing, but often error if multiple BAs. Imports nothing. Imports nothing.Thanks.

I am attempting to import External Applications (screen SM301000), but the process is failing when running the import.I get this error in the Import by Scenario screen when importing:There is no Error message in the “Error” column.The Import Scenario is pretty basic:The goal is to make it look something like this: I also checked Trace, but it did not show anything else useful.Does anyone have a suggestion? Thanks! --Brian

Hi,Does anyone have a way to import customer notes but with multiple lines such as for phone numbers. This is so it will carry over to service orders and appointments.  

I want to fire an import scenario to update a user field on multiple stock items when the Vendor Price Worksheet is released.  The BE will work only when Raise Event is For All Records which means the import scenario is run multiple times.  I would like it to only run once.

Hi, I had to create a custom EFT Export file from scratch for a client without the Canadian localization due to cost. It does export and we sent to the client’s bank CIBC for testing. We did get some errors back. For the most part the I believe most of the errors can be corrected but need help formatting the file to comply with the 1464 characters requirement per line. I have attached a copy of the export file and CIBC requirements. Would anyone be able to provide guidance to update the export file?     Thank you,Frances  

I’ve tried to find an import scenario to import users into a new system and am not finding what I need.  I created the Excel Data Provider as follows using guidance from some older posts in AUG Forums.The import scenario is:When I try to Prepare the Import by Scenario, I immediately get this error:The column 'Active' is not found in the data setDoes any one have an import scenario that works for users or can tell me what is wrong with mine?

Just to preface, I am self-teaching on Import Scenarios for the most part, and I don’t have a lot of experience with them yet. This is around the third Import Scenario I have built from scratch, and it has one complicated part I am really having trouble getting right. Now on to the problem:I have some Stock Items that I want to make default a certain vendor. The vendor is already on the Stock Items, I just want to use Import Scenarios to check the default box for that specific vendor. There are multiple vendors on these items, so I need the Import Scenario to choose the line that vendor is already on and check that lines box for the default. I have set it up a ton of different ways, and I can get it to check the box, but it always checks the box on the first vendor in the list. Alternatively, the way I have it set up at the moment is giving an error about adding a duplicate line. Screen shots below. If any other info would help just let me know. Stock Item Vendo

I have import scenario. When import have some error  

Hi, i want to import migration data for AP Bill but when i try it there’s an Error 'AP Subaccount' cannot be empty. Enter the document open balance to this box”.There is any mapping that i missing, i really confused about this, when i try to remove the reference number, the error becomes “The Save button is disabled” So. i decided to put it random number, but when i try to input the number, there is a new error, please take a look, you can see the picture bellow:  And i already input Account and Subaccount in excel, i already did it manually in Bill & Adj. Form to see the Account and Subaccount but Acumatica cannot read it ya? Please help me to solve about this, i r

Hi, i want to import an AP Bill in Acumatica use Import Scenario but when i try to import there is an error “The Save Button is disabled” i already looked up my mapping and following the same field order as the screen but i still don’t get it. Please take  a look of my mapping bellow:I really appreciate for your help, thank you😊    

After importing the PO into the AP Bill I want to compare the unit cost provided in the import to the PO unit cost and mark the AP Bill in some way,  However, the Transactions.CuryUnitCost is not populated.For example,the import file has $100 as the unit cost but the PO unit cost is $80.00.  The problem seems to be the Transaction columns are not populated and the condition is true every time,The formula is =IIF([Transactions.CuryUnitCost]<>[Unit Cost],Concat('Unit Cost of ',[Unit Cost],' Not the same as PO Cost'),'')Where [Unit Cost] is the source data being imported, 

I’m trying to create a Import Scenario that updates a Automation Schedule for Turnover. I’ve produced this import scenario, but I’m getting a “System failed to commit the fill rows” every time. Any advice on how I could achieve this?  

Hi guys,I’ve created the following two user fields:BAccountExt.usrSAGAlteKDNr BAccountExt.usrSAGAlteLieferantenNrI would like to make these fields searchable via the global search. Hope u can help me.Thanks