By using this website, you agree to our Terms of Use (click here)
Hi All...
I'm trying to update an existing Sales Order Line but it keeps creating a new line instead. I'm utilizing a custom key to find and update the existing line via the Inventory ID. These test Sales Order are very basic with only 1 line.
Can anybody see what I'm doing wrong? I've tried to follow the new 2019 Import Scenario Training Docs to the T with no luck.
Thanks,
Brett
The line that you have highlighted in your screenshot for the Line Number with the value "=-1" needs to be unchecked on the Active box so that it is inactive. Other than that it looks like you have everything set up correctly.
Thanks Brandon. I was trying to follow the example on pg 108 which I believe is supposed to update the PO Line quantities...
https://openuni.acumatica.com/wp-content/uploads/2017/08/I100_Integration_Scenarios_2019R1.pdf
Now that I have the right SO/SO Line selected my ultimate goal is to execute the "PO Link" button and associate the SO to an existing PO. For this I'm trying to follow the example on pg 114. I have added these additional lines to the import scenario. I'm getting "Error: 'LineNbr.' cannot be empty"
I also can't seem to find the equivalent to their command after they have "selected" the line. Maybe it is not need in this case.
Thanks,
Brett
For matching on the line number, isn't page 93 more what you're looking for?
As for the PO LINK button, I've never tried that. Not sure how you would match on the desired line. Not saying it's not possible, I'm just not sure how.
Thanks Tim. I was able to get it to work. In my case I already had the Sales Orders and Purchase Orders imported but needed to "Link" them together as a "Purchase to Order". I knew the Acumatica SO # and the Acumatica PO #. This finds the SO by the Acumatica SO Number (A CO Num) and then finds the correct Sales Order line by Inventory ID (which was sufficient in my case). It then executes the "PO Link" button and associates via the Acumatica PO Number (A PO Num). The part that threw me off was the next to last line of the import scenario. Unlike dialog boxes where you acknowledge BEFORE the event here you execute the Action (PO Link) at the END of the event.
Hope this helps others.
Brett
Wow, this is AWESOME! Thank you so much for sharing this.
Online Members
