visual integrator - update old sales order based on customer po number

SOLVED

Using Visual Integrator, how can i prevent the importing of a Sales Orrder, and make it update an old sales order instead, if the PO number of the currently importing Sales Order is the same as the PO number of an old sales order?

Parents Reply
  • 0 in reply to iateadonut
    SUGGESTED

    That warning is an SO Option to find duplicate customer PO and not a feature of VI.  If you want to update an SO by VI, you need to feed that SO number into VI. 

    Using an MS Access query (like BigLouie suggests) is one option.  An Excel query and VLOOKUP is another.  I've also scripted an ODBC lookup to edit a CSV with such a value as an extra column.

    If you want to pay a master developer / providex programmer to do something with Perform logic, that might be feasible, but those kinds of things can be expensive.

Children
No Data