So I'm trying to figure out the best structure for this scenario:
We have products, which we manufacture and sell.
We sell these products at multiple price points (distributor, wholesale, retail, and custom price points for certain customers).
I'm trying to figure out how I could have multiple price sheets, linked somehow with products.
Realistically, we can get away with price sheets being a separate table and not linked in with anything, but I feel like that makes adding it to the DB redundant.
If it could be linked, the idea would be that when quoting or "invoicing"* we could select the price sheet which would then populate the cost based on the product we select.
I thought I almost figured it out but then it fizzled into a pile of 'not going to work'.
*we do our actual invoicing in an accounting software, but setting up pseudo-invoicing would be beneficial as it could act as a packing slip as well as an invoice displaying our product by the pack or carton instead of individual unit.
Hi Julian
That's what I had a vague idea of in my head. Good to know I'm on the right track.
I'll update this thread with my results to benefit anyone else wanting to do the same.
I am having to check if all of what we want to do can be done with netsuite though, as we are hoping to have it implemented to allow for an account system that can be used globally.
edited to amend
Looking at netsuite, it may suite our needs, but there's a chance it wont be approved so going forward I'm going to go ahead with Ninox as both an on-boarding process and contingency plan in case net suite doesn't happen for a while.