ACCESS Databse design

En curso Publicado Dec 30, 2010 Pagado a la entrega
En curso Pagado a la entrega

I have a warehouse inventory datbase and need somebody to do FIFO Inventory Calculation Formula on this datbase . I so I can show the result on my ASP website for my client . NO form design . The data Result should be either on queries or another tables .

Here is more explanation :

I have a inventory database which Containes 4 tables with ItemNo or I PrdtID as a related field between these 4 tables

1- Inbound

1a -Inbound Itemized

Inbound table has Container number and Date it received

Inbound Itemized table has the ItemNo Field and the quantity received , This itemNo. can be few different Items that received to our warehouse in one date and then there is the outbound

2- OutBound which has the order number and ship date

2a-OutboundItmized which has the ItemNo and QTY and dates that shipped ..

the shipment of the item nu. can be in different data until the QTY of that Item number from that container is reachd ZERO balance which in my website will be disapear as been shiped and is out of the picture

I want to make a query or procedure that show me the balance of that Item number in same query or differeny query and carry in forward for next order for that ItemNO .

I hope I could get my point across

Sample databses is attached . This is just a sample I will send the actual database later

Microsoft Access

Nº del proyecto: #898670

Sobre el proyecto

28 propuestas Proyecto remoto Activo Jan 12, 2011

28 freelancers están ofertando un promedio de $360 por este trabajo

kulhanekd

I would like to bid. Donna

$500 USD en 15 días
(34 comentarios)
5.8
frehmanpk

Respected Sir, Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Looking forward to your prompt reply. Kindest regards.

$250 USD en 0 días
(14 comentarios)
4.4
kemlatak

I do understand the FIFO concept. There is no problem with the incoming stock as per incoming recorded based on date/time. The complex would be on outgoing stock, as user sees a complete stock, and the units would be d Más

$500 USD en 3 días
(2 comentarios)
4.3
mrbrave

Ready to start now...

$320 USD en 4 días
(7 comentarios)
4.0
davidt999

Hi! I can do this for you. Please see PMB for a sample of my work. Thanks! David

$250 USD en 5 días
(6 comentarios)
3.9
VenturSum

Please see my PM. I've 15 years exp developing Access and Excel applications. Further I have my MBA with a Finance concentration.

$275 USD en 2 días
(1 comentario)
2.5
muthumuni

Hi Sir! I am expert on this project. Please see my personal massage. Thank you!

$250 USD en 3 días
(1 comentario)
2.0
yvayse01

check pm for details

$250 USD en 3 días
(0 comentarios)
0.0
Ali1966

**** I can do this for you today.... ie NOW FOR 150 DOLLARS ***** I have already done it I am an access database specialist.

$250 USD en 0 días
(0 comentarios)
2.8
gvyshnya

I will be pleased to apply my 14+ year experience with VBA/Access programming and ERP/WMS implementations to help you with the FIFO implementation for your warehouse database. Please see more details in PM.

$500 USD en 3 días
(0 comentarios)
0.0
sushilck

Will do this

$500 USD en 10 días
(0 comentarios)
0.0
etogether

Know well access date.

$255 USD en 3 días
(0 comentarios)
0.0
engsmagdy

10 years experience in DB analysis, Design in Stock control, financial systems.

$400 USD en 4 días
(0 comentarios)
0.0
zxchubs

Bid detail: 300 USD in 2 working days

$300 USD en 3 días
(0 comentarios)
0.0
muhammadibaad

Sir, Plz see your PMB for more detail.

$260 USD en 20 días
(0 comentarios)
0.0
salman1978

I will do this using my 10 years experience in this field in 15 days along with documentation and code.

$500 USD en 15 días
(0 comentarios)
0.0
mithuprogrammer

Hello Sir, I am ready to start immediately to complete the task. Please see PMB for details.

$250 USD en 2 días
(0 comentarios)
0.0
hemantgautam

I am from India, working with windows, sql server, access, vb6, vb.net,C, C#, Crystal Reports, foxpro since 1994, I have developed many projects like inventory, accounting, payroll, hotel management, School Fees Coll Más

$700 USD en 20 días
(0 comentarios)
0.0
kajavaid

I am an expert Inventory Analyst as well as a professional VB and MS Access programmer. I am quite confident that I can handle this job with complete understanding of the business as well as technical requirements.

$250 USD en 4 días
(0 comentarios)
0.0
wasginc

hello sir how are you i am ready to start work on your project

$250 USD en 10 días
(0 comentarios)
0.0