Forum Discussion

LSolutions's avatar
LSolutions
Experienced Cover User
2 years ago
Solved

Customer transactions report

Good Morning,   Is there something wrong with the Customer Transactions report?  I want to run a report for the customer to show payments applied to a particular invoice down to zero (eg part payme...
  • Sean_DC's avatar
    Sean_DC
    2 years ago

    Hi LSolutions 

     

    Thank you for your post. It's good to know that the customer statement was able to provide you with what you need. When it comes to the Customer Transactions report, I can give you a few tips. Filter out the date range without changing the date from and to. Export it as a PDF to have a better view of the report. This also gives you more details on the report. 
     


    Please feel free to post again. I'm happy to assist further.

     

    If my response has answered your enquiry please click "Accept as Solution" to assist other users to find this information.

     

LSolutions's avatar
LSolutions
Experienced Cover User

I've just realised I can run a customer statement selecting activity as the statement type which does give me what I need.   However it is worth bringing up that the transaction report doesn't work.

Sean_DC's avatar
Sean_DC
MYOB Moderator
2 years ago

Hi LSolutions 

 

Thank you for your post. It's good to know that the customer statement was able to provide you with what you need. When it comes to the Customer Transactions report, I can give you a few tips. Filter out the date range without changing the date from and to. Export it as a PDF to have a better view of the report. This also gives you more details on the report. 
 


Please feel free to post again. I'm happy to assist further.

 

If my response has answered your enquiry please click "Accept as Solution" to assist other users to find this information.

 

  • LSolutions's avatar
    LSolutions
    Experienced Cover User
    2 years ago

    Hi Sean,

     

    Thanks for your reply, very interesing you can export it into a PDF when nothing comes up on the report thanks for the tip I didn't think to export it as no results showed, but it's all on the PDF. 

     

    Fiddling with the dates it only displays a result if the 'Date From' and 'Date to' are set to the period of when the invoice was sent and up until it was paid.   Once the 'date to' is on or after the date the invoice was fully paid it shows no results.   Confusing to explain so I hope that makes sense.   

     

    BUT as you have pointed out even in the situation where no results show up, you can still export into a PDF and all the information comes up in the PDF!

     

    Just Fyi - 

    Invoice was partially paid on 14/04/23 - comes up on report 

    Invoice was fully paid on 15/04/23 - no results on report but is on the PDF when exported

     

     

     

    Thanks for your help.

     

    Regards

    Kristy

    • Sean_DC's avatar
      Sean_DC
      MYOB Moderator
      2 years ago

      Hi LSolutions 

       

      Yes, you are right. You can still export it as a PDF and it would most of the time show you the results of the report that you want. I would also pass this on to the team so that it's something they can be aware of as well from now on. Here on Product Ideas Board, you can publicly share it so that those who can relate can vote for it. I appreciate your post in sharing this.