nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

General Ledger Report-

Grvkhadka

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?

Find more posts tagged with

Accepted answers

Genreve_S

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

All comments

Doreen_P

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:

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

Cheers,

Doreen