Development of an automated Google Sheet for inventory accounting
100 USD It is necessary to develop a Google Sheet with automation for inventory accounting. The sheet should contain filters, color formatting for easy searching and navigation, as well as a detailed development instruction so that changes can be made in the future.
1) There should be 3 sheets:
- PRODUCT LIST: this will contain a list of all products by categories. The following fields should be included: CATEGORY, NAME, ARTICLE, SERIAL NUMBER.
- STATUS CHANGE: this should display all changes related to the product. The following fields should be included: DATE, STATUS CHANGE, CATEGORY, NAME, ARTICLE, SERIAL NUMBER (if necessary), QUANTITY, COMMENT.
- WAREHOUSE: this will contain the entire list of products and their quantities. The following fields should be included: CATEGORY, NAME, ARTICLE, SERIAL NUMBER (if necessary), WAREHOUSE, RESERVE, EXPECTED, REPAIR, APPROVAL, REPLACEMENT, TEST, GIFT, SOLD.
2) First, the PRODUCT LIST sheet is filled in with all products categorized by categories, names, and articles. A separate checkbox is placed in the SERIAL NUMBER field (the serial number itself is not specified, as it varies for each unit of product. This will be needed later for entry in the STATUS CHANGE and WAREHOUSE sheets).
3) All products and their quantities are entered into the WAREHOUSE using the STATUS CHANGE (the WAREHOUSE sheet is locked for manual entry, all data must automatically come from the STATUS CHANGE):
- in the DATE field, the date is entered, format – day.month.year.
- in the STATUS CHANGE field (you may suggest a better solution for this point), it indicates FROM à TO:
- FROM à TO: the corresponding quantity of product is subtracted from FROM, and added to TO on the WAREHOUSE sheet. For example, FROM selects WAREHOUSE, TO selects SOLD – the corresponding quantity of product will be subtracted from the WAREHOUSE field on the WAREHOUSE sheet and added to the SOLD field.
There may simply be a receipt of new products, then nothing is specified in the FROM tab, and in the TO field, WAREHOUSE is indicated, and the corresponding quantity of product is added to the WAREHOUSE field on the WAREHOUSE sheet.
- in the CATEGORY field, all product categories are pulled (in a dropdown list) from the PRODUCT LIST sheet.
- in the NAME field (in a dropdown list), all products of the selected category are pulled.
- in the ARTICLE field, the article of the selected product automatically appears from the PRODUCT LIST sheet. It should also work the other way around: if the article of the product is entered directly, the CATEGORY and NAME fields are automatically filled.
- in the SERIAL NUMBER field, the serial number of a specific unit of product is indicated, but only for those products where the corresponding checkbox is checked in the SERIAL NUMBER field on the PRODUCT LIST sheet. At the same time, the serial number is indicated for EACH unit, meaning if a certain unit of product has multiple pieces received or sold, each piece must have its own serial number. Serial numbers must also be stored so that they can be indicated during sale. It is also desirable to somehow automate this process, so that if a certain product comes in 10 pieces, it is not necessary to specify separately 10 lines for 1 piece each with different serial numbers, but rather 1 line, but with serial numbers for each of the 10 pieces (possibly hidden separately).
- in the QUANTITY field, the number of products is indicated.
- the COMMENT field is optional.
Client's review of cooperation with Artem K.
Development of an automated Google Sheet for inventory accountingEverything is great. The performer quickly got in touch and made the necessary adjustments. I am satisfied with the work and look forward to further collaboration!
Freelancer's review of cooperation with Vladislav D.
Development of an automated Google Sheet for inventory accountingPleasant, reliable, attentive client. Thank you, Vladislav, for your understanding and cooperation. I recommend!
-
4 days134 USD
402 4 days134 USD
Good morning, Bohdan!
The task is clear, however, there are still a few questions regarding the specifications that we can discuss when agreeing on the terms.
It won't be cheap, but we will set up automation to avoid costs in the future.
I have worked with WMS multiple times, I can send examples in personal correspondence, for further communication - please contact me.
Thank you.
-
5 days111 USD
492 1 0 5 days111 USD
Hello. I can create the template as per the provided description. The completion time is within 5 days. If you accept the proposal, I suggest we have an online meeting to discuss all the requirements, then I will take 3-4 days to complete it (I am allowing some extra time, it might be sooner) and we will meet again online, I will show you the finished template, if there are any comments and something needs to be adjusted, I will take another day for the adjustments. If everything is okay, then I will send you the template and you will make the payment.
-
1 day134 USD
267 1 day134 USD
I propose to establish proper inventory accounting based on a modern standard software product. I have been engaged in accounting automation for 30 years and I know for sure that after struggling with spreadsheets, you will turn to automation based on accounting software. I suggest saving your energy and time.
-
14 days95 USD
957 19 0 14 days95 USD
Good day.
I have experience with similar projects. I will implement everything as conveniently and automated as possible.
To start, I would do it according to the specifications you described. After that, we can make adjustments according to your wishes.
I indicate the duration of execution along with all adjustments.
-
7 days89 USD
287 7 days89 USD
Good day. I would be happy to try to complete your task, I have created tables and databases, and I have ideas on how to trigger the status change with a dialog window for comfortable data entry.
-
7 days44 USD
166 7 days44 USD
"I am ready to complete your task quickly and efficiently, I have extensive experience in this field."
-
Winning proposal7 days100 USD
2242 35 0 Winning proposal7 days100 USD
Good day, I have experience with about ten completed projects related to inventory accounting. I will propose an optimal solution. Feel free to contact me.
-
5 days45 USD
204 2 0 5 days45 USD
Good day!
Of course, I can pile up a lot of text about how great I am, but...
But the truth is that a normal working table is something in between the whims of the client and the experience of the developer.
And this certainly does not negate the fact that in the end we get a result that you will like.
P.S. Regarding the deadlines, it is likely that it will take a little more time.
-
3 days67 USD
419 13 0 3 days67 USD
Hello!
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
Hello.
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
… Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
-
4 days134 USD
4461 102 0 4 days134 USD
Good evening. I will be happy to help. I will complete everything quickly and efficiently.
-
На что только не готовы люди, абы не разбираться как вести учет.
-
цирк и бред
-
Current freelance projects in the category Databases & SQL
Database parsing
45 USD
Channel requirements: 1. Content language: Russian or Ukrainian (mixed RU/UA content is allowed) 2. Number of subscribers: At least 500 subscribers 3. Activity: The last post published no later than 32 hours ago 4. Comments: Comments must be open under the posts (through a group… Databases & SQL, Data Parsing ∙ 1 day 5 hours back ∙ 29 proposals |
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 4 days 8 hours back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 5 days 1 hour back ∙ 10 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 5 days 19 hours back ∙ 92 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 5 days 22 hours back ∙ 18 proposals |
Ukraine