1. Home
  2. Point-Of-Sale Software
  3. A Few Questions

A Few Questions

1) Is there a way to print out a profit margin report ONLY for items that have been "last received" on any given day. I would like to change my pricing based upun cost and be able to check that for items that I have received that day.

2) My store has over 9000 sku's...is there a way to set up the system so that items cannot ring out for less than cost? For new items I am entering "lower bound pricing", but for the thousands of old items....is there a way to set it up automatically for all of them without going to each individual item and entering the cost?

Thanks for your help!

Reply to
Lance
Loading thread data ...

You could use a query to set LowerBound to Cost (or Cost +/* X).

I think the query would look like this: UPDATE Item SET PriceLowerBound = Cost WHERE LowerBound < Cost

I tried this with ...WHERE ID = X for a single item and it worked.

Backup your database before you run any query.

HTH, Tom

Reply to
Terrible Tom

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.