ACCESS Databse design
$250-750 USD
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
Nº del proyecto: #898670
Sobre el proyecto
28 freelancers están ofertando un promedio de $360 por este trabajo
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.
Please see my PM. I've 15 years exp developing Access and Excel applications. Further I have my MBA with a Finance concentration.
**** I can do this for you today.... ie NOW FOR 150 DOLLARS ***** I have already done it I am an access database specialist.
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.
I will do this using my 10 years experience in this field in 15 days along with documentation and code.
Hello Sir, I am ready to start immediately to complete the task. Please see PMB for details.
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
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.