Import and Export Scenarios
Discussions Import and Export Scenatios
- 496 Topics
- 2,144 Replies
Hello, Is there a way to set up an export scenario or automation schedule to export the files from a Shipment? We have a customization built in already that captures the Shop for rates carrier info and stores it in the Files of the Shipment. I want to be able to export these files and save them on my computer or in OneDrive. I can do this one at a time now, but is there a way to do this in bulk or on a schedule?Thanks!
I’m creating an Import Scenario for the Purchase Request screen (PO.30.20.00).I’m having difficulty adding an individual PO line (other than the first PO line) using the ADD PO LINE button (found under the DETAILS tab). It seems like the 2nd line never gets properly selected thus, by default, the first line remains selected.How do I add a PO line other than the first one?Here is are my steps (in two screenshots):
Hello Acumatica Community,I hope you are all doing well. I'm currently facing an issue with an Export Scenario in Acumatica, and I could use some assistance in resolving it.Problem Description:I've set up an Export Scenario to export purchase requests from Acumatica. Each purchase request can contain multiple lines with unique line descriptions. However, when I use the Export Scenario, it's not exporting the multiple line details correctly. Instead, it exports only one line, and the line description appears to be duplicating from other requests. Can anyone help me with it please? I have attached the export scneario too.Thank you in advance for your assistance.Best regards,Naing Aung Kyaw
Hi Everyone!@KarthikGajendran May be you can help here.We have 1000+ Items which contains only one variant. For an exampleCURTIS is my Inventory and below are child itemsColor is my variant. Now I want to create a Template Item and assign Template ID to child items When I am creating a template ID, We need to assign a default row and column in the configuration.But I want to update all 1000 + Items only either as default row and column, but system shows two are mandatory, Manually I am marking all other variants marked as not required which allows one default row/coumn as a mandatory and saving the record but I want to implement same steps in the import scenario for 1000+ Items Please assist me how to execute above scenairo in importsHow we are handling Import if we have only one variant?
I have an import scenario based on a GI. The GI is grouped by several key fields, and one of the resulting fields is called ‘State’, which is a count of the number of States that are represented in the data.The GI returns the correct result: But when I attempt to use the resulting value in the Import Scenariothe result is empty.I’ve tried so many work-arounds, but nothing with aggregate fields seems to compute.Is this a bug or a known limitation?
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 want to update vendor classes. I can’t seem to find an action that will override the warning note which I want to set to NO. When I run import below; it has been to confirm if I want to update the vendor settings which is in all cases NO. Any suggestions? Or Which action I should use to answer the”warning”
We have a work center that is being replaced by a new one. They are identical except for the new work center number and description. I need to update all BOM’s that have operations with this work center. I have an existing import that will add a line for the new WC but am looking for a better way to possibly just replace the previous number/description with the new. Can someone give me a bit of guidance with the best way to approach this? Thank you very much.
We’re in the beginning stages of testing order imports from Our test Shopify environment to Acumatica. When attempting to import new orders we’ve started to see an error message when going to Process Data, after the Sales Order has been prepared.: “Another process has updated the 'SOOrder' record. Your changes will be lost.”We haven’t made any changes to the orders that fail versus the orders that don’t fail, and we haven't been able to identify a trend. Any ideas on how to resolve this error so that we can have all orders import properly?
Hello.We would like to know if it is possible to import sales orders via Excel that contain multiple rows per order and use the automatic numbering feature. We have found several topics on this in the community, but none of them have worked for us yet.Any help would be appreciated.Thank you.
Hi,I am trying to import charges under the section called charges-->Lease Space in the Add/View Button. I was able to import the lease first without charges. Then I had to do a second import for the charges and keep getting errors. Here is the error message I keep getting The system failed to commit the ContractDetails row. I have also attached a copy of my import scenario. What am I missing? The client is on 2023 R1. They have the latest Property Management customization loaded. Thanks,Frances
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.
Looking for suggestions or someone to point out what I’m missing. I am attempting to set the Hold flag on BOM’s through an import scenario and it is not working as expected. On the import scenario I am using the Hold from the Bill of Material screen and set it to =True The import processes but it does not place the BOM on hold. Thanks very much.
An error occurred during processing of the field PackageOption: Object reference not set to an instance of an object..
Hello,I am getting an error message during a stock item import. Here is the error message:An error occurred during processing of the field PackageOption: Object reference not set to an instance of an object..I think the issue is with trying to import the package option which should be By Quanity.Any help is appreciated.
Hey Everyone, I know I have the command <Action: Create Shipment> from the Sales Order screen under Order Summary. This in turn generates a dialogue box with two options (Shipment Date and the Warehouse ID).The Warehouse ID will auto-fill properly, but I need to access Shipment Date in the dialogue box as it always picks “today”, which isn’t overly helpful in this scenario. The only options I have for Dialogue boxes seem to be the “OK” and “Cancel” options in the import scenario. Anyone know if/how I can access the date fields through the Dialogue Box before generating the shipment? Thanks in advance,
Hi Experts,I'm working on an import scenario for Journal Transaction Entries and I am getting an error saying the Batch is out balance.I have attached my import scenario for better understanding of issue.Any help would be greatly apricated.Regards,Sweta.
Hello,There might not be a way to do this but I would like to export all of our item classes.I want to use a Vlookup to map the classes to an import of new products.There is not an excel button to export the list, so I am assuming I would need to use an Export Scenario to accomplish this.
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.