Dear Members,
Kindly help me with the following scenario, Purchase, Sales are entered manually, Closing Stock as per Physical stock available,
Requirement:
For Sales: Qty will be entered manually, but price as per FIFO METHOD
For Closing Stock: Qty and Rate has to get calculated as per FIFO Method
Right now after physical stock verification Closing Stock is getting entered manually, i am unable to crack formula
Kindly help me with the following scenario, Purchase, Sales are entered manually, Closing Stock as per Physical stock available,
Requirement:
For Sales: Qty will be entered manually, but price as per FIFO METHOD
For Closing Stock: Qty and Rate has to get calculated as per FIFO Method
Right now after physical stock verification Closing Stock is getting entered manually, i am unable to crack formula
ADD OR MINUS | TYPE | DATE | PARTICULARS | SL.NO. | QTY | RATE | VALUE |
ADD | Opening Balance | 1 | |||||
01/01/2021 | OPENING BALANCE-27 | 2 | 2,000.00 | 86.94 | 1,73,880.00 | ||
01/01/2021 | OPENING BALANCE-28 | 3 | 1,550.00 | 86.94 | 1,34,757.00 | ||
ADD | Purchase | 4 | |||||
09/01/2021 | INV NO.13934 DT.8-1-2021 | 5 | 5,000.00 | 88.02 | 4,40,100.00 | ||
20/01/2021 | INV NO.14491 DT.19-1-2021 | 6 | 5,000.00 | 88.02 | 4,40,100.00 | ||
25/01/2021 | INV NO.14862 DT.25-1-2021 | 7 | 5,000.00 | 88.02 | 4,40,100.00 | ||
30/01/2021 | INV NO.15214 DT.29-1-2021 | 8 | 3,000.00 | 88.02 | 2,64,060.00 | ||
30/01/2021 | INV NO.15236 DT.29-1-2021 | 9 | 2,000.00 | 88.02 | 1,76,040.00 | ||
07/01/2021 | INV NO.15239 DT.29-1-2021 | 10 | 500.00 | 86.94 | 43,470.00 | ||
MINUS | Sales | 11 | |||||
20/01/2021 | 3095/20.01.21-35 | 12 | 1,500.00 | 88.02 | 1,32,030.00 | ||
MINUS | Closing Stock | 13 | |||||
31/01/2021 | CLOSING STOCK-36 | 14 | 2,000.00 | 88.02 | 1,76,040.00 | ||
31/01/2021 | CLOSING STOCK-37 | 15 | 3,000.00 | 88.02 | 2,64,060.00 | ||
31/01/2021 | CLOSING STOCK-38 | 16 | 3,369.90 | 88.02 | 2,96,618.60 | ||
31/01/2021 | CLOSING STOCK-39 | 17 | - | - | |||
31/01/2021 | CLOSING STOCK-40 | 18 | - | - | |||
31/01/2021 | CLOSING STOCK-41 | 19 | - | - | |||
EQUALS | Consumption | 20 | |||||
31/01/2021 | CONSUMPTION-42 | 21 | 14,180.10 | 87.71 | 12,43,758.40 |