- Multiple branch locations, such as individual retail locations with a central billing location.
- Trace sales reports that show the End Users to which goods are shipping.
- Design house that uses contract manufacturers in their OEM products.
For these case, the Account Number being used by the manufacturer doesn't track to the location within the Rep Agencies territory, or necessarily to the same sales rep as might be assigned the main billing location. It is, of course, important to get the correct location and correct sales rep for each Invoice, especially in cases where bonuses or split commissions are paid based on those sales.
Make Them Unique
Example 1: Account Number (not unique) + Customer Name + City
Given that you have some columns that describe the customer, such as parts of the address, some name for the location, and possibly a non-unique account number that you are trying to work from, combine those parts into a unique whole. The formula you would might look like this:
10000 Burn Seat
10000 Carm Camb
Don't Use Them
What to Do?