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; } } }

Supplier Inv No. displayed in a General Ledger Report

LearnerAtMYOB

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 blanks in the Supplier Invoice Number column.

Find more posts tagged with

general ledger detail

Accepted answers

Princess_R

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

All comments

LearnerAtMYOB

Thank you Princess

Princess_R

Hi @LearnerAtMYOB,

Cheers,

Princess

LearnerAtMYOB

Thank you Doreen. I was hoping to avoid acquiring additional software in order to extract information that is already sitting in MYOB!

Doreen_P

Hey @LearnerAtMYOB,

We have a third-party app available in our Apps Marketplace that can help you customise reports. The app is called Datawise Report Writer. It allows you to create and customise reports according to your specific needs, including the option to add Supplier Invoice numbers. If you need further assistance with this, make sure to reach out to our support team directly. You can reach them on live chat via our virtual assistant MOCA or by submitting a support case via MyAccount.

Best regards,

Doreen

LearnerAtMYOB

Thank you for the reply, Sai. However this is not the solution I was after as I'm hoping to run the report from a GL account perspective.

Do you know if there is a report writer module which could help solving my request?

LearnerAtMYOB

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.pdf

Earl_HD

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