Hello
Project: Access 2003 or 2007 (I'm using Office Spanish Version)
You must develop it with VBA code and must remain open for possible future changes.
The project aims to determine the balance at the end of each month of the stock (stock of goods).
It starts from two tables.
In table 1 will have the photo to a specific date of the composition of the stock. The fields will be as follows:
1) Date
2) Codart
3) Type (f / D)
4) Store
5) Quantity
In table 2 you will see the movement of inputs and outputs to date and document. The fields you see are:
1) date
2) doc
3) codart
4) type (F / D)
5) Store
6) Quantity
Based on the balance at a date to be obtained from Table1, you should reach the balance at the end of each previous month, with movements that are obtained from Table 2.
See attached examples.
Scrow Payment
Thanks