Ive been using excel for awhile to create invoices for our customers and although it works I want something a little more cohesive (and friendly to someone other than myself).
I want to create invoices with access but I'm running into a mental road block on how to set up inventory and pricing. We have contracts with our clients that sometimes set a price on an item. So I need a way to set a price on an item per a customer and/or just a generic price (for when a client doesnt have the provision). Also some clients have a set mark up on items, so sometimes they might have a 10% mark up. I need a way of handing all these different situations. Not 100% sure where to start. Is this something I will be able to accomplish? ... Also it would be nice to track inventory so I don't necessarily want different items for each customer, just pricing.
(Im just in the planning phase of this project)
Please HELP
I want to create invoices with access but I'm running into a mental road block on how to set up inventory and pricing. We have contracts with our clients that sometimes set a price on an item. So I need a way to set a price on an item per a customer and/or just a generic price (for when a client doesnt have the provision). Also some clients have a set mark up on items, so sometimes they might have a 10% mark up. I need a way of handing all these different situations. Not 100% sure where to start. Is this something I will be able to accomplish? ... Also it would be nice to track inventory so I don't necessarily want different items for each customer, just pricing.
(Im just in the planning phase of this project)
Please HELP
Invoicing / Inventory
