Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Import Vendors into Compiere

2005-11-29
2013-05-02
  • Chris Farley
    Chris Farley
    2005-11-29

    In the Business Parntner Import, is there a way to specifically designate imported records as "Vendors" (as opposed to Customers or Employees)? By default, my incoming records are being designated as Customers, and the "Vendors" checkbox is left unchecked. I don't really see any field in the import dialog that would allow me to designate the record as a vendor.

    Alternately, is there a way to change a whole group of already-imported records to a "Vendor"? It would be very laborious to manually change each record by hand!

    Thanks!

     
    • Q Wang
      Q Wang
      2005-12-02

      I had the same needs too. As the column of "IsVendor" was not provided to select as bp importation, I just write a simple sql statement to update the columns as needs, such as "UPDATE C_BPARTNER SET ISVENDOR = 'Y' WHERE AD_CLIENT_ID = 1000000 AND VALUE LIKE 'V%'"...

      Hope this helps.

       
    • James Minney
      James Minney
      2006-01-27

      Alternatively, import your vendors first, and then use SQL to update that field for all the BPartners.  Then import the customers after.  You could import your employees in between (Set isEmployee = 'Y' where IsVendor != 'Y')

      Don't forget also to switch isCustomer off for the people who aren't.