Hi, I have a problem which I'm hoping someone knows a good technique for. I have stock movement records in periods in which stock has moved with a resulting SOH figure on each record, eg
Stock:
LOAD * INLINE [
product,branch,PostingDate,onhand
F100,100,'31/10/14',100
F100,100,'29/10/14',102
F200,100,'28/09/15', 77
];
I want to report stock as at 31/1/15 (or any period) which is a calendar record by selecting the period. If there is no stock record, it needs to pick up the most recent priod stock movement record. Can this be done with Set analysis?
Joining the Calendar and Stock table would create a rather large table, but how to do this and then update the subsequent periods with the correct onhand figure?
Thanks.
