Products cost

Lukket Opslået 5 år siden Betalt ved levering
Lukket Betalt ved levering

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

Projekt ID: #18356790

Om projektet

5 bud Remote projekt Aktiv 5 år siden

5 freelancere byder i gennemsnit $162 timen for dette 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 Flere

$250 USD på 1 dag
(13 bedømmelser)
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 Flere

$200 USD in 10 dage
(2 bedømmelser)
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 dage
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
0.0