Companies
The implications for using a single table for both the vendors and customers is minimal. The reference number simply uses CMP##### instead of VEN##### and CUS#####, since a company can be both a vendor and a customer.
The time where we need to filter out the companies between vendor and customers occurs at the Purchase Order and Sales Order layouts. Those lists are built to show only the correct subset of the company records. That is, the Purchase Order list will only display vendors and the Sales Order list will only display customers.
This list separation also occurs when assigning a vendor to an item as well as on a Return Order.
Copy link