BPL5683

I think I just answered my own question. Would I simply print the report from the company contacts then place the "company name" field in the leading grand summary, but then how do I place the company name on the same level as the first contact. duh, -WTF

Q: I have a small contacts database which lists companies I do business with. It has main "Companies" table In another related table I have individual "company contacts". Of course each company has multiple contacts. I use a portal when viewing the contacts on my computer. However, when I want to print out a report listing all the companies and all of their respective contacts I cannot figure out how to list more than just the first contact. Please help, WTF

Well, the way I understand it, every so often a customer will place the order directly with the vendor (if this happens it's almost always a re-order). Yet the vendor, will still give us credit, because we established the customer, and do the leg work. To be more specific what ends up happening in these situations is the rep will go visit the customer sell them on our various lines, and leave them plenty of literature. Sometimes, the vendor catalogs will include the vendor's order forms, and the customers will send in the orders themselves. Luckily most if not all of our vendors are honest folks and will still credit the Rep with the sale because it was within their territory. Hence in this situation we will only get an invoice copy and not the original order. Thanks again.

Wow, Ok, I know some of you guys are professionals and you do this kinda stuff for money. But, if you aren't really interested in helping somebody out (who doesn't really have the money to spend on it) then why bother even responding or acknowledging my post? I just figured with so many experts on here there would be plenty of people who have maybe seen this scenario, and would be willing to point me in the right direction. I'm not asking for a fully made, custom tailored solution, but maybe some simple pointers. Thanks for at least reading through it. And thanks Zcast for your help, I do appreciate it very much.

The commission is not paid out until they receive a check from the vendor for only what was shipped to the customer (in other words the invoice total). The invoice total is sometimes different from the order total (depending on what the vendor is able to ship to the customer), however the actual commission split and the percentages each rep will get are determined when the order is written. At the point when the percentages are first determined the commission amount is only an estimation. However the percentages of the commission will stay on through to the pay out for the reps.

Hello Everybody, I am downright desperate. I need some "Pro Bono" help regarding a solution I'm working on for my father's company. He owns a Manufacturers' Representative firm, and I am having the hardest time building him a working solution The main problem lies in tracking his rep's commissions, and having the ability to split them up if they share a sale. I have created a work flow type of interface, but the data doesn't always seem go through the relationships. Here is a summary: [Customers]----<[Orders]------<[invoices]>--------[Commissions Recieved]--------<[Commissions Payable] To walk you through the process 1.) A customer writes an order with us, that customer usually has a default rep by territory. 2.) Orders are sent to the Manufacturer ( this step is not necessary in the database) a.) At this point it is determined if the commission will be split between two (or more) reps. b.) Part of the commission is also given to the house, to pay for overhead, and expenses 3.) When the order is received by the Manufacturer, it is fulfilled, and sent to the customer. 4.) Once the order is shipped with an Invoice, we receive a copy of the Invoice (usually) and match the Order with the Invoice (Do I need a One to One link here since one order will only have one matched invoice?) a.) I should mention we don't always receive an invoice for our order, or an order for an invoice (but we still get commission). b.) We even receive some invoices scribbled on notebook paper. 5.) The invoices are then compiled by Manufacturer, Where we get a total for the commissions due. a.) Sometimes they send commissions along with Invoice copies b.) Other times only partial payments are made on commissions due. 6.) Reps are payed bi-weekly only what is shipped (the invoice total) to the customers, and only on what is received in commissions in those periods. I have literally been working on this solution for months, and have been racking (possibly frying it) my brain. Currently they rely on custom software that was given and tested on them back in 1999. So it was developed to work in OS 9. Which means the newest OS it will run on is 10.4. thanks to OS 9 virtualization support. Hence the application is very buggy and full of error messages, but somehow it works. The developer had since abandoned the project and was actually hired on by Apple. Any advice you'd be willing to share would be HUGELY appreciated. This is my first database ever, and so far the experience has not been pleasant.