Inventory is EndInv = BegInv + Purch - Sales.
The general method of doing it is to create an inventory table with ItemNos, Qty, and Date. Generally you only update that table periodically, typically the end of the month. During the month, you create a query making that calculation creating a virtual inventory. Then, at the end of the month, append the EndInv as the BegInv for the next month. Be sure to have a method to make manual adjustments; damages, returns, loss (theft), etc.
For dates, in the Inventory table, I use YYMM, e.g., 1501 for Jan, 1502 for Feb.
I'm not one of the MVPs, but can send you some query formulas/SQL statements later.
Adam
__._,_.___
Posted by: runuphillracing@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar