Software (include version): Ancora, DocStar IDC, Epicor IDC


Use Case: populate vendor id based on vendor name


Customer: N/A


Prerequisites: N/A


Instructions:

  1. This formula goes in Vendor ID field

    1. SQLEXEC(STRJOIN("select [VendorID] from dbo.PIF_Vendor where [VendorName] ='",FT_VENDOR_ERP, "'"))


Helpful Links: N/A