Products cost

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

I have a view contains all items movements (In/Out transactions) and i want to calculate item cost for each item based on method of calculation (Avg. cost, FIFO, LIFO). I need my end result to be like the following:

ItemID | Date | Transaction Type | Qty In | Qty Out | Unit Price | Total Amount | Remaining Qty | Remaining Cost

Items Table has field identify cost method (1= Avg. Cost, 2= FIFO, 3= LIFO)

based on cost calculation method result should be changed for each item.

The last two fields (Remaining Qty and Remaining Cost) should be calculate with each record.

Microsoft SQL Server

Project ID: #18356790

About the project

5 proposals Remote project Active 5 years ago

5 freelancers are bidding on average $162 for this job

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. Please let me know more details and when we will start. Sky pe jiken More

$250 USD in 1 day
(13 Reviews)
3.9
dipakmoliya

Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you have a view contains all items movements (In/Out transactions) and I want to calculate item cost for each item based on t More

$200 USD in 10 days
(2 Reviews)
2.3
topithub

Products cost I have an excellent background as a web developer. there are some question related to project. Want to discuss in detail.

$155 USD in 3 days
(0 Reviews)
0.0
Juan10123

Hi, I work doing things like that, with 2 years of experiences in T-SQL and I will do my best

$166 USD in 1 day
(0 Reviews)
0.0