Clients (a table) can have multiple Orders (Bookings - a Table)
Orders have one Invoice (a Table)?
Invoices can have one | mulitple Payments (a Table)?
Invoice is billed at six weeks (42 days) before Order is delivered?
Unless Order is placed less than six weeks before delivery then is billed immediatedly?
All the above is correct, except that the invoice is always issued on booking to be paid 6wks from that date (deposit) then balance due 6 wks before arrival in resort (normal case scenario) with 40% of the cases being no deposit required instead full payment required before arrival where I set the date.
To give you a better idea, the product we sell is Ski Lessons, 1 client can book anything from 1 lesson to 10 lessons on the same booking and can then come back again a couple of months later to book more on another booking. Some clients will book months in advance, hence the automatic 6wks deposit 50% payment, with balance paid 6 wks before arrival. Where other clients will book a month before they come out, so I will give them 2 wks max to pay the full balance, but this can vary depending on booking date and arrival date.
I have 2 different invoices, one for full booking and one for 50%, which are automatically set to the 6 wks, accessed through buttons on my bookings page, I then have these same invoices duplicated which I can run from a script when needed for a closer date.
Basically I just want to make my life easier, so that I can choose the amount of weeks to pay before arrival, instead of just writing it in or ignoring the automatic one. so it does it automatically once I choose the option and then just stick to the 2 main invoice buttons running the 2 main scripts.
I have been using the old way for a year now, just want to make it more efficient.