Hi All,
We need to copy the data from PurchaseOrderNo field to InvoceNo field, to do that we have set the new values with an update SQL query. (below you can find the query)
UPDATE pod
SET
pod.InvoiceNo= po.purchaseorderno,
pod.InheritPOInvoiceDetail...