Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-23-2017, 03:31 AM
mag8524 mag8524 is offline Invoice to inventory Windows 7 64bit Invoice to inventory Office 2016
Novice
Invoice to inventory
 
Join Date: Nov 2017
Posts: 1
mag8524 is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 11-23-2017, 07:33 AM
ArviLaanemets ArviLaanemets is offline Invoice to inventory Windows 8 Invoice to inventory Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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.
Reply With Quote
  #3  
Old 11-23-2017, 01:12 PM
Logit Logit is offline Invoice to inventory Windows 10 Invoice to inventory Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Post your workbook for review.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
inventory database unk51 Excel Programming 1 11-24-2014 10:38 PM
Invoice to inventory Inventory smart sheet Iraj Excel 5 10-01-2013 04:11 PM
I need help with keeping an inventory organized w/ WORD or Excel? CeltFan09 Excel 2 05-04-2011 05:46 PM
Invoice to inventory Help with Inventory-Job on the line Folks prokf Excel 1 03-11-2011 11:20 AM
I need help with keeping an inventory organized w/ WORD CeltFan09 Word 1 01-31-2011 06:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft