| klste@hotmail.de |
Manage and control the issue and return of materials, tools and machines in Excel VBA
In this program, each tool or material receives its own Inventory_Article No. and its own invoice. The program has room for 2000 accounts.
An employee picks up a tool or material, this is recorded as Issuance Inventory_Article No., after use, the employee returns the tool or unused material, this is recorded as Return Inventory_Article No.
Newly purchased tools or materials are included in the program as an Inventory Increase. Lost or broken tools and used materials are removed from the program as Stock Reduction.
The program has room for 1000 Personal No. accounts and 1000 Warehouse No. accounts.
When data is entered, entries are made in the accounts involved and in the journal. Log entries create a better overview of the management and issuance-refund process.
An example of how the program works.
The employee receives a drill and 500 screws. After completing the work, the employee returned the drill and 100 unused screws.
For drills, an account is created Inventory_Article No.: New Inventory_Article No. - Dr1, Designation - Drill, Unit of measurement - pieces (pcs).
For screws, an account is created Inventory_Article No.: New Inventory_Article No. - Scr1, Designation - Screw, Unit of measurement - pieces (pcs).
Two Warehouse No. accounts are created: Wa1 and Wa2.
An account is created Personal No.: New Personal No. - Pn1, Surname - S1, First name - Fn1.
2 drills are entered into the program as an Inventory Increase. They are stored in storage bin Wa1.
1000 screws are entered into the program as an Inventory Increase. They are stored in storage bin Wa2.
The employee receives 1 drill. This is recorded as Issuance Inventory_Article No.
The employee receives 500 screws. This is recorded as Issuance Inventory_Article No.
Employee returns 1 drill. This is recorded as Return Inventory_Article No.
Employee returns 100 unused screws. This is recorded as Return Inventory_Article No.
400 screws used by employees are removed from the program as Stock Reduction.
The width of all columns in the list is automatically adjusted to the length of the entered data.
If something is deleted or cleaned in the program, a password is requested, the password is always the number 3.
If the "List" or “Journal" checkbox becomes active, you can double-click the left mouse button to select each line in the list and display it in input fields of the same color as the list.