Forum Discussion

Lisa_BBP's avatar
Lisa_BBP
Trusted Cover User
8 months ago
Solved

Excel formula not working when exported

Hello MYOB

When I export a trial balance to excel I used to be able to add a formula but now it's showing a VALUE error. What has changed in the background that I am no longer able to add a formula to a trial balance exported to excel? Why have you removed this simple yet handy feature?

Frustrated Partner

MYOB is getting worse!

  • Hi Lisa_BBP,
    This is caused by the MYOB export putting something in cells that appear blank, that isn't a number. Using a formula that references that cell and expects a number, will result in the #VALUE! error.

    This issue is visible when you look at the name of an account on export and its truncated, but when you press delete on the cell to the right, the full name of the account becomes visible. Its also identifiable when you 'ctrl+arrow' through a document which should take you to the next cell with data, but it skips whole sections with or without numbers as excel considers the entire area to contain information, like a whole column of DR despite only several rows containing actual numbers. This issued does not exist on Excel exports from the desktop AR package, just the cloud version of MYOB.

    The Export process needs to be corrected to not export zero length strings.

     

    This is solvable in a roundabout way:

    1. Open find and replace (Ctrl+H)
    2. Leave the "Find What" field blank
    3. Enter "x" in the "Replace With" field
    4. Make sure to check the "Match Entire Cell Contents" box
    5. Click Replace All
    6. Now switch what you entered in each field. Put the "x" in Find what, and delete everything in Replace with
    7. Click Replace All
    8. All apparently empty cells should now be truly empty.

    Yep, MYOB needs to improve their exporting processes.

"}},"componentScriptGroups({\"componentId\":\"custom.widget.Custom_Footer\"})":{"__typename":"ComponentScriptGroups","scriptGroups":{"__typename":"ComponentScriptGroupsDefinition","afterInteractive":{"__typename":"PageScriptGroupDefinition","group":"AFTER_INTERACTIVE","scriptIds":[]},"lazyOnLoad":{"__typename":"PageScriptGroupDefinition","group":"LAZY_ON_LOAD","scriptIds":[]}},"componentScripts":[]},"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"components/community/NavbarDropdownToggle\"]})":[{"__ref":"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/EscalatedMessageBanner\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"components/users/UserLink\"]})":[{"__ref":"CachedAsset:text:en_US-components/users/UserLink-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserRank\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserRank-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageTime\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageTime-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSolvedBadge\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSubject\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSubject-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageBody\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageBody-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageCustomFields\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageCustomFields-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageReplyButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageReplyButton-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSolutionList\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSolutionList-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/AcceptedSolutionButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/common/Pager/PagerLoadMore\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/common/Pager/PagerLoadMore-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"components/customComponent/CustomComponent\"]})":[{"__ref":"CachedAsset:text:en_US-components/customComponent/CustomComponent-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageView/MessageViewInline\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1743051948261"}],"message({\"id\":\"message:876727\"})":{"__ref":"AcceptedSolutionMessage:message:876727"},"message({\"id\":\"message:876921\"})":{"__ref":"ForumReplyMessage:message:876921"},"message({\"id\":\"message:890758\"})":{"__ref":"ForumReplyMessage:message:890758"},"message({\"id\":\"message:876915\"})":{"__ref":"ForumReplyMessage:message:876915"},"message({\"id\":\"message:874406\"})":{"__ref":"ForumReplyMessage:message:874406"},"message({\"id\":\"message:874582\"})":{"__ref":"ForumReplyMessage:message:874582"},"message({\"id\":\"message:874619\"})":{"__ref":"ForumReplyMessage:message:874619"},"message({\"id\":\"message:874623\"})":{"__ref":"ForumReplyMessage:message:874623"},"message({\"id\":\"message:874678\"})":{"__ref":"ForumReplyMessage:message:874678"},"messages({\"constraints\":{\"solution\":{\"eq\":true},\"topicId\":{\"eq\":\"message:874387\"}},\"first\":10,\"sorts\":{\"postTime\":{\"direction\":\"ASC\"}}})":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8aXwxMHwzOToxfGludCw4NzY3MjcsODc2NzI3","node":{"__ref":"AcceptedSolutionMessage:message:876727"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null},"totalCount":1},"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserAvatar\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1743051948261"}],"cachedText({\"lastModified\":\"1743051948261\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/ranks/UserRankLabel\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1743051948261"}]},"CachedAsset:pages-1742488487604":{"__typename":"CachedAsset","id":"pages-1742488487604","value":[{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"BlogViewAllPostsPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId/all-posts/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"CasePortalPage","type":"CASE_PORTAL","urlPath":"/caseportal","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"CreateGroupHubPage","type":"GROUP_HUB","urlPath":"/groups/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"CaseViewPage","type":"CASE_DETAILS","urlPath":"/case/:caseId/:caseNumber","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"InboxPage","type":"COMMUNITY","urlPath":"/inbox","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"HelpFAQPage","type":"COMMUNITY","urlPath":"/help","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"IdeaMessagePage","type":"IDEA_POST","urlPath":"/idea/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"IdeaViewAllIdeasPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/all-ideas/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"LoginPage","type":"USER","urlPath":"/signin","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"BlogPostPage","type":"BLOG","urlPath":"/category/:categoryId/blogs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"ThemeEditorPage","type":"COMMUNITY","urlPath":"/designer/themes","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"TkbViewAllArticlesPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId/all-articles/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"OccasionEditPage","type":"EVENT","urlPath":"/event/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"OAuthAuthorizationAllowPage","type":"USER","urlPath":"/auth/authorize/allow","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"PageEditorPage","type":"COMMUNITY","urlPath":"/designer/pages","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"PostPage","type":"COMMUNITY","urlPath":"/category/:categoryId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"ForumBoardPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"TkbBoardPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"EventPostPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"UserBadgesPage","type":"COMMUNITY","urlPath":"/users/:login/:userId/badges","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"GroupHubMembershipAction","type":"GROUP_HUB","urlPath":"/membership/join/:nodeId/:membershipType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"MaintenancePage","type":"COMMUNITY","urlPath":"/maintenance","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"IdeaReplyPage","type":"IDEA_REPLY","urlPath":"/idea/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"UserSettingsPage","type":"USER","urlPath":"/mysettings/:userSettingsTab","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"GroupHubsPage","type":"GROUP_HUB","urlPath":"/groups","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"ForumPostPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"OccasionRsvpActionPage","type":"OCCASION","urlPath":"/event/:boardId/:messageSubject/:messageId/rsvp/:responseType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"VerifyUserEmailPage","type":"USER","urlPath":"/verifyemail/:userId/:verifyEmailToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"AllOccasionsPage","type":"OCCASION","urlPath":"/category/:categoryId/events/:boardId/all-events/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"EventBoardPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"TkbReplyPage","type":"TKB_REPLY","urlPath":"/kb/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"IdeaBoardPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"CommunityGuideLinesPage","type":"COMMUNITY","urlPath":"/communityguidelines","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"CaseCreatePage","type":"SALESFORCE_CASE_CREATION","urlPath":"/caseportal/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"TkbEditPage","type":"TKB","urlPath":"/kb/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"ForgotPasswordPage","type":"USER","urlPath":"/forgotpassword","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"IdeaEditPage","type":"IDEA","urlPath":"/idea/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"TagPage","type":"COMMUNITY","urlPath":"/tag/:tagName","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"BlogBoardPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"OccasionMessagePage","type":"OCCASION_TOPIC","urlPath":"/event/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"ManageContentPage","type":"COMMUNITY","urlPath":"/managecontent","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"ClosedMembershipNodeNonMembersPage","type":"GROUP_HUB","urlPath":"/closedgroup/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"CommunityPage","type":"COMMUNITY","urlPath":"/","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"ForumMessagePage","type":"FORUM_TOPIC","urlPath":"/discussions/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"IdeaPostPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"BlogMessagePage","type":"BLOG_ARTICLE","urlPath":"/blog/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"RegistrationPage","type":"USER","urlPath":"/register","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"EditGroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"ForumEditPage","type":"FORUM","urlPath":"/discussions/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"ResetPasswordPage","type":"USER","urlPath":"/resetpassword/:userId/:resetPasswordToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"TkbMessagePage","type":"TKB_ARTICLE","urlPath":"/kb/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"BlogEditPage","type":"BLOG","urlPath":"/blog/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"ManageUsersPage","type":"USER","urlPath":"/users/manage/:tab?/:manageUsersTab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"ForumReplyPage","type":"FORUM_REPLY","urlPath":"/discussions/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"PrivacyPolicyPage","type":"COMMUNITY","urlPath":"/privacypolicy","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"NotificationPage","type":"COMMUNITY","urlPath":"/notifications","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"UserPage","type":"USER","urlPath":"/users/:login/:userId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"HealthCheckPage","type":"COMMUNITY","urlPath":"/health","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"OccasionReplyPage","type":"OCCASION_REPLY","urlPath":"/event/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"ManageMembersPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/manage/:tab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"SearchResultsPage","type":"COMMUNITY","urlPath":"/search","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"BlogReplyPage","type":"BLOG_REPLY","urlPath":"/blog/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"GroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"TermsOfServicePage","type":"COMMUNITY","urlPath":"/termsofservice","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"CategoryPage","type":"CATEGORY","urlPath":"/category/:categoryId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"ForumViewAllTopicsPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/all-topics/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"TkbPostPage","type":"TKB","urlPath":"/category/:categoryId/kbs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742488487604,"localOverride":null,"page":{"id":"GroupHubPostPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"}],"localOverride":false},"CachedAsset:text:en_US-components/context/AppContext/AppContextProvider-0":{"__typename":"CachedAsset","id":"text:en_US-components/context/AppContext/AppContextProvider-0","value":{"noCommunity":"Cannot find community","noUser":"Cannot find current user","noNode":"Cannot find node with id {nodeId}","noMessage":"Cannot find message with id {messageId}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-0":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-0","value":{"title":"Loading..."},"localOverride":false},"User:user:-1":{"__typename":"User","id":"user:-1","uid":-1,"login":"Anonymous","email":"","avatar":null,"rank":null,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":"ANONYMOUS","registrationTime":null,"confirmEmailStatus":false,"registrationAccessLevel":"VIEW","ssoRegistrationFields":[]},"ssoId":null,"profileSettings":{"__typename":"ProfileSettings","dateDisplayStyle":{"__typename":"InheritableStringSettingWithPossibleValues","key":"layout.friendly_dates_enabled","value":"true","localValue":"true","possibleValues":["true","false"]},"dateDisplayFormat":{"__typename":"InheritableStringSetting","key":"layout.format_pattern_date","value":"dd-MM-yyyy","localValue":"MM-dd-yyyy"},"language":{"__typename":"InheritableStringSettingWithPossibleValues","key":"profile.language","value":"en-US","localValue":null,"possibleValues":["en-US"]}},"deleted":false},"Theme:customTheme1":{"__typename":"Theme","id":"customTheme1"},"AssociatedImage:{\"url\":\"https://community.myob.com/t5/s/myob/images/bi04MjYtcnNLbmo3?image-coordinates=0%2C0%2C320%2C320\"}":{"__typename":"AssociatedImage","url":"https://community.myob.com/t5/s/myob/images/bi04MjYtcnNLbmo3?image-coordinates=0%2C0%2C320%2C320","mimeType":"image/png"},"Category:category:Business":{"__typename":"Category","id":"category:Business","entityType":"CATEGORY","displayId":"Business","nodeType":"category","depth":2,"title":"MYOB Business","shortTitle":"MYOB Business","parent":{"__ref":"Category:category:Support"},"categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:top":{"__typename":"Category","id":"category:top","displayId":"top","nodeType":"category","depth":0,"title":"Top","entityType":"CATEGORY","shortTitle":"Top"},"Category:category:Support":{"__typename":"Category","id":"category:Support","displayId":"Support","nodeType":"category","depth":1,"parent":{"__ref":"Category:category:top"},"title":"Product Help & Ideas","entityType":"CATEGORY","shortTitle":"Product Help & Ideas","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:Bus-Report":{"__typename":"Forum","id":"board:Bus-Report","entityType":"FORUM","displayId":"Bus-Report","nodeType":"board","depth":3,"conversationStyle":"FORUM","title":"MYOB Business: Reports","description":"","avatar":{"__ref":"AssociatedImage:{\"url\":\"https://community.myob.com/t5/s/myob/images/bi04MjYtcnNLbmo3?image-coordinates=0%2C0%2C320%2C320\"}"},"profileSettings":{"__typename":"ProfileSettings","language":null},"parent":{"__ref":"Category:category:Business"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:community:myob"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:Support"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:Business"}}]},"userContext":{"__typename":"NodeUserContext","canAddAttachments":true,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"boardPolicies":{"__typename":"BoardPolicies","canPublishArticleOnCreate":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","key":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","args":[]}}},"shortTitle":"MYOB Business: Reports","repliesProperties":{"__typename":"RepliesProperties","sortOrder":"LIKES","repliesFormat":"threaded"},"eventPath":"category:Business/category:Support/community:myobboard:Bus-Report/","tagProperties":{"__typename":"TagNodeProperties","tagsEnabled":{"__typename":"PolicyResult","failureReason":null}},"requireTags":false,"tagType":"FREEFORM_ONLY"},"Rank:rank:171":{"__typename":"Rank","id":"rank:171","position":55,"name":"Trusted Cover User","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:153350":{"__typename":"User","id":"user:153350","uid":153350,"login":"Lisa_BBP","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/images/dS0xNTMzNTAtMzMwNDFpQzM2RDJCQzRCNDREMEYxRg"},"rank":{"__ref":"Rank:rank:171"},"email":"","messagesCount":137,"biography":null,"topicsCount":29,"kudosReceivedCount":64,"kudosGivenCount":68,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2016-09-20T10:57:41.959+10:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":5,"entityType":"USER","eventPath":"community:myob/user:153350"},"ForumTopicMessage:message:874387":{"__typename":"ForumTopicMessage","uid":874387,"subject":"Excel formula not working when exported","id":"message:874387","revisionNum":1,"repliesCount":11,"author":{"__ref":"User:user:153350"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Bus-Report"},"conversation":{"__ref":"Conversation:conversation:874387"},"readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:874387"},"body":"

Hello MYOB

When I export a trial balance to excel I used to be able to add a formula but now it's showing a VALUE error. What has changed in the background that I am no longer able to add a formula to a trial balance exported to excel? Why have you removed this simple yet handy feature?

Frustrated Partner

MYOB is getting worse!

","body@stringLength":"354","rawBody":"

Hello MYOB

When I export a trial balance to excel I used to be able to add a formula but now it's showing a VALUE error. What has changed in the background that I am no longer able to add a formula to a trial balance exported to excel? Why have you removed this simple yet handy feature?

Frustrated Partner

MYOB is getting worse!

","kudosSumWeight":0,"postTime":"2024-07-30T15:30:19.862+10:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:874387_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":244},"visibilityScope":"PUBLIC","canonicalUrl":null,"seoTitle":null,"seoDescription":null,"isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"archivalData":null,"searchSnippet":"Hello MYOB When I export a trial balance to excel I used to be able to add a formula but now it's showing a VALUE error. What has changed in the background that I am no longer able to add a formula ...","replies":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wxMHwxNDowLDM5OjF8MQ","node":{"__ref":"AcceptedSolutionMessage:message:876727"}},{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wxMHwxNDowLDM5OjF8Mg","node":{"__ref":"ForumReplyMessage:message:874406"}},{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wxMHwxNDowLDM5OjF8Mw","node":{"__ref":"ForumReplyMessage:message:874619"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"Conversation:conversation:874387":{"__typename":"Conversation","id":"conversation:874387","solved":true,"topic":{"__ref":"ForumTopicMessage:message:874387"},"lastPostingActivityTime":"2025-03-19T08:37:30.223+11:00","lastPostTime":"2025-03-19T08:37:30.223+11:00","unreadReplyCount":11,"isSubscribed":false},"ModerationData:moderation_data:874387":{"__typename":"ModerationData","id":"moderation_data:874387","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":"member"},"Revision:revision:874387_1":{"__typename":"Revision","id":"revision:874387_1","lastEditTime":"2024-07-30T15:30:19.862+10:00"},"CachedAsset:theme:customTheme1-1742488487153":{"__typename":"CachedAsset","id":"theme:customTheme1-1742488487153","value":{"id":"customTheme1","animation":{"fast":"150ms","normal":"250ms","slow":"500ms","slowest":"750ms","function":"cubic-bezier(0.07, 0.91, 0.51, 1)","__typename":"AnimationThemeSettings"},"avatar":{"borderRadius":"10px","collections":["custom"],"__typename":"AvatarThemeSettings"},"basics":{"browserIcon":{"imageAssetName":"Favicon-1710285586777.png","imageLastModified":"1710285589142","__typename":"ThemeAsset"},"customerLogo":{"imageAssetName":"logo2-1710285458800.png","imageLastModified":"1710285462029","__typename":"ThemeAsset"},"maximumWidthOfPageContent":"1350px","oneColumnNarrowWidth":"800px","gridGutterWidthMd":"30px","gridGutterWidthXs":"10px","pageWidthStyle":"WIDTH_OF_BROWSER","__typename":"BasicsThemeSettings"},"buttons":{"borderRadiusSm":"100vw","borderRadius":"100vw","borderRadiusLg":"100vw","paddingY":"5px","paddingYLg":"7px","paddingYHero":"var(--lia-bs-btn-padding-y-lg)","paddingX":"12px","paddingXLg":"16px","paddingXHero":"60px","fontStyle":"NORMAL","fontWeight":"700","textTransform":"NONE","disabledOpacity":0.5,"primaryTextColor":"var(--lia-bs-white)","primaryTextHoverColor":"var(--lia-bs-white)","primaryTextActiveColor":"var(--lia-bs-white)","primaryBgColor":"var(--lia-bs-primary)","primaryBgHoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.85))","primaryBgActiveColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.7))","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","primaryBorderActive":"1px solid transparent","primaryBorderFocus":"1px solid var(--lia-bs-white)","primaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","secondaryTextColor":"var(--lia-bs-gray-900)","secondaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","secondaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","secondaryBgColor":"var(--lia-bs-gray-200)","secondaryBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","secondaryBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","secondaryBorder":"1px solid transparent","secondaryBorderHover":"1px solid transparent","secondaryBorderActive":"1px solid transparent","secondaryBorderFocus":"1px solid transparent","secondaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","tertiaryTextColor":"var(--lia-bs-gray-900)","tertiaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","tertiaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","tertiaryBgColor":"transparent","tertiaryBgHoverColor":"transparent","tertiaryBgActiveColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.04)","tertiaryBorder":"1px solid transparent","tertiaryBorderHover":"1px solid hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","tertiaryBorderActive":"1px solid transparent","tertiaryBorderFocus":"1px solid transparent","tertiaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","destructiveTextColor":"var(--lia-bs-danger)","destructiveTextHoverColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.95))","destructiveTextActiveColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.9))","destructiveBgColor":"var(--lia-bs-gray-200)","destructiveBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","destructiveBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","destructiveBorder":"1px solid transparent","destructiveBorderHover":"1px solid transparent","destructiveBorderActive":"1px solid transparent","destructiveBorderFocus":"1px solid transparent","destructiveBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","__typename":"ButtonsThemeSettings"},"border":{"color":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","mainContent":"DARK","sideContent":"DARK","radiusSm":"6px","radius":"10px","radiusLg":"18px","radius50":"100vw","__typename":"BorderThemeSettings"},"boxShadow":{"xs":"0 0 0 1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08), 0 3px 0 -1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08)","sm":"0 2px 4px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.06)","md":"0 5px 15px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.15)","lg":"0 10px 30px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.15)","__typename":"BoxShadowThemeSettings"},"cards":{"bgColor":"var(--lia-panel-bg-color)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":"var(--lia-box-shadow-xs)","__typename":"CardsThemeSettings"},"chip":{"maxWidth":"300px","height":"30px","__typename":"ChipThemeSettings"},"coreTypes":{"defaultMessageLinkColor":"var(--lia-bs-link-color)","defaultMessageLinkDecoration":"none","defaultMessageLinkFontStyle":"NORMAL","defaultMessageLinkFontWeight":"400","defaultMessageFontStyle":"NORMAL","defaultMessageFontWeight":"400","forumColor":"#EC0677","forumFontFamily":"var(--lia-bs-font-family-base)","forumFontWeight":"var(--lia-default-message-font-weight)","forumLineHeight":"var(--lia-bs-line-height-base)","forumFontStyle":"var(--lia-default-message-font-style)","forumMessageLinkColor":"var(--lia-default-message-link-color)","forumMessageLinkDecoration":"var(--lia-default-message-link-decoration)","forumMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","forumMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","forumSolvedColor":"#18AD31","blogColor":"#8118CD","blogFontFamily":"var(--lia-bs-font-family-base)","blogFontWeight":"var(--lia-default-message-font-weight)","blogLineHeight":"1.75","blogFontStyle":"var(--lia-default-message-font-style)","blogMessageLinkColor":"var(--lia-default-message-link-color)","blogMessageLinkDecoration":"var(--lia-default-message-link-decoration)","blogMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","blogMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","tkbColor":"#430071","tkbFontFamily":"var(--lia-bs-font-family-base)","tkbFontWeight":"var(--lia-default-message-font-weight)","tkbLineHeight":"1.75","tkbFontStyle":"var(--lia-default-message-font-style)","tkbMessageLinkColor":"var(--lia-default-message-link-color)","tkbMessageLinkDecoration":"var(--lia-default-message-link-decoration)","tkbMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","tkbMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaColor":"#4099E2","qandaFontFamily":"var(--lia-bs-font-family-base)","qandaFontWeight":"var(--lia-default-message-font-weight)","qandaLineHeight":"var(--lia-bs-line-height-base)","qandaFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkColor":"var(--lia-default-message-link-color)","qandaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","qandaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaSolvedColor":"#3FA023","ideaColor":"#FF8000","ideaFontFamily":"var(--lia-bs-font-family-base)","ideaFontWeight":"var(--lia-default-message-font-weight)","ideaLineHeight":"var(--lia-bs-line-height-base)","ideaFontStyle":"var(--lia-default-message-font-style)","ideaMessageLinkColor":"var(--lia-default-message-link-color)","ideaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","ideaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","ideaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","contestColor":"#FCC845","contestFontFamily":"var(--lia-bs-font-family-base)","contestFontWeight":"var(--lia-default-message-font-weight)","contestLineHeight":"var(--lia-bs-line-height-base)","contestFontStyle":"var(--lia-default-message-link-font-style)","contestMessageLinkColor":"var(--lia-default-message-link-color)","contestMessageLinkDecoration":"var(--lia-default-message-link-decoration)","contestMessageLinkFontStyle":"ITALIC","contestMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","occasionColor":"#D13A1F","occasionFontFamily":"var(--lia-bs-font-family-base)","occasionFontWeight":"var(--lia-default-message-font-weight)","occasionLineHeight":"var(--lia-bs-line-height-base)","occasionFontStyle":"var(--lia-default-message-font-style)","occasionMessageLinkColor":"var(--lia-default-message-link-color)","occasionMessageLinkDecoration":"var(--lia-default-message-link-decoration)","occasionMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","occasionMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","grouphubColor":"#333333","categoryColor":"#949494","communityColor":"#FFFFFF","productColor":"#949494","__typename":"CoreTypesThemeSettings"},"colors":{"black":"#000000","white":"#FFFFFF","gray100":"#F7F7F7","gray200":"#F7F7F7","gray300":"#E8E8E8","gray400":"#D9D9D9","gray500":"#CCCCCC","gray600":"#949494","gray700":"#707070","gray800":"#545454","gray900":"#333333","dark":"#545454","light":"#F7F7F7","primary":"#A130F5","secondary":"#333333","bodyText":"#333333","bodyBg":"#FFFFFF","info":"#409AE2","success":"#41C5AE","warning":"#FCC844","danger":"#D13A1F","alertSystem":"#FF6600","textMuted":"#707070","highlight":"#FFFCAD","outline":"var(--lia-bs-primary)","custom":["#C497FE","#7B14EF","#EBDCFD","#232428","#FFF854","#070708"],"__typename":"ColorsThemeSettings"},"divider":{"size":"3px","marginLeft":"4px","marginRight":"4px","borderRadius":"50%","bgColor":"var(--lia-bs-gray-600)","bgColorActive":"var(--lia-bs-gray-600)","__typename":"DividerThemeSettings"},"dropdown":{"fontSize":"var(--lia-bs-font-size-sm)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius-sm)","dividerBg":"var(--lia-bs-gray-300)","itemPaddingY":"5px","itemPaddingX":"20px","headerColor":"var(--lia-bs-gray-700)","__typename":"DropdownThemeSettings"},"email":{"link":{"color":"#0069D4","hoverColor":"#0061c2","decoration":"none","hoverDecoration":"underline","__typename":"EmailLinkSettings"},"border":{"color":"#e4e4e4","__typename":"EmailBorderSettings"},"buttons":{"borderRadiusLg":"5px","paddingXLg":"16px","paddingYLg":"7px","fontWeight":"700","primaryTextColor":"#ffffff","primaryTextHoverColor":"#ffffff","primaryBgColor":"#0069D4","primaryBgHoverColor":"#005cb8","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","__typename":"EmailButtonsSettings"},"panel":{"borderRadius":"5px","borderColor":"#e4e4e4","__typename":"EmailPanelSettings"},"__typename":"EmailThemeSettings"},"emoji":{"skinToneDefault":"#ffcd43","skinToneLight":"#fae3c5","skinToneMediumLight":"#e2cfa5","skinToneMedium":"#daa478","skinToneMediumDark":"#a78058","skinToneDark":"#5e4d43","__typename":"EmojiThemeSettings"},"heading":{"color":"var(--lia-bs-body-color)","fontFamily":"Inter","fontStyle":"NORMAL","fontWeight":"500","h1FontSize":"34px","h2FontSize":"32px","h3FontSize":"28px","h4FontSize":"24px","h5FontSize":"20px","h6FontSize":"16px","lineHeight":"1.3","subHeaderFontSize":"11px","subHeaderFontWeight":"500","h1LetterSpacing":"normal","h2LetterSpacing":"normal","h3LetterSpacing":"normal","h4LetterSpacing":"normal","h5LetterSpacing":"normal","h6LetterSpacing":"normal","subHeaderLetterSpacing":"2px","h1FontWeight":"var(--lia-bs-headings-font-weight)","h2FontWeight":"var(--lia-bs-headings-font-weight)","h3FontWeight":"var(--lia-bs-headings-font-weight)","h4FontWeight":"var(--lia-bs-headings-font-weight)","h5FontWeight":"var(--lia-bs-headings-font-weight)","h6FontWeight":"var(--lia-bs-headings-font-weight)","__typename":"HeadingThemeSettings"},"icons":{"size10":"10px","size12":"12px","size14":"14px","size16":"16px","size20":"20px","size24":"24px","size30":"30px","size40":"40px","size50":"50px","size60":"60px","size80":"80px","size120":"120px","size160":"160px","__typename":"IconsThemeSettings"},"imagePreview":{"bgColor":"var(--lia-bs-gray-900)","titleColor":"var(--lia-bs-white)","controlColor":"var(--lia-bs-white)","controlBgColor":"var(--lia-bs-gray-800)","__typename":"ImagePreviewThemeSettings"},"input":{"borderColor":"var(--lia-bs-gray-600)","disabledColor":"var(--lia-bs-gray-600)","focusBorderColor":"var(--lia-bs-primary)","labelMarginBottom":"10px","btnFontSize":"var(--lia-bs-font-size-sm)","focusBoxShadow":"0 0 0 3px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","checkLabelMarginBottom":"2px","checkboxBorderRadius":"3px","borderRadiusSm":"100vw","borderRadius":"100vw","borderRadiusLg":"100vw","formTextMarginTop":"4px","textAreaBorderRadius":"18px","activeFillColor":"var(--lia-bs-primary)","__typename":"InputThemeSettings"},"loading":{"dotDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.2)","dotLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.5)","barDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.06)","barLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.4)","__typename":"LoadingThemeSettings"},"link":{"color":"var(--lia-bs-primary)","hoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) - 10%))","decoration":"none","hoverDecoration":"underline","__typename":"LinkThemeSettings"},"listGroup":{"itemPaddingY":"15px","itemPaddingX":"15px","borderColor":"var(--lia-bs-gray-300)","__typename":"ListGroupThemeSettings"},"modal":{"contentTextColor":"var(--lia-bs-body-color)","contentBg":"var(--lia-bs-white)","backgroundBg":"var(--lia-bs-black)","smSize":"440px","mdSize":"760px","lgSize":"1080px","backdropOpacity":0.3,"contentBoxShadowXs":"var(--lia-bs-box-shadow-sm)","contentBoxShadow":"var(--lia-bs-box-shadow)","headerFontWeight":"700","__typename":"ModalThemeSettings"},"navbar":{"position":"FIXED","background":{"attachment":null,"clip":null,"color":"var(--lia-bs-white)","imageAssetName":"","imageLastModified":"0","origin":null,"position":"CENTER_CENTER","repeat":"NO_REPEAT","size":"COVER","__typename":"BackgroundProps"},"backgroundOpacity":0.8,"paddingTop":"15px","paddingBottom":"15px","borderBottom":"1px solid var(--lia-bs-border-color)","boxShadow":"var(--lia-bs-box-shadow-sm)","brandMarginRight":"30px","brandMarginRightSm":"10px","brandLogoHeight":"30px","linkGap":"10px","linkJustifyContent":"flex-start","linkPaddingY":"5px","linkPaddingX":"10px","linkDropdownPaddingY":"9px","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkColor":"var(--lia-bs-body-color)","linkHoverColor":"var(--lia-bs-primary)","linkFontSize":"var(--lia-bs-font-size-sm)","linkFontStyle":"NORMAL","linkFontWeight":"400","linkTextTransform":"NONE","linkLetterSpacing":"normal","linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkBgColor":"transparent","linkBgHoverColor":"transparent","linkBorder":"none","linkBorderHover":"none","linkBoxShadow":"none","linkBoxShadowHover":"none","linkTextBorderBottom":"none","linkTextBorderBottomHover":"none","dropdownPaddingTop":"10px","dropdownPaddingBottom":"15px","dropdownPaddingX":"10px","dropdownMenuOffset":"2px","dropdownDividerMarginTop":"10px","dropdownDividerMarginBottom":"10px","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","controllerIconColor":"var(--lia-bs-body-color)","controllerIconHoverColor":"var(--lia-bs-body-color)","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","controllerHighlightColor":"hsla(30, 100%, 50%)","controllerHighlightTextColor":"var(--lia-yiq-light)","controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerColor":"var(--lia-nav-controller-icon-color)","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","hamburgerBgColor":"transparent","hamburgerBgHoverColor":"transparent","hamburgerBorder":"none","hamburgerBorderHover":"none","collapseMenuMarginLeft":"20px","collapseMenuDividerBg":"var(--lia-nav-link-color)","collapseMenuDividerOpacity":0.16,"__typename":"NavbarThemeSettings"},"pager":{"textColor":"var(--lia-bs-link-color)","textFontWeight":"var(--lia-font-weight-md)","textFontSize":"var(--lia-bs-font-size-sm)","__typename":"PagerThemeSettings"},"panel":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-bs-border-radius)","borderColor":"var(--lia-bs-border-color)","boxShadow":"none","__typename":"PanelThemeSettings"},"popover":{"arrowHeight":"8px","arrowWidth":"16px","maxWidth":"300px","minWidth":"100px","headerBg":"var(--lia-bs-white)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius)","boxShadow":"0 0.5rem 1rem hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.15)","__typename":"PopoverThemeSettings"},"prism":{"color":"#000000","bgColor":"#f5f2f0","fontFamily":"var(--font-family-monospace)","fontSize":"var(--lia-bs-font-size-base)","fontWeightBold":"var(--lia-bs-font-weight-bold)","fontStyleItalic":"italic","tabSize":2,"highlightColor":"#b3d4fc","commentColor":"#62707e","punctuationColor":"#6f6f6f","namespaceOpacity":"0.7","propColor":"#990055","selectorColor":"#517a00","operatorColor":"#906736","operatorBgColor":"hsla(0, 0%, 100%, 0.5)","keywordColor":"#0076a9","functionColor":"#d3284b","variableColor":"#c14700","__typename":"PrismThemeSettings"},"rte":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":" var(--lia-panel-box-shadow)","customColor1":"#bfedd2","customColor2":"#fbeeb8","customColor3":"#f8cac6","customColor4":"#eccafa","customColor5":"#c2e0f4","customColor6":"#2dc26b","customColor7":"#f1c40f","customColor8":"#e03e2d","customColor9":"#b96ad9","customColor10":"#3598db","customColor11":"#169179","customColor12":"#e67e23","customColor13":"#ba372a","customColor14":"#843fa1","customColor15":"#236fa1","customColor16":"#ecf0f1","customColor17":"#ced4d9","customColor18":"#95a5a6","customColor19":"#7e8c8d","customColor20":"#34495e","customColor21":"#000000","customColor22":"#ffffff","defaultMessageHeaderMarginTop":"40px","defaultMessageHeaderMarginBottom":"20px","defaultMessageItemMarginTop":"0","defaultMessageItemMarginBottom":"4px","diffAddedColor":"hsla(170, 53%, 51%, 0.4)","diffChangedColor":"hsla(43, 97%, 63%, 0.4)","diffNoneColor":"hsla(0, 0%, 80%, 0.4)","diffRemovedColor":"hsla(9, 74%, 47%, 0.4)","specialMessageHeaderMarginTop":"40px","specialMessageHeaderMarginBottom":"20px","specialMessageItemMarginTop":"0","specialMessageItemMarginBottom":"4px","__typename":"RteThemeSettings"},"tags":{"bgColor":"var(--lia-bs-gray-200)","bgHoverColor":"var(--lia-bs-gray-400)","borderRadius":"var(--lia-bs-border-radius-sm)","color":"var(--lia-bs-body-color)","hoverColor":"var(--lia-bs-body-color)","fontWeight":"var(--lia-font-weight-md)","fontSize":"var(--lia-font-size-xxs)","textTransform":"UPPERCASE","letterSpacing":"0.5px","__typename":"TagsThemeSettings"},"toasts":{"borderRadius":"var(--lia-bs-border-radius)","paddingX":"12px","__typename":"ToastsThemeSettings"},"typography":{"fontFamilyBase":"'Segoe UI', 'Helvetica Neue', Helvetica, Roboto, Arial, sans-serif","fontStyleBase":"NORMAL","fontWeightBase":"400","fontWeightLight":"300","fontWeightNormal":"400","fontWeightMd":"500","fontWeightBold":"700","letterSpacingSm":"normal","letterSpacingXs":"normal","lineHeightBase":"1.5","fontSizeBase":"16px","fontSizeXxs":"11px","fontSizeXs":"12px","fontSizeSm":"14px","fontSizeLg":"20px","fontSizeXl":"24px","smallFontSize":"14px","customFonts":[],"__typename":"TypographyThemeSettings"},"unstyledListItem":{"marginBottomSm":"5px","marginBottomMd":"10px","marginBottomLg":"15px","marginBottomXl":"20px","marginBottomXxl":"25px","__typename":"UnstyledListItemThemeSettings"},"yiq":{"light":"#ffffff","dark":"#000000","__typename":"YiqThemeSettings"},"colorLightness":{"primaryDark":0.36,"primaryLight":0.74,"primaryLighter":0.89,"primaryLightest":0.95,"infoDark":0.39,"infoLight":0.72,"infoLighter":0.85,"infoLightest":0.93,"successDark":0.24,"successLight":0.62,"successLighter":0.8,"successLightest":0.91,"warningDark":0.39,"warningLight":0.68,"warningLighter":0.84,"warningLightest":0.93,"dangerDark":0.41,"dangerLight":0.72,"dangerLighter":0.89,"dangerLightest":0.95,"__typename":"ColorLightnessThemeSettings"},"localOverride":false,"__typename":"Theme"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1743051948261","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:myob.prod:pages/forums/ForumMessagePage:board:Bus-Report-1742488485330":{"__typename":"CachedAsset","id":"quilt:myob.prod:pages/forums/ForumMessagePage:board:Bus-Report-1742488485330","value":{"id":"ForumMessagePage","container":{"id":"Common","headerProps":{"backgroundImageProps":null,"backgroundColor":null,"addComponents":null,"removeComponents":["community.widget.bannerWidget"],"componentOrder":null,"__typename":"QuiltContainerSectionProps"},"headerComponentProps":{"community.widget.breadcrumbWidget":{"disableLastCrumbForDesktop":false}},"footerProps":null,"footerComponentProps":null,"items":[{"id":"message-list","layout":"MAIN_SIDE","bgColor":"var(--lia-bs-gray-200)","showTitle":false,"showDescription":false,"textPosition":"CENTER","textColor":"var(--lia-bs-body-color)","sectionEditLevel":null,"bgImage":null,"disableSpacing":null,"edgeToEdgeDisplay":null,"fullHeight":null,"showBorder":null,"__typename":"MainSideQuiltSection","columnMap":{"main":[{"id":"messages.widget.topicWithThreadedReplyListWidget","className":"lia-topic-with-replies","props":{"editLevel":"CONFIGURE"},"__typename":"QuiltComponent"}],"side":[{"id":"custom.widget.Start_a_post","className":null,"props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":true,"title":"Looking for something else?","lazyLoad":false},"__typename":"QuiltComponent"},{"id":"custom.widget.Online_Help_SME","className":null,"props":{"customComponentId":"custom.widget.Online_Help_SME","customComponentProps":[]},"__typename":"QuiltComponent"},{"id":"custom.widget.MYOB_Academy","className":null,"props":{"customComponentId":"custom.widget.MYOB_Academy","customComponentProps":[]},"__typename":"QuiltComponent"},{"id":"messages.widget.relatedContentWidget","className":null,"props":{"hideIfEmpty":true,"enablePagination":false,"useTitle":true,"listVariant":{"type":"unstyled","props":{"listItemSpacing":"md"}},"instanceId":"1706573650217","pageSize":8,"style":"compact","pagerVariant":{"type":"none"},"viewVariant":{"type":"inline","props":{"useRepliesCount":false,"useMedia":false,"useAuthorRank":false,"useNode":false,"boardIconSize":"24","useAuthorLoginLink":true,"useNodeLink":true,"usePreviewMedia":true,"timeStampType":"postTime","useTextBody":true,"useSolvedBadge":false,"subjectAs":"h6","renderPostTimeBeforeAuthor":true,"useAvatar":true,"useVideoPreview":false,"portraitClampBodyLines":3,"useCompactSpacing":true,"useTimeToRead":false,"useSpoilerFreeBody":true,"useKudosCount":false,"useViewCount":false,"useBody":false,"useTags":false,"clampSubjectLines":1,"useBoardIcon":false,"useMessageTimeLink":true,"useAuthorLogin":true}},"lazyLoad":false,"panelType":"bubble"},"__typename":"QuiltComponent"}],"__typename":"MainSideSectionColumns"}}],"__typename":"QuiltContainer"},"__typename":"Quilt","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/EmailVerification-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1743051948261","value":{"email.verification.title":"Email Verification Required","email.verification.message.update.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. To change your email, visit My Settings.","email.verification.message.resend.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. Resend email."},"localOverride":false},"CachedAsset:text:en_US-pages/forums/ForumMessagePage-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1743051948261","value":{"title":"{contextMessageSubject} | {communityTitle}","errorMissing":"This message cannot be found","name":"Forum Message Page","section.message-list.title":"Forum Discussion","archivedMessageTitle":"This Content Has Been Archived","section.FvIRbP.title":"Forum Discussion","section.message-list.description":"","section.FvIRbP.description":""},"localOverride":false},"CachedAsset:quiltWrapper:myob.prod:Common:1742488389518":{"__typename":"CachedAsset","id":"quiltWrapper:myob.prod:Common:1742488389518","value":{"id":"Common","header":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"var(--lia-bs-gray-200)","items":[{"id":"community.widget.navbarWidget","props":{"showUserName":true,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"links":{"sideLinks":[],"mainLinks":[{"children":[{"linkType":"INTERNAL","id":"solo-link","params":{"categoryId":"Solo"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-1","params":{"categoryId":"Business"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-2","params":{"categoryId":"AccountRight"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-3","params":{"categoryId":"NZinfo"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-4","params":{"categoryId":"AdvancedPlatform"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-5","params":{"categoryId":"EntProdHelp"},"routeName":"CategoryPage"}],"linkType":"INTERNAL","id":"migrated-link-0","params":{"categoryId":"Support"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"partner-program-members","params":{"categoryId":"partner-program-members"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-7","params":{"boardId":"AD_Notices","categoryId":"beta"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-8","params":{"boardId":"MYOBAdvisor","categoryId":"beta"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-9","params":{"boardId":"myob-client-accounting","categoryId":"beta"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-10","params":{"boardId":"AETax","categoryId":"beta"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-11","params":{"boardId":"PracticeBAS","categoryId":"beta"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-6","params":{"categoryId":"beta"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-21","params":{"categoryId":"Scholarly"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-22","params":{"categoryId":"Developer"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-23","params":{"boardId":"AccountRightAPIquestions","categoryId":"top"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-24","params":{"categoryId":"MYOBAdvanced"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-25","params":{"categoryId":"enterprisesolutionpartners"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-26","params":{"groupHubId":"Payroll"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"migrated-link-27","params":{"boardId":"AccountEdge","categoryId":"PartnersGroup"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-20","params":{"categoryId":"PartnersGroup"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"Common-welcome-link","params":{"boardId":"Welcome","categoryId":"PurpleLounge"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"Common-community-blog-link","params":{"boardId":"CommunityBlog","categoryId":"PurpleLounge"},"routeName":"BlogBoardPage"},{"linkType":"INTERNAL","id":"Common-myobconnect-link","params":{"boardId":"myobconnect","categoryId":"PurpleLounge"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"Common-incident-communications-link","params":{"boardId":"incident-communications","categoryId":"PurpleLounge"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"Common-bank-feed-updates-link","params":{"boardId":"bank-feed-updates","categoryId":"PurpleLounge"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"Common-purple-lounge-link","params":{"categoryId":"PurpleLounge"},"routeName":"CategoryPage"}]},"className":"QuiltComponent_lia-component-edit-mode__0nCcm","style":{"boxShadow":"var(--lia-bs-box-shadow-sm)","linkFontWeight":"400","controllerHighlightColor":"hsla(30, 100%, 50%)","dropdownDividerMarginBottom":"10px","hamburgerBorderHover":"none","linkFontSize":"14px","linkBoxShadowHover":"none","backgroundOpacity":0.8,"controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerBgColor":"transparent","linkTextBorderBottom":"none","hamburgerColor":"var(--lia-nav-controller-icon-color)","brandLogoHeight":"34px","linkLetterSpacing":"normal","linkBgHoverColor":"transparent","collapseMenuDividerOpacity":0.16,"paddingBottom":"15px","dropdownPaddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"1px solid var(--lia-bs-border-color)","hamburgerBorder":"none","dropdownPaddingX":"10px","brandMarginRightSm":"10px","linkBoxShadow":"none","linkJustifyContent":"flex-start","linkColor":"var(--lia-bs-body-color)","collapseMenuDividerBg":"var(--lia-nav-link-color)","dropdownPaddingTop":"10px","controllerHighlightTextColor":"var(--lia-yiq-dark)","controllerTextColor":"var(--lia-nav-controller-icon-color)","background":{"imageAssetName":"","color":"var(--lia-bs-gray-200)","size":"COVER","repeat":"NO_REPEAT","position":"CENTER_CENTER","imageLastModified":""},"linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkHoverColor":"var(--lia-bs-body-color)","position":"FIXED","linkBorder":"none","linkTextBorderBottomHover":"2px solid var(--lia-bs-primary)","brandMarginRight":"30px","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","linkBorderHover":"none","collapseMenuMarginLeft":"20px","linkFontStyle":"NORMAL","linkPaddingX":"10px","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","paddingTop":"15px","linkPaddingY":"5px","linkTextTransform":"NONE","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkBgColor":"transparent","linkDropdownPaddingY":"9px","controllerIconColor":"var(--lia-bs-body-color)","dropdownDividerMarginTop":"10px","linkGap":"10px","controllerIconHoverColor":"var(--lia-bs-body-color)"},"showSearchIcon":true,"languagePickerStyle":"iconAndLabel"},"__typename":"QuiltComponent"},{"id":"community.widget.breadcrumbWidget","props":{"backgroundColor":"transparent","linkHighlightColor":"var(--lia-bs-primary)","visualEffects":{"showBottomBorder":true},"backgroundOpacity":100,"linkTextColor":"var(--lia-bs-gray-700)"},"__typename":"QuiltComponent"},{"id":"community.widget.bannerWidget","props":{"backgroundColor":"transparent","visualEffects":{"showBottomBorder":true},"backgroundOpacity":100,"backgroundImageProps":{"backgroundSize":"COVER","backgroundPosition":"CENTER_CENTER","backgroundRepeat":"NO_REPEAT"},"fontColor":"var(--lia-bs-body-color)"},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"footer":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"var(--lia-bs-gray-200)","items":[{"id":"community.widget.footerWidget","props":null,"__typename":"QuiltComponent"},{"id":"custom.widget.Custom_Footer","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":false,"title":"","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"__typename":"QuiltWrapper","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/ActionFeedback-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1743051948261","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","groupHubInviteNotFound.message":"Sorry, we could not find your invitation to the group. The owner may have canceled the invite.","groupHubNotFound.title":"Group Not Found","groupHubNotFound.message":"The grouphub you tried to join does not exist. It may have been deleted.","existingGroupHubMember.title":"Already Joined","existingGroupHubMember.message":"You are already a member of this group.","accountLocked.title":"Account Locked","accountLocked.message":"Your account has been locked due to multiple failed attempts. Try again in {lockoutTime} minutes.","editedGroupHub.title":"Changes Saved","editedGroupHub.message":"Your group has been updated.","leftGroupHub.title":"Goodbye","leftGroupHub.message":"You are no longer a member of this group and will not receive future updates.","deletedGroupHub.title":"Deleted","deletedGroupHub.message":"The group has been deleted.","groupHubCreated.title":"Group Created","groupHubCreated.message":"{groupHubName} is ready to use","accountClosed.title":"Account Closed","accountClosed.message":"The account has been closed and you will now be redirected to the homepage","resetTokenExpired.title":"Reset Password Link has Expired","resetTokenExpired.message":"Try resetting your password again","invalidUrl.title":"Invalid URL","invalidUrl.message":"The URL you're using is not recognized. Verify your URL and try again.","accountClosedForUser.title":"Account Closed","accountClosedForUser.message":"{userName}'s account is closed","inviteTokenInvalid.title":"Invitation Invalid","inviteTokenInvalid.message":"Your invitation to the community has been canceled or expired.","inviteTokenError.title":"Invitation Verification Failed","inviteTokenError.message":"The url you are utilizing is not recognized. Verify your URL and try again","pageNotFound.title":"Access Denied","pageNotFound.message":"You do not have access to this area of the community or it doesn't exist","eventAttending.title":"Responded as Attending","eventAttending.message":"You'll be notified when there's new activity and reminded as the event approaches","eventInterested.title":"Responded as Interested","eventInterested.message":"You'll be notified when there's new activity and reminded as the event approaches","eventNotFound.title":"Event Not Found","eventNotFound.message":"The event you tried to respond to does not exist.","redirectToRelatedPage.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.message":"The content you are trying to access is archived","redirectToRelatedPage.message":"The content you are trying to access is archived","relatedUrl.archivalLink.flyoutMessage":"The content you are trying to access is archived View Archived Content"},"localOverride":false},"CachedAsset:component:custom.widget.Start_a_post-en-1742488507270":{"__typename":"CachedAsset","id":"component:custom.widget.Start_a_post-en-1742488507270","value":{"component":{"id":"custom.widget.Start_a_post","template":{"id":"Start_a_post","markupLanguage":"HTML","style":null,"texts":null,"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Start_a_post","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"TEXTHTML","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":null,"form":null},"localOverride":false},"CachedAsset:component:custom.widget.Online_Help_SME-en-1742488507270":{"__typename":"CachedAsset","id":"component:custom.widget.Online_Help_SME-en-1742488507270","value":{"component":{"id":"custom.widget.Online_Help_SME","template":{"id":"Online_Help_SME","markupLanguage":"HTML","style":null,"texts":null,"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Online_Help_SME","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"TEXTHTML","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":null,"form":null},"localOverride":false},"CachedAsset:component:custom.widget.MYOB_Academy-en-1742488507270":{"__typename":"CachedAsset","id":"component:custom.widget.MYOB_Academy-en-1742488507270","value":{"component":{"id":"custom.widget.MYOB_Academy","template":{"id":"MYOB_Academy","markupLanguage":"HTML","style":null,"texts":null,"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.MYOB_Academy","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"TEXTHTML","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":null,"form":null},"localOverride":false},"CachedAsset:component:custom.widget.Custom_Footer-en-1742488507270":{"__typename":"CachedAsset","id":"component:custom.widget.Custom_Footer-en-1742488507270","value":{"component":{"id":"custom.widget.Custom_Footer","template":{"id":"Custom_Footer","markupLanguage":"HANDLEBARS","style":".sr-only {\n position: absolute;\n width: 1px;\n height: 1px;\n padding: 0;\n margin: -1px;\n overflow: hidden;\n clip: rect(0, 0, 0, 0);\n border: 0;\n}\n\n.custom-footer-wrapper {\n background-color: #1b2830;\n}\n\n.custom-footer {\n width: 100%;\n padding: 40px var(--lia-bs-grid-gutter-width);\n margin: 0 auto;\n font-size: 14px;\n\n @media (min-width: 576px) {\n max-width: 33.75rem;\n }\n\n @media (min-width: 768px) {\n max-width: 45rem;\n padding: 40px calc(var(--lia-bs-grid-gutter-width) * 0.5);\n }\n\n @media (min-width: 992px) {\n max-width: 60rem;\n }\n\n @media (min-width: 1260px) {\n max-width: var(--lia-container-max-width);\n }\n}\n\n.footer-links-wrapper {\n display: flex;\n justify-content: flex-start;\n flex-wrap: wrap;\n width: 100%;\n color: var(--lia-rte-custom-color-18);\n\n ul {\n list-style: none;\n padding: 0;\n flex: 100%;\n margin-bottom: 0;\n\n li {\n a {\n color: var(--lia-rte-custom-color-18);\n padding: 5px 0;\n display: inline-block;\n }\n }\n }\n\n + .footer-links-wrapper {\n border-top: 1px solid #687480;\n margin-top: 20px;\n padding-top: 20px;\n }\n}\n\n.footer-text-wrapper {\n color: var(--lia-rte-custom-color-18);\n width: 100%;\n}\n\n.footer-text-wrapper p {\n margin-bottom: 0;\n}\n\n.footer-social-wrapper {\n display: flex;\n justify-content: space-between;\n color: var(--lia-rte-custom-color-18);\n border-top: 1px solid var(--lia-rte-custom-color-18);\n margin-top: 20px;\n padding-top: 20px;\n width: 100%;\n}\n\n.footer-links-wrapper .footer-social-wrapper ul li {\n width: auto;\n display: inline-block;\n}\n\n.footer-links-wrapper .footer-social-wrapper ul li a {\n padding: 0;\n margin-right: 0;\n border-radius: 12px;\n}\n\n@media (min-width: 992px) {\n .footer-text-wrapper,\n .footer-social-wrapper {\n width: auto;\n }\n\n .footer-social-wrapper {\n border-top: 0;\n margin-top: 0;\n padding-top: 0;\n width: auto;\n }\n\n .footer-links-wrapper ul {\n flex: auto;\n flex-wrap: wrap;\n }\n\n .footer-links-wrapper ul li {\n display: inline-block;\n }\n\n .footer-links-wrapper ul li a {\n margin-right: 20px;\n }\n\n .footer-links-wrapper-2 {\n justify-content: space-between;\n }\n}\n\n.myob-social-links a:hover .myob-icon {\n fill: #969ea7;\n}\n\n.myob-social-links .myob-icon {\n -webkit-transition: fill 0.2s ease-out;\n transition: fill 0.2s ease-out;\n fill: #687480;\n}\n\n.myob-social-links .myob-icon a {\n -webkit-transition: color 0.2s ease-out;\n transition: color 0.2s ease-out;\n color: #969ea7;\n text-decoration: none;\n}\n\n.myob-footer-copyright {\n color: #687480;\n padding-right: 20px;\n}\n\n.myob-footer-copyright a,\n.myob-footer-copyright a:hover {\n color: var(--lia-rte-custom-color-18);\n}\n\n.myob-social-links {\n margin-bottom: 0;\n}\n\n.myob-social-links li {\n float: left;\n margin-bottom: 0;\n line-height: 0;\n}\n\n.myob-social-links li + li {\n margin-left: 1.25em;\n}\n\n.myob-social-links li a:before {\n content: \" \";\n display: inline-block;\n width: 24px;\n height: 24px;\n background-size: contain;\n background-position: center;\n}\n.myob-social-links .twitter a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 6%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,0A12,12,0,1,0,24,12,12,12,0,0,0,12,0Zm5.33,10c0,.12,0,.23,0,.35A7.75,7.75,0,0,1,5.4,16.92a5.48,5.48,0,0,0,4-1.13A2.73,2.73,0,0,1,6.89,13.9a2.73,2.73,0,0,0,1.23,0,2.73,2.73,0,0,1-2.19-2.67v0a2.73,2.73,0,0,0,1.23.34,2.73,2.73,0,0,1-.84-3.64,7.74,7.74,0,0,0,5.62,2.85,2.76,2.76,0,0,1-.07-.62,2.73,2.73,0,0,1,4.72-1.86,5.49,5.49,0,0,0,1.73-.66c-.2.64-.23.87-.79,1.21a1.46,1.46,0,0,0,1.34,0A5.8,5.8,0,0,1,17.33,10Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.myob-social-links .googleplus a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 4%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,0A12,12,0,1,0,24,12,12,12,0,0,0,12,0ZM9,17.5a5.5,5.5,0,1,1,4.1-9.17L11.61,9.67a3.5,3.5,0,1,0,.56,3.84H9v-2h4.47a1,1,0,0,1,1,1.11A5.49,5.49,0,0,1,9,17.5Zm10.5-4v2h-2v-2h-2v-2h2v-2h2v2h2v2Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.myob-social-links .facebook a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 1%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,0A12,12,0,1,0,24,12,12,12,0,0,0,12,0Zm3.51,12H13.2v7.2h-3V12H8.4V9.58h1.8V8.29A2.61,2.61,0,0,1,13,5.4h2.6V7.77H13.81a.58.58,0,0,0-.61.66V9.58h2.56Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.myob-social-links .linkedin a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 5%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,24A12,12,0,1,0,0,12,12,12,0,0,0,12,24Zm1.82-10.71a1.2,1.2,0,0,0-1.2,1.2v4.2h-3s0-7.2,0-7.8h3v.89A3.72,3.72,0,0,1,15,10.91c1.78,0,3,1.29,3,3.78v4H15v-4.2A1.2,1.2,0,0,0,13.82,13.29ZM6.91,9.69h0A1.47,1.47,0,0,1,5.4,8.2,1.44,1.44,0,0,1,6.93,6.75a1.47,1.47,0,1,1,0,2.94Zm1.51,9h-3v-7.8h3Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.myob-social-links .instagram a:before {\n background: url(\"data:image/svg+xml;base64,PHN2ZyBjbGFzcz0ibXlvYi1pY29uIiB2aWV3Qm94PSIwIDAgMjQgMjQiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+IDxwYXRoIGQ9Ik0xMiAwYzYuNjE3IDAgMTIgNS4zODMgMTIgMTIgMCA2LjYxNi01LjM4MyAxMi0xMiAxMlMwIDE4LjYxNiAwIDEyQzAgNS4zODQgNS4zODMgMCAxMiAwem03IDE2LjE2NlY3LjgzYzAtMS41Ni0xLjI3LTIuODMtMi44MzMtMi44M0g3LjgzM0M2LjI3MSA1IDUgNi4yNyA1IDcuODN2OC4zMzVDNSAxNy43MjkgNi4yNzEgMTkgNy44MzMgMTloOC4zMzRDMTcuNzMgMTkgMTkgMTcuNzMgMTkgMTYuMTY2ek04LjU0NSA5LjUyTDggOS41MjRWNmgxdjIuODgxYy0uMTcyLjE5Ny0uMzIzLjQxLS40NTUuNjM5ek0xNSAxMS41YzAgMS42NTYtMS4zNDQgMy0zIDMtMS42NTcgMC0zLTEuMzQ0LTMtMyAwLTEuNjU3IDEuMzQzLTMgMy0zIDEuNjU2IDAgMyAxLjM0MyAzIDN6bS01LTMuNDQ0VjZoNi4xNjdDMTcuMTc4IDYgMTggNi44MjIgMTggNy44MzF2MS42N2wtMi41NTMuMDA1QzE0Ljc1NCA4LjMxMyAxMy40NzcgNy41IDEyIDcuNWMtLjczMSAwLTEuNDA5LjIxMi0yIC41NTZ6TTE2IDhoMVY3aC0xdjF6TTcgOS41MjRsLTEgLjAwM1Y3LjgzMmMwLS43MS40MDktMS4zMTggMS0xLjYyMnYzLjMxNHoiIGZpbGw9IiM2ODc0ODAiIGZpbGwtcnVsZT0iZXZlbm9kZCIvPiA8L3N2Zz4=\")\n no-repeat;\n}\n","texts":null,"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Custom_Footer","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":{"css":".custom_widget_Custom_Footer_sr-only_7twck_1 {\n position: absolute;\n width: 0.0625rem;\n height: 0.0625rem;\n padding: 0;\n margin: -0.0625rem;\n overflow: hidden;\n clip: rect(0, 0, 0, 0);\n border: 0;\n}\n\n.custom_widget_Custom_Footer_custom-footer-wrapper_7twck_12 {\n background-color: #1b2830;\n}\n\n.custom_widget_Custom_Footer_custom-footer_7twck_12 {\n width: 100%;\n padding: 2.5rem var(--lia-bs-grid-gutter-width);\n margin: 0 auto;\n font-size: 0.875rem;\n\n @media (min-width: 576px) {\n max-width: 33.75rem;\n }\n\n @media (min-width: 768px) {\n max-width: 45rem;\n padding: 2.5rem calc(var(--lia-bs-grid-gutter-width) * 0.5);\n }\n\n @media (min-width: 992px) {\n max-width: 60rem;\n }\n\n @media (min-width: 1260px) {\n max-width: var(--lia-container-max-width);\n }\n}\n\n.custom_widget_Custom_Footer_footer-links-wrapper_7twck_40 {\n display: flex;\n justify-content: flex-start;\n flex-wrap: wrap;\n width: 100%;\n color: var(--lia-rte-custom-color-18);\n\n ul {\n list-style: none;\n padding: 0;\n flex: 100%;\n margin-bottom: 0;\n\n li {\n a {\n color: var(--lia-rte-custom-color-18);\n padding: 0.3125rem 0;\n display: inline-block;\n }\n }\n }\n\n + .custom_widget_Custom_Footer_footer-links-wrapper_7twck_40 {\n border-top: 1px solid #687480;\n margin-top: 1.25rem;\n padding-top: 1.25rem;\n }\n}\n\n.custom_widget_Custom_Footer_footer-text-wrapper_7twck_69 {\n color: var(--lia-rte-custom-color-18);\n width: 100%;\n}\n\n.custom_widget_Custom_Footer_footer-text-wrapper_7twck_69 p {\n margin-bottom: 0;\n}\n\n.custom_widget_Custom_Footer_footer-social-wrapper_7twck_78 {\n display: flex;\n justify-content: space-between;\n color: var(--lia-rte-custom-color-18);\n border-top: 1px solid var(--lia-rte-custom-color-18);\n margin-top: 1.25rem;\n padding-top: 1.25rem;\n width: 100%;\n}\n\n.custom_widget_Custom_Footer_footer-links-wrapper_7twck_40 .custom_widget_Custom_Footer_footer-social-wrapper_7twck_78 ul li {\n width: auto;\n display: inline-block;\n}\n\n.custom_widget_Custom_Footer_footer-links-wrapper_7twck_40 .custom_widget_Custom_Footer_footer-social-wrapper_7twck_78 ul li a {\n padding: 0;\n margin-right: 0;\n border-radius: 0.75rem;\n}\n\n@media (min-width: 992px) {\n .custom_widget_Custom_Footer_footer-text-wrapper_7twck_69,\n .custom_widget_Custom_Footer_footer-social-wrapper_7twck_78 {\n width: auto;\n }\n\n .custom_widget_Custom_Footer_footer-social-wrapper_7twck_78 {\n border-top: 0;\n margin-top: 0;\n padding-top: 0;\n width: auto;\n }\n\n .custom_widget_Custom_Footer_footer-links-wrapper_7twck_40 ul {\n flex: auto;\n flex-wrap: wrap;\n }\n\n .custom_widget_Custom_Footer_footer-links-wrapper_7twck_40 ul li {\n display: inline-block;\n }\n\n .custom_widget_Custom_Footer_footer-links-wrapper_7twck_40 ul li a {\n margin-right: 1.25rem;\n }\n\n .custom_widget_Custom_Footer_footer-links-wrapper-2_7twck_125 {\n justify-content: space-between;\n }\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 a:hover .custom_widget_Custom_Footer_myob-icon_7twck_130 {\n fill: #969ea7;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 .custom_widget_Custom_Footer_myob-icon_7twck_130 {\n transition: fill 0.2s ease-out;\n fill: #687480;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 .custom_widget_Custom_Footer_myob-icon_7twck_130 a {\n transition: color 0.2s ease-out;\n color: #969ea7;\n text-decoration: none;\n}\n\n.custom_widget_Custom_Footer_myob-footer-copyright_7twck_147 {\n color: #687480;\n padding-right: 1.25rem;\n}\n\n.custom_widget_Custom_Footer_myob-footer-copyright_7twck_147 a,\n.custom_widget_Custom_Footer_myob-footer-copyright_7twck_147 a:hover {\n color: var(--lia-rte-custom-color-18);\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 {\n margin-bottom: 0;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 li {\n float: left;\n margin-bottom: 0;\n line-height: 0;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 li + li {\n margin-left: 1.25em;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 li a:before {\n content: \" \";\n display: inline-block;\n width: 1.5rem;\n height: 1.5rem;\n background-size: contain;\n background-position: center;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 .custom_widget_Custom_Footer_twitter_7twck_179 a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 6%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,0A12,12,0,1,0,24,12,12,12,0,0,0,12,0Zm5.33,10c0,.12,0,.23,0,.35A7.75,7.75,0,0,1,5.4,16.92a5.48,5.48,0,0,0,4-1.13A2.73,2.73,0,0,1,6.89,13.9a2.73,2.73,0,0,0,1.23,0,2.73,2.73,0,0,1-2.19-2.67v0a2.73,2.73,0,0,0,1.23.34,2.73,2.73,0,0,1-.84-3.64,7.74,7.74,0,0,0,5.62,2.85,2.76,2.76,0,0,1-.07-.62,2.73,2.73,0,0,1,4.72-1.86,5.49,5.49,0,0,0,1.73-.66c-.2.64-.23.87-.79,1.21a1.46,1.46,0,0,0,1.34,0A5.8,5.8,0,0,1,17.33,10Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 .custom_widget_Custom_Footer_googleplus_7twck_184 a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 4%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,0A12,12,0,1,0,24,12,12,12,0,0,0,12,0ZM9,17.5a5.5,5.5,0,1,1,4.1-9.17L11.61,9.67a3.5,3.5,0,1,0,.56,3.84H9v-2h4.47a1,1,0,0,1,1,1.11A5.49,5.49,0,0,1,9,17.5Zm10.5-4v2h-2v-2h-2v-2h2v-2h2v2h2v2Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 .custom_widget_Custom_Footer_facebook_7twck_189 a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 1%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,0A12,12,0,1,0,24,12,12,12,0,0,0,12,0Zm3.51,12H13.2v7.2h-3V12H8.4V9.58h1.8V8.29A2.61,2.61,0,0,1,13,5.4h2.6V7.77H13.81a.58.58,0,0,0-.61.66V9.58h2.56Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 .custom_widget_Custom_Footer_linkedin_7twck_194 a:before {\n background: url(\"data:image/svg+xml;charset=utf8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3E%3Ctitle%3EAsset 5%3C/title%3E%3Cg id='Layer_2' data-name='Layer 2'%3E%3Cg id='Layer_1-2' data-name='Layer 1'%3E%3Cpath d='M12,24A12,12,0,1,0,0,12,12,12,0,0,0,12,24Zm1.82-10.71a1.2,1.2,0,0,0-1.2,1.2v4.2h-3s0-7.2,0-7.8h3v.89A3.72,3.72,0,0,1,15,10.91c1.78,0,3,1.29,3,3.78v4H15v-4.2A1.2,1.2,0,0,0,13.82,13.29ZM6.91,9.69h0A1.47,1.47,0,0,1,5.4,8.2,1.44,1.44,0,0,1,6.93,6.75a1.47,1.47,0,1,1,0,2.94Zm1.51,9h-3v-7.8h3Z' style='fill:%23687480'/%3E%3C/g%3E%3C/g%3E%3C/svg%3E\")\n no-repeat;\n}\n\n.custom_widget_Custom_Footer_myob-social-links_7twck_130 .custom_widget_Custom_Footer_instagram_7twck_199 a:before {\n background: url(\"data:image/svg+xml;base64,PHN2ZyBjbGFzcz0ibXlvYi1pY29uIiB2aWV3Qm94PSIwIDAgMjQgMjQiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+IDxwYXRoIGQ9Ik0xMiAwYzYuNjE3IDAgMTIgNS4zODMgMTIgMTIgMCA2LjYxNi01LjM4MyAxMi0xMiAxMlMwIDE4LjYxNiAwIDEyQzAgNS4zODQgNS4zODMgMCAxMiAwem03IDE2LjE2NlY3LjgzYzAtMS41Ni0xLjI3LTIuODMtMi44MzMtMi44M0g3LjgzM0M2LjI3MSA1IDUgNi4yNyA1IDcuODN2OC4zMzVDNSAxNy43MjkgNi4yNzEgMTkgNy44MzMgMTloOC4zMzRDMTcuNzMgMTkgMTkgMTcuNzMgMTkgMTYuMTY2ek04LjU0NSA5LjUyTDggOS41MjRWNmgxdjIuODgxYy0uMTcyLjE5Ny0uMzIzLjQxLS40NTUuNjM5ek0xNSAxMS41YzAgMS42NTYtMS4zNDQgMy0zIDMtMS42NTcgMC0zLTEuMzQ0LTMtMyAwLTEuNjU3IDEuMzQzLTMgMy0zIDEuNjU2IDAgMyAxLjM0MyAzIDN6bS01LTMuNDQ0VjZoNi4xNjdDMTcuMTc4IDYgMTggNi44MjIgMTggNy44MzF2MS42N2wtMi41NTMuMDA1QzE0Ljc1NCA4LjMxMyAxMy40NzcgNy41IDEyIDcuNWMtLjczMSAwLTEuNDA5LjIxMi0yIC41NTZ6TTE2IDhoMVY3aC0xdjF6TTcgOS41MjRsLTEgLjAwM1Y3LjgzMmMwLS43MS40MDktMS4zMTggMS0xLjYyMnYzLjMxNHoiIGZpbGw9IiM2ODc0ODAiIGZpbGwtcnVsZT0iZXZlbm9kZCIvPiA8L3N2Zz4=\")\n no-repeat;\n}\n","tokens":{"sr-only":"custom_widget_Custom_Footer_sr-only_7twck_1","custom-footer-wrapper":"custom_widget_Custom_Footer_custom-footer-wrapper_7twck_12","custom-footer":"custom_widget_Custom_Footer_custom-footer_7twck_12","footer-links-wrapper":"custom_widget_Custom_Footer_footer-links-wrapper_7twck_40","footer-text-wrapper":"custom_widget_Custom_Footer_footer-text-wrapper_7twck_69","footer-social-wrapper":"custom_widget_Custom_Footer_footer-social-wrapper_7twck_78","footer-links-wrapper-2":"custom_widget_Custom_Footer_footer-links-wrapper-2_7twck_125","myob-social-links":"custom_widget_Custom_Footer_myob-social-links_7twck_130","myob-icon":"custom_widget_Custom_Footer_myob-icon_7twck_130","myob-footer-copyright":"custom_widget_Custom_Footer_myob-footer-copyright_7twck_147","twitter":"custom_widget_Custom_Footer_twitter_7twck_179","googleplus":"custom_widget_Custom_Footer_googleplus_7twck_184","facebook":"custom_widget_Custom_Footer_facebook_7twck_189","linkedin":"custom_widget_Custom_Footer_linkedin_7twck_194","instagram":"custom_widget_Custom_Footer_instagram_7twck_199"}},"form":null},"localOverride":false},"CachedAsset:text:en_US-components/community/Breadcrumb-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1743051948261","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1743051948261","value":{"messageMarkedAsSpam":"This post has been marked as spam","messageMarkedAsSpam@board:TKB":"This article has been marked as spam","messageMarkedAsSpam@board:BLOG":"This post has been marked as spam","messageMarkedAsSpam@board:FORUM":"This discussion has been marked as spam","messageMarkedAsSpam@board:OCCASION":"This event has been marked as spam","messageMarkedAsSpam@board:IDEA":"This idea has been marked as spam","manageSpam":"Manage Spam","messageMarkedAsAbuse":"This post has been marked as abuse","messageMarkedAsAbuse@board:TKB":"This article has been marked as abuse","messageMarkedAsAbuse@board:BLOG":"This post has been marked as abuse","messageMarkedAsAbuse@board:FORUM":"This discussion has been marked as abuse","messageMarkedAsAbuse@board:OCCASION":"This event has been marked as abuse","messageMarkedAsAbuse@board:IDEA":"This idea has been marked as abuse","preModCommentAuthorText":"This comment will be published as soon as it is approved","preModCommentModeratorText":"This comment is awaiting moderation","messageMarkedAsOther":"This post has been rejected due to other reasons","messageMarkedAsOther@board:TKB":"This article has been rejected due to other reasons","messageMarkedAsOther@board:BLOG":"This post has been rejected due to other reasons","messageMarkedAsOther@board:FORUM":"This discussion has been rejected due to other reasons","messageMarkedAsOther@board:OCCASION":"This event has been rejected due to other reasons","messageMarkedAsOther@board:IDEA":"This idea has been rejected due to other reasons","messageArchived":"This post was archived on {date}","relatedUrl":"View Related Content","relatedContentText":"Showing related content","archivedContentLink":"View Archived Content"},"localOverride":false},"CachedAsset:text:en_US-components/messages/RelatedContentWidget-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/RelatedContentWidget-1743051948261","value":{"title":"Related Content","emptyDescription":"No content to show","title@instance:1706573650217":"Related content","title@instance:ozpMun":"Related content"},"localOverride":false},"CachedAsset:text:en_US-components/community/FooterWidget-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/community/FooterWidget-1743051948261","value":{"homeLink":"Community Home","topOfPage":"Top of Page","buildHash":"Build Hash:","buildNumber":"Build Number:","buildTime":"Build Time:","privacyPolicy":"Privacy Policy","helpLink":"Help"},"localOverride":false},"Forum:board:Welcome":{"__typename":"Forum","id":"board:Welcome","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:NZinfo":{"__typename":"Category","id":"category:NZinfo","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:beta":{"__typename":"Category","id":"category:beta","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:PurpleLounge":{"__typename":"Category","id":"category:PurpleLounge","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:AccountEdge":{"__typename":"Forum","id":"board:AccountEdge","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:AccountRightAPIquestions":{"__typename":"Forum","id":"board:AccountRightAPIquestions","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:CommunityBlog":{"__typename":"Blog","id":"board:CommunityBlog","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:AccountRight":{"__typename":"Category","id":"category:AccountRight","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"entityType":"CATEGORY","displayId":"AccountRight","nodeType":"category","depth":2,"title":"MYOB AccountRight","shortTitle":"MYOB AccountRight"},"Forum:board:AETax":{"__typename":"Forum","id":"board:AETax","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:AD_Notices":{"__typename":"Forum","id":"board:AD_Notices","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:MYOBAdvisor":{"__typename":"Forum","id":"board:MYOBAdvisor","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:PartnersGroup":{"__typename":"Category","id":"category:PartnersGroup","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:AdvancedPlatform":{"__typename":"Category","id":"category:AdvancedPlatform","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"GroupHub:grouphub:Payroll":{"__typename":"GroupHub","id":"grouphub:Payroll","grouphubPolicies":{"__typename":"GroupHubPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Scholarly":{"__typename":"Category","id":"category:Scholarly","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:PracticeBAS":{"__typename":"Forum","id":"board:PracticeBAS","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:myobconnect":{"__typename":"Forum","id":"board:myobconnect","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:EntProdHelp":{"__typename":"Category","id":"category:EntProdHelp","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:myob-client-accounting":{"__typename":"Forum","id":"board:myob-client-accounting","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:incident-communications":{"__typename":"Forum","id":"board:incident-communications","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Solo":{"__typename":"Category","id":"category:Solo","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:bank-feed-updates":{"__typename":"Forum","id":"board:bank-feed-updates","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Rank:rank:187":{"__typename":"Rank","id":"rank:187","position":63,"name":"Experienced User","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:213224":{"__typename":"User","id":"user:213224","uid":213224,"login":"Michel-lci","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-10-08T11:17:51.667+11:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-10.svg?time=0"},"rank":{"__ref":"Rank:rank:187"},"messagesCount":15,"kudosGivenCount":1,"kudosReceivedCount":5,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":1,"entityType":"USER","eventPath":"community:myob/user:213224"},"AssociatedImage:{\"url\":\"https://community.myob.com/t5/s/myob/images/bi05MTctNDd1V01V?image-coordinates=0%2C0%2C320%2C320\"}":{"__typename":"AssociatedImage","url":"https://community.myob.com/t5/s/myob/images/bi05MTctNDd1V01V?image-coordinates=0%2C0%2C320%2C320","mimeType":"image/png"},"Forum:board:ARimportexport":{"__typename":"Forum","id":"board:ARimportexport","entityType":"FORUM","displayId":"ARimportexport","nodeType":"board","depth":3,"conversationStyle":"FORUM","title":"AccountRight: Import/Export & Integrations","shortTitle":"AccountRight: Import/Export & Integrations","parent":{"__ref":"Category:category:AccountRight"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":true,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":{"__ref":"AssociatedImage:{\"url\":\"https://community.myob.com/t5/s/myob/images/bi05MTctNDd1V01V?image-coordinates=0%2C0%2C320%2C320\"}"},"description":"","eventPath":"category:AccountRight/category:Support/community:myobboard:ARimportexport/"},"ForumTopicMessage:message:716273":{"__typename":"ForumTopicMessage","uid":716273,"subject":"Export to Excel doesn't work","id":"message:716273","revisionNum":1,"repliesCount":14,"author":{"__ref":"User:user:213224"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:ARimportexport"},"conversation":{"__ref":"Conversation:conversation:716273"},"moderationData":{"__ref":"ModerationData:moderation_data:716273"},"postTime":"2021-07-28T09:53:39.101+10:00","lastPublishTime":"2021-07-28T09:53:39.101+10:00","readOnly":true,"metrics":{"__typename":"MessageMetrics","views":9232},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:ARimportexport/message:716273"},"Conversation:conversation:716273":{"__typename":"Conversation","id":"conversation:716273","solved":true,"topic":{"__ref":"ForumTopicMessage:message:716273"},"lastPostingActivityTime":"2021-08-10T11:10:58.272+10:00","lastPostTime":"2021-08-10T11:10:58.272+10:00"},"ModerationData:moderation_data:716273":{"__typename":"ModerationData","id":"moderation_data:716273","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:716273":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:716273","relatedMessage":{"__ref":"ForumTopicMessage:message:716273"}},"User:user:239387":{"__typename":"User","id":"user:239387","uid":239387,"login":"Polly_Templeton","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2020-11-05T15:52:20.559+11:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-6.svg?time=0"},"rank":{"__ref":"Rank:rank:187"},"messagesCount":20,"kudosGivenCount":4,"kudosReceivedCount":2,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":2,"entityType":"USER","eventPath":"community:myob/user:239387"},"AssociatedImage:{\"url\":\"https://community.myob.com/t5/s/myob/images/bi05MDktUjVDVmk1?image-coordinates=0%2C0%2C320%2C320\"}":{"__typename":"AssociatedImage","url":"https://community.myob.com/t5/s/myob/images/bi05MDktUjVDVmk1?image-coordinates=0%2C0%2C320%2C320","mimeType":"image/png"},"Forum:board:AccountRight-Reports":{"__typename":"Forum","id":"board:AccountRight-Reports","entityType":"FORUM","displayId":"AccountRight-Reports","nodeType":"board","depth":3,"conversationStyle":"FORUM","title":"AccountRight: Reports","shortTitle":"AccountRight: Reports","parent":{"__ref":"Category:category:AccountRight"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":true,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":{"__ref":"AssociatedImage:{\"url\":\"https://community.myob.com/t5/s/myob/images/bi05MDktUjVDVmk1?image-coordinates=0%2C0%2C320%2C320\"}"},"description":"","eventPath":"category:AccountRight/category:Support/community:myobboard:AccountRight-Reports/"},"ForumTopicMessage:message:890484":{"__typename":"ForumTopicMessage","uid":890484,"subject":"Export to Excel and send Excel file not working","id":"message:890484","revisionNum":1,"repliesCount":2,"author":{"__ref":"User:user:239387"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:AccountRight-Reports"},"conversation":{"__ref":"Conversation:conversation:890484"},"moderationData":{"__ref":"ModerationData:moderation_data:890484"},"postTime":"2025-03-14T10:13:22.886+11:00","lastPublishTime":"2025-03-14T10:13:22.886+11:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":30},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:AccountRight-Reports/message:890484"},"Conversation:conversation:890484":{"__typename":"Conversation","id":"conversation:890484","solved":true,"topic":{"__ref":"ForumTopicMessage:message:890484"},"lastPostingActivityTime":"2025-03-14T11:47:27.347+11:00","lastPostTime":"2025-03-14T11:47:27.347+11:00"},"ModerationData:moderation_data:890484":{"__typename":"ModerationData","id":"moderation_data:890484","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:890484":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:890484","relatedMessage":{"__ref":"ForumTopicMessage:message:890484"}},"User:user:263603":{"__typename":"User","id":"user:263603","uid":263603,"login":"tomwidauer","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-01-13T16:12:31.144+11:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-11.svg?time=0"},"rank":null,"messagesCount":3,"kudosGivenCount":0,"kudosReceivedCount":1,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:263603"},"ForumTopicMessage:message:739767":{"__typename":"ForumTopicMessage","uid":739767,"subject":"Export to Excel not working in AccountRight 2021.8","id":"message:739767","revisionNum":1,"repliesCount":3,"author":{"__ref":"User:user:263603"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:ARimportexport"},"conversation":{"__ref":"Conversation:conversation:739767"},"moderationData":{"__ref":"ModerationData:moderation_data:739767"},"postTime":"2022-01-13T16:22:38.025+11:00","lastPublishTime":"2022-01-13T16:22:38.025+11:00","readOnly":true,"metrics":{"__typename":"MessageMetrics","views":1814},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:ARimportexport/message:739767"},"Conversation:conversation:739767":{"__typename":"Conversation","id":"conversation:739767","solved":true,"topic":{"__ref":"ForumTopicMessage:message:739767"},"lastPostingActivityTime":"2022-01-19T11:04:52.367+11:00","lastPostTime":"2022-01-19T11:04:52.367+11:00"},"ModerationData:moderation_data:739767":{"__typename":"ModerationData","id":"moderation_data:739767","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:739767":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:739767","relatedMessage":{"__ref":"ForumTopicMessage:message:739767"}},"User:user:321654":{"__typename":"User","id":"user:321654","uid":321654,"login":"MMA1","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2024-02-04T16:02:40.067+11:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-1.svg?time=0"},"rank":null,"messagesCount":1,"kudosGivenCount":0,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:321654"},"AssociatedImage:{\"url\":\"https://community.myob.com/t5/s/myob/images/bi0zNDktZ0hzaUZO?image-coordinates=0%2C0%2C320%2C320\"}":{"__typename":"AssociatedImage","url":"https://community.myob.com/t5/s/myob/images/bi0zNDktZ0hzaUZO?image-coordinates=0%2C0%2C320%2C320","mimeType":"image/png"},"Forum:board:Staffing_and_Payroll":{"__typename":"Forum","id":"board:Staffing_and_Payroll","entityType":"FORUM","displayId":"Staffing_and_Payroll","nodeType":"board","depth":3,"conversationStyle":"FORUM","title":"AccountRight: Payroll","shortTitle":"AccountRight: Payroll","parent":{"__ref":"Category:category:AccountRight"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":true,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":{"__ref":"AssociatedImage:{\"url\":\"https://community.myob.com/t5/s/myob/images/bi0zNDktZ0hzaUZO?image-coordinates=0%2C0%2C320%2C320\"}"},"description":"Discuss any issues with payroll and staffing.","eventPath":"category:AccountRight/category:Support/community:myobboard:Staffing_and_Payroll/"},"ForumTopicMessage:message:856462":{"__typename":"ForumTopicMessage","uid":856462,"subject":"EXPORT EMPLOYEE DETAILS","id":"message:856462","revisionNum":1,"repliesCount":1,"author":{"__ref":"User:user:321654"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Staffing_and_Payroll"},"conversation":{"__ref":"Conversation:conversation:856462"},"moderationData":{"__ref":"ModerationData:moderation_data:856462"},"postTime":"2024-02-04T16:10:03.291+11:00","lastPublishTime":"2024-02-04T16:10:03.291+11:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":710},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:Staffing_and_Payroll/message:856462"},"Conversation:conversation:856462":{"__typename":"Conversation","id":"conversation:856462","solved":true,"topic":{"__ref":"ForumTopicMessage:message:856462"},"lastPostingActivityTime":"2024-02-07T11:57:45.399+11:00","lastPostTime":"2024-02-07T11:57:45.399+11:00"},"ModerationData:moderation_data:856462":{"__typename":"ModerationData","id":"moderation_data:856462","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:856462":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:856462","relatedMessage":{"__ref":"ForumTopicMessage:message:856462"}},"Rank:rank:189":{"__typename":"Rank","id":"rank:189","position":64,"name":"Contributing User","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:311165":{"__typename":"User","id":"user:311165","uid":311165,"login":"ANCCranes","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-09-13T12:35:30.768+10:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-8.svg?time=0"},"rank":{"__ref":"Rank:rank:189"},"messagesCount":5,"kudosGivenCount":0,"kudosReceivedCount":4,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:311165"},"ForumTopicMessage:message:836415":{"__typename":"ForumTopicMessage","uid":836415,"subject":"Unable to Export Reports to Excel","id":"message:836415","revisionNum":1,"repliesCount":18,"author":{"__ref":"User:user:311165"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:AccountRight-Reports"},"conversation":{"__ref":"Conversation:conversation:836415"},"moderationData":{"__ref":"ModerationData:moderation_data:836415"},"postTime":"2023-09-13T12:41:53.546+10:00","lastPublishTime":"2023-09-13T12:41:53.546+10:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":3749},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:AccountRight-Reports/message:836415"},"Conversation:conversation:836415":{"__typename":"Conversation","id":"conversation:836415","solved":true,"topic":{"__ref":"ForumTopicMessage:message:836415"},"lastPostingActivityTime":"2024-12-16T17:22:03.557+11:00","lastPostTime":"2024-12-16T17:22:03.557+11:00"},"ModerationData:moderation_data:836415":{"__typename":"ModerationData","id":"moderation_data:836415","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:836415":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:836415","relatedMessage":{"__ref":"ForumTopicMessage:message:836415"}},"Rank:rank:177":{"__typename":"Rank","id":"rank:177","position":58,"name":"Cover User","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:163113":{"__typename":"User","id":"user:163113","uid":163113,"login":"GM3191","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2017-04-12T09:19:22.383+10:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-12.svg?time=0"},"rank":{"__ref":"Rank:rank:177"},"messagesCount":2,"kudosGivenCount":0,"kudosReceivedCount":1,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:163113"},"AssociatedImage:{\"url\":\"https://community.myob.com/t5/s/myob/images/bi0zNTAtT25CV1B3?image-coordinates=0%2C0%2C320%2C320\"}":{"__typename":"AssociatedImage","url":"https://community.myob.com/t5/s/myob/images/bi0zNTAtT25CV1B3?image-coordinates=0%2C0%2C320%2C320","mimeType":"image/png"},"Forum:board:Sales_and_Purchases":{"__typename":"Forum","id":"board:Sales_and_Purchases","entityType":"FORUM","displayId":"Sales_and_Purchases","nodeType":"board","depth":3,"conversationStyle":"FORUM","title":"AccountRight: Sales and Purchases","shortTitle":"AccountRight: Sales and Purchases","parent":{"__ref":"Category:category:AccountRight"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":true,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":{"__ref":"AssociatedImage:{\"url\":\"https://community.myob.com/t5/s/myob/images/bi0zNTAtT25CV1B3?image-coordinates=0%2C0%2C320%2C320\"}"},"description":"Chat about sales and purchasing in AccountRight.","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/"},"ForumTopicMessage:message:857840":{"__typename":"ForumTopicMessage","uid":857840,"subject":"Exporting Reports to Excel not working","id":"message:857840","revisionNum":1,"repliesCount":12,"author":{"__ref":"User:user:163113"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"conversation":{"__ref":"Conversation:conversation:857840"},"moderationData":{"__ref":"ModerationData:moderation_data:857840"},"postTime":"2024-02-14T13:42:21.659+11:00","lastPublishTime":"2024-02-14T13:42:21.659+11:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":2185},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/message:857840"},"Conversation:conversation:857840":{"__typename":"Conversation","id":"conversation:857840","solved":false,"topic":{"__ref":"ForumTopicMessage:message:857840"},"lastPostingActivityTime":"2024-10-23T10:57:24.577+11:00","lastPostTime":"2024-10-23T10:57:24.577+11:00"},"ModerationData:moderation_data:857840":{"__typename":"ModerationData","id":"moderation_data:857840","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:857840":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:857840","relatedMessage":{"__ref":"ForumTopicMessage:message:857840"}},"User:user:347491":{"__typename":"User","id":"user:347491","uid":347491,"login":"Shane404","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2024-09-05T16:23:21.650+10:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-10.svg?time=0"},"rank":{"__ref":"Rank:rank:187"},"messagesCount":18,"kudosGivenCount":4,"kudosReceivedCount":11,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:347491"},"ForumTopicMessage:message:881674":{"__typename":"ForumTopicMessage","uid":881674,"subject":"Unable to export report","id":"message:881674","revisionNum":1,"repliesCount":3,"author":{"__ref":"User:user:347491"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:AccountRight-Reports"},"conversation":{"__ref":"Conversation:conversation:881674"},"moderationData":{"__ref":"ModerationData:moderation_data:881674"},"postTime":"2024-10-25T14:13:12.742+11:00","lastPublishTime":"2024-10-25T14:13:12.742+11:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":123},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:AccountRight-Reports/message:881674"},"Conversation:conversation:881674":{"__typename":"Conversation","id":"conversation:881674","solved":true,"topic":{"__ref":"ForumTopicMessage:message:881674"},"lastPostingActivityTime":"2024-10-25T15:29:19.663+11:00","lastPostTime":"2024-10-25T15:29:19.663+11:00"},"ModerationData:moderation_data:881674":{"__typename":"ModerationData","id":"moderation_data:881674","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:881674":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:881674","relatedMessage":{"__ref":"ForumTopicMessage:message:881674"}},"User:user:342737":{"__typename":"User","id":"user:342737","uid":342737,"login":"ElleMC","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2024-07-08T15:43:20.579+10:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-11.svg?time=0"},"rank":null,"messagesCount":4,"kudosGivenCount":0,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:342737"},"ForumTopicMessage:message:889945":{"__typename":"ForumTopicMessage","uid":889945,"subject":"Exporting reports to Excel not working","id":"message:889945","revisionNum":1,"repliesCount":9,"author":{"__ref":"User:user:342737"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:AccountRight-Reports"},"conversation":{"__ref":"Conversation:conversation:889945"},"moderationData":{"__ref":"ModerationData:moderation_data:889945"},"postTime":"2025-03-07T12:15:06.706+11:00","lastPublishTime":"2025-03-07T12:15:06.706+11:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":72},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:AccountRight-Reports/message:889945"},"Conversation:conversation:889945":{"__typename":"Conversation","id":"conversation:889945","solved":false,"topic":{"__ref":"ForumTopicMessage:message:889945"},"lastPostingActivityTime":"2025-03-25T13:12:03.364+11:00","lastPostTime":"2025-03-25T13:12:03.364+11:00"},"ModerationData:moderation_data:889945":{"__typename":"ModerationData","id":"moderation_data:889945","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:889945":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:889945","relatedMessage":{"__ref":"ForumTopicMessage:message:889945"}},"QueryVariables:TopicReplyList:message:874387:1":{"__typename":"QueryVariables","id":"TopicReplyList:message:874387:1","value":{"id":"message:874387","first":10,"sorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":true,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"ROOT_MUTATION":{"__typename":"Mutation"},"CachedAsset:text:en_US-components/community/Navbar-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1743051948261","value":{"community":"Community Home","inbox":"Inbox","manageContent":"Manage Content","tos":"Terms of Service","forgotPassword":"Forgot Password","themeEditor":"Theme Editor","edit":"Edit Navigation Bar","skipContent":"Skip to content","migrated-link-9":"MYOB Client Accounting","migrated-link-7":"Admin Tasks & General Discussions","Common-community-blog-link":"MYOB Announcements","migrated-link-8":"MYOB Practice Manager / Document Manager","Common-purple-lounge-link":"MYOB Community Hub","Common-incident-communications-link":"Incident Communications","migrated-link-1":"MYOB Business","migrated-link-21":"Students & Educators","migrated-link-2":"MYOB AccountRight","migrated-link-22":"Developers","Common-bank-feed-updates-link":"Bank Feed Updates","onboarding-hub":"Installing the app","migrated-link-0":"Product Help & Ideas","migrated-link-20":"Other Groups & Software","migrated-link-5":"MYOB EXO","migrated-link-6":"Accountants & Bookkeepers","migrated-link-3":"NZ Payroll and Tax","migrated-link-4":"MYOB Acumatica","migrated-link-18":"Contacts - manage you customers and suppliers","migrated-link-19":"Categories - organise your transactions","migrated-link-16":"Invoicing - get paid faster","migrated-link-17":"Expenses - stay on top of your spending","migrated-link-14":"Share your ideas","migrated-link-15":"Early access program news","migrated-link-12":"EAP Hub","migrated-link-13":"Getting set up","partner-program-members":"Partner Program Members","Common-myobconnect-link":"MYOB Community Connect","migrated-link-10":"MYOB AU Tax","migrated-link-11":"MYOB Online Tax AU","solo-link":"Solo by MYOB","help":"Ask a question","migrated-link-27":"Other MYOB software","migrated-link-25":"MYOB Enterprise Solutions Partners","town-square---soloists":"Soloist Town Square","migrated-link-26":"Payroll Hub","migrated-link-23":"MYOB Business API","migrated-link-24":"MYOB Acumatica Partners","Common-welcome-link":"Welcome to the Community"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarHamburgerDropdown-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1743051948261","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1743051948261","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1743051948261","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1743051948261","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1743051948261","value":{"title.login":"Sign In","title.registration":"Register","title.forgotPassword":"Forgot Password","title.multiAuthLogin":"Sign In"},"localOverride":false},"CachedAsset:text:en_US-components/nodes/NodeLink-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1743051948261","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1743051948261","value":{"anonymous":"Anonymous","author":"{messageAuthorLogin}","authorBy":"{messageAuthorLogin}","board":"{messageBoardTitle}","replyToUser":" to {parentAuthor}","showMoreReplies":"Show More","replyText":"Reply","repliesText":"Replies","markedAsSolved":"Marked as Solved","movedMessagePlaceholder.BLOG":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.TKB":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.FORUM":"{count, plural, =0 {This reply has been} other {These replies have been} }","movedMessagePlaceholder.IDEA":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.OCCASION":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholderUrlText":"moved.","messageStatus":"Status: ","statusChanged":"Status changed: {previousStatus} to {currentStatus}","statusAdded":"Status added: {status}","statusRemoved":"Status removed: {status}","labelExpand":"expand replies","labelCollapse":"collapse replies","unhelpfulReason.reason1":"Content is outdated","unhelpfulReason.reason2":"Article is missing information","unhelpfulReason.reason3":"Content is for a different Product","unhelpfulReason.reason4":"Doesn't match what I was searching for"},"localOverride":false},"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1743051948261","value":{"title":"{count, plural, one{# Reply} other{# Replies}}","title@board:BLOG":"{count, plural, one{# Comment} other{# Comments}}","title@board:TKB":"{count, plural, one{# Comment} other{# Comments}}","title@board:IDEA":"{count, plural, one{# Comment} other{# Comments}}","title@board:OCCASION":"{count, plural, one{# Comment} other{# Comments}}","noRepliesTitle":"No Replies","noRepliesTitle@board:BLOG":"No Comments","noRepliesTitle@board:TKB":"No Comments","noRepliesTitle@board:IDEA":"No Comments","noRepliesTitle@board:OCCASION":"No Comments","noRepliesDescription":"Be the first to reply","noRepliesDescription@board:BLOG":"Be the first to comment","noRepliesDescription@board:TKB":"Be the first to comment","noRepliesDescription@board:IDEA":"Be the first to comment","noRepliesDescription@board:OCCASION":"Be the first to comment","messageReadOnlyAlert:BLOG":"Comments have been turned off for this post","messageReadOnlyAlert:TKB":"Comments have been turned off for this article","messageReadOnlyAlert:IDEA":"Comments have been turned off for this idea","messageReadOnlyAlert:FORUM":"Replies have been turned off for this discussion","messageReadOnlyAlert:OCCASION":"Comments have been turned off for this event"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyCallToAction-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1743051948261","value":{"leaveReply":"Leave a reply...","leaveReply@board:BLOG@message:root":"Leave a comment...","leaveReply@board:TKB@message:root":"Leave a comment...","leaveReply@board:IDEA@message:root":"Leave a comment...","leaveReply@board:OCCASION@message:root":"Leave a comment...","repliesTurnedOff.FORUM":"Replies are turned off for this topic","repliesTurnedOff.BLOG":"Comments are turned off for this topic","repliesTurnedOff.TKB":"Comments are turned off for this topic","repliesTurnedOff.IDEA":"Comments are turned off for this topic","repliesTurnedOff.OCCASION":"Comments are turned off for this topic","infoText":"Stop poking me!"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1743051948261","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/BuildInformation-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/BuildInformation-1743051948261","value":{"buildHash":"Build Hash: {buildHash}","buildNumber":"Build Number: {buildNumber}","buildTime":"Build Time: {buildTime}"},"localOverride":false},"CachedAsset:text:en_US-components/community/KhorosLogo-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/community/KhorosLogo-1743051948261","value":{"alt":"Powered By Khoros"},"localOverride":false},"User:user:346406":{"__typename":"User","id":"user:346406","uid":346406,"login":"Nigel_ST","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2024-08-20T17:49:23.600+10:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-10.svg?time=0"},"rank":null,"entityType":"USER","eventPath":"community:myob/user:346406"},"ModerationData:moderation_data:876727":{"__typename":"ModerationData","id":"moderation_data:876727","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":"member"},"Rank:rank:165":{"__typename":"Rank","id":"rank:165","position":52,"name":"Ultimate Cover User","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:1368":{"__typename":"User","id":"user:1368","uid":1368,"login":"Mike_James","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2007-05-08T09:52:23.407+10:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/images/dS0xMzY4LTQ4N2k3M0EzMkFBQzNCOUMwOUJE"},"rank":{"__ref":"Rank:rank:165"},"entityType":"USER","eventPath":"community:myob/user:1368"},"AcceptedSolutionMessage:message:876727":{"__typename":"AcceptedSolutionMessage","uid":876727,"id":"message:876727","revisionNum":1,"author":{"__ref":"User:user:346406"},"readOnly":false,"repliesCount":3,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Bus-Report"},"parent":{"__ref":"ForumTopicMessage:message:874387"},"conversation":{"__ref":"Conversation:conversation:874387"},"subject":"Re: Excel formula not working when exported","moderationData":{"__ref":"ModerationData:moderation_data:876727"},"body":"

Hi Lisa_BBP,
This is caused by the MYOB export putting something in cells that appear blank, that isn't a number. Using a formula that references that cell and expects a number, will result in the #VALUE! error.

This issue is visible when you look at the name of an account on export and its truncated, but when you press delete on the cell to the right, the full name of the account becomes visible. Its also identifiable when you 'ctrl+arrow' through a document which should take you to the next cell with data, but it skips whole sections with or without numbers as excel considers the entire area to contain information, like a whole column of DR despite only several rows containing actual numbers. This issued does not exist on Excel exports from the desktop AR package, just the cloud version of MYOB.

The Export process needs to be corrected to not export zero length strings.

 

This is solvable in a roundabout way:

  1. Open find and replace (Ctrl+H)
  2. Leave the \"Find What\" field blank
  3. Enter \"x\" in the \"Replace With\" field
  4. Make sure to check the \"Match Entire Cell Contents\" box
  5. Click Replace All
  6. Now switch what you entered in each field. Put the \"x\" in Find what, and delete everything in Replace with
  7. Click Replace All
  8. All apparently empty cells should now be truly empty.

Yep, MYOB needs to improve their exporting processes.

","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":2,"postTime":"2024-08-20T17:59:46.444+10:00","lastPublishTime":"2024-08-20T17:59:46.444+10:00","solution":true,"metrics":{"__typename":"MessageMetrics","views":181},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_REPLY","eventPath":"category:Business/category:Support/community:myobboard:Bus-Report/message:874387/message:876727","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wzfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:876921"}},{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wzfDE0OjAsMzk6MXwy","node":{"__ref":"ForumReplyMessage:message:876915"}}]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"editFrozen":false,"body@stringLength":"1473","rawBody":"

Hi Lisa_BBP,
This is caused by the MYOB export putting something in cells that appear blank, that isn't a number. Using a formula that references that cell and expects a number, will result in the #VALUE! error.

This issue is visible when you look at the name of an account on export and its truncated, but when you press delete on the cell to the right, the full name of the account becomes visible. Its also identifiable when you 'ctrl+arrow' through a document which should take you to the next cell with data, but it skips whole sections with or without numbers as excel considers the entire area to contain information, like a whole column of DR despite only several rows containing actual numbers. This issued does not exist on Excel exports from the desktop AR package, just the cloud version of MYOB.

The Export process needs to be corrected to not export zero length strings.

 

This is solvable in a roundabout way:

  1. Open find and replace (Ctrl+H)
  2. Leave the \"Find What\" field blank
  3. Enter \"x\" in the \"Replace With\" field
  4. Make sure to check the \"Match Entire Cell Contents\" box
  5. Click Replace All
  6. Now switch what you entered in each field. Put the \"x\" in Find what, and delete everything in Replace with
  7. Click Replace All
  8. All apparently empty cells should now be truly empty.

Yep, MYOB needs to improve their exporting processes.

","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:876727_1"},"latestVersion":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"203","videos":{"__typename":"VideoConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"ModerationData:moderation_data:876921":{"__typename":"ModerationData","id":"moderation_data:876921","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":"member"},"Rank:rank:185":{"__typename":"Rank","id":"rank:185","position":62,"name":"Trusted User","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:220187":{"__typename":"User","id":"user:220187","uid":220187,"login":"H-TS","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2020-02-14T13:03:26.517+11:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/m_assets/avatars/default/avatar-6.svg?time=0"},"rank":{"__ref":"Rank:rank:185"},"entityType":"USER","eventPath":"community:myob/user:220187"},"ForumReplyMessage:message:876921":{"__typename":"ForumReplyMessage","uid":876921,"id":"message:876921","revisionNum":1,"author":{"__ref":"User:user:1368"},"readOnly":false,"repliesCount":1,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Bus-Report"},"parent":{"__ref":"AcceptedSolutionMessage:message:876727"},"conversation":{"__ref":"Conversation:conversation:874387"},"subject":"Re: Excel formula not working when exported","moderationData":{"__ref":"ModerationData:moderation_data:876921"},"body":"

Hi Lisa_BBP , @Nigel_ST , in addition I found another method - highlight the debit and credit columns  (one column at a time), excluding any merged cells, and select Data, Text to columns. This also clears the zero-length strings.

","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"208","kudosSumWeight":1,"postTime":"2024-08-22T10:23:16.254+10:00","lastPublishTime":"2024-08-22T10:23:16.254+10:00","metrics":{"__typename":"MessageMetrics","views":71},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:Business/category:Support/community:myobboard:Bus-Report/message:874387/message:876921","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wxfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:890758"}}]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"editFrozen":false,"body@stringLength":"431","rawBody":"

Hi , @Nigel_ST , in addition I found another method - highlight the debit and credit columns  (one column at a time), excluding any merged cells, and select Data, Text to columns. This also clears the zero-length strings.

","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:876921_1"},"latestVersion":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"customFields":[]},"ModerationData:moderation_data:890758":{"__typename":"ModerationData","id":"moderation_data:890758","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":"member"},"ForumReplyMessage:message:890758":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:220187"},"id":"message:890758","revisionNum":1,"uid":890758,"depth":3,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Bus-Report"},"parent":{"__ref":"ForumReplyMessage:message:876921"},"conversation":{"__ref":"Conversation:conversation:874387"},"subject":"Re: Excel formula not working when exported","moderationData":{"__ref":"ModerationData:moderation_data:890758"},"body":"

Mike_Jamesand Nigel_ST Thank you! MVP awards to you both! This has been driving me insane.

","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"92","kudosSumWeight":0,"repliesCount":0,"postTime":"2025-03-19T08:37:30.223+11:00","lastPublishTime":"2025-03-19T08:37:30.223+11:00","metrics":{"__typename":"MessageMetrics","views":17},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:Business/category:Support/community:myobboard:Bus-Report/message:874387/message:890758","attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"readOnly":false,"editFrozen":false,"body@stringLength":"475","rawBody":"

and Thank you! MVP awards to you both! This has been driving me insane.

","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:890758_1"},"latestVersion":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"customFields":[]},"ModerationData:moderation_data:876915":{"__typename":"ModerationData","id":"moderation_data:876915","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":"member"},"ForumReplyMessage:message:876915":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:153350"},"id":"message:876915","revisionNum":1,"uid":876915,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Bus-Report"},"parent":{"__ref":"AcceptedSolutionMessage:message:876727"},"conversation":{"__ref":"Conversation:conversation:874387"},"subject":"Re: Excel formula not working when exported","moderationData":{"__ref":"ModerationData:moderation_data:876915"},"body":"

