HI ALL RESPECTED,
i am using Access 2010 and i am not able to subtract my stock inventory while creating sale invoice.
i am new here with you and i want to know easy way that how can i subtract my stock when i issuing sale invoice?
HI ALL RESPECTED,
i am using Access 2010 and i am not able to subtract my stock inventory while creating sale invoice.
i am new here with you and i want to know easy way that how can i subtract my stock when i issuing sale invoice?
Basically, you shouldn't. Saving aggregate data should be only in exceptional circumstances. Enter transaction records and calculate balances when needed. Review http://allenbrowne.com/AppInventory.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
short answer is you don't - maintaining a current stock quantity as a calculated field is fraught with possible problems.
At it's most basic you should have a table of transactions - stock in, stock out and adjustments. Then current stock is simply the sum of those transactions