0

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

null
    • Fred
    • 13 days ago
    • Reported - view

    Can you post a sample DB?

    • John_Halls
    • 13 days ago
    • Reported - view

    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