Splitting percentages of payments

[s_cameron]

I am developing a db for our web design/hosting company.

Here's the dillema. I have three databases. vc_client, vc_billing and vc_server. All of the revenues for design are straight forward. However, we have two people providing hardware for servers. We have a seperate agreement with each one. Each one receives 30% of all revenues collected for hosting ONLY for clients hosted on their respective server.

Am I completely confusing you yet? ;-)

In the vc_billing db, I have a field for each server that I enter the amount the client has committed to for hosting on a monthly basis. For instance, if I am serving your web site on server1, I will enter 50.00 into the server1 field. If I am hosting you on server2, I will enter 50.00 into the server2 field.

Now, here's what I need to have happen. I would like to have that monthly amount automatically post to a new_charges field also in the vc_billing db on the 14th of each month so I can generate current invoices on the 15th

Next, when I post a payment into post_payment from a client in the vc_billing db for hosting, I need to have 30% of the hosting fees post to the vc_server db in a field called host_revenues that is automatically routed to the appropriate servers record. And yes, each server is assigned a server ID.

This 30% needs to be figured off of the static monthly amount , not total payment posted as there may be design fees in a payment posted.

Would it be easier to have two payment posted fields? One for hosting and one for design?

I may be making this way more difficult than it needs to be. I am just beginning to wrap my mind around the power of FMP and appreciate your patience with this soon-to-not-be-a-beginner developer!

Cheers! Stephanie Cameron

[BobWeaver]

Having gone through something similar recently, I suggest that you create two records for the payments to the vc_server db, one for 30% to one server and one for 70% to the other. If you try to do this with two fields and one record, you will likely find it difficult to work with the data.

[Fitch]

Rather than entering an amount in server1 or server2, it seems like it would be simpler to have just a single field for amount, and another field for serverNumber. That way, you could easily break out payments for a given server by number.

[s_cameron]

Told you I thought I was making it WAY too complicated!!

Thanks for the help. I think your suggestions are what I needed to get past this sticking point.

Back to the trenches ...

Stephanie