Newbies zip Posted June 28, 2000 Newbies Share Posted June 28, 2000 Does any one know if this is duable? I have 4 FileMaker db's 1)Invoice 2)LineItem 3)Inventory 4)Customer Items in the inventory db contain products that come in 3 different sizes. Problem The price on the items I sell are different for each customer. I'm attempting to have the invoice automatically give the correct price base on the customer. Any ideas?? Link to comment Share on other sites More sharing options...
ryan93 Posted June 28, 2000 Share Posted June 28, 2000 Here's a thought. This will work if each individual customer has a price increased by the same percent for each product. Give each customer a field called Percent Markup. Make it a lookup field in your line items. Then your cost would have the formula: Cost = Unit Price x (1+Percent Markup Field) Just don't show the Percent Markup Field on your invoice...the customer might get suspicious. That's the thought I had for now. Good Luck! ------------------ Ryan [email protected] Link to comment Share on other sites More sharing options...
ZuperZZ Posted June 29, 2000 Share Posted June 29, 2000 Hi, 1. You need the information of the size in the Customer file. In the Inventory: you have three diferent Records for each size?, or you have each product with the three prices ? I Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8712 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now