Hi Nigel_ST

Thank you so much for your assistance. MYOB certainly makes the simplest tasks more difficult these days.

","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"120","kudosSumWeight":0,"repliesCount":0,"postTime":"2024-08-22T09:51:35.830+10:00","lastPublishTime":"2024-08-22T09:51:35.830+10:00","metrics":{"__typename":"MessageMetrics","views":82},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:Business/category:Support/community:myobboard:Bus-Report/message:874387/message:876915","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"readOnly":false,"editFrozen":false,"body@stringLength":"130","rawBody":"

Hi Nigel_ST

Thank you so much for your assistance. MYOB certainly makes the simplest tasks more difficult these days.

","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:876915_1"},"latestVersion":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"customFields":[]},"Rank:rank:62":{"__typename":"Rank","id":"rank:62","position":4,"name":"MYOB Moderator","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:294708":{"__typename":"User","id":"user:294708","uid":294708,"login":"Earl_HD","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-03-03T17:14:13.686+11:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/images/dS0yOTQ3MDgtNDA1OThpQTBENDNEMTdGNTBFMjQzMg"},"rank":{"__ref":"Rank:rank:62"},"entityType":"USER","eventPath":"community:myob/user:294708"},"ModerationData:moderation_data:874406":{"__typename":"ModerationData","id":"moderation_data:874406","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:874406":{"__typename":"ForumReplyMessage","uid":874406,"id":"message:874406","revisionNum":1,"author":{"__ref":"User:user:294708"},"readOnly":false,"repliesCount":1,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Bus-Report"},"parent":{"__ref":"ForumTopicMessage:message:874387"},"conversation":{"__ref":"Conversation:conversation:874387"},"subject":"Re: Excel formula not working when exported","moderationData":{"__ref":"ModerationData:moderation_data:874406"},"body":"

