I found Amazing FIFO formula from this forum, but when i try to create more SKU, the value is not right...
I found Amazing FIFO formula from this forum, but when i try to create more SKU, the value is not right...
Which result is wrong and which result did you expect?
Last edited by HansDouwe; 12-13-2023 at 11:48 PM.
SKU 101044, i purchase 10 item for 80.000 total 800.000, when i sell it for 2 item, it show the price 215.000 each, did I do something wrong...
The usage formula in column J (column T) only considers the purchages entered on the same line or earlier.
For that reason, the formula in J45 (T45) does not see the corresponding purchage in range E52:G52.
If you enter this usage on line 52 or lower the formulas will work as expected.
Last edited by HansDouwe; 12-14-2023 at 12:44 AM.
oh i see.. thank you...
You are Welcome! Thanks for the feedback and rep . Glad to have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks