Inventory management system in MS Access needed
Required skills: Data Entry, eBay, Excel, Inventory Management, Microsoft Access
I need a complete inventory management system in MS access. It should be multi-user..
Following features are required:
BASIC STOCK SYSTEM
- Holds product information e.g. SKU, details, cost, size/weight code
- Shows quantity of stock items
- Offers easy addition of new products
- Offers easy addition and deduction of units of stock
To allow easy lookup of our products all in one location which can be accessed by multiple users simultaneously.
STOCK NOTIFICATION
- Ability to set a ‘Re-order’ level stock quantity.
- Tickboxes for each product (upto 3) for which sales channel the item is to be sold on.
- ‘Re-Order’ notification. Send an email to the person responsible for the sales channel(s) the item is to be sold on, to advise reorder of product is needed.
- ‘Out of Stock’ notification. Send an email to the person responsible for the sales channel(s) the item is to be sold on, to advise stock is at zero.
- ‘Review Product’ notification. . Send an email to the person responsible for the sales channel(s) the item is to be sold on, when a set number of days have passed since the stock figure last changed.
Feature will stop products being over-sold, will improve the way re-ordering is handled, and will advise seller that a price adjustment may be necessary on old stock.
STOCK TRACKING
- Ability to set and show the quantity of a product in the system which is
o ‘unpacked, unavailable for sale’
o ‘packed, unavailable for sale’ or
o ‘packed, available for sale’
This will enable us to determine where the product is in our building and whether it is ‘active’
SALES MARGIN CALCULATOR (FOR EACH SALES CHANNEL)
- Deducting tax, product cost and variable costs (adjustable formula) from suggested sale price to give product profit/loss and margin.
This will help us set our price and know how viable it is to stock/sell this product. Since products may be sold at different prices on different sales channels.
STOCK COSTINGS TABLE
- Holds cost calculations for a product (accessory costs, packing cost, sales channel costs) to give true cost of product
We can talk further in detail via pm..
Thanks
Following features are required:
BASIC STOCK SYSTEM
- Holds product information e.g. SKU, details, cost, size/weight code
- Shows quantity of stock items
- Offers easy addition of new products
- Offers easy addition and deduction of units of stock
To allow easy lookup of our products all in one location which can be accessed by multiple users simultaneously.
STOCK NOTIFICATION
- Ability to set a ‘Re-order’ level stock quantity.
- Tickboxes for each product (upto 3) for which sales channel the item is to be sold on.
- ‘Re-Order’ notification. Send an email to the person responsible for the sales channel(s) the item is to be sold on, to advise reorder of product is needed.
- ‘Out of Stock’ notification. Send an email to the person responsible for the sales channel(s) the item is to be sold on, to advise stock is at zero.
- ‘Review Product’ notification. . Send an email to the person responsible for the sales channel(s) the item is to be sold on, when a set number of days have passed since the stock figure last changed.
Feature will stop products being over-sold, will improve the way re-ordering is handled, and will advise seller that a price adjustment may be necessary on old stock.
STOCK TRACKING
- Ability to set and show the quantity of a product in the system which is
o ‘unpacked, unavailable for sale’
o ‘packed, unavailable for sale’ or
o ‘packed, available for sale’
This will enable us to determine where the product is in our building and whether it is ‘active’
SALES MARGIN CALCULATOR (FOR EACH SALES CHANNEL)
- Deducting tax, product cost and variable costs (adjustable formula) from suggested sale price to give product profit/loss and margin.
This will help us set our price and know how viable it is to stock/sell this product. Since products may be sold at different prices on different sales channels.
STOCK COSTINGS TABLE
- Holds cost calculations for a product (accessory costs, packing cost, sales channel costs) to give true cost of product
We can talk further in detail via pm..
Thanks
Posted In:Data EntryExceleBayInventory ManagementMicrosoft Access |
Related projects:
Need an inventory management system in open source
system.
-Cost of goods sold calculations when scanning out inventory
-Ability to scan inout inventory by barcode
-Open database so that it can be integrated into other software in the future.
Features that would be nice
-Safety stock calculation based on lead times
-Forecasting abilities
-Web based
Ps : i need it in open source it's mean i buy copyrigth too (it's include in price of project)
-Cost of goods sold calculations when scanning out inventory
-Ability to scan inout inventory by barcode
-Open database so that it can be integrated into other software in the future.
Features that would be nice
-Safety stock calculation based on lead times
-Forecasting abilities
-Web based
Ps : i need it in open source it's mean i buy copyrigth too (it's include in price of project)
POS & Inventory Management System Upgraded
his number can be used for any number of times)
Latest Upgrade Info: I have added two more modules to the software, one, for entering employee information and other for entering expenses information. Then I have utilised these two information to calculate net sales and net profit for a company or a business entity. These two buttons with names: “Employee Form” and “Expenses Form” can be found at the bottom of the main form: “Form1”.
Latest Upgrade Info: I have added two more modules to the software, one, for entering employee information and other for entering expenses information. Then I have utilised these two information to calculate net sales and net profit for a company or a business entity. These two buttons with names: “Employee Form” and “Expenses Form” can be found at the bottom of the main form: “Form1”.
Ms Access 2007 Query Help Needed
f data for that particular year.
2. Indicator should be set to Yes if AVGSALES for that record is >=200 and the month is in between July and December irrespective of the year.
You can write this in two, three, four etc. steps. And add columns to the table if needed. The queries will be called from a macro that will be executed on the press of a button - just FYI.
Can chat and answer any questions you have once I have selected you for the project.
2. Indicator should be set to Yes if AVGSALES for that record is >=200 and the month is in between July and December irrespective of the year.
You can write this in two, three, four etc. steps. And add columns to the table if needed. The queries will be called from a macro that will be executed on the press of a button - just FYI.
Can chat and answer any questions you have once I have selected you for the project.
Client Management System
We are running a company we change motor oil of different vehicles. We need following records to show up on due date.
1. Vehicle engine oil expiry date.
2. Confirmation call to client.
3. Next oil change date.
4. Bill to client.
5. Address/Phone Book
6. Ledgers of clients.
7. Promotion handling.
Please bid if you have experience in MS Access. We need front end and back end both in MS Access 2007.
Happy bidding
1. Vehicle engine oil expiry date.
2. Confirmation call to client.
3. Next oil change date.
4. Bill to client.
5. Address/Phone Book
6. Ledgers of clients.
7. Promotion handling.
Please bid if you have experience in MS Access. We need front end and back end both in MS Access 2007.
Happy bidding
Batch Update In Ms Access 2010
:
I have two MS Access 2010 tables in the same database. There is a UPC code in both table A and table B. Table A contains an ingredients column with data in it. I need to access the data in Table A and then find the same UPC code in table B and update the Ingredients field in it. Table A contains several thousand records, so this query needs to be able to loop.
I need to know how to run this update inside MS Access (using the tools in it)
pays US $ 20
I have two MS Access 2010 tables in the same database. There is a UPC code in both table A and table B. Table A contains an ingredients column with data in it. I need to access the data in Table A and then find the same UPC code in table B and update the Ingredients field in it. Table A contains several thousand records, so this query needs to be able to loop.
I need to know how to run this update inside MS Access (using the tools in it)
pays US $ 20
Shopping Cart Inventory Management System Ebay Amazon
proposed solution along with your bid. Please state why your proposed solution is the best solution. Please also provide examples other shopping carts / ecommerce sites that you have setup.
I also need help in finding the best Fedex.com discount for Ground shipping.
I also need help in finding the best Fedex.com discount for Ground shipping.
Ecommerce with backend inventory management and Google SEO
align=right style="padding-left: 20px; width: 320px">
Additional files submitted: (Files are only available for logged in users)
Device+Lease.pdf
Additional files submitted: (Files are only available for logged in users)
Device+Lease.pdf
E-Com site upgrade and Create Inventory Management System
hould have option of selecting items for discounts/promotions. Items on discount/promotions should be marked as such on each item. I.e. if the item is reduced by 20%, then item should show original price with a strike across it and then the new price.
* Future expansion - database should have option of expansion in future to accommodate other variables in product i.e. colour, size, gender.
* Future expansion - database should have option of expansion in future to accommodate other variables in product i.e. colour, size, gender.
Ms Access Development
inning bidder the icons and a copy of the database with the user password to be able to look at the full capabilities of the system.
Some enhancements to the software are attached. If there are some things for example that you do not have the capability of doing, just let me know and we can work around that. I am looking for a cost effective solution.
Please when you respond, tell me about your MS Access experience. This needs to be developed in MS Access 2007.
Some enhancements to the software are attached. If there are some things for example that you do not have the capability of doing, just let me know and we can work around that. I am looking for a cost effective solution.
Please when you respond, tell me about your MS Access experience. This needs to be developed in MS Access 2007.
Help With Ms Access Set Up
load my raw files in MS Access (2007) and create queries that will combine A and B.
I need to create 4 different queries and I currently have the formulas in Excel only.
So, the winner of this project will have to guide me how to set-up the database in Access 2007, write the queries and show me how to modify them when/where needed.
How to set up everything, to have Access update the existing database based on the updated A and B files?
Thank you.
I need to create 4 different queries and I currently have the formulas in Excel only.
So, the winner of this project will have to guide me how to set-up the database in Access 2007, write the queries and show me how to modify them when/where needed.
How to set up everything, to have Access update the existing database based on the updated A and B files?
Thank you.
Application for Project Management- PHP, MySQL, Tables have been defined in MS Access by aicsystemes
Need a Modular application for Project Management. Define project tasks, schedule them, create Gantt-type chart, export into Excel format. Future modules will be done at a later time, including GIS. All tables have been defined in MS Access. If interested, please contact me on PM, I will send you: detailed description+ MS Access file+ Excel format. Thanks
Need Inventory Management system already completed by colmbyrne
********
MUST BE ALREADY COMPLETED !!!!!!!!!!!!
***********
Your reply should be something like this.
"We have a fully developed inventory management system completed in C# and SQL 2005" We can set up a time for you to review the system in an online meeting. We have all the source code. This is a mult-tier system.,.." etc.
Don't tell me you can build it. We need one already completed/
MUST BE ALREADY COMPLETED !!!!!!!!!!!!
***********
Your reply should be something like this.
"We have a fully developed inventory management system completed in C# and SQL 2005" We can set up a time for you to review the system in an online meeting. We have all the source code. This is a mult-tier system.,.." etc.
Don't tell me you can build it. We need one already completed/
Ms Access Expert
you know what you are doing.
I've spent hours waiting for people to complete this job only for them to admit they can't do it.
I cannot mess around with this. I must watch you working on teamviewer so that I know you know what you are doing!!!!!!!!!!!!!
If you can do this, there will be more work.
If you apply for this job and cannot do it I will leave negative feedback.
You must have skype and teamviewer and be available for work NOW.
I've spent hours waiting for people to complete this job only for them to admit they can't do it.
I cannot mess around with this. I must watch you working on teamviewer so that I know you know what you are doing!!!!!!!!!!!!!
If you can do this, there will be more work.
If you apply for this job and cannot do it I will leave negative feedback.
You must have skype and teamviewer and be available for work NOW.
Inventory management system
mall retail stores are facing strong competition from organized retail stores and supermarkets due to the FDI in retail industry in India. These stores have limited working capital to run the business. In order to survive the competition and retain the customers, they need to utilize the capital available to them in an efficient manner. These stores invest more on products than any other resources to run the business. Kirana stores h
Ms Access Accounting Project / Web
Need an accounting database made; fairly complex - can be updated by any other user with access; stored data online; could even enter data online and or offline.
Would like it built in MS Access.
Please demonstrate your ability in PMB but dont spam me a long list of your achievements, personal messages are preferred!
Would like it built in MS Access.
Please demonstrate your ability in PMB but dont spam me a long list of your achievements, personal messages are preferred!
Develope simple forms in MS Access
and the Projects details.
I have already created the tables for this applicaiton. I need someone to help me with the below
1. Designing the form layout and field validations
2. Getting the querry right
3. Add Macro actions to the forms
4. Add one derived field in the form. The derived field should be a combination of 3 other fields.
I have already created the tables for this applicaiton. I need someone to help me with the below
1. Designing the form layout and field validations
2. Getting the querry right
3. Add Macro actions to the forms
4. Add one derived field in the form. The derived field should be a combination of 3 other fields.
Ms Access Report Help
y and reporting.!!
In attached mdb results table contains mid marks of all subjects of students. I want to show these Nos in a style that subject name will become column heading or label and all the nos under his relevant heading.
The requirement is highlighted in the report with yellow color. It can be achieved by cross tab query, sub query or sub report & it is not more than 10-15 minutes assignment. I have developed everything only this minor part is remaining.
In attached mdb results table contains mid marks of all subjects of students. I want to show these Nos in a style that subject name will become column heading or label and all the nos under his relevant heading.
The requirement is highlighted in the report with yellow color. It can be achieved by cross tab query, sub query or sub report & it is not more than 10-15 minutes assignment. I have developed everything only this minor part is remaining.
Worksheets/Reports in MS Access 2007
/>
Additional information submitted: 11/11/2010 at 20:02 EST:
Bid above $ 50 will not be accepted.
"Please add $ 50 so that I should know its not a fake bid"
Additional information submitted: 11/11/2010 at 20:02 EST:
Bid above $ 50 will not be accepted.
"Please add $ 50 so that I should know its not a fake bid"
Inventory Management System
Please see attached information for details. Need to build a customized inventory management system. Prefer it be built in PHP and MYSQL. Site will be available to employees only. Also requires storage of photos and very interested in Ebay, PayPal, Amazon integration options.
Ms Access Dbase
I need to have someone build a very simple dbase for me in MS Access
it will have a basic 5-7 fields and should be user friendly and searchable by the same fields.
it will have a basic 5-7 fields and should be user friendly and searchable by the same fields.
