I need a database that is setup very similar to the product inventory template in access. I would need a way to show who is creating the entry in the database or some sort of login.
I would need the template modified to show just the main tables of Inventory, Shipping, QA/QC, and Sales. Or if creating from scratch is easier
When a product is ordered from a manufacturer, I would need a form to show name of manufacturer, order date, Qty, unit of measure, unit cost, total price. This would need to be linked to the inventory table.
In the inventory table, I would need fields of invoice #(linked to order form), product name, lot #, Qty, unit of measure, reserved inventory, available inventory (Qty - reserved), Retest date, # of days until retest (Todays date - retest date), Status, and location.
In the shipping table, I would need the following fields. Ship date, customer name, ship to, invoice # (linked to order form), Customer PO#, Product name, Lot #, Qty, unit of measure (linked to inventory), total items, Shipping type, Tracking #, Status. Once product is shipped out, the qty of product available should decrease.
In the QA/QC table, I would need the following fields. Receiving date, product name, qty, unit of measure, total qty. Invoice # (linked to order form). Mfg Tracking #, Lot #, Retest date, Manufacturer name, vendor name, Status, NDC #, Note
Sales table. I would need Sales agent name, Customer name, Customer PO, Order Date, Product name, Quantity, unit of measure. Cost per unit. Total cost
I would need a report that can show real time data of products available in inventory, a report that shows products shipped each day, a report for # of sales per quarter by sales agent","employmentType":["FULL_TIME","PART_TIME","CONTRACTOR","TEMPORARY","PER_DIEM"],"jobLocationType":"TELECOMMUTE","hiringOrganization":{"@type":"Organization","name":"Toogit","sameAs":"https://www.toogit.com/","logo":"https://www.toogit.com/images/toogit_logo_initial.png"},"identifier":{"@type":"PropertyValue","name":"Toogit","value":377185},"skills":["software development"],"applicantLocationRequirements":[{"@type":"Country","name":"IN"},{"@type":"Country","name":"Canada"},{"@type":"Country","name":"USA"},{"@type":"Country","name":"Germany"},{"@type":"Country","name":"Pakistan"},{"@type":"Country","name":"Philippines"},{"@type":"Country","name":"Indonesia"},{"@type":"Country","name":"Sri Lanka"},{"@type":"Country","name":"Nigeria"},{"@type":"Country","name":"China"},{"@type":"Country","name":"Russia"},{"@type":"Country","name":"Bangladesh"}],"validThrough":"2024-10-25T04:40:30+05:30","url":"https://www.toogit.com/freelance-jobs/Mzc3MTg1"}
Remote Network And System Administration Job In IT And Networking
Find more Network And System Administration remote jobs posted recently Worldwide
Work from Anywhere
40 hrs / weekHourly Type
Remote Job$476.87
Cost Looking for help? Checkout our video tutorial
How to search and apply for jobs
How to apply? Do you have more questions about the Job?
See frequently asked questions
Need to enhance the email security. As it has been compromised. Only serious freelancers contact
Hello,
I am a UI/UX designer and looking for a developer (PHP for now) to make some changes in a exiting website. Below are the changes-
- Spacing, fonts, color change
- Change the present logo with a new one(design will be provided)...read more
MUST BE TECH AND PROGRAMMING SAVY AND AN EXPERT AT YOUR CRAFT
I need a developer with expertise in Prestashop Web Development. I am working on website development. I am looking for someone who can work under the guidance of me and my team for backend web development with the given scope of work tasks. Work task...read more
Im in need a a graphic and text logo design for new company! Experience with design for apparel and merchandise logo design would be great!