Forum Discussion

Experienced User

2 months ago

Supplier Inv No. displayed in a General Ledger Report

Which General Ledger report can I run to display Supplier invoice numbers for all purchase transactions in a specific general ledger account? Transactions processed through Bank Feeds should show bla...

general ledger detail

Princess_R
2 months ago
Hi LearnerAtMYOB,

You can try exporting both the General Ledger and Purchase Supplier reports to Excel and customise the data to meet your needs. However, aside from manually extracting and combining the data from both reports, there isn't another built-in option within MYOB to achieve this. Thanks for understanding.

Cheers,

Princess

Earl_HD

MYOB Moderator

2 months ago

Hi LearnerAtMYOB,

To display Supplier invoice numbers for all purchase transactions in a specific general ledger account, you can run the "General Ledger Detail" report in MYOB. This report allows you to filter transactions by specific general ledger accounts and includes detailed information such as supplier invoice numbers. General Ledger [Detail] report

I hope this helps!

Regards,
Earl

LearnerAtMYOB
Experienced User
2 months ago
Hello Earl, I have looked at that report previously, and I can only see the Purchase ID number, but not the Suppler Invoice Number. I added all the available fields by going to the "Show/Hide columns" functionality.
Refer my diagram that is attached to see which field I'm after.
Supplier Invoice Number example_Redacted.pdf236 KB
- Isaiah_C
  MYOB Moderator
  2 months ago
  Hi LearnerAtMYOB,
  
  It sounds like the General Ledge Details report doesn't display the Supplier Invoice Number field as expected. Instead, to view Supplier Invoice Numbers for purchase transactions, I'd suggest running the Purchases [Supplier Detail] report. Ensure the Supplier Invoice Number column is included by using the Show/Hide Columns feature.
  
  Regards,
  
  Sai