|
-
Oct 20th, 2018, 03:27 PM
#3
Re: First In, First Out subtraction from rows?
 Originally Posted by Zvoni
Hmmm, reminds of the "net-worth"-calculation we have in the company i work for.
Basically, we do it as follows:
Each stock-location/item has its net-worth in a separate field beside the stock-quantity.
To stay in your example: as long as we ship quantity from stock location "a" it's calculated according to the cost of that stock location (and subsequently subtracted from that stock-location).
Meaning: A general total-"average" is calculated during runtime in realtime
Care to share an example?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|