MYOBCommunity
Partner Zone
|
|
Partner Zone

General ledger report listing account transactions with description not by memo/supplier

Highlighted
Trusted Cover User lindso
73 Posts
Trusted Cover User
Australia
lindso
Trusted Cover User

73Posts

12Kudos

2Solutions

Solved: Go to Solution

General ledger report listing account transactions with description not by memo/supplier

Hi,

I can't find a general ledger report that lists a the transactions of a particular report by the description used when entering the bill under purchases as opposed to the supplier name. I have tried the Account Transactions report but there isn't a description field to choose from. I have tried the General Ledger Detail report which DOES have a description field to show but when I run the report the description field is blank. All the reports have the memo field which only lists the supplier. I require a list of the transactions showing the description as is entered when raising a bill. Surely there is a report that can report on this somewhere?

Thanks

4 REPLIES 4
MYOB Staff Post RienaP
2,155 Posts
MYOB Staff Post
New Zealand
RienaP
MYOB Staff Post

2155Posts

224Kudos

315Solutions

Accepted Solution Solved Solution

Re: General ledger report listing account transactions with description not by memo/supplier

Hi @lindso,

 

The Purchases [Supplier Detail] report lists the purchases by Description entered in the bill and also shows the items bought if it is a bill in Item layout and General Ledger account if it is a service bill. Please see below and let us know if this is something that will benefit you. 

 

2.png

 

Hope this will help and let us know how you go. Looking forward to hearing from you.


Regards,
Riena
MYOB Training Specialist
Trusted Cover User lindso
73 Posts
Trusted Cover User
Australia
lindso
Trusted Cover User

73Posts

12Kudos

2Solutions

Re: General ledger report listing account transactions with description not by memo/supplier

Hi @RienaP

 

Thanks for your reply and hooray this report does do what I need it to do!! Unfortunately this report, while it does give the account numbers, is primarily a report by supplier and is time consuming in converting it to a report by account number. I have to show/hide filters, (showing the memo field which shows the supplier), export this report to excel, sort the report according to account, copy and paste the account transactions to another sheet, then compare this report to a general ledger account report to make sure that all of the transactions are included in the report. This is for each general ledger account that I need to view. The report takes a long time as it reports on every single purchase for the period chosen which is more than one financial year. If this is all that is available I will use it but there should be a general ledger report with this information and I will post this as an idea for future consideratin by MYOB.

 

Kind regards

Lindso

Experienced Cover User HeatherDBS
114 Posts
Experienced Cover User
Australia
HeatherDBS
Experienced Cover User

114Posts

43Kudos

0Solutions

Re: General ledger report listing account transactions with description not by memo/supplier

@lindso

 

If you assign jobs to all transactions, then you could also use the Job Activity [Detail] report and save a custom version with the allocation memo selected as viewable, and run it for "all jobs". If you have transactions with no job allocated they might not appear (I haven't tried). This is the workaround I have been using for another report which doesn't allow you to show the allocation memo (even though it USED TO in classic). It sorts by General ledger account.  The only problem with the saved custom report is it also saves the date range and job selection but that's bearable.

Experienced Cover User Neane123
14 Posts
Experienced Cover User
Australia
Neane123
Experienced Cover User

14Posts

3Kudos

1Solutions

Re: General ledger report listing account transactions with description not by memo/supplier

Lindso, this is exactly what I was looking for also.  I would have thought there would be a way. I hope you have made the suggestion.

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post