SUPPLIER TRANSACTION REPORT
I am having trouble getting a supplier transaction report and realise that I have to do the below as they are spend money transactions however there is no option to select a Contact, just a date? Al...
Forum Discussion
Hi Lisa,
No, I don't you use bank feeds or bank rules and always use spend money, not entering the invoice.
You would think that I would be able to get a contact transactions report somehow?
It's so simple in Accountright, why can't the same thing happen in Essentials.
Regards
BERNIE
Hi Bernie
unfortunately I don,t believe that essentials has the same functionality as accountright
Can you send a screenshot of one of your spend money transactions and the excel spreadsheet with payee column
or can you select a spend money transaction and run the report in excel to bring up that transaction to see what populates where by following that through?
if you select a transaction and narrow down the general ledger account report to capture it you should be able to find the best descriptor to narrow down your search
certainly in my search the payee came up with the contact I had entered
hope that helps
Lisa
Hi Lisa,
This is the excel spreadsheet
1-1120 CBA - Date Reference Type Description Deposit ($) Withdrawal ($) Balance($) Payee 01/07/2021 SM000634 Spend money APRIL JUNE BAS 21 94,638.00 ######## 01/07/2021 SM000635 Spend money APR JUNE BAS AND PAYG 70,000.00 ######## 01/07/2021 SM000636 Spend money SUPERANNUATION 1,784.59 ######## 02/07/2021 SM000637 Spend money OFFICE CLEAN 180.00 ######## 05/07/2021 SM000638 Spend money FUEL 30.00 ######## 05/07/2021 SM000639 Spend money MATERIAL 565.18 ######## I'm not quite sure what you mean by
"if you select a transaction and narrow down the general ledger account report to capture it you should be able to find the best descriptor to narrow down your search"
Thanks
BERNIE
Hi Bernie
what I meant but narrowing down by general ledger was - if the supplier you are looking for is allocated to a particular gl code then you could run the report on that gl
as far as your report goes you need to select name as per my spreadsheet
if you go to customise and go past the default selection to the dropdown box just select all
run the report and export and see what comes up
my example was to show you where the fields you fill in in a spend money transaction show up in this report
Lisa
Hi Lisa,
I did a general report and it worked, so it seems that is the only way to do it.
Thanks for your help.
BERNIE
