One of the modules of my program contains an inventory, which is like a place for storing raw materials, each with a specific price, however, you may have two or more entries for the same material, with different price. I want a way so that when for example i want to withdraw 50 units of a specific material, and i have 60 units in stock, but 40 of which were prices $20 and the remaining 20 were priced say $10, i want the program to tell me that the transaction went as follows: 40 from the ones priced at $20 and 10 from the ones priced at $10. Is there a way to do this? i am using access but SQL solutions are also welcome.
Question
abohmeed
Dear all
One of the modules of my program contains an inventory, which is like a place for storing raw materials, each with a specific price, however, you may have two or more entries for the same material, with different price. I want a way so that when for example i want to withdraw 50 units of a specific material, and i have 60 units in stock, but 40 of which were prices $20 and the remaining 20 were priced say $10, i want the program to tell me that the transaction went as follows: 40 from the ones priced at $20 and 10 from the ones priced at $10. Is there a way to do this? i am using access but SQL solutions are also welcome.
Thanks a lot in advance
Link to comment
Share on other sites
2 answers to this question
Recommended Posts