StockLocator

Fermé Publié le il y a 2 ans Paiement à la livraison
Fermé Paiement à la livraison

Utility description

Need a Excel VBA to create and compare a list of stock with location and quantity data, from barcode scanned items in store / warehouse location.

The list will be imported into a stock control program called Unleashed, to update the location & quantity of stock.

The unique field will be the scanned barcode. The user will input a location, and scan the barcodes of the items in that location ( Multiple items, of multiple different types of items can exist at one location). Then repeat the process for another location. The list will be created & updated in excel, and used to Import data to Unleashed.

If stock data is already present in Unleashed, to start the process an export is taken from Unleashed and imported to Excel.

In excel, user will open VBA utility and enter location data in the format of a warehouse code or store code ( see Location examples below ).

Location data entered will be retained and used for subsequent barcodes scanned, until it is changed by the user. Barcodes will be scanned by user, and optionally a quantity entered for each. Excel list will be searched for matching barcode. If not found and quantity data has not been entered, it will be prompted for. The barcode, location and quantity data will be added to the list. If found location data will be updated, quantity data will be overwritten if it has been entered by the user. Quantity data will not be changed if not entered by user. Location data will be updated as follows.

If no existing data is present, the field is populated with location data previously entered by user. If location data is present the data type is compared to that entered. If not found the data is saved. It is prepended to store data if that is present and it is warehouse data. It is appended to warehouse data if that is present, and it is store data. If data is present of the type being entered, the location is updated, without changing data of the other type if that is present. For example, if the location field contains warehouse location data, and warehouse location data has been entered it will be updated, without changing store location if that is present.

Once user completes update of list, it is imported to Unleashed. Overwriting the Unleashed data.

‘Location’ field in excel corresponds to ‘Bin Location’ in Unleashed and can contain two types of data, a warehouse code and a store code. Therefore the combinations for the field are, nothing / warehouse data / store data / warehouse and store data.

Warehouse code format is Ann-Bn-Sn. Store code format is AAA-Gnnn-Sn. If. Both warehouse and store data is present it is recorded in that order with a single space character between.

Excel Visual Basic

Nº du projet : #30095905

À propos du projet

11 propositions Projet à distance Actif il y a 2 ans

11 freelances font une offre moyenne de 357 $ pour ce travail

asin1987

Dear Employer, I am an Excel expert and have delivered over 1000 projects since over a decade now. I have checked your project details and will ensure highly professional delivery. Kindly check my previous reviews he Plus

$500 AUD en 7 jours
(244 Commentaires)
8.1
khushh07

Hello Greetings to you!! I am an Excel (Macro)/Visual Basic expert and interested to work with your project. I have checked your requirements and that makes complete sense to me. I assure you of a high-quality job. Ple Plus

$300 AUD en 3 jours
(319 Commentaires)
7.3
Jayant222

I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to per Plus

$250 AUD en 3 jours
(22 Commentaires)
4.3
ArioNugroho

Hello, From what I understand you want to create an automated form that a user will fill in. These inputs will then be compared to the database from Unleashed, that is exported to excel. If there are any mismatch or m Plus

$300 AUD en 7 jours
(2 Commentaires)
3.0
Wanngming

==== Able to start work right away ==== Hi, bro! I have read your job specification very carefully. I have rich experiences with Excel VBA and Data Proccessing . As a talented and skillful software developer, I am 100 Plus

$250 AUD en 3 jours
(4 Commentaires)
2.4
shaojin

Hello! I have read your requirement carefully, so I am very interested your project. I have rich experience with data processing using Excel VBA in 6 years. I will finish your Excel VBA project in time with high qualit Plus

$250 AUD en 2 jours
(0 Commentaires)
0.0
architbanthia

I possess very good skills in excel. I know each and every formulas of excel and how to use them. I am better at Formatting the Data and Showing it systematically.

$499 AUD en 2 jours
(0 Commentaires)
0.0