Polly_Templeton
Experienced User
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Export to Excel and send Excel file not working
Many thanks I restarted and it got stuck again. However I discovered another hidden popup window that said the Excel 97-2003 file type has been blocked by File Block settings in Trust Center. So that's our IT end to address. It's weird how it's suddenly changed. I am now going to try another database that also exports to Excel 97-2003 file type and report it to our IT volunteers. Thank you for the information on how to clear the cache. I am not sure how to get up the virtual assistant when I am using the desktop application. Thanks for advice on going to MyAccount. This can be closed now.73Views0likes0CommentsWeird increase in Inventory Current Value
Yesterday I discovered that four out of some 30 items have had their current value doubled and then tripled from initial purchase in February 2023. One item as an example -Centenary Air Force Bear - 500 purchased at cost of $13.772 = total cost $6,886 and current value $6,886. Note that sales are not recorded through MYOB Inventory - a yearly count is undertaken and stock then reduced. In November 2023 stock of this item was 28 on hand so I recorded -472 reduction in stock which was -$6,500.45. Therefore the current value should be $385.62 for 28 bears. I entered the count inventory with stock numbers at November 2023 and it said -472 and all looked fine. Yesterday when I went to reduce the stock of this bear to zero it came up with error messages. On re-running an inventory value reconciliation report at 31/12/2023 the current value of this item for 28 units was showing as $6,886 instead of $385.62 and the original current value from 3/2/23 had jumped to $13,386.38. It then showed -$6,500.45 leaving a balance of $6,886 for 28 unit. After another attempt at re-doing the Nov 2023 count the current value at 3/2/23 jumped up to $19,886.77 and did reduce by -$6,500.45 in Nov 2023 but now the Current Value is $13,386.32. I eventually got the -28 units count for yesterday's stocktake to reduce by $13,386.32 which leave 0 on Hand and $0 current value! But then my balances were all out for both Inventory asset and stock expense adjustment accounts. So I had to do a general journal for each of these four items to reverse each of these four inflated values and leave the correct stock on hand value balance. Multiple documents attempting to show this are attached. My main concern is what did I do for this to occur and how not to have it happen again.Add non inventory item to item layout purchase
We received a quantity of stock from supplier that I have entered using the item layout. However there is one item that is not an inventory item but is just an expense. I couldn't find a method of entering in a non-inventory item with/without a quantity and just putting the total price. I resorted in the end to adding it to the freight amount just to get the invoice to be the correct total due. I would be grateful for advice on how to do this correctly in future.Solved116Views0likes2CommentsRe: Long Service Leave taken and paid by portable LSL Authority
Hi Princess, Thanks so much for your answer. I had seen this MYOB help article but wanted to note that it is for Victoria only and does not mention the case where the authority pays the long service service. Otherwise this message can be closed.856Views0likes0CommentsLong Service Leave taken and paid by portable LSL Authority
The ACT has the portable long service leave scheme that our employees are registered with. One employee is taking her Long Service Leave 4 weeks soon and is going to be paid by the ACT Long Service Leave Authority. My questions are how to account for this in MYOB STP while she is away. I understand that as she is being paid by the scheme we will not need to pay super. However I believe that she will continue to accrue annual and personal leave. I am not sure how to accrue this through payroll when she is not being paid anything - would you calculate how many hours it is and see what the accrual for both is, then delete the hours worked and add in the accruals and process a nil pay? As she is not being paid by us her employer then I am assuming that the authority will report the leave being taken and PAYG being taken out and it will all end up in her end of year payment summary. I would be grateful for any advice on how this all works.Solved535Views0likes2CommentsSales invoices not appearing in Sales Register
Good morning, I am using AccountRight 2020.4 with Windows 10. On 22 January I raised two sales invoices dated 22/01/2021 (12022046 and 12022047) but they are not showing in the Sales Register under All Sales. At the time I printed them off and also emailed them to the customers. In fact one customer has paid the invoice and I was able to receive the payment from the bank feed. However this invoice does not appear in Closed Invoices and the other one that is still open does not appear in Open Invoices. I read a similar post from July 2019 which suggested that the AccountRight cache be cleared. I have managed to do this but still the missing two invoices do not appear. Snips showing existence of invoices and the sales register without them. Please can you assist. Many thanks Polly What is even more strange is that I raised one other invoice after this on 22/1/21 (12022048) but the invoice was dated 31/12/2020. It appears fine.Solved965Views0likes2Comments