Products cost
$30-250 USD
Betalades vid leverans
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.
Projekt-id: #18356790
About the project
5 frilansare har lagt bud på i genomsnitt $162 för det här jobbet
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 Mer
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 Mer
Products cost I have an excellent background as a web developer. there are some question related to project. Want to discuss in detail.
Hi, I work doing things like that, with 2 years of experiences in T-SQL and I will do my best