Find Jobs
Hire Freelancers

Change inventory to work in FIFO in PHP Order Manager

$30-250 USD

En curso
Publicado hace casi 16 años

$30-250 USD

Pagado a la entrega
We currently have a simple php and mysql software to manage our sales orders. It manages inventory in a very simple way, just add and substract from total quantity When we need to add inventory, we just add the amount to the inventory displayed on screen, and we manually calculate the average cost. What we need is the inventory and cost to work in FIFO, and give option to work in average cost. We need someone to modify the way inventory works so we can view past inventory aditions, substractions, etc. Right now we have a screen where a list of products is displayed, along with its cost, quantity, and price. All of which can be edited. We need that to change to a screen where a list of products is displayed with total quantity available, current cost, and price. When clicked on the product name or row, a new screen is displayed with the inventory batch history. There I should be able to add inventory quantity and cost, view available inventory batch, and past depleted inventory. For example: Product List PID Product Quantity Cost Price 1 USB Memory 1GB 126 $10 $12 [Edit] [Del] 2 Computer Monitor14 $150 $170 [Edit] [Del] 3 Mouse 42 $3 $5 [Edit] [Del] Example of inventory screen: Product: USB Memory 1GB [Add] Date Quantity Available Cost 20/05/2008 100 100 9.8 [Edit] 15/04/2008 50 26 10.0 [Edit] 02/04/2008 90 0 11.0 [Edit] 25/03/2008 -2 0 12.0 [Edit] In this example, the USB Memory 1GB, there are 126 units available, the current FIFO cost is $10. When we look into the inventory history, the units from 02/04/2008 are depleted, now the system is using inventory from 15/04/2008 until they get depleted, the system then will use the 20/05/2008 inventory with $9.8 cost. Notice that in product price is not set in inventory screen, price should be able to be set somehow in the product list. Once a coder is selected, the source code will be given. We accept suggestions or ideas. Thanks.
ID del proyecto: 265025

Información sobre el proyecto

13 propuestas
Proyecto remoto
Activo hace 16 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos

Sobre este cliente

Bandera de MEXICO
Monterrey, Mexico
4,5
3
Forma de pago verificada
Miembro desde feb 7, 2008

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.