| klste@hotmail.de |
Here everyone can create this program themselves.
The heading Create yourself warehouse management program in Excel VBA with article images and integrated supplier customer database and picture are two links to the homepage page with list of 527 links to YouTube movies.
The 527 YouTube movies describe how the program is created.
All VBA code are located on page Link to the Page with code warehouse with databases and, if description is a code, simply mark the code, copy and paste in Excel file in the right place.
Before inserting the code you should make the line spacing as small as possible in a Word document.
This program has room for 1260 article numbers, 2047 storage bins, 100,000 booking records, 2000 withdrawal notes, 50,000 customer accounts and 3,000 supplier accounts. In the program each article is stored under its own subscription price, stored under a uniform average price and outsourced at its own subscription price.
Warehouse Management Program in Excel with item images and integrated supplier customer database.
With the program, you can 1260 manage article number 2047 campsites, 1 year make 1048010 booking rates, create approximately 25.000 withdrawal slips, and produce up to 40 positions in each sampling license.
6000 is the supplier accounts, highest number of which is the needs created or deleted. The supplier accounts are integrated in the program, in each posting record access or removal, should be, of which suppliers are the articles involved in the booking record. The integration allows conducting a detailed statistics and each time to find any article in the camp.
1047997 is the customer accounts, highest number of which is the needs created or deleted. The customer accounts are integrated in the program, if removal is recorded, to stand, to which customers, delivered the articles involved in the booking record, which enables a sales statistics for each customer to lead.
The program manages the stocks a year. After the end of the year, with button "change year" all booking records in the land and in all article and storage accounts are deleted and current opening balance on all articles and storage accounts, recorded.
Stock program inventory with pictures. Images in Excel VBA.
This program is an Excel file with VBA code programmed. About user an input mask is done in the program.
The input mask is not large and contains no unnecessary controls.
Using this program, you can easily manage a warehouse with 4095 articles.
The program can store a maximum of 3 images for each article and displaying the stored images in various lists and accounts.
In each article account can all article master data (product code, name, unit, storage location, category...) any change.
Input - output for each article is simply updated and current inventory for each posting automatically calculated.
The program can easily evaluate the entire stock to three main concepts: storage location, category, condition. The main concepts of storage location and category can have up to 100 keywords. The State has only 3 search terms.