TSQL Calc Cost of goods Sold (FIFo,AVG ,LIFO) Sql server 2012

£10-15 GBP / hour

Imefungwa

Imechapishwa

over 5 years ago

£10-15 GBP / hour

I Use Sql server 2012 I have ERP System and I need to calc FIFO,LIFO and Average cost for the inventory Items I have 4 types of transaction 'IN' (Purchase) ,'OUT' Sale ,'INR' Returned Purchase , ''OUTR' for Sales return Database Structure - Items Table ( Has ItemID, And Item Name and Calculation Method ) -Transaction Table (has ItemID,Date,Qty,Price,TransactionCode) I need To calculate the Avg ,Fifo And Lifo after any Update or save in the Transaction table because all data depend on the Transaction Date , for example After Purchase ID ItemID Qty Price TransCode CurrentQty CurrentValue 1 1000 10 10 IN 10 100 2 1000 10 20 IN 20 300 Now Sales with FIFO 3 1000 6 0 Out 14 240 Sales With LIFO 3 1000 6 0 Out 14 180 Sales With Avg 3 1000 6 0 Out 14 210 ----- the Problem Will happen If the Customer Need to Delete the Transaction With ID=1 then I must re Calc All Rows again depend to the change , and this need very fast TSQL Code Please read the article as reference --- [login to view URL] ---- Please download the test data from the [login to view URL] Unzip the file and import the data (consisting of over a million rows) into the Stock table using your method of choice (I used the SQL Server Import Wizard). Run this query SELECT * FROM Stock to view the data Project ID: 17465758

Database Administration

Microsoft SQL Server

Oracle

Software Architecture

SQL

Kitambulisho cha mradi: 18435408

Kuhusu mradi

16 mapendekezo

Mradi wa mbali

Inatumika 5 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

16 wafanyakazi huru wana zabuni kwa wastani £13 GBP/saa kwa kazi hii

@adeeladeel1234

I have extensive experience in database development and financial and inventory domain I can explain this cycle on detail and automate as per your requirements please send me message to discuss

£11 GBP ndani ya siku 30

4.7

(72 hakiki)

6.5

@damianhill40

Hello, I have read your project description and the red gate article linked in it. I think it would be a good idea to build a stored procedure to handle the calculations, this would allow for a high performing calculation script that can be broken down into discrete stages, this approach would allow a new person to come along in the future and be ab,e to understand and so change the script logic quickly and easily. I’d be more than happy to discuss your project with you should you want to proceed with my proposal. Thank you for taking the time to consider my proposal and bid. Regards Damian

£14 GBP ndani ya siku 40

5.0

(8 hakiki)

5.1

@superbpartner

Bedera ya LAO PEOPLE'S DEMOCRATIC REPUBLIC

Hi,dear. I am very interested in your project - 'TSQL Calc Cost of goods Sold (FIFo,AVG ,LIFO) Sql server 2012'. I've already done this kind of project before. I'm a professional programmer with 12 years of experience. If you award me, I'll implement all of your requirements in a short time. Skills: Database Administration, Microsoft SQL Server, Oracle, Software Architecture, SQL

£13 GBP ndani ya siku 1

4.8

(8 hakiki)

5.1

@alyelhaddad

Hi there - I'm Aly, I've seen your post and I'm interested. The raw data you posted is in text format which cannot be imported anywhere, I'd like to have a look over either generated query or the MDB file itself. I'm not sure what exactly did you mean by FIFO and LIFO query, but I'm pretty confident with my SQL Server skills and I believe you can describe the task better. Feel free to contact me so we can talk further. Sincerely, Aly El-Haddad

£15 GBP ndani ya siku 40

4.9

(16 hakiki)

4.8

@Altantsetseg

Hello. From your project declaration, I strongly believe that I can complete this task successfully with your high satisfaction . I have been experienced in programming including MS SQL since 2000. During 2006-2013, I had been working as a senior developer for Financial system developed in MS Access backend database was with MSSQL server. I am quite familiar with your task because I did similar task before. Until now I use Ms SQL server coding and I am experienced extremely. I can develop the coding for your task successfully. Hope to hear from you back soon. Regards, Alta

