Share via

Northwind Traders Template: How is 'on hand' Inventory (Goods) updated?

Anonymous
2019-05-23T15:03:38+00:00

I have downloaded the template, and imported the structure / objects into a new database for my small eBay business.

Most things have been figured-out, but inventory is causing me headaches!

  • I already own all my inventory, so Purchase Orders are not going to be used
  • I have copied this structure to a new 'Inventory Adjustments' form, so I can add inventory to my database, BUT -

   THIS FORM IS NOT AFFECTING THE 'ON HAND' TOTALS FOR MY PRODUCTS.

Suggestions / help would be greatly appreciated...yes, I'm not well versed in Access.

Thanks!

Cary C.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-05-23T21:02:39+00:00

    To add to what ScottG said:

    Even with inventory you own, you still must add it to your inventory. This servers as your baseline inventory (your starting point), and you then add and subtract to this. If you look at the Inventory Transactions table in Northwinds, you'll see a Transaction Type column. The "Purchased" type would be incoming inventory (of one sort), and that's how you'd add your current inventory to your new system.

    If you look at the design of the Inventory Query, you'll see all the items needed to properly determine inventory counts in Northwinds. Note this is a somewhat primitive inventory system. Most have quite a few more working parts, like Returned items, short shipped items, etc etc.

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments
  2. ScottGem 68,820 Reputation points Volunteer Moderator
    2019-05-23T18:45:56+00:00

    Hi Cary, I'm an independent advisor and will try to help.

    On Hand inventory should be calculated on the fly, not stored. As I recall, Northwinds uses an order detail table to record transactions of outgoing items. You need to use the Purchase Order function to add items to inventory. On Hand is then calculated with a query that adds all the incoming transactions and subtracts the outgoing transactions.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments