Import and Export Scenarios

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 one.  While this seems to be on topic and is marked as Solved, I have not found a working solution.  If someone has been able to get this working, I would be grate

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 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 Vendor List: I have cut the e

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 really appreciated. ​​Thank you, i really appreciated for your solving.

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

Hi, i want to import the AR Invoice and Memo using Import Scenario, but when i try import there is an error “The Save Button is disabled”  i already looked up my mapping but i still don’t get it. Please take  a look of my mapping bellow and XML:Please help me to solve about this, i really appreciate, thank you 😊  

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 but i still don’t get it. Please take  a look of my mapping bellow:I really appreciate for your help, thank you😊   

Good morning everyone. I am trying to create a new bom with a business event using a GI and an import scenario on a schedule. I am getting the error “The last error was Cannot generate the next number for the BOM sequence.”. To diagnose it easier, I exported the GI to excel and made a data provider, new import scenario, and used import by scenario to upload. i used the community post below to find a solution that worked. This post used option 1 in the below screenshot. It worked fine and created a new bom with the next autonumber with everything correct on it. I then made the change to the business event subscriber import scenario and I got the “cannot generate next number” error. I then tried option 2 below and the business event history shows that it ran successfully with no errors but it didnt actually create the bom. I saw another post where someone could only get the header to get created and had to add materials later so I tried making the GI as simple as possible and use only th

There is a lot of documentation and training around non-XML data providers but not very much around XML data providers.  The documentation and examples don’t feel very clear around what can be done before custom development is required.To create this XML file going out, can I use the existing XML data provider or will I have to create my own?  (There are more elements but this example shows the deepest elements and entities.)<?xml version="1.0" standalone="no"?><File PmtRecCount="7" PmtRecTotal="7000.00"> <PmtRec PmtCrDr="C" PmtMethod="CHK"> <Message MsgType="CHK"> <MsgText>Check Memo~35</MsgText> </Message> <Check> <ChkNum>1234567890</ChkNum> <ChkDocNum>CR9999CL9999WS9999</ChkDocNum> <DeliveryCode>100</DeliveryCode> </Check> <OrgnrParty> <Name> <Name1>ABC Company~60</Name1> </Name> <PostAddr> &lt

Hi, I am reaching out regarding a customer requirement related to importing Sales Orders through the Import Scenario.The customer needs to upload invoices in bulk, where each invoice contains multiple line items. We identified that column wise import of the Inventory Item field is not supported. Other fields can be mapped correctly, but the system consolidates the Inventory Items into a single line instead of creating separate lines for each item.Customer Requirement– Ability to import Sales Orders with multiple line items using an Excel template.– Each Inventory Item should appear as a separate line in the Sales Order during import. Issue Observed– The Import Scenario does not support column-wise mapping for the Inventory Item field.– Inventory Items are not created as separate lines.Could anyone confirm whether Acumatica supports this functionality? If not, could you suggest an alternative approach to handle this requirement? 

Does anyone have an example of an import scenario that inserts Lot/Serial Nbrs. into Line Details?I have a Business Event that will create IN Issue documents when an IN Transfer is released, but I’m having trouble getting the Lot/Serial Nbrs from the Transfer’s Line Details included in the Line Details of the IN Issue. 

I’m trying to create an import scenario that replaces the current default salesperson on the customer account with a new salesperson, sets the new salesperson as the default, and still works even if there is no current default salesperson assigned.This is what I have so far, but it currently only adds the new salesperson and sets them as default; I’m not sure how to remove the original default salesperson if there is one: