#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
|
|||
|
|||
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
|
|||
|
|||
Post your workbook for review.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
inventory database | unk51 | Excel Programming | 1 | 11-24-2014 10:38 PM |
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 |
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 |