transaction list by contact

Question

I have difficulty searching for a transaction by a specific supplier. Can you suggest which report I can use to search for payments I made to a specific contact? Thank you.

tracey_h · Accepted Answer

Hi&nbsp;Leigh_P&nbsp;
&nbsp;
As explained previously the Account Transactions report will display both the debit and credit sides of the transactions. You can filter by specific accounts in Report options. In this example I have selected the Business bank account and Credit card in the Account filter and Coles in the Contacts filter. Clicking on the expand arrow lists the transactions posted to those specific accounts. Clicking on the ID number will open the transaction to see the allocation accounts.
&nbsp;

&nbsp;
&nbsp;
Your other option is to enter all purchases as Bills, you can then use the supplier reports.
&nbsp;
Please let me know if you need further help.
&nbsp;
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

tracey_h · Answer

Hi&nbsp;Leigh_P&nbsp;
&nbsp;
Thanks for your post. The Supplier transactions report displays all bills, payments and debit transactions. Search by a specific supplier by clicking on Suppliers and selecting the required supplier, click on the expand arrow to display all transactions. You can also click on the ID No of a transaction to open that transaction. The Supplier transactions report is in Reporting&gt;&gt;Reports&gt;&gt;Purchases.
&nbsp;

&nbsp;
Please let me know if you need further help.
&nbsp;
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

leigh_p · Answer

Thanks for your reply. That report only seems to show a random selection of suppliers even though I have selected 'all' suppliers and the desired date range. It doesn't show me every transaction by supplier I have recorded in MYOB.

tracey_h · Answer

Hi&nbsp;Leigh_P&nbsp;
&nbsp;
Can you send me a screenshot of that report and a transaction you expect to see displayed so that I can assist further.

leigh_p · Answer

When I run both of the attached reports it only seems to show transactions that have been entered as bills. When I have run each of the attached reports I have searched for Coles Supermarkets. They are transactions that were paid with a credit card which I allocated on Bank Transactions. I can't find a report that brings up a list of all the transactions to Coles Supermarkets. Thanks for your help.

tracey_h · Answer

Hi&nbsp;Leigh_P&nbsp;
&nbsp;
When you allocate a withdrawal bank transaction a Spend money transaction is automatically recorded. Only transactions entered through Purchases (Bills, Bill payments) are included in the supplier reports. This means that Spend money transactions will not appear in the supplier reports.
&nbsp;
You would need to run the Account transactions report to view Spend money transactions. Select Accrual as the Accounting method then click on Report options to filter by a specific contact. Click on Transaction type to filter by a specific transaction type. This report will default to show both the debit and credit for each transaction, you can select to filter by specific account(s) in Report options. For example, selecting the bank or credit card account will only display the credit side of the transaction.
&nbsp;
Please let me know if you need further help.
&nbsp;
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Forum Discussion

transaction list by contact

9 Replies

Related content

active contact list

MYOB contact list

Help/Contact MYOB

Update Contact Details

Reports - Contacts

Exporting contact list

Activity List

Account Right - how to delete transaction in electronic payments list