Stocktaking/inventory
Hi there,
Sure it can be done but how?
This very common job takes at least two tables : one with a list of items and one with the inventory lines (very much like the invoice examples less the customers table) with a link in between those two.
Does it necessarily want a third table called "inventory", of which the "inventorylines" would be a composition (sub-table)?
The purpose would then be to import a csv file - only with codes and quantities - in the sub-table (or otherwise) - in order to have an immediate total value of the stock showing the description (and prices of course) picked up in the list of items.
Thank you
2 replies
-
Can you post a sample DB?
-
I have written many stock-taking programs over the years. I have yet to perfect it (maybe this year?).
Can you let me know
Is it a single site
Do you have Bins?
Do you have Batches?
Is your stock collated into cases and/or pallets?
Regards John
Content aside
- 13 days agoLast active
- 2Replies
- 32Views
-
3
Following