Missing Report File - secaudit.xlt doesn't exist in reports folder
One of our users are getting the following error when trying to generate a report. They see the preview but when they try to export to Excel they get the following the below error This specific report is a security audit. The following article suggests there is no template(?). https://www.myob.com/au/support/myob-business/reporting/exporting-reports/microsoft-excel-templates?productview=Browser#:~:text=Journal%20Security%20Audit A previous search suggested tried adding the reports folder as a trusted location in Excel. The reports folder is in their documents so they have full control. Copying an existing template and naming it secaudit.xlt results in a successful export but the headings obviously don't match because its the wrong template. I've done a fresh install of MYOB on my own system and that specific file is still missing. I've also checked the reports folder for other MYOB users and none of them have the specific report template secaudit.xlt where do I find it?45Views0likes1CommentUser Role to access only job reports in accounts tab
We have an employee who has sales & purchases user roles in Accountright but we also would like them to have access to only the Job reports in the Accounts Tab in the reporting section. I'm not sure this is possible. We don't want them to be able to view payroll information though. If they have access to the Accounts tab in reports, will they be able to drill into a general ledger etc to see payroll info?171Views0likes7CommentsCustomer sales report
Hi All I have a customer who requires a sales report including their purchase order number. I add their PO Number on every invoice but can not find where to add it to the report/statement. I use AccountRight, Appreciate your help. Regards David ZukerSolved158Views0likes2CommentsInventory and cost of orders
Good morning MYOB community, I’m hoping someone here can help me. I’m trying to find my true inventory value. The issue I’m having is that when I look at the Inventory Value Reconciliation report, orders that are pending invoicing are showing up. What I really need to know is the value of inventory I actually have available to sell—i.e., not yet committed to a customer prior to invoicing. Does that make sense? Thanks in advance for any help! Cheers, MYOB_rookieSolved101Views0likes6CommentsReport unit sold by Custom List (either Customer List, Identifier or Price Level)
Hi, We've got sales for 2x businesses in the same MYOB file (bad idea I know). I'm trying to generate 3x sales revenue reports for business A (FY23, FY24 & FY25). This isn't a problem as there's a report for that. The problem is, business B sells some of the same products & I need to add the value of that to Business A's revenue. To do this I need to calculate how many products business B has sold for the 3 financial years. I found two reports that could work but require a lot of manual data work to get the end result: Sales Reports > Customer > Sales [Customer Detail]. Lists sales by customer name, not customer type. ie I get a list of every customer name rather than simply Does anyone have any bright ideas how to generate a report that shows qty of product sold by customer type, ie Customer List, Identifier or Price Level. Report unit sold by custom Customer List, Identifier or Price Level need to run a reportSolved75Views0likes2CommentsAccountRight not exporting to Excel
Hi, Started receiving a message today when attempting export to Excel, which is something I do on a daily basis. Error C:\Users\Public\Documents\MYOB\AccountRight\Current\Reports\Spreadsheet\GENJRLS.XLT Urgently need help. This is a process I have been doing on a daily basis until today. It is a big part of my reporting procedure. Thanks, BronwynSolved591Views0likes4CommentsCustom Report date defaulting to 2020
Hi, We run many weekly custom reports through AccountRight. Every time we run these reports, the date defaults to 4/05/2020 to 08/05/2020. (see photo attached) For each report we have to change the date to the desired date range and it would be so much easier if there was a way to save the date to the last time the report was used (eg. If we ran the report on 14/02/2025, next week when we select custom reports, all we have to change is the DAY part. How can we do this?62Views0likes1CommentSupplier Ledger not reflecting credit that was offset against invoice
Dear MYOB Community, I have attached some diagrams to illustrate the issue I’m facing: The first diagram shows an invoice with a credit applied: $1,608.20 minus $740.64, resulting in $867.56. The second diagram is a snippet of the respective purchase journals. The third diagram is the Supplier Ledger Report, which does not reflect the credit correctly. Instead, the two amounts are added together, displaying $2,348.84 ($1,608.20 plus $740.64) in both the Debit and Credit columns. The Supplier Ledger Report is the standard report found under ‘Purchases / Supplier’. Could you please advise if we are setting off the credits incorrectly? Thank you.59Views0likes1CommentAnalyse Sales [Item] Report - Sold ITEM displaying incorrectly
Hi All, We have a glitch in our system where some products are showing up with the incorrect amount of items solved, which is incorrect, and is throwing our sales figures out. This has happened after some inventory adjustments. See attachment. I can see Earl_HD has assisted with another user before with a similar error. Analyse Sales [Item] Report - Sold ITEM displaying as NEGATIVE but this is not correct. | MYOB Community Can we please get some assistance with this? Thanks, RorySolved106Views0likes1Comment