Post by jnm21 on Mar 2, 2018 0:58:50 GMT
I just worked out that the export facility has a foible; I expected that start date & end date would both be included, but end date is excluded!
For example, in 2017 I have transactions on 30th, 31st March & 1st April - an extract for 1st to 31st March only includes up to the 30th and one for 1st to 30th April includes the 1st April.
propertymoose this is actually very useful (please don't change it) - means I can do a series of extracts from 1st to 1st without getting any overlap (which saves having to chop & change the end dates to anywhere between 28th & 31st). What would be a useful change is clearly labelling the start date as inclusive & the end date as exclusive (feel free to borrow text from this post for a KB article to back up the logic, assuming that there isn't one that I missed).
Another one I noticed is that SPV 89 is not handled properly (may be the same for any other cancelled opportunities); when I topped up & invested, I have the credit record, the invest record (as would be normal) is missing, meaning that my balance change with the next transaction doesn't add up. When I invested with existing funds, the invest record (as would be normal) is also missing, meaning that my balance change with the next transaction also doesn't add up. Finally both missing invest records do have equivalent refund records (this creates an imbalance between a running total of all my records & the balance on PM). I have added in the invest records myself, that resolves all the issues.
For example, in 2017 I have transactions on 30th, 31st March & 1st April - an extract for 1st to 31st March only includes up to the 30th and one for 1st to 30th April includes the 1st April.
propertymoose this is actually very useful (please don't change it) - means I can do a series of extracts from 1st to 1st without getting any overlap (which saves having to chop & change the end dates to anywhere between 28th & 31st). What would be a useful change is clearly labelling the start date as inclusive & the end date as exclusive (feel free to borrow text from this post for a KB article to back up the logic, assuming that there isn't one that I missed).
Another one I noticed is that SPV 89 is not handled properly (may be the same for any other cancelled opportunities); when I topped up & invested, I have the credit record, the invest record (as would be normal) is missing, meaning that my balance change with the next transaction doesn't add up. When I invested with existing funds, the invest record (as would be normal) is also missing, meaning that my balance change with the next transaction also doesn't add up. Finally both missing invest records do have equivalent refund records (this creates an imbalance between a running total of all my records & the balance on PM). I have added in the invest records myself, that resolves all the issues.