Hi Lisa_BBP,

Thanks for your post. I recommend visiting these related posts, which you might find helpful. 
Export to Excel doesn't work
Exporting Reports to Excel not working

If you're still experiencing the issue after reviewing those posts, why not try our virtual assistant, MOCA? It's designed to dive deeper into issues like this. Give it a go! Feel free to engage with MOCA through myob.com/support for any queries or assistance you might need. If MOCA can't provide the help you need, our live chat team is available to pick up where MOCA left off.

Regards,
Earl

","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"208","kudosSumWeight":0,"postTime":"2024-07-30T16:59:48.253+10:00","lastPublishTime":"2024-07-30T16:59:48.253+10:00","metrics":{"__typename":"MessageMetrics","views":85},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:Business/category:Support/community:myobboard:Bus-Report/message:874387/message:874406","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wzfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:874582"}}]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[],"editFrozen":false,"body@stringLength":"1111","rawBody":"

Hi ,

Thanks for your post. I recommend visiting these related posts, which you might find helpful. 
Export to Excel doesn't work
Exporting Reports to Excel not working

If you're still experiencing the issue after reviewing those posts, why not try our virtual assistant, MOCA? It's designed to dive deeper into issues like this. Give it a go! Feel free to engage with MOCA through myob.com/support for any queries or assistance you might need. If MOCA can't provide the help you need, our live chat team is available to pick up where MOCA left off.

