Skip to Content
0
Former Member
Apr 22, 2014 at 08:22 AM

FIFO Sequence not right

204 Views

Dear Experts,

Please help me about this FIFO sequence, i found it not right when the items out.

Item No. Whse System Date Posting Date Document Quantity Cost Trans. Value Cumulative Qty Cumulative Value FLANGE#600-025 0 0 23 1,802,955.00 01PST 0 0 12 858,550.00 Opening Balance 0 0 0 0 1 08.04.14 01.12.13 SI 1010000229 8 85,855.00 686,840.00 8 686,840.00 2 30.12.13 03.12.13 PD 2010000787 8 73,200.00 585,600.00 16 1,272,440.00 3 27.01.14 03.12.13 IM 1025020133 -6 73,200.00 -439,200.00 10 833,240.00 4 27.01.14 03.12.13 IM 1025020133 -2 85,855.00 -171,710.00 8 661,530.00 5 03.02.14 11.12.13 IM 1025020134 -8 85,855.00 -686,840.00 0 -25,310.00 6 21.04.14 31.12.13 SI 1010000231 1 85,855.00 85,855.00 1 60,545.00 7 21.04.14 31.12.13 SO 1010000199 -1 85,855.00 -85,855.00 0 -25,310.00 8 21.04.14 31.12.13 SI 1010000236 1 0 0 1 -25,310.00 9 21.04.14 31.12.13 SO 1010000200 -1 85,855.00 -85,855.00 0 -111,165.00 10 21.04.14 31.12.13 SI 1010000237 1 0 0 1 -111,165.00 11 21.04.14 31.12.13 SO 1010000203 -1 85,855.00 -85,855.00 0 -197,020.00 12 03.02.14 01.01.14 SI 1010000084 12 85,855.00 1,030,260.00 12 833,240.00 13 23.01.14 07.01.14 PD 2010000015 2 85,855.00 171,710.00 14 1,004,950.00 14 16.01.14 08.01.14 IM 1025020014 -2 73,200.00 -146,400.00 12 858,550.00 02A01 0 0 11 944,405.00 Opening Balance 0 0 0 0 15 27.01.14 03.12.13 IM 1025020133 6 73,200.00 439,200.00 6 439,200.00 16 27.01.14 03.12.13 IM 1025020133 2 85,855.00 171,710.00 8 610,910.00 17 03.02.14 11.12.13 IM 1025020134 8 85,855.00 686,840.00 16 1,297,750.00 18 11.02.14 11.12.13 DN 1025020817 -6 73,200.00 -439,200.00 10 858,550.00 19 11.02.14 11.12.13 DN 1025020817 -2 73,200.00 -146,400.00 8 712,150.00 20 16.01.14 08.01.14 IM 1025020014 2 73,200.00 146,400.00 10 858,550.00 21 03.04.14 08.01.14 SI 1025020009 2 85,855.00 171,710.00 12 1,030,260.00 22 03.04.14 25.03.14 DN 1025020326 -1 85,855.00 -85,855.00 11 944,405.00

Item No. Whse System Date Posting Date Quantity Cost Trans. Value Cumulative Qty Cumulative Value A 0 0 23 1,802,955.00 01PST 0 0 12 858,550.00 1 08.04.14 01.12.13 8 85,855.00 686,840.00 8 686,840.00 2 30.12.13 03.12.13 8 73,200.00 585,600.00 16 1,272,440.00 3 27.01.14 03.12.13 -6 73,200.00 -439,200.00 10 833,240.00 4 27.01.14 03.12.13 -2 85,855.00 -171,710.00 8 661,530.00 5 03.02.14 11.12.13 -8 85,855.00 -686,840.00 0 -25,310.00 6 21.04.14 31.12.13 1 85,855.00 85,855.00 1 60,545.00 7 21.04.14 31.12.13 -1 85,855.00 -85,855.00 0 -25,310.00 8 21.04.14 31.12.13 1 0 0 1 -25,310.00 9 21.04.14 31.12.13 -1 85,855.00 -85,855.00 0 -111,165.00 10 21.04.14 31.12.13 1 0 0 1 -111,165.00 11 21.04.14 31.12.13 -1 85,855.00 -85,855.00 0 -197,020.00 12 03.02.14 01.01.14 12 85,855.00 1,030,260.00 12 833,240.00 13 23.01.14 07.01.14 2 85,855.00 171,710.00 14 1,004,950.00 14 16.01.14 08.01.14 -2 73,200.00 -146,400.00 12 858,550.00 02A01 0 0 11 944,405.00 15 27.01.14 03.12.13 6 73,200.00 439,200.00 6 439,200.00 16 27.01.14 03.12.13 2 85,855.00 171,710.00 8 610,910.00 17 03.02.14 11.12.13 8 85,855.00 686,840.00 16 1,297,750.00 18 11.02.14 11.12.13 -6 73,200.00 -439,200.00 10 858,550.00 19 11.02.14 11.12.13 -2 73,200.00 -146,400.00 8 712,150.00 20 16.01.14 08.01.14 2 73,200.00 146,400.00 10 858,550.00 21 03.04.14 08.01.14 2 85,855.00 171,710.00 12 1,030,260.00 22 03.04.14 25.03.14 -1 85,855.00 -85,855.00 11 944,405.00

Please advise,

Thanks, Ferly