Kontakt- E-Mail- Adresse:klste@hotmail.de

 

Commons program inventory management based on an Excel file 756 article VBA programming

Examples in pictures

 

1 Name (Leather chairs) and unit (pieces) is awarded the article 1001

 

2 Input of 200 leather chairs is posted. Total $4000 (invoice ER-1)

 

3 Discount of $21 (document GU-1) is posted

 

4 Obtained from 2 leather chairs (article 1001)

 

5 Table view of account 1001

 

6 All accounting records are entered in the journal

 

7 Table view of collection license 1

 

8 Obtained from 3 leather chairs (article 1001)

 

9 Last posting record is deleted

 

10 Everything is deleted

 

 

Commons program inventory management based on an Excel file 756 article VBA programming
 
 
It is well suited to a small camp or a private collection. The operation is pretty simple and self explanatory. The approaches and outputs per article with date display are booked on a form, the current inventory is displayed one after each booking.
 
The most important advantages at a glance:
Comfortable entry of records on a form
65528 Entry sets per a year
756 Article number
Failure audit
Incorrect entries can be easily removed
With a few mouse clicks delete all entries
Automatically posts the removal in the creation of the collection note
 
Free hard disk space 30 MB