Can I use SmartConnect to update the quantities on a SOP line item? My idea is to use something like an Excel spreadsheet or an InfoPath form to allow the users to update the Qty to Invoice and Qty Fulfilled fields without having to go into the sales orders.
As a test, I created the InfoPath form and have the data passing back into GP through SmartConnect -- but it very rarely updates the quantities of the line item. If there are previously invoiced quantities, it does not work -- it just doesn't do anything. Only if the quantity ordered and the quantity to back order fields equal does it actually do the allocation and fulfillment.
Is something like this possible? Or is this something that eConnect can't do?
Thanks.
-Joe
*This post is locked for comments