Master data: who you deal with
Customers and vendors are master records — the people and businesses you sell to and buy from. In AWRA every sale, invoice, payment, purchase order, and return links back to one of these records. Get the master data right and the rest of the system has someone to attach activity to; get it wrong and history scatters across duplicates.
A master record is created once and reused everywhere. That single source is why a customer’s full history — orders, invoices, payments, returns — can be seen in one place rather than reconstructed.
Decide a naming convention before you start loading records, because it is the cheapest fix now and the most painful later. Pick one form — say, registered business name first (“Jambo Hardware Ltd”), not the contact person — so “Jambo Hardware”, “J. Hardware”, and “Mary at Jambo” don’t become three records for one customer. The convention is what lets the next person find the existing record instead of creating a fourth.
Key takeaways
- Customers and vendors are reusable master records.
- Every transaction links back to a customer or vendor record.
- One clean record per party keeps history together, not scattered.
- Agree a naming convention up front (business name, not contact person) so the same party is always found, never re-created.