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...
I'm sorry. I don't understand it. Maybe you could explain what FIFO is first. I would have translated it as First in First out. Is that correct? Why does position number 9 exist twice? Once positive and once negative? What do you mean mapping? Number 9 is -400000 in the first List! Please explain the logic of your comparison in more detail.
Hi dscheikey,
So in first case Positive amount is 737429 and its document no. is 1.
Now we want to adjust negative amount with positive amount on First in First out basis.
So, the 1st negative value is of 400000 and its corresponding document number is 6, so it 1st mapped against 737429
Now remaining positive balance is (737429-400000) 337429, the second negative value is of 162954, which is now mapped against 737429, but in 2nd line with its document number and date.
After adjustment of above balance amount is (737429-400000-162954) 174475, the next negative amount is of 400000, but the maximum adjustment can be made up to 174475, so the mapping of of 174475 is mapped against 737429 in 3rd line with document number and date of 3rd negative amount.
Now Since the 1st positive value has been exhausted, now we will move to 2nd Positive amount, the 2nd positive amount is of 809893, now we will map the remaining negative value of (400000-174475) 225525 with document number as 9 and its date, as 225525 is balance against document number 8 of 400000.
And so on....
Let me know, if you have any query.
Regartds
Sandeep daga
So in first case Positive amount is 737429 and its document no. is 1.
Now we want to adjust negative amount with positive amount on First in First out basis.
So, the 1st negative value is of 400000 and its corresponding document number is 6, so it 1st mapped against 737429
Now remaining positive balance is (737429-400000) 337429, the second negative value is of 162954, which is now mapped against 737429, but in 2nd line with its document number and date.
After adjustment of above balance amount is (737429-400000-162954) 174475, the next negative amount is of 400000, but the maximum adjustment can be made up to 174475, so the mapping of of 174475 is mapped against 737429 in 3rd line with document number and date of 3rd negative amount.
Now Since the 1st positive value has been exhausted, now we will move to 2nd Positive amount, the 2nd positive amount is of 809893, now we will map the remaining negative value of (400000-174475) 225525 with document number as 9 and its date, as 225525 is balance against document number 8 of 400000.
And so on....
Let me know, if you have any query.
Regartds
Sandeep daga
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.