Recent Posts & Replies
VAT transactions not being recorded in VAT Payable
Hi there, I am having an issue where some of my VAT transactions have not been added to my VAT payable. It is happening very sporadically and seems to fix by changing it to N-T, recording the transaction, and then changing it back to VAT. Is there any way to see or reconcile which transactions are not appearing in VAT payable other than adding it to an excel sheet? Thanks
Consolidated 'Job Profit & Loss Statement' does not agree to 'Profit and Loss Statement' report
Wondering if someone can please help me? We use the 'job' feature in MYOB AccountRight to be able to report on the performance of each of our business 'departments' (a.k.a. 'jobs'). However, on running a consolidated 'Job Profit & Loss Statement' report for a given period and including ALL jobs (both active and inactive) and comparing this to the 'Profit and Loss Statement' report, I have found that the two reports don't agree. I have subsequently run the 'Job Exceptions' reports (for both cash and invoice transactions) on the offchance that an entry has been recorded without a 'job' code, but these reports have not detected any issues. Has anybody else encountered this and/or can tell me what I am missing? The variance isn't huge (< $1k for the first quarter) but it is concerning that these two reports don't agree. To this end, I don't feel as though I can trust the 'Job Profit & Loss Statement' report. Thanks in advance for your help/feedback! PS - it is worth noting that we code all payroll items to 'jobs' during payroll processing so this is not the reason for the variance.
Hi
We have just started using this myob, I have used the very old version. We are now doing payroll, the problem is we are a disability organization, we have employees working weekends, evenings, sleepovers with clients, also weekly. How do you add the above into their timesheets and wages. I appreciate any help. Thank you, Tricia
MYOB PowerBI/Power Query connection
Hi All, I have seen some conflicting information on this so would love to hear exactly what the situation is from someone who knows. I used to use an ODBC link to access the back end of MYOB with Excel. It appears this is no longer supported and I now need to subscribe to a 3rd party software like CData. Is this correct? A lot of Chat GPT responses are telling me to access the database via the MYOB API but this requires authenticating withhttps://secure.myob.com/oauth2/v1/authorize to retrieve an access token so this does not appear to be viable without a custom build interface. Given that all I am looking for is to build Power BI reports or Excel reports, I am looking for any of the following: The details of a MYOB ODBC connector A method of parsing my MYOB credentials through an Excel data link A work around to obtain an access token without creating a custom built interface so that I can utilise the MYOB API A recommendation for a well priced 3rd party MYOB connector Thanks, Steve
Negative Annual Leave accrual on Termination
Hi, one of our employees resigned, giving 2 week's notice. He had -44.5 hours accrued for Annual Leave, which we are taking off his final pays. His last week and a bit's pay will not quite cover the repayment of the negative balance. Do we process a normal pay for his last week, then separate treatment of the leave on termination? How is the negative leave on termination processed in MYOB?Transactions missing from reconciliation page, but showing in bank register
My clients file has been reconcilled to 30/06/2023 and says there are no further transaction to todays date. However there are transactions in the bank feed (fully allocated) from 1/07/2023 to todays date which match the bank statements I have. I have undone all historic reoncillations to see if that solved the issue but transactions are still missing. Unsure how to proceed. ThanksConsignment Stock Inventory
Hi, we receive stock on consignment from one of our suppliers. I have set up the stock as follows Buy - Cost of Sales (Supplier) Sell - Sales Inventory - Consignment Stock (Supplier) we prepare an order for the stock and receive the stock when it arrives. how do i then bill the stock that we have sold. i keep getting an error when i try to bill the sold items. we don't receive all items in the PO at once, as this is an overseas supplier, some is air freight and some arrives on a ship?
Duplicate Purchase Order Numbers
Account Right is duplicating purchased order numbers every now and then. There is no method to the madness. Why is the software provider allowing this to happen? Is it a glitch in the software? I have changed my preferences in the desk top version to provide a warning with both invoice numbers and purchase order numbers but I don't know where to update the preferences in the online version. Please help!Average days to pay figure incorrect
Hi there, I've noticed a few posts going back as far as 8 months and as recently as 25 days. The average days to pay figure on some client accounts is incorrect to the tune of 10's of thousands, so instead of saying Average to pay 9 days, it will have something ridiculous like 18,497 days - our business has not been going for 50 years!!! Why is this taking so long to be resolved and how soon do you think it will be? Thank you. Tania
Automatic invoice reminder emailing error
Hi, We are trying to set up automatic invoice reminder emails but its is not working. I have full access administrator access but when I go to set up - preferences - emailing - invoice reminders all we are getting is an open blank box. How do we fix this error
