• Registered: 2020-05-22
  • Posts: 31

Topic: Inventory help

Hi to all,
I was wondering if I'am able to create some simple inventory with production report,
So I would build database with all info I need (name, code, supplier....) but I want to add work order for example coffee...

Here is sample:
1. Database with coffee brand, coffe price, coffee supplier, sugar supplier, price.... milk supplier, price

For one coffee I need 0.01kg of coffe, 0.01kg of sugar, and milkm cookies and some more items are optional

I want to create document work order for 100 coffees with all data of price, brand, extras to print

Thank You in advance

  • Registered: 2020-05-22
  • Posts: 31

Re: Inventory help

Just to clarify little more

I have database with all info on stock of "RawGoods" (name, supplier, price....)

Work order document would have to decrease size of stock of raw goods for amount entered in work order document and to give new product in new database "Products"

3 Reply by CDB (edited by CDB 2020-05-26 10:37:03)

  • CDB
  • Member
  • Offline
  • Registered: 2019-12-16
  • Posts: 370

Re: Inventory help

There are two projects somewhere  on here that might help you on your way,


Look for POSCALC  and STORE2020.  Unfortunately I can't recall the poster of either of these, but the topic for 2020 was back in March of this year.


Found 2020 http://myvisualdatabase.com/forum/viewtopic.php?id=6077

On a clear disk you can seek forever
  • Registered: 2020-05-22
  • Posts: 31

Re: Inventory help

Thank You CDB
Almost what I needed but I can see where to go next

It would be perfect if I could add more than one product per sale