General Ledger Report-

Is there a way to include invoice details in the general ledger reporting?

Currently, I use the supplier name and date to track payments made or received. It would be much easier to locate transactions if they could be traced back to the invoice number.

I checked the show/hide menu but couldn't find an option for this. Does anyone know how this can be done?

Genreve_S
6 days ago
Hi Grvkhadka,

I can see how having those invoice numbers can make the report more useful. The General Ledger [Detail] report includes the ID No. column. For sales transactions, this shows the AccountRight invoice number. For purchase transactions, it shows the AccountRight bill or purchase number.

To include it, customise the report and select ID No under Show/Hide. This lets you identify the invoice or bill linked to each General Ledger entry.

If you need the supplier’s own invoice number, that is a separate Supplier Inv No. field on the bill and isn’t available as a column in this report. Use the Purchases [Supplier Detail] report instead, then add Supplier Inv No under Show/Hide.

For more information:

https://www.myob.com/au/support/myob-business/purchases/entering-purchases/enter-a-bill-quote-or-order?productview=Desktop

https://www.myob.com/au/support/myob-business/reporting/purchases-reports

Regards,
Genreve

3 Replies

Doreen_P
MYOB Moderator
6 days ago
Hi Grvkhadka,

Thanks for clarifying what you’re trying to achieve. AccountRight’s General Ledger [Detail] report doesn’t allow the Supplier Invoice Number to be added as a column, even through the report’s Insert/Modify options. A workaround is to run the General Ledger [Detail] report for the relevant accounts and dates, then run a supplier-focused report such as Supplier Detail, Supplier Ledger or Purchase Register. Export both reports to Excel and match the transactions using details such as the supplier, date, amount and transaction number. This should give your auditors a clear link between the GL entries and the original supplier invoice references. You can find more information here:

Supplier Invoice Number displayed in a General Ledger report

Purchases reports

Displaying a report

It’s not quite the one-click report option we’d all love, but this should provide a workable audit trail.

Cheers,

Doreen
Grvkhadka
Member
6 days ago
Thanks, Genreve.

I did run the General Ledger [Detail] report and, as shown in my previous screenshot, I had already selected the ID No.

I am actually looking to display the Supplier Invoice references in the GL report. Our auditors need a way to tag these supplier references in the reports so they can tie them back to the original invoices.

Is there any way to include the Supplier Invoice references in the General Ledger [Detail] report?
Genreve_S
MYOB Moderator
6 days ago
Hi Grvkhadka,

I can see how having those invoice numbers can make the report more useful. The General Ledger [Detail] report includes the ID No. column. For sales transactions, this shows the AccountRight invoice number. For purchase transactions, it shows the AccountRight bill or purchase number.

To include it, customise the report and select ID No under Show/Hide. This lets you identify the invoice or bill linked to each General Ledger entry.

If you need the supplier’s own invoice number, that is a separate Supplier Inv No. field on the bill and isn’t available as a column in this report. Use the Purchases [Supplier Detail] report instead, then add Supplier Inv No under Show/Hide.

For more information:

https://www.myob.com/au/support/myob-business/purchases/entering-purchases/enter-a-bill-quote-or-order?productview=Desktop

https://www.myob.com/au/support/myob-business/reporting/purchases-reports

Regards,
Genreve