Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following table:
Date | Entry type | Item | Qty | GRN no. | Vendor |
1-Jan-16 | GRN | RBC12300 | 10 | GRN-101 | ABC |
3-Jan-16 | Sale | RBC12300 | -20 | SRN-678 | DEF |
4-Jan-16 | GRN | RBC12300 | 30 | GRN-102 | CDE |
5-Jan-16 | Output | RBC12300 | 25 | ORN-345 | RC! |
6-Jan-16 | GRN | RBC12300 | 15 | GRN-103 | ABC |
1-Feb-16 | GRN | RAC56789 | 10 | GRN-101 | ABC |
3-Feb-16 | Sale | RAC56789 | -20 | SRN-678 | DEF |
4-Feb-16 | GRN | RAC56789 | 30 | GRN-102 | CDE |
5-Feb-16 | Output | RAC56789 | 35 | ORN-345 | RC! |
6-Feb-16 | GRN | RAC56789 | 15 | GRN-103 | ABC |
Table 2:
Closing stock of RBC 12300 | 60 | ||
Closing stock of RBC 12300 | 70 |
i need the following output :
The system should compare recent Receipts (GRN and Output)
with the closing stock. to the extent Receipts matches with the closing stock, it should consider.
6-Jan-16 | GRN | RBC12300 | GRN-103 | 15 |
5-Jan-16 | Output | RBC12300 | ORN-345 | 25 |
4-Jan-16 | GRN | RBC12300 | GRN-102 | 20 |
6-Feb-16 | GRN | RAC56789 | GRN-103 | 15 |
5-Feb-16 | Output | RAC56789 | ORN-345 | 25 |
4-Feb-16 | GRN | RAC56789 | GRN-102 | 30 |
for eg. in the output for item RBC 12300, GRN Qty is 30, but only 20 is considered as the sum total is equal to 60.
kindly provide code for this in qlikview/
I don't really understand your requested output description:
- Are you only considering records looking back to the last sale as 'recent'? Or why have you left out 1-Jan and 1-Feb receipts?
-"for eg. in the output for item RBC 12300, GRN Qty is 30, but only 20 is considered as the sum total is equal to 60."
I am totally lost, can't get how you calculate 30, then consider only 20????