schryan
Contributing User
Joined 12 years ago
User Profile
User Widgets
Contributions
Error when Exporting to Excel
I’m using AccountRight 2022.8 on Windows 11 virtual machine (using Parallels) and attempting to export a few reports to Excel. On selecting the report (e.g. Profit & Loss Statement) and applying the required filters, I click “Export to Excel” and a pop-up appears which says "Error" and provides the following path:- C:\Users\Public\Documents\MYOB\AccountRight\2022.8\Reports\Spreadsheet The error pop-up says nothing else (see attached screenshot). I have confirmed that the above folder path exists in my Windows 11 folder structure. I have attempted the above with numerous other reports and receive the same error. Is someone able to please assist in rectifying this so I’m able to export data to Excel. ThanksSolvedRe: ACCOUNTS LIST TOTALS WONT ADD UP CORRECTLY
Hi Gavin. Thanks for your reply and appreciate your suggestions. I've managed to restore an earlier version of the file and I'm in the middle of reconstructing it (had the sense to take a backup at an earlier stage). Fortunately, only 2-3 hours of re-work (not days). Quite frustrating and astounding that a bug like this exists. Regards, Peter395Views0likes1CommentRe: ACCOUNTS LIST TOTALS WONT ADD UP CORRECTLY
Hi Celia. Thanks for your reply. The issue may have been triggered by accounts that I removed. However, I removed these after I re-assigned "$0.00" to the Opening Balance field for each. Please note that:- 1. the GL trial balance is in balance; 2. the balance sheet balances; 3. there is no "Historical Balancing" amount and; 4. all required accounts exist. I'm an accountant and understand the implications of deleting an account which has any activity or an opening balance. Myob doesn't permit you to delete an account with non-zero amounts. This is definitely a bug in Myob's ability to relcalulate the rolled-up amount. I find interesting the reply in this thread posted bygavin12345 and supportive of what I've uncovered. Regards, Peter395Views0likes0CommentsACCOUNTS LIST TOTALS WONT ADD UP CORRECTLY
I've created a new company and am progressively setting-up accounts. As I'm doing this, I'm entering opening balances for Equity accounts. After some deliberation, I've moved account numbers around a bit to better reflect the structure I'm after. What's resulted is that the grand total of the "Equity" amount does not add to the respective "child" accounts which roll-up to the Equity total. I now have a total Equity amount of $1,513,518.61 for which child accounts add to $68,996.13. I have attempted to rectify this by removing the opening balances previously entered in the child accounts (now $0.00 for all). I have also moved accounts up/down in the hierarchy as suggested in the post here: https://community.myob.com/t5/AccountRight-Sales-and-purchases/ACCOUNTS-LIST-ISSUE-TOTALS-WONT-ADD-UP-CORRECTLY/td-p/680903 I have also deleted the "child accounts", however this made the situation worse by then calculating a "historical balance" (I subsquently restored from backup to rectify the historical balance problem. The screen-shot provided is after the restore). The balance sheet is calculating correctly. Would you please suggest a remedy for the issue.Custom Fields Available for Customer [Sales Detail] Report
I have created a custom report cloned from the "Sales [Customer Detail]" report. There are 6 x Custom Fields available, listed as follows (yes, there are 2 x sets of custom fields):- Custom Field #1 Custom Field #2 Custom Field #3 Custom Field #1 (populated from customer card) Custom Field #2(populated from customer card) Custom Field #3(populated from customer card) I have populated the set of custom fields in the customer card record as follows:- Custom Field #1 - value: "Salesforce ID" Custom Field #2 - value: "Division" Custom Field #3 - value: "Branch" The report extracts the above values from the customer card correctly, however, it's unknown from where the other set of values is extracted. Q. From where does the report retrieve values for the other set of "Custom Field" fields? Refer to attached set of screenshots.