Re: [MS_AccessPros] Table approach for Inventory database

 

Bill-

In any Inventory applications I've built, I don't let the user touch the "stock" at all.  They have to fill out an order for items to be removed from stock and the "post" the order to get it filled and subtracted from inventory.  To put in additional "stock", they have to fill out a Purchase Order, then mark the items received and "post" that to add to inventory.  No worries about + or - numbers because they have to fill out two completely different documents to add to or subtract from inventory.

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On May 25, 2017, at 6:55 PM, 'Bill Singer' Bill.Singer@at-group.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I am in the process of designing on paper a simple inventory database that will track inventory coming in and going out as well as calculating a balance.  I am confused as to how to design the part of the table that will actually keep track of the numerical transactions.   Do I use two quantity columns and run it like a check book with debits and credits or should I use one column and use positive numbers and negative numbers.  My fear is that someone will forget to put in a negative number when they are withdrawing inventory and then the balance will be off.   I checked the sample database that comes with Access and they use only one column.

 

Your thoughts are appreciated.

 

Bill

Minnesota

Access 2016

 

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___