FIFO help

Please see attachment

I need to correlate the GRN No & Vendor Code against each issues, so that I know against which receipt, a particular issue has been made.(it it involves 2 different GRN/Vendor then both should show up)

I also need the formula, since I have this issue on a regular basis.

The data is not complete hence there may be errors (in the sense that there may not be receipts but issues would show up-- but pl ignore such issues)

Thanks for the help in advance.

Regards and Have a great day.

Your issue is not very clear. Is it possible to give a sample output sheet so we can easily understand what you need?

I have given an attachment. could you please look into it. Thanks for your response.

It will be good if you could attach a output sheet (that's what i asked for) so we can understand your requirement.

Originally Posted by arlu1201

It will be good if you could attach a output sheet (that's what i asked for) so we can understand your requirement.

Sorry that I did not understand ur requirement earlier.

I am attaching a output file. Hope it explains my requirement, though I am not sure that I have managed to do that.

Originally Posted by royUK

I haven't got a clue what you are asking, I can see nothing that calculates FIFO at all.

I am once again attaching the Excel file with comments on what I want. I hope this explains what I want. The comments are highlighted in yellow.

Sorry for the trouble. Thanks in advance for the effort taken.

Any help on this please. Please use the excel file attached for 3rd time (File Size 94 KB).

This is urgently needed. Thanks to all concerned.