Home → Problems →

Investment Transactions Report Some Actions Don't Work

• Edit

Henry Sully

15 Oct, 2024 01:40 PM

I am using version 2024.1 5122.

When actions Buyxfr, Sellxfr and DivReinvest are selected as filters in the Investment Transaction report, nothing is reported. Why is this? I use a lot of Buyxfr and Sellxfr transactions for several valid reasons. These are very useful actions indeed. It would be very helpful to be able to generate an investment transaction report that include these actions.

I did see a previous post where it was recommended to use a combination of DIV and BUY for a dividend that is reinvested, but why do that if there is a combination action provided? It is a lot of work to go back and modify many, many valid transactions just for the sake of reporting, yet the reporting is needed. Is there a version of MD where this is working? Is it just not possible to code this fix? I have been using MD for 9 years.

Thanks, Henry

1. 1 Posted by Stuart Beesley ... on 15 Oct, 2024 02:08 PM

   

   These work for me both in 5118 and 5169... Please send a screen shot of the report settings and also a transaction that you would expect to see?

   There is no need to do two separate div and buy txns!

   NOTE: This action search only appeared in the 2024 series of MD updates...

   • Edit

2. 2 Posted by HH Sully-Gmail on 15 Oct, 2024 03:41 PM

   

   Hi Stuart,

   Here's a screen shot of a DivReinvest action. I will also send another that shows a Buyxfr or Sellxfr.

   The top window is the investment register set to search the date where the dividend was entered. The second window is the transaction report result. And the third is the report settings when using the EDIT button.

   Thanks, Henry
   

   On 10/15/2024 10:08 AM, Stuart Beesley (Mr Toolbox) wrote:
   

   pre { width: 92%; margin: 10px 2%; padding: 5px 2%; background: #efefef; border: 1px solid #d6d6d6 }blockquote { margin-left: 0; padding-left: 1em; border-left: 5px solid #ccc; }

   // Please reply above this line ================================================== From: Stuart Beesley (Mr Toolbox) These work for me both in 5118 and 5169... Please send a screen shot of the report settings and also a transaction that you would expect to see? There is no need to do two separate div and buy txns! NOTE: This action search only appeared in the 2024 series of MD updates... On Tue, Oct 15 at 06:40 AM PDT, Henry Sully wrote: I am using version 2024.1 5122. When actions Buyxfr, Sellxfr and DivReinvest are selected as filters in the Investment Transaction report, nothing is reported. Why is this? I use a lot of Buyxfr and Sellxfr transactions for several valid reasons. These are very useful actions indeed. It would be very helpful to be able to generate an investment transaction report that include these actions. I did see a previous post where it was recommended to use a combination of DIV and BUY for a dividend that is reinvested, but why do that if there is a combination action provided? It is a lot of work to go back and modify many, many valid transactions just for the sake of reporting, yet the reporting is needed. Is there a version of MD where this is working? Is it just not possible to code this fix? I have been using MD for 9 years. Thanks, Henry

   Having trouble reading this? View this discussion online: Investment Transactions Report Some Actions Don't Work. Reply with #ignore to stop receiving notifications for this discussion.

   • eNOqITp0q3D9gMU4.png 244 KB
   • Edit

3. Support Staff 3 Posted by Maddy on 15 Oct, 2024 03:46 PM

   

   You may want to install the latest update.

   A new update was released on 10 October 2024 .

   Moneydance 2024.2 (5165) is available to download from this page.

   For a full list of improvements in the preview version, please refer to this page.

   We recommend overwriting or manually removing the older version.

   Please keep us posted on your progress, Thank you!

   --
   Maddy, Infinite Kind Support

   • Edit

4. 4 Posted by HH Sully-Gmail on 15 Oct, 2024 03:49 PM

   

   Hi Stuart,

   This is one where there is a buy, sell, div and buyxfr. The buyxfr does not show up as can be seen.

   Thanks, Henry

   On 10/15/2024 10:08 AM, Stuart Beesley (Mr Toolbox) wrote:
   

   pre { width: 92%; margin: 10px 2%; padding: 5px 2%; background: #efefef; border: 1px solid #d6d6d6 }blockquote { margin-left: 0; padding-left: 1em; border-left: 5px solid #ccc; }

   // Please reply above this line ================================================== From: Stuart Beesley (Mr Toolbox) These work for me both in 5118 and 5169... Please send a screen shot of the report settings and also a transaction that you would expect to see? There is no need to do two separate div and buy txns! NOTE: This action search only appeared in the 2024 series of MD updates... On Tue, Oct 15 at 06:40 AM PDT, Henry Sully wrote: I am using version 2024.1 5122. When actions Buyxfr, Sellxfr and DivReinvest are selected as filters in the Investment Transaction report, nothing is reported. Why is this? I use a lot of Buyxfr and Sellxfr transactions for several valid reasons. These are very useful actions indeed. It would be very helpful to be able to generate an investment transaction report that include these actions. I did see a previous post where it was recommended to use a combination of DIV and BUY for a dividend that is reinvested, but why do that if there is a combination action provided? It is a lot of work to go back and modify many, many valid transactions just for the sake of reporting, yet the reporting is needed. Is there a version of MD where this is working? Is it just not possible to code this fix? I have been using MD for 9 years. Thanks, Henry

   Having trouble reading this? View this discussion online: Investment Transactions Report Some Actions Don't Work. Reply with #ignore to stop receiving notifications for this discussion.

   • IU1psY1HJtyfs2VV.png 331 KB
   • Edit

5. 5 Posted by Stuart Beesley ... on 15 Oct, 2024 04:03 PM

   

   Hmm. You have a lot of ‘ands’ in this filter. What happens if you just select the action and date?

   Can you make a small test dataset that demonstrates this issue and upload a backup of it?

   • Edit

6. 6 Posted by Stuart Beesley ... on 15 Oct, 2024 05:14 PM

   

   OK, I just tested this. The problem is the amount... A DivReinvest has a next cash value of zero.. Your filter is between 0.10 to 1000000.00.

   • Edit

7. 7 Posted by Stuart Beesley ... on 15 Oct, 2024 05:17 PM

   

   Ditto for the SellXfr and BuyXfr..

   I'm inclined to say that this is NOT a bug and that this is fine.... Otherwise where do you start looking for values? The actual dividend amount>? The fee? etc etc

   • Edit

8. 8 Posted by HH Sully-Gmail on 15 Oct, 2024 05:54 PM

   

   Hi Stuart,

   That was actually a very good suggestion! It turns out the dollar amount range seems to be causing the issue. I had set it up to be 0.1 on the minimum, and for the BuyXrf and DivReinvest transactions. Disabling the amount filter allowed the transactions to be listed in the report.

   However, now I am seeing something else that I don't quite understand. For example, in the DivReinvest, the amount of the transaction is 738.60 in the register, but in the report now it is 0.00. Similar for the BuyXfr. The amount transacted in the account register is 2,207.92, but is 0.00 in the report.

   The transaction amounts are being transferred into a category for these actions, but they definitely are not 0.

   The category for the BuyXfr is not showing up in the investment transaction report. But, the category is showing up for the Div action.

   I also did play around with the settings in the amount filter. Setting the minimum amount to 0 allows BuyXfr to show up in the report, but a -1 did not. While not in this particular example, I do have transactions that are negative amounts in my portfolio. What is the purpose of the amount filter?
   

   Is there a good explanation for this?

   -Henry
   

   On 10/15/2024 12:03 PM, Stuart Beesley (Mr Toolbox) wrote:
   

   pre { width: 92%; margin: 10px 2%; padding: 5px 2%; background: #efefef; border: 1px solid #d6d6d6 }blockquote { margin-left: 0; padding-left: 1em; border-left: 5px solid #ccc; }

   // Please reply above this line ================================================== From: Stuart Beesley (Mr Toolbox) Hmm. You have a lot of ands in this filter. What happens if you just select the action and date? Can you make a small test dataset that demonstrates this issue and upload a backup of it? On Tue, Oct 15 at 08:49 AM PDT, HH Sully-Gmail wrote: Hi Stuart, This is one where there is a buy, sell, div and buyxfr. The buyxfr does not show up as can be seen. Thanks, Henry On 10/15/2024 10:08 AM, Stuart Beesley (Mr Toolbox) wrote: pre { width: 92%; margin: 10px 2%; padding: 5px 2%; background: #efefef; border: 1px solid #d6d6d6 }blockquote { margin-left: 0; padding-left: 1em; border-left: 5px solid #ccc; } // Please reply above this line ================================================== From: Stuart Beesley (Mr Toolbox) These work for me both in 5118 and 5169... Please send a screen shot of the report settings and also a transaction that you would expect to see? There is no need to do two separate div and buy txns! NOTE: This action search only appeared in the 2024 series of MD updates... On Tue, Oct 15 at 06:40 AM PDT, Henry Sully wrote: I am using version 2024.1 5122. When actions Buyxfr, Sellxfr and DivReinvest are selected as filters in the Investment Transaction report, nothing is reported. Why is this? I use a lot of Buyxfr and Sellxfr transactions for several valid reasons. These are very useful actions indeed. It would be very helpful to be able to generate an investment transaction report that include these actions. I did see a previous post where it was recommended to use a combination of DIV and BUY for a dividend that is reinvested, but why do that if there is a combination action provided? It is a lot of work to go back and modify many, many valid transactions just for the sake of reporting, yet the reporting is needed. Is there a version of MD where this is working? Is it just not possible to code this fix? I have been using MD for 9 years. Thanks, Henry Having trouble reading this? View this discussion online: Investment Transactions Report Some Actions Don't Work. Reply with #ignore to stop receiving notifications for this discussion.

   Having trouble reading this? View this discussion online: Investment Transactions Report Some Actions Don't Work. Reply with #ignore to stop receiving notifications for this discussion.

   • hxwXDt501g3gNDr9.png 316 KB
   • Edit