£15 GBP ndani ya siku 40

4.9

(16 hakiki)

4.9

@sreenivas2903

Hi. Iam expertise in sql server i would like to work o. This and dinish ur requirment if u willing to work ping me

£22 GBP ndani ya siku 10

4.9

(22 hakiki)

4.6

@varshil8060

I am a PL/SQL expert with 9+ years of experience. I can help you write the Stored procedure in Sql server to meet your requirement. I just need to understand the schema of the database tables you have mentioned in the post. Looking forward to get some more details and start the work asap. Await your response

£13 GBP ndani ya siku 20

4.8

(7 hakiki)

4.4

@vw7590795vw

Please message me. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 9.1 years experience in MS SQL Server and 6.4 years experience in SSRS, SSIS (Import / Export). Please let me know more details and when we will start. Sky pe jikenjd

£10 GBP ndani ya siku 16

5.0

(25 hakiki)

4.3

@NoSonforhim

I have 17 years in Database Developing, Programming, Training, and Accounting Solutions / Finance with Computer

£10 GBP ndani ya siku 40

5.0

(5 hakiki)

2.6

@avinpanwar300

Hello , Greetings !!! I just read your Project Description and i m willing to go ahead and start Development on this Project sending FIFO Stock Inventory Problem . I have done this kind of project recently i can give you this Project in real quick time. I have 10 year working experience on multiple Database Project based on MS SQL server, mysql and Oracle. i will work in Strategic milestones and transparency so that you will be frequently uploaded on where we stand in the project i can achieve the result that you are looking . Looking forward to hearing at your earliest convenience. Thank you Avin

£12 GBP ndani ya siku 40

5.0

(2 hakiki)

1.0

@mhedhbi220456

DEVELOPER 2000 ORACLE REPORTS, DEVELOPER 2000 ORACLE FROMS PART II & I and DEVELOPER 2000 PROCEDURES. - ORACLE SQL AND PL/SQL. - DEVELOPER6i, DEVELOPER 9i, DEVELOPER 10G, DEVELOPER 11G

£13 GBP ndani ya siku 40

0.0

(0 hakiki)

0.0

@tvboris4

Alright. That sounds like a cool problem to solve. I'm interested.

£11 GBP ndani ya siku 40

0.0

(0 hakiki)

0.0

@pawand7

hi I have gone through the description of the project requirement and would be glad to assure that I can do well in this project if provided an opportunity. My skill set suits the project requirement and also my keen desire to learn something motivates me to work hard and smart for this project.

£13 GBP ndani ya siku 10

0.0

(0 hakiki)

0.0

@iabello

Working with: Installing and Configuring SQL Server Databases and Storage Planning and Implementing a Backup Strategy Importing and Exporting Data Whit Sql Server Integration Server SSIS Monitoring SQL Server with Notifications and Alerts Performing Database Maintenance, Automating SQL Server Management Managing SQL Server Security T-SQL Querying, Writing Queries,Querying Multiple Tables,Sorting and Filtering Data DML to Modify Data and Built-In Functions Grouping and Aggregating Data, Subqueries,Table Expressions Window Ranking, Offset, and Aggregate Functions Designing, Implementing and Executing Stored Procedures, Views, User-Defined Functions, Tiggers Implementing Error Handling, Transactions Pivoting and Grouping Sets Designing and Implementing Databases and Advanced Table Designs (Partitioning and Compressing) Ensuring Data Integrity Through Constraints, Indexes and Optimized Index Strategies. SSRS Implementing and Configuartion. Managing SSRS Security Design, Programing and Maintenance a wide variety of custom SSRS reports . Implementing data warehouses, and BI tools such as Microsoft SQL Server Reporting Services (2005 or higher)

£13 GBP ndani ya siku 40