the purpose of the program is to calculate the average cost of items
the reason why i am not using it from excel sheet because we got inhouse application but his calculations are incorrect
i know the business logic and thats why i displayed it on the excel sheet but i want it to run from the...
Each Transaction i want to record Balance, Average Cost, and Total Cost of Item "using Average Cost"
Meaning
Transaction 1 was 1st transaction on item so the balance after 1st transaction is 5 which is the same balance as the transaction because item balance was zero
-"Balance" Displays the...
For sometime i wanted to create a program to track the transaction History of an Inventory Item with it's Average cost in the a table
For Example
TAC "Total Average Cost"
TTC "Total Transaction Cost"
Item Qty Ucost TTC Acost Balance TAC
x 5 10 50 10 5 50
x 5 12 60 11 10 110
x -2 11...
How could i generate in a report Serial Number
column 1 column 2 column 3
1 record1 record1
2 record2 record2
3 record3 record3
Column 1 is automatically generated and incremented based on the number of records displayed from the table
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.