Regards,
Earl

","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:874406_1"},"latestVersion":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}}},"ModerationData:moderation_data:874582":{"__typename":"ModerationData","id":"moderation_data:874582","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":"member"},"ForumReplyMessage:message:874582":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:153350"},"id":"message:874582","revisionNum":1,"uid":874582,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Bus-Report"},"parent":{"__ref":"ForumReplyMessage:message:874406"},"conversation":{"__ref":"Conversation:conversation:874387"},"subject":"Re: Excel formula not working when exported","moderationData":{"__ref":"ModerationData:moderation_data:874582"},"body":"

Thanks for your reply, Earl, however you did not assist appropriately on this occasion as referring me to a \"bot\" clearly demonstrates that you are not interested in resolving this matter. I'm sure your time is valuable so I will continue to solve the matter in my own time.

Please do not mark this as a solution to the question, instead I suggest you archive it with the many other unresolved queries.

","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2024-08-01T09:02:54.978+10:00","lastPublishTime":"2024-08-01T09:02:54.978+10:00","metrics":{"__typename":"MessageMetrics","views":76},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:Business/category:Support/community:myobboard:Bus-Report/message:874387/message:874582","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"readOnly":false,"editFrozen":false,"body@stringLength":"415","rawBody":"

Thanks for your reply, Earl, however you did not assist appropriately on this occasion as referring me to a \"bot\" clearly demonstrates that you are not interested in resolving this matter. I'm sure your time is valuable so I will continue to solve the matter in my own time.

Please do not mark this as a solution to the question, instead I suggest you archive it with the many other unresolved queries.

","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:874582_1"},"latestVersion":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}}},"ModerationData:moderation_data:874619":{"__typename":"ModerationData","id":"moderation_data:874619","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":"member"},"ForumReplyMessage:message:874619":{"__typename":"ForumReplyMessage","uid":874619,"id":"message:874619","revisionNum":1,"author":{"__ref":"User:user:1368"},"readOnly":false,"repliesCount":4,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Bus-Report"},"parent":{"__ref":"ForumTopicMessage:message:874387"},"conversation":{"__ref":"Conversation:conversation:874387"},"subject":"Re: Excel formula not working when exported","moderationData":{"__ref":"ModerationData:moderation_data:874619"},"body":"

Hi Lisa_BBP , would the formula you are adding be a vlookup or similar? Sometimes the looked-up value is not exactly the same as the value in the lookup range, which you can test by entering a formula like =a1=a23. If this returns false, then the values are somehow different.

What values result in the error?

 

","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"postTime":"2024-08-01T11:48:29.948+10:00","lastPublishTime":"2024-08-01T11:48:29.948+10:00","metrics":{"__typename":"MessageMetrics","views":71},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:Business/category:Support/community:myobboard:Bus-Report/message:874387/message:874619","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wzfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:874623"}}]},"customFields":[],"editFrozen":false,"body@stringLength":"524","rawBody":"

Hi , would the formula you are adding be a vlookup or similar? Sometimes the looked-up value is not exactly the same as the value in the lookup range, which you can test by entering a formula like =a1=a23. If this returns false, then the values are somehow different.

What values result in the error?

 

","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:874619_1"},"latestVersion":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}}},"ModerationData:moderation_data:874623":{"__typename":"ModerationData","id":"moderation_data:874623","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":"member"},"ForumReplyMessage:message:874623":{"__typename":"ForumReplyMessage","uid":874623,"id":"message:874623","revisionNum":1,"author":{"__ref":"User:user:153350"},"readOnly":false,"repliesCount":3,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Bus-Report"},"parent":{"__ref":"ForumReplyMessage:message:874619"},"conversation":{"__ref":"Conversation:conversation:874387"},"subject":"Re: Excel formula not working when exported","moderationData":{"__ref":"ModerationData:moderation_data:874623"},"body":"

Hi Mike thank you for your reply. The formula is a very simple formula ie =a2-a1 using the amounts from the trial balance that have been exported to excel. I use the exported trial balance and enter the accountant adjustments and create the simple subtraction formula to calculate the difference in order to enter a manual adjustment journal to reconcile month end amounts in MYOB. The formula always gives me a #VALUE and it seems that the amounts in the downloaded trial balance are text and not numbers. My own solution is to enter the trial balance figures in separate columns in order to calculate the difference. This is not ideal as it is double entering values, hence doubling my data entry time. Does MYOB export the trial balance amounts as text and not numbers?

","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"postTime":"2024-08-01T12:01:27.253+10:00","lastPublishTime":"2024-08-01T12:01:27.253+10:00","metrics":{"__typename":"MessageMetrics","views":71},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:Business/category:Support/community:myobboard:Bus-Report/message:874387/message:874623","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wxfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:874678"}}]},"customFields":[],"editFrozen":false,"body@stringLength":"779","rawBody":"

Hi Mike thank you for your reply. The formula is a very simple formula ie =a2-a1 using the amounts from the trial balance that have been exported to excel. I use the exported trial balance and enter the accountant adjustments and create the simple subtraction formula to calculate the difference in order to enter a manual adjustment journal to reconcile month end amounts in MYOB. The formula always gives me a #VALUE and it seems that the amounts in the downloaded trial balance are text and not numbers. My own solution is to enter the trial balance figures in separate columns in order to calculate the difference. This is not ideal as it is double entering values, hence doubling my data entry time. Does MYOB export the trial balance amounts as text and not numbers?

","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:874623_1"},"latestVersion":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}}},"ModerationData:moderation_data:874678":{"__typename":"ModerationData","id":"moderation_data:874678","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":"member"},"ForumReplyMessage:message:874678":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1368"},"id":"message:874678","revisionNum":1,"uid":874678,"depth":3,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Bus-Report"},"parent":{"__ref":"ForumReplyMessage:message:874623"},"conversation":{"__ref":"Conversation:conversation:874387"},"subject":"Re: Excel formula not working when exported","moderationData":{"__ref":"ModerationData:moderation_data:874678"},"body":"

Hi Lisa_BBP , the error is caused by the empty cells. They appear to be empty but might not be. If you edit one of those cells, then backspace (either in the cell or in the formula bar), then press Enter to update, the formula will work. So there must be a non-printable character in those cells. 

I haven't found any other way to correct those cells; maybe someone else will have a suggestion.

","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":2,"postTime":"2024-08-01T15:28:40.951+10:00","lastPublishTime":"2024-08-01T15:28:40.951+10:00","metrics":{"__typename":"MessageMetrics","views":72},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:Business/category:Support/community:myobboard:Bus-Report/message:874387/message:874678","customFields":[],"readOnly":false,"editFrozen":false,"body@stringLength":"601","rawBody":"

Hi , the error is caused by the empty cells. They appear to be empty but might not be. If you edit one of those cells, then backspace (either in the cell or in the formula bar), then press Enter to update, the formula will work. So there must be a non-printable character in those cells. 

I haven't found any other way to correct those cells; maybe someone else will have a suggestion.

","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:874678_1"},"latestVersion":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}}},"QueryVariables:MessageSolutions":{"__typename":"QueryVariables","id":"MessageSolutions","value":{"first":10,"constraints":{"topicId":{"eq":"message:874387"},"solution":{"eq":true}},"sorts":{"postTime":{"direction":"ASC"}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":false,"useBody":true,"useKudosCount":false,"useTimeToRead":false,"useMedia":true,"useRepliesCount":false,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":true,"useTags":false,"useUserHoverCard":false,"useNodeHoverCard":false,"usePreviewSubjectModal":false,"useMessageStatus":false}},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1743051948261","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1743051948261","value":{"escalationMessage":"Escalated to Salesforce by {username} on {date}","viewDetails":"View Details","modalTitle":"Case Details","escalatedBy":"Escalated by: ","escalatedOn":"Escalated on: ","caseNumber":"Case Number: ","status":"Status: ","lastUpdateDate":"Last Update: ","automaticEscalation":"automatic escalation","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-components/users/UserLink-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1743051948261","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1743051948261","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1743051948261","value":{"postTime":"Published: {time}","lastPublishTime":"Last Update: {time}","conversation.lastPostingActivityTime":"Last posting activity time: {time}","conversation.lastPostTime":"Last post time: {time}","moderationData.rejectTime":"Rejected time: {time}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1743051948261","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1743051948261","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1743051948261","value":{"showMessageBody":"Show More","mentionsErrorTitle":"{mentionsType, select, board {Board} user {User} message {Message} other {}} No Longer Available","mentionsErrorMessage":"The {mentionsType} you are trying to view has been removed from the community.","videoProcessing":"Video is being processed. Please try again in a few minutes.","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageCustomFields-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1743051948261","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1743051948261","value":{"repliesCount":"{count}","title":"Reply","title@board:BLOG@message:root":"Comment","title@board:TKB@message:root":"Comment","title@board:IDEA@message:root":"Comment","title@board:OCCASION@message:root":"Comment"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolutionList-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolutionList-1743051948261","value":{"emptyDescription":"No has been message solutions yet"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1743051948261","value":{"accept":"Mark as Solution","accepted":"Marked as Solution","errorHeader":"Error!","errorAdd":"There was an error marking as solution.","errorRemove":"There was an error unmarking as solution.","solved":"Solved","topicAlreadySolvedErrorTitle":"Solution Already Exists","topicAlreadySolvedErrorDesc":"Refresh the browser to view the existing solution"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Pager/PagerLoadMore-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Pager/PagerLoadMore-1743051948261","value":{"loadMore":"Show More"},"localOverride":false},"CachedAsset:text:en_US-components/customComponent/CustomComponent-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/customComponent/CustomComponent-1743051948261","value":{"errorMessage":"Error rendering component id: {customComponentId}","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1743051948261","value":{"bylineAuthor":"{bylineAuthor}","bylineBoard":"{bylineBoard}","anonymous":"Anonymous","place":"Place {bylineBoard}","gotoParent":"Go to parent {name}"},"localOverride":false},"Revision:revision:890758_1":{"__typename":"Revision","id":"revision:890758_1","lastEditTime":"2025-03-19T08:37:30.223+11:00"},"Revision:revision:874582_1":{"__typename":"Revision","id":"revision:874582_1","lastEditTime":"2024-08-01T09:02:54.978+10:00"},"Revision:revision:876921_1":{"__typename":"Revision","id":"revision:876921_1","lastEditTime":"2024-08-22T10:23:16.254+10:00"},"Revision:revision:876727_1":{"__typename":"Revision","id":"revision:876727_1","lastEditTime":"2024-08-20T17:59:46.444+10:00"},"Revision:revision:874406_1":{"__typename":"Revision","id":"revision:874406_1","lastEditTime":"2024-07-30T16:59:48.253+10:00"},"Revision:revision:874623_1":{"__typename":"Revision","id":"revision:874623_1","lastEditTime":"2024-08-01T12:01:27.253+10:00"},"Revision:revision:876915_1":{"__typename":"Revision","id":"revision:876915_1","lastEditTime":"2024-08-22T09:51:35.830+10:00"},"Revision:revision:874678_1":{"__typename":"Revision","id":"revision:874678_1","lastEditTime":"2024-08-01T15:28:40.951+10:00"},"Revision:revision:874619_1":{"__typename":"Revision","id":"revision:874619_1","lastEditTime":"2024-08-01T11:48:29.948+10:00"},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1743051948261","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1743051948261":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1743051948261","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"bus-report","messageSubject":"excel-formula-not-working-when-exported","messageId":"874387"},"buildId":"9FJG2s74-Surmr3HCEDcZ","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"myob","openTelemetryServiceVersion":"25.2.0","openTelemetryUniverse":"prod","openTelemetryCollector":"http://localhost:4318","openTelemetryRouteChangeAllowedTime":"5000","apolloDevToolsEnabled":false,"inboxMuteWipFeatureEnabled":false},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["./components/seo/QAPageSchema/QAPageSchema.tsx","./components/community/Navbar/NavbarWidget.tsx","./components/community/Breadcrumb/BreadcrumbWidget.tsx","./components/messages/TopicWithThreadedReplyListWidget/TopicWithThreadedReplyListWidget.tsx","./components/customComponent/CustomComponent/CustomComponent.tsx","./components/messages/RelatedContentWidget/RelatedContentWidget.tsx","./components/community/FooterWidget/FooterWidget.tsx","./components/messages/MessageView/MessageViewStandard/MessageViewStandard.tsx","./components/messages/ThreadedReplyList/ThreadedReplyList.tsx","./components/community/FooterWidgetHelpLink/FooterWidgetHelpLink.tsx","./components/community/KhorosLogo/KhorosLogo.tsx","../shared/client/components/common/List/UnstyledList/UnstyledList.tsx","./components/messages/MessageView/MessageView.tsx","../shared/client/components/common/Pager/PagerLoadMore/PagerLoadMore.tsx","./components/customComponent/CustomComponentContent/HtmlContent.tsx","./components/messages/MessageView/MessageViewInline/MessageViewInline.tsx","./components/customComponent/CustomComponentContent/TemplateContent.tsx","./components/customComponent/CustomComponentContent/CustomComponentScripts.tsx"],"appGip":true,"scriptLoader":[]}