Import and Export Scenarios
Discussions Import and Export Scenatios
- 200 Topics
- 803 Replies
Hi Everyone, I’m trying to figure out how to use an Import Scenario to modify the Sales Order Detail section. To be more specific, when we issue a warranty with a receipt line I would like to add a not to the issue lines saying, “Please include a return label”. Since this note will appear on the pick list our warehouse team will see it and can take action.Another way I thought of and would would be happy to resolve this is to use the import scenario to add a ‘return label’ non-stock line item. We could set this to $0.00 and as long as it is an ‘issue’ it should appear on the pick list. Below is what I have so far. The problem is I get this error when it tries to run, “The last error was IN Error: Unit conversion is missing.” Looking forward to see what everyone has to say.
Hello, Our vendor is requiring us send files which are exported from Acumatica to them by SFTP in daily basis. Yes, this can be done manually, I can export the file to my local computer and then I use a SFTP client to send the file. However, I am wondering can this be done in an automation way? Thanks in advance.
We assign Delegates on Employees to facilitate Expense Claim entry on behalf of our field employees that do not have Acumatica credentials. We have a scenario where a particular person moved locations and is responsible for a different group of field employees. I know how mass add to all the new employees, but I cannot figure out how to mass delete from the old employees. Short of <Action: Delete> on the Employee Info target object, I cannot see where removing a row is possible. Does anyone have tips or tricks to achieve?
Hi,I am trying to use the “Quick Process” in an import scenario. The SO already exists in Advanced. The import contains only the Sales Order Nbr. The SO has he “Quick Process” actions to “Ship” and “Invoice”. The Import Scenario comes up with an Error “View: Name Document”.Import Scenario is very basic. It is attached.I would really appreciate any assistance. A Sales Order just needs to exist in MYOB. Add the Sales Order no. i the Import Scenario . And the quick action turned on in the SO Type. Regards,Laura
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 trying to use an import scenario to run price recalculation on a list of Sales Orders (provider is an Excel provider). Here is my import scenario. If anyone has any ideas about how to do this, I would appreciate it. I’ve tried different variations of the OK button that are available in the list including <dialog answer>. Also tried moving the OK button before the Action line. Also tried the different Action->Recalculates that are in the list.Any help is appreciated.
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> <
I’m new to business events and was wondering if the following is even possible.I want to add a business event to take an inquiry and upload it as a new document (sales order of type TR). Not to edit an existing one, which is the use-case I keep seeing online.I’m creating Sales Orders of type TR from Purchase Order data.Here’s the hooks:The inquiry MUST have a user defined parameter (container number)I then want my user hit some kind of button to trigger the upload from the data that now exists in the inquiry.Is this possible?
I have created an import Scenario to import time entries into the acumatica clock entry screen. I am receiving the following error”1 items have not been processed successfully. View name: header.” Any help would be much appreciated. Thanks in advance. Here are the details for my scenario Data Provider Data Provider SchemaSpreadsheet
Hi,I have created import scenario to import invoces and line items, when i execute prepare and import action for each record from excel a new invoice is created.In the excel there is only one invoice with 53 line items. But when import is done 53 invoices are getting created.Following is the image shot of the Import Scenario i have created. Let me know what is the wrong in the above scenario.
Importing Journal Transactions: The Post Period is being overwritten by the transaction date's default post period
When I import journal transactions, I have multiple line details grouping to be one GL batch by JE number and post period. Each GL Batch has the same Post Period, but some lines within a batch have a different transaction date in the source file (I’m brining in historical SL GL batches and its common for SL Batches to span multiple dates in one batch). In Acumatica, if I bring in the post period and transaction date at the batch level, Acumatica will just default the post period that the last transaction date is in. The only way my GL batches get the proper Post Period is if all the line details share the same date, or if their dates share the same default post period as the post period I want to load. Let me know if this isn’t making any sense, but I have ran into this issue with multiple implementations and I have been trying to find a solution.Thank you!-Landry
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?
Hello, I am new to Acumatica.I am building an import Scenario for the “Employee Time Activities” screen.The data is coming-in via a .CSV file (provided by an external source).The Project number is coming-in from the .CSV file non-segmented.The Project number segmented in Acumatica. (xx-xx-xxxxx). I have tried this two ways (in the .CSV file):Project number as segmented. Result: Field: Project, Value: SP-21-095, Error: 'Year' of 'Project' does not exist in the system. Project number as non-segmented. Result: error: Nullable object must have a valueWhen manually entering an Employee Time Activity record, I notice that Acumatica inserts default values the following columns: Hold, Status, Data, Time, Earning Type,Time Spent, Billable, Billable Time,and then copies values from the previous record columns: Project, Project Task, and Description.It was suggested to me that bringing in the Project number as non-segmented was preferred. Has anyone encountered the two errors (above) before?How d
I am trying to write an import scenario to clean files which are 1 year ago and no longer needed. The datasource is from a GI which is wrote to search the obsoleted files out. However, my scenario is run with errors which is saying “object not set to an instance”.So probably, I am lacking 1 step in import scenrio which is to set the focus on the line to be deleted.Can anyone give me some help on how to write this kind of import scenario.Thank you.
Hello,I am trying to import historical invoices into Acumatica using the out-of-the-box ACU Import AR Invoices import scenario. My file has a column for total tax which I tried to map to the tax total field on the invoice header. After running the import scenario, the invoices are created but the tax total remains 0. I suspect this is because the field is greyed out/disabled on the invoice entry screen. I tried to enable the field using both the ASPX editor and by setting the Enabled property of the PXUIField attribute in code. Neither of these worked, the field is still disabled. Does anyone know how to enable the tax total field, or have had success importing tax amounts for historical invoices?
When exporting a payment batch an error appears saying“The bank routing number specified for the vendor is invalid or empty. The number must be at least 8 digits. Verify the vendor’s payment settings on the Vendors (AP303000) form.”Is there a way to find out which vendor is the issue? We’re dealing with a batch of hundreds of payments and don’t have a way to easily narrow it down.
I’m trying to update the Vendor Inventory ID found on the Vendor Details tab of the Stock Items screen. I want to look up the record using the Vendor ID and the Purchase Unit of Measure. I’ve tried a couple of combinations thinking that the order might be important but I’m missing something.This first attempt was to populate the VendorId variable and then the Purchase UOM variable, but that didn’t work.Trying to populate custom key one field at a timeThe second attempt was to capture both search values and then apply them:Capturing values first before searching for themDo I have the search key configured incorrectly or is searching on multiple fields a challenge? I realize that I could probably create a screen on the POVendorInventory table to update the records without going through the Stock Items screen but I was hoping that there is something that I’ve missed.
I need to have an import scenario that records the payment and applies the payment to the related invoice or invoices. I started using the one included but I am getting the error:The system failed to commit the adjustment rows.Here is a screenshot of the application section of my import. Any help would be appreciated.Thanks...coleen
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.