Hi, I need someone proficient in VBA who can build me a few Macros for an inventory stocktake sheet. I already have an activex combo box which generates a new entry every time I select a name from a drop down list. Now I need three things. 1. I need a button so that once the user inputs data (stock out, stock in etc), a confirmation pops up asking
Trying to make our stock takes more user friendly and efficient by moving away from pens and paper and using a small webapp which update the main sheet on the fly to allow the inventory manager to see live results and send teams back to count locations where there may be a miscount or gap in quantities. Please my budget is not massive and i have found a way to use google sheets however I would rat...
I Need a very simple android application I want to use to create, edit and email a simple .CSV and .TXT file Please see attached example of CSV and TXT file and PDF on basic functions on the application, The first column is barcode and the second is QTY It must automatically save to google drive and also email to an email address we specify in the setup file
I have some work, in an Excel spreadsheet. Hello , we are currently undertaking a stocktake in our retail store , all barcodes are being recorded and will be exported to excel. There is approximately 200 different products lines and in total 15,000 items. What we are looking for is a price to search and find all the same matching barcodes and give a
Daily Stocktake for in/out Stocktake of Transfer orders (Warehouse to site / vice versa) Transfer order to be of custom format to accommodate print requirement Inventory database to be automatically updated for each transfer order with "Submit" button
Filemaker Pro app design for inventory / loan out. Needs to store: Customer Information Product Information (Description, Material, Type, Photographs, Condition, Asset ID, Barcode) Have functionality to: Search for Items Hire Out Products to our Customers Print Reports (Product Report and Hire Report) Book Products Back into Stock
...progress (e.g. 75 from 100 counted | 75% done) - Collaborate with multiple users on the same stocktake - Record full (whole bottle) and partial counts. For the latter, a screen-slider will be used as per the wireframes. - Save, submit, and send a stocktake when done. - View historical stocktakes Longer term goals/features include placing orders
Hi we are after someone that can reconcile our handwritten data that we too when we did a stocktake and cost everything back to our buy price table to work out the value of stock we had on hand. Everything is written in English and some is written in a very easy shorthand The stock take sheets are about 57 sheets with 24 lines per page. Project
...the Kanban limits (min, max, and trigger) and then there needs to be a form to update/add products, a form to update/add kanban details, and a form to perform the actual stocktake which is where each day you simply enter the number of pallets or products that are physically on hand. once completed you can generate a production report which tells
Small Android Application: - Stocktake/inventory using barcode scanning - Price lookup/scanning application Data is coming from internally-hosted Web Services.
...preparing a first cut of the materials (i.e. Country Paper, Presentation Slides) for use during the Conference. Deliverables by the next 3 weeks include: i. Provide a historic stocktake on past national productivity efforts/policies and how these contributed to the economic growth of Singapore ii. Research on recent productivity and innovation-related policies
...Quick access to condiments • Customisable visual layout REPORTING -------------------- 20+ types of reports • Daily Sales • Product Sales • Shift/End of Day • Stocktake • Custom Reports • Anytime overview of revenues • Match your chart of accounts • Caters for bookkeeping • Expedite BAS lodgement • Email direct or ...
...files are returns the difference. The first file is the original stock file, that includes item code, barcode, quantity and expiry and the second file is the stocktake file received from the stocktake machine that includes barcode, quantity and expiry. The application needs to look at the new file and finds rows with same barcode and same expiry and merge
Currently to calculate the cost percentage for a job, there is a requirement for a lot of multiple entries. We want to streamline that process and use the Stocktake Management System to do that for us. We will provide the right candidate with all the required source code, formulas and database structure. Please see the attached scope document for detailed
...storing/saving key documents - Ability to set tasks for particular members - Mobile compatibility - Online payment of fees - Basic inventory for canteen stock - NOT online sales of stock, but able to keep track of stock in/stock out and generate list to do stocktake against. This does not all need to be developed at once, but may be done in
Stocktake and ordering mobile application that uses non-native React/Redux/PhoneGap stack. Must support integration with Bluetooth barcode scanners. Will integrate with existing POS REST API specs.
...repeatable; this means either a Excel Macro or exe There are two spreadsheets : BoatTemplate and Stocktake with Itemcode. BoatTemplate has the information I need to copy to other spreadsheets in column H - R. BoatTemplate also has the VBA Code in module. Stocktake with Itemcode spreadsheet is only provided for reference purposes as linked to BoatTemplate
...15 or so key clients. -Time sheets need to be blocked out for them to edit but can see there past and present weeks earning -Inventory to be updated on materials used, stocktake and restocking function I have tried a number of apps but yet to find something that I was happy with the best one was Trello, I almost had job cards getting created and
...materials and booking of installers within a linked gannt chart which collectively recognises a bill of materials to be ordered with estimated pricing. - to maintain a inventory stocktake and have alerts and reminders for required orders - to generate Po for approval - to use calender and linked email - to add notes and attachments to job for system design
I need you to develop some software for me. I would like this software to be developed for Windows . Need a smartsheet expert to: Build a workflow system for my installation business. The system would have a master spreadsheet which would have differing rows and columns accessable to differing business roles. Each role and person would have a username
...Android App to meet our company’s needs. The repository for the app can be found here: [login to view URL] There are 2 main parts to this project Part A This is just a rebrand of the app. - All visual references to ODK need to be changed to our name (there are not many) - Branding image logo to be changed to ours (app icon, app
...changes across the rest of the tabs There will be multiple tabs that use this product listing for staff to input against and have history Stocktake Sales Product Costings Based on Sales and Stocktake then calculate how many weeks stock we have and what is low Orders placed We have a rough draft but the main issue is the updating of the list
I am a pharmacy manager, i own Windows mobile device for stocktake And our software is sql server db And i want to make software on the windows mobile to can stocktake quantity even box or strip by device , and convert data to text file (item code , quantity ) Also the other hand export from the pc The last db with quantities
I have started building a website, however i am over my head technically. I am creating a website that will assist in simplifying stocktake. I have hosting package already and am looking for someone to finish the website and make it more secure. I have started writing this site in php using mysql however it is very basic at the time. I would also
We want to improve our end of day cash out procedures at our 4 locations. 1. A smartsheet that ...each location at a specified time each day. The managers enter data , smart sheet collates and our accountant approves. 2. Retail stock take from each location combining stocktake information into a centralised database that can be checked weekly.
I need to make 5 excel sheets talk together to create a stock control system for a small manuf...components) So when we fill and package the finished product this sheet will subtract from sheet 2 and sheet 4 Sheet 5 is a Snapshot so this sheet should give us a total stocktake number and then an stock number for sheet 1, sheet 2, sheet 3 and sheet 4
I would like to move my list of items from an excel spreadsheet to a webpage I can access to perform an inventory audit/stocktake at multiple locations at multiple sites. There is roughly 150-200 items that we audit and replace regularly at different client sites. So what I need is: - Easy to navigate webpage that I can customise to the client
The website and backend are built with custom PHP code. The Following is what needs to be completed in 2 hours. Stock Module - Add download Excel Spread sheet for stocktake Users Module: - Check spelling – incorrect - In this module please add a column which shows us which users have signed up for which offers in regards to using the sliders
we are looking for someone that can design a app for stocktaking this will be used to keep track of our tools on job site and where they are located the app needs to be designed so the user can do a stocktake and send through to the office for recording basically needs to be a checklist that gets stored on a database not sure the best way for this
Hi I would like a small program written that can be maybe used on a handheld scanner . all the requirements i need are in this link to a similar program. ...can be maybe used on a handheld scanner . all the requirements i need are in this link to a similar program. [login to view URL] Mini Stocktake Pro
... View past sales. Email invoices to customers. Apply discounts to sales if the customer selected is a trade customer. Inventory: Add/view/edit/delete stock items. Stocktake Category List Multi item add/edit/delete Record waste Purchasing Discounts Customers: Add/view/edit/delete customers. Send email to customers Expenses: Add/view/edit/delete
...go to a website, etc. PLEASE SEE ATTACHMENT FOR MORE DETAIL ON WHAT I NEED. Please note, the actual barcode scanning code is complete (uses the zBar free SDK) and the app code that i currently have will be given to the chosen person to use as a base. I need this code modified to do the following: Connect to a locally hosted .NET web service
...contains a master list of all ingredients we use. There are three stocktake lists that are made up from some of these ingredients in the master list. In the master list, we need to be able to check a box for an ingredient and have that ingredient turn up into the A, B or C stocktake list (with all the associated cells, the price, the 'in bulk' quantity
Input payroll data and process payroll reports and post journals Enter stocktake figures Bank Reconciliations GL Reconciliations Input invoices/ Receive goods into stock system Prepare and post general journals Prepare accounts for review by Financial Controller
...for me to update. Things such as adding a size/colour/option feature to my store listings, adding a new menu to my website, adding a "view all" type feature that helps with stocktake, adding an extra field to the listings, fixing a few bugs, a few minor changes to the layout etc. The site must show up well in both PC format and phone format. The site is
Our Business need's a spreadsheet made up to enable us to do a scanning stocktake. As you can see from the picture provided we will be pasteing in our stock list with the columns provided. We will be using a scanner to scan serial numbers once the serial number is found in the serial number column we would like it to select the whole column that
STOCKTAKE HAS BEEN MANUALLY COMPLETED AND RECORDED IN HANDWRITING (EASILY READABLE), STAFF ARE AWAY FROM WORK UNWELL. PROJECT REQUIRES APPROXIMATELY 2-3 HOURS OF DATA ENTRY FROM THE SCANNED STOCKTAKE (WHICH WILL BE PROVIDED), THE DATA NEEDS TO BE RECORDED IN A SPREADSHEET. THERE IS APPROXIMATELY 430 PRODUCTS AND 3 DATA FIELDS PER PRODUCT (NAME
...Create accurate customer invoices and match to all job costs • Automatic reminders via letter, email or SMS • Mechanic diary • Mechanic job costing • Parts inventory and stocktake • Create repair orders • Automated kit creation • Barcoding for parts and services • Quotations • Management reports • Sales reports • Inventory...