By using this website, you agree to our Terms of Use (click here)
I am trying to create an Import Scenario for RC SO Type and trying to add mappings for Add Invoice Popup. I am not able to do it and have no clue what the error is. Below is the screenshot of my mappings. Any help on this?
Import-Scenarios-20180911-1.xlsx
To start with try using "Add Invoice Details " or "Add Invoice Details -> DocType" in the target object. and adding whichever fields you need in the field /action name.
I just tried and failed. I think my trouble is with the Dialog Answer which doesn't have ADD & CLOSE as an option:
Hi All,
We with colleague spent a good deal of time to crack this question but finally, we made workable IS to deal with 'Add Invoice' pop-up.
Please find it in the attachment.
Hi,
I am attempting to create an import scenario for sales order CM type record referencing an original invoice. I found this and it seems to be exactly what I needed, but when I create it I get an error 'system failed to commit the document row'. I thought I followed your steps but I must be missing something. Also, this is being run on 2018 R2. do you think that makes a difference?
Import-Scenarios-20200218.xlsx
Thank you for any assistance you can provide.
Thanks for sharing Nazar!
I was just able to get this to work in my Acumatica 2019 R2 (19.203.0042) environment, but it only imported the 1st line:
I submitted this into Acumatica support also and they have escalated it to the dev team.
I'm going to commit the cardinal sin of Thread Necro here, but it seems I've hit on this specific scenario but am experiencing an error I've never seen before, and I'm looking for thoughts. I created my scenario independent of this, but seeing the above example inspired confidence that I'm heading down the correct path. My objective is injecting the lines via the "Add Invoice" dialogue, for which I am matching PO records against the Customer Order Number field and targeting the specific line by keying against invoicesplits.inventoryID. Unlike the example above, this throws the following error:
The table schema of the InvoiceSplits table was not found in the cache. The table is locked by another process. Please try again later.
Walking through the process as a human works fine, so I'm not entirely sure how to make sense of if in this context.
Scenario:
