Stockroom.com

That should be easy to do using either Access or Report Writer. Do you have either of those available?

No, I don't. I do have Visual FoxPro though....?

Thanks for the response, David. I'm new to this site, but it looks like you're one of the active posters who is keeping the site going.

This pricing situation is a pain. Looking at the STOCK.DBF file, it seems that the numbers in the "Uncost" never change, and so it's a useless field as far as I can tell, and I don't know why it's there. Then there is "Reordprice," but that also does not reflect the current price. I need the most recent price that an item was received at. As far as I can tell, that would be the last entry for each given item from the INVENTOR.DBF file? I'm not sure how to pull that out... and then of course I'd want it added to a spreadsheet along with pricing that came from both STOCK.DBF and PRICE.DBF (regular and wholesale prices).

That would finally give me the correct data that I need to edit my prices, but then I'll still need to figure out how to get that data properly imported back into MOM.

I am not an IT person... the IT guy I do have is new, busy with other high-priority issues, and not really familiar with the MOM data structure yet (if anybody really does understand all that soup of .DBF files). But it seems like making up a sheet that has costs and prices for each item would be a painfully obvious report that anyone would want, and I don't get why there doesn't seem to be any way of getting that information accurately from MOM.

I guess this should have been its own thread. This was why I signed on today, looking for information on how to handle this data. Surely others have faced this same mess with MOM, and I was hoping there was an easy solution so I didn't have to reinvent the wheel.


Joel

If that feature were available, we would be using it.

As long as it isn't, that might be one reason for us to switch to something else.

Yes, that is done in price.dbf... for each price level, there will be a separate entry in that dbf, with a particular ctype.

e.g. We use "W" in the ctype1 field for our wholesale accounts, and then you would enter a W price in the price.dbf with W in ctype1.

...And then you'll be in the same annoying position I'm in, which is that I don't know an easy way to print up a wholesale price list, or to edit pricing. That's why I logged in to this group today, to see if anyone has a utility for doing that.

Joel
Founder/President, Stockroom.com
(using MOM since 1999)