Sharing Vendor table

Comments

• Options

  Mitch_Rolsky Member Posts: 7

  2000-02-04

  Do they need to print out seperate financial reports?
  
  I'am not postitive but --- If so, then you'll have to create a field "company" in several tables and add some programimg at various points. Otherwise the you won't be able filter out by company.
  
  good luck

  0
• Options

  Dennis Member Posts: 25

  2000-02-04

  You cannot 'just' change the vendor-table to be company-independent. Think about the related tables that are not company-independent. You would have to make sure that all the information in a related table exists in all companies, or make these tables company independent to, which you cannot do, I don't think it is wise and/or desirable to share invoices, posts etc.
  And what about the number-ranges for the vendor table, sharing this means sharing all numberranges, which you don't want to do.
  
  My point is, it can be done (we have done it several times) but be sure you know what you're doing. Doing it wrong may (and will) cause a lot of trouble!!
  
  Dennis van Es
  PerCom: Research & Development BV
  the Netherlands
  
  [This message has been edited by Dennis (edited 04-02-2000).]

  Dennis van Es
  Qwinsoft BV
  The Netherlands

  0
• Options

  Lars_Westman Member Posts: 116

  2000-02-04

  Hi
  
  We often do lika this. Just be aware that You often ends up opening more tables than just the vendor table. You have to think about the tables with posting groups, postin setup and also the chart of accounts.
  
  Also make sure to change the test when deleting the vendor. There is a test that there is no open entries for the current fiscal year. This test has to be nested in a loop that goes through vendor entries in all companys in the database.
  
  //Lars Westman

  Lars Westman
  http://www.linkedin.com/in/larswestman

  0