I have a scenario where I need to Ship and Invoice a Sales Order via an import scenario. Occasionally I will need Qty Shipped to be different than the Qty on the Sales Order and I also will need to update the unit price on the invoice that is created. This will take 2 import scenarios because the unit price is not available on the shipment form. I have figured out how to get the shipment import scenario working.
However the import scenario I have built for SO303000 is adding a new line to the invoice, not updating the existing one that matches the item.
Any ideas what could be causing that?
Best answer by vkumarView original
Please use following two lines to update existing SO line.
Let me know if this helps.
@Brian Rowerdink Addition to @vkumar still, if you have any queries on the import scenarios, below article will helps you a lot.
I have made progress. I hadn’t change the Source Value to =[Transactions.InventoryID], but once I did in the scenario, it updated the unit price. I just need to confirm the search will work with multiple lines and I noticed it is not updating the Ext price. Should be Qty times Unit price.
You may map the extended price column manually as well if the values are available on import source file.
This is how the column behaves :
If you want to update the extended price automatically to the current value (that is, the applicable sales or default price multiplied by the item quantity), you can use the Recalculate Prices and Discounts action. If you have modified the extended price once and saved the document, the value will not be updated by the system if you change the document date.
Thanks, I have it working now.