Forum Discussion
Map invoice and receipt on FIFO basis
Hi, i am attaching a sample data below, in which i have amounts in Positive as Invoices raised and Negative Values as Amount received, now i want to map receipts against invoice documents on FIFO bas...
Now I've understood half of it. I still have 2 problems. You have a transposed number. In your table the value is -162594, in your description you write -162954. In addition, the value 225525 does not appear in your table.
Honestly, that's too high for me. I'm not an accountant. I also wouldn't know how to implement this with Excel. I'm not smart enough for that.
dscheikey
those are my typo errors,
Also, you are very talented, i saw your previous above formula, which was complicated itself.
I know this is very complicated, i also tried on the same, but you tried and gave your time to it, i am thankful for that.
those are my typo errors,
Also, you are very talented, i saw your previous above formula, which was complicated itself.
I know this is very complicated, i also tried on the same, but you tried and gave your time to it, i am thankful for that.