SeedCode Support Forum

This is mostly a database design question but since I'm using Seedcode I thought I'd ask here.

We email virtually all our invoices and monthly statements as pdfs. They seem to have a strange habit of going unpaid if they don't reach the right person
Some companies use a generic address like mail@ or accounts@, some companies use the email account that belongs to a contact like eric@, glenda@

My potential solutions are;
1. add a billing email address to the Companies table
2. add a tag to the accounts contact

Because our accounting is not handled by Seedcode I like to have the billing email print on our hard copy project sheets. It helps keep that vital piece of information synchronised between the accounts desk and the coal face. This is easy to achieve using solution 1, but the Companies table is so minimal I'm reluctant to add any unnecessary detail if I don't have to.

I actually haven't begun to think how it might work with solution 2.

Perhaps there's another solution I haven't thought of...

Hey Robert,

I appreciate your reluctance to add fields when you don't have to, but this is a fact about the company and I don't see a downside to this save that you may not know how to address the email: [email protected] doesn't let you know if that is "David" or "Dianna".

So tagging a contact as the billing contact might be nicer. A relationship from Companies to Contacts based on the company ID and the "billing contact" tag would get the email address AND contact's name etc. into the company context so you could show it on project sheets, etc.