Microsoft Office Forums Invoice to inventory
 Register FAQ Search Today's Posts Mark Forums Read

#1
11-23-2017, 03:31 AM
 mag8524 Windows 7 64bit Office 2016 Novice Join Date: Nov 2017 Posts: 1
Invoice to inventory

I have created an invoice and an inventory to keep track of my stock. The problem is when i start a new invoice the numbers in the inventory go back to 0. For example: i have ten items in stock a customer buys 2 and 8 are left. When a new customer comes and buys another 1 the total is 9 instead of 7. How to keep the entries from the previous invoice and go on from there?
#2
11-23-2017, 07:33 AM
 ArviLaanemets Windows 8 Office 2016 Expert Join Date: May 2017 Posts: 564

Keep track of movements, not of inventory. I.e. you have all incoming quantities and amounts as positive values and all outgoing quantities and amounts as negative values.

To calculate current quantity of article in stock, you sum all quantities for this article - same for monetary amount for article in stock.

To calculate the quantity (and amount) of article at given date, you sum all quantites/amounts for this article with movement date <= this given date.

To calculate the balance for given period, you calculate quantity/amount at end of period and deduce the quantity/amount before start of period.
#3
11-23-2017, 01:12 PM
 Logit Windows 10 Office 2007 Expert Join Date: Jan 2017 Posts: 307

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post unk51 Excel Programming 1 11-24-2014 10:38 PM Iraj Excel 5 10-01-2013 04:11 PM CeltFan09 Excel 2 05-04-2011 05:46 PM prokf Excel 1 03-11-2011 11:20 AM CeltFan09 Word 1 01-31-2011 06:44 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:17 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top