Forum Discussion
Find technical support and help for all MYOB products in our online help centre
Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.
We frequently export reports to Excel, in the past this has been a terrific feature.
However this month since upgrading to 2020.3 our reports are HUGE in size, we can not email the reports they are that big.
Is this a known issue? what has changed?
","kudosSumWeight":0,"postTime":"2020-10-01T13:34:14.518+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:678539_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":1599},"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,"customFields":[]},"Conversation:conversation:678539":{"__typename":"Conversation","id":"conversation:678539","solved":true,"topic":{"__ref":"ForumTopicMessage:message:678539"},"lastPostingActivityTime":"2020-11-10T12:50:05.588+11:00","lastPostTime":"2020-11-10T12:50:05.588+11:00","unreadReplyCount":9,"isSubscribed":false},"ModerationData:moderation_data:678539":{"__typename":"ModerationData","id":"moderation_data:678539","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:678539_1":{"__typename":"Revision","id":"revision:678539_1","lastEditTime":"2020-10-01T13:34:14.518+10:00"},"ForumReplyMessage:message:679844":{"__typename":"ForumReplyMessage","id":"message:679844","conversation":{"__ref":"Conversation:conversation:678539"},"author":{"__ref":"User:user:202751"},"revisionNum":1,"uid":679844,"depth":3,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"subject":"Re: Exporting Reports to Excel","readOnly":true,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:679844"},"parent":{"__ref":"ForumReplyMessage:message:679410"},"body":"
Hi SueSSA
\n
Generally, it could be due to the amount of transactions that have been retrieved in the report. You can try compressing the Excel spreadsheet and then emailing it as that would considerably reduce the file size. The only other alternative would be shortening the date range and creating a report that has less number of transactions and then emailing them out individually.
\n
That being said, we're currently investigating if the issue is related to recent update and will post an update on this thread if it is.
","body@stringLength":"766","rawBody":"Hi
Generally, it could be due to the amount of transactions that have been retrieved in the report. You can try compressing the Excel spreadsheet and then emailing it as that would considerably reduce the file size. The only other alternative would be shortening the date range and creating a report that has less number of transactions and then emailing them out individually.
\n
That being said, we're currently investigating if the issue is related to recent update and will post an update on this thread if it is.
","kudosSumWeight":0,"repliesCount":6,"postTime":"2020-10-12T11:42:38.924+11: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":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:679844_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":1518},"visibilityScope":"PUBLIC","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":[]}}},"customFields":[],"replies":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wxMHwxNDowLDM5OjF8MQ","node":{"__ref":"ForumReplyMessage:message:682260"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"CachedAsset:theme:customTheme1-1743557929554":{"__typename":"CachedAsset","id":"theme:customTheme1-1743557929554","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":"400","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":"Inter","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1744329197109","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:myob.prod:pages/forums/ForumMessagePage:board:Sales_and_Purchases-1744329195954":{"__typename":"CachedAsset","id":"quilt:myob.prod:pages/forums/ForumMessagePage:board:Sales_and_Purchases-1744329195954","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1744329197109","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1744329197109","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:1742490619964":{"__typename":"CachedAsset","id":"quiltWrapper:myob.prod:Common:1742490619964","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1744329197109","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-1742490734946":{"__typename":"CachedAsset","id":"component:custom.widget.Start_a_post-en-1742490734946","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-1742490734946":{"__typename":"CachedAsset","id":"component:custom.widget.Online_Help_SME-en-1742490734946","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-1742490734946":{"__typename":"CachedAsset","id":"component:custom.widget.MYOB_Academy-en-1742490734946","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-1742490734946":{"__typename":"CachedAsset","id":"component:custom.widget.Custom_Footer-en-1742490734946","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1744329197109","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1744329197109","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/RelatedContentWidget-1744329197109","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/community/FooterWidget-1744329197109","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}}},"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:Business":{"__typename":"Category","id":"category:Business","categoryPolicies":{"__typename":"CategoryPolicies","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}}},"User:user:236070":{"__typename":"User","id":"user:236070","uid":236070,"login":"CathS-BW","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2020-09-07T12:27:51.145+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-3.svg?time=0"},"rank":{"__ref":"Rank:rank:187"},"messagesCount":12,"kudosGivenCount":5,"kudosReceivedCount":3,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:236070"},"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:891817":{"__typename":"ForumTopicMessage","uid":891817,"subject":"Can't export reports to Excel","id":"message:891817","revisionNum":1,"repliesCount":4,"author":{"__ref":"User:user:236070"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:AccountRight-Reports"},"conversation":{"__ref":"Conversation:conversation:891817"},"moderationData":{"__ref":"ModerationData:moderation_data:891817"},"postTime":"2025-04-07T12:49:34.460+10:00","lastPublishTime":"2025-04-07T12:49:34.460+10:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":41},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:AccountRight-Reports/message:891817"},"Conversation:conversation:891817":{"__typename":"Conversation","id":"conversation:891817","solved":true,"topic":{"__ref":"ForumTopicMessage:message:891817"},"lastPostingActivityTime":"2025-04-07T14:03:01.068+10:00","lastPostTime":"2025-04-07T14:03:01.068+10:00"},"ModerationData:moderation_data:891817":{"__typename":"ModerationData","id":"moderation_data:891817","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:891817":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:891817","relatedMessage":{"__ref":"ForumTopicMessage:message:891817"}},"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":3819},"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"}},"User:user:209776":{"__typename":"User","id":"user:209776","uid":209776,"login":"DL111","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-08-14T09:36:55.716+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-7.svg?time=0"},"rank":{"__ref":"Rank:rank:187"},"messagesCount":33,"kudosGivenCount":9,"kudosReceivedCount":16,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:209776"},"ForumTopicMessage:message:753702":{"__typename":"ForumTopicMessage","uid":753702,"subject":"Export Reports to Excel","id":"message:753702","revisionNum":1,"repliesCount":10,"author":{"__ref":"User:user:209776"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:AccountRight-Reports"},"conversation":{"__ref":"Conversation:conversation:753702"},"moderationData":{"__ref":"ModerationData:moderation_data:753702"},"postTime":"2022-04-11T17:54:37.922+10:00","lastPublishTime":"2022-04-11T17:54:37.922+10:00","readOnly":true,"metrics":{"__typename":"MessageMetrics","views":1997},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:AccountRight-Reports/message:753702"},"Conversation:conversation:753702":{"__typename":"Conversation","id":"conversation:753702","solved":true,"topic":{"__ref":"ForumTopicMessage:message:753702"},"lastPostingActivityTime":"2022-05-24T09:14:51.868+10:00","lastPostTime":"2022-05-24T09:14:51.868+10:00"},"ModerationData:moderation_data:753702":{"__typename":"ModerationData","id":"moderation_data:753702","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:753702":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:753702","relatedMessage":{"__ref":"ForumTopicMessage:message:753702"}},"Rank:rank:173":{"__typename":"Rank","id":"rank:173","position":56,"name":"Experienced Cover User","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:59632":{"__typename":"User","id":"user:59632","uid":59632,"login":"6203","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2012-08-07T13:02:06.592+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-1.svg?time=0"},"rank":{"__ref":"Rank:rank:173"},"messagesCount":53,"kudosGivenCount":2,"kudosReceivedCount":4,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:59632"},"ForumTopicMessage:message:801466":{"__typename":"ForumTopicMessage","uid":801466,"subject":"Can't export reports to Excel","id":"message:801466","revisionNum":1,"repliesCount":7,"author":{"__ref":"User:user:59632"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:AccountRight-Reports"},"conversation":{"__ref":"Conversation:conversation:801466"},"moderationData":{"__ref":"ModerationData:moderation_data:801466"},"postTime":"2023-01-30T15:32:50.651+11:00","lastPublishTime":"2023-01-30T15:32:50.651+11:00","readOnly":true,"metrics":{"__typename":"MessageMetrics","views":1305},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:AccountRight-Reports/message:801466"},"Conversation:conversation:801466":{"__typename":"Conversation","id":"conversation:801466","solved":true,"topic":{"__ref":"ForumTopicMessage:message:801466"},"lastPostingActivityTime":"2023-07-07T09:30:13.766+10:00","lastPostTime":"2023-07-07T09:30:13.766+10:00"},"ModerationData:moderation_data:801466":{"__typename":"ModerationData","id":"moderation_data:801466","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:801466":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:801466","relatedMessage":{"__ref":"ForumTopicMessage:message:801466"}},"User:user:126404":{"__typename":"User","id":"user:126404","uid":126404,"login":"deb06","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2014-11-26T22:24:41.889+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-9.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:126404"},"ForumTopicMessage:message:862858":{"__typename":"ForumTopicMessage","uid":862858,"subject":"Exporting report to Excel","id":"message:862858","revisionNum":1,"repliesCount":2,"author":{"__ref":"User:user:126404"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:AccountRight-Reports"},"conversation":{"__ref":"Conversation:conversation:862858"},"moderationData":{"__ref":"ModerationData:moderation_data:862858"},"postTime":"2024-03-23T09:54:13.372+11:00","lastPublishTime":"2024-03-23T09:54:13.372+11:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":216},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:AccountRight-Reports/message:862858"},"Conversation:conversation:862858":{"__typename":"Conversation","id":"conversation:862858","solved":true,"topic":{"__ref":"ForumTopicMessage:message:862858"},"lastPostingActivityTime":"2024-08-12T12:20:11.062+10:00","lastPostTime":"2024-08-12T12:20:11.062+10:00"},"ModerationData:moderation_data:862858":{"__typename":"ModerationData","id":"moderation_data:862858","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:862858":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:862858","relatedMessage":{"__ref":"ForumTopicMessage:message:862858"}},"User:user:276588":{"__typename":"User","id":"user:276588","uid":276588,"login":"EQ996","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-07-01T10:45:20.326+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-7.svg?time=0"},"rank":{"__ref":"Rank:rank:189"},"messagesCount":11,"kudosGivenCount":0,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:myob/user:276588"},"ForumTopicMessage:message:787580":{"__typename":"ForumTopicMessage","uid":787580,"subject":"Excel report export","id":"message:787580","revisionNum":1,"repliesCount":1,"author":{"__ref":"User:user:276588"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:AccountRight-Reports"},"conversation":{"__ref":"Conversation:conversation:787580"},"moderationData":{"__ref":"ModerationData:moderation_data:787580"},"postTime":"2022-10-28T12:41:20.888+11:00","lastPublishTime":"2022-10-28T12:41:20.888+11:00","readOnly":true,"metrics":{"__typename":"MessageMetrics","views":466},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:AccountRight-Reports/message:787580"},"Conversation:conversation:787580":{"__typename":"Conversation","id":"conversation:787580","solved":true,"topic":{"__ref":"ForumTopicMessage:message:787580"},"lastPostingActivityTime":"2022-10-31T07:57:24.922+11:00","lastPostTime":"2022-10-31T07:57:24.922+11:00"},"ModerationData:moderation_data:787580":{"__typename":"ModerationData","id":"moderation_data:787580","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:787580":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:787580","relatedMessage":{"__ref":"ForumTopicMessage:message:787580"}},"User:user:203109":{"__typename":"User","id":"user:203109","uid":203109,"login":"HazelT","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-06-20T09:02:38.622+10:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":null},"rank":{"__ref":"Rank:rank:187"},"messagesCount":15,"kudosGivenCount":4,"kudosReceivedCount":11,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":2,"entityType":"USER","eventPath":"community:myob/user:203109"},"ForumTopicMessage:message:819739":{"__typename":"ForumTopicMessage","uid":819739,"subject":"EXPORTING SALES REPORT TO EXCEL","id":"message:819739","revisionNum":1,"repliesCount":2,"author":{"__ref":"User:user:203109"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"conversation":{"__ref":"Conversation:conversation:819739"},"moderationData":{"__ref":"ModerationData:moderation_data:819739"},"postTime":"2023-06-14T11:59:05.467+10:00","lastPublishTime":"2023-06-14T11:59:05.467+10:00","readOnly":true,"metrics":{"__typename":"MessageMetrics","views":569},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/message:819739"},"Conversation:conversation:819739":{"__typename":"Conversation","id":"conversation:819739","solved":true,"topic":{"__ref":"ForumTopicMessage:message:819739"},"lastPostingActivityTime":"2023-06-15T16:41:32.695+10:00","lastPostTime":"2023-06-15T16:41:32.695+10:00"},"ModerationData:moderation_data:819739":{"__typename":"ModerationData","id":"moderation_data:819739","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:819739":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:819739","relatedMessage":{"__ref":"ForumTopicMessage:message:819739"}},"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":9280},"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"}},"CachedAsset:text:en_US-components/community/Navbar-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1744329197109","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1744329197109","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1744329197109","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1744329197109","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1744329197109","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1744329197109","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1744329197109","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1744329197109","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/MessageDeepLink-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageDeepLink-1744329197109","value":{"viewFullDiscussion@board:FORUM":"View Full Discussion ({repliesCount} Replies)","viewFullDiscussion@board:BLOG":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:TKB":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:IDEA":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:OCCASION":"View Full Discussion ({repliesCount} Comments)","showParents@board:FORUM":"Show Parent Replies","showParents@board:BLOG":"Show Parent Comments","showParents@board:TKB":"Show Parent Comments","showParents@board:IDEA":"Show Parent Comments","showParents@board:OCCASION":"Show Parent Comments"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyCallToAction-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1744329197109","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1744329197109","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/BuildInformation-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/BuildInformation-1744329197109","value":{"buildHash":"Build Hash: {buildHash}","buildNumber":"Build Number: {buildNumber}","buildTime":"Build Time: {buildTime}"},"localOverride":false},"CachedAsset:text:en_US-components/community/KhorosLogo-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/community/KhorosLogo-1744329197109","value":{"alt":"Powered By Khoros"},"localOverride":false},"QueryVariables:MessageSolutions":{"__typename":"QueryVariables","id":"MessageSolutions","value":{"first":10,"constraints":{"topicId":{"eq":"message:678539"},"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}},"ROOT_MUTATION":{"__typename":"Mutation"},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1744329197109","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1744329197109","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1744329197109","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1744329197109","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1744329197109","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1744329197109","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1744329197109","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1744329197109","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1744329197109","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1744329197109","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolutionList-1744329197109","value":{"emptyDescription":"No has been message solutions yet"},"localOverride":false},"CachedAsset:text:en_US-components/customComponent/CustomComponent-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/customComponent/CustomComponent-1744329197109","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-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1744329197109","value":{"bylineAuthor":"{bylineAuthor}","bylineBoard":"{bylineBoard}","anonymous":"Anonymous","place":"Place {bylineBoard}","gotoParent":"Go to parent {name}"},"localOverride":false},"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"},"entityType":"USER","eventPath":"community:myob/user:1368","rank":{"__ref":"Rank:rank:165"}},"ForumReplyMessage:message:683646":{"__typename":"ForumReplyMessage","uid":683646,"id":"message:683646","revisionNum":1,"author":{"__ref":"User:user:229640"},"readOnly":true,"depth":6,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"parent":{"__ref":"ForumReplyMessage:message:683042"},"conversation":{"__ref":"Conversation:conversation:678539"},"subject":"Re: Exporting Reports to Excel","moderationData":{"__ref":"ModerationData:moderation_data:683646"},"body":"There are no logos or images and they are being exported to Excel in the same fashion as always, again this month the end file size is huge.
I run a series of reports and copy those reports into one excel spreadsheet for reporting purposes. I copy the whole sheet not just the cells with information as it saves time, and up to now has not caused an issue.
Are the reports now formatting the whole worksheet? is that the issue? if so can you not?
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"208","kudosSumWeight":0,"repliesCount":2,"postTime":"2020-11-05T14:55:36.569+11:00","lastPublishTime":"2020-11-05T14:55:36.569+11:00","metrics":{"__typename":"MessageMetrics","views":1445},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/message:678539/message:683646","customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"editFrozen":false,"body@stringLength":"529","rawBody":"
There are no logos or images and they are being exported to Excel in the same fashion as always, again this month the end file size is huge.
I run a series of reports and copy those reports into one excel spreadsheet for reporting purposes. I copy the whole sheet not just the cells with information as it saves time, and up to now has not caused an issue.
Are the reports now formatting the whole worksheet? is that the issue? if so can you not?
","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:683646_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:683798":{"__typename":"ModerationData","id":"moderation_data:683798","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"AcceptedSolutionMessage:message:683798":{"__typename":"AcceptedSolutionMessage","author":{"__ref":"User:user:1368"},"id":"message:683798","revisionNum":1,"uid":683798,"depth":7,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"parent":{"__ref":"ForumReplyMessage:message:683646"},"conversation":{"__ref":"Conversation:conversation:678539"},"subject":"Re: Exporting Reports to Excel","moderationData":{"__ref":"ModerationData:moderation_data:683798"},"body":"
Hi SueSSA , none of the report templates that AccountRight uses are above 100k, so I suspect the issue may occur in your process.
Can you run a test - prepare the set of reports as you do, but save the file under a different name at the very beginning, and between each new report added. Then have a look at the file sizes, and see if there is any one report that causes a large increase.
Then repeat the process, but this time only copy the area of data from each report, not the whole thing. Again check the file sizes.
","body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"218","postTime":"2020-11-06T11:21:04.825+11:00","lastPublishTime":"2020-11-06T11:21:04.825+11: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":[]},"solution":true,"metrics":{"__typename":"MessageMetrics","views":1454},"placeholder":false,"originalMessageForPlaceholder":null,"videos":{"__typename":"VideoConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"isEscalated":null,"entityType":"FORUM_REPLY","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/message:678539/message:683798","customFields":[],"readOnly":true,"editFrozen":false,"body@stringLength":"883","rawBody":"
Hi
Can you run a test - prepare the set of reports as you do, but save the file under a different name at the very beginning, and between each new report added. Then have a look at the file sizes, and see if there is any one report that causes a large increase.
Then repeat the process, but this time only copy the area of data from each report, not the whole thing. Again check the file sizes.
","kudosSumWeight":0,"repliesCount":1,"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:683798_1"},"latestVersion":null,"visibilityScope":"PUBLIC","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":[]}}}},"Rank:rank:61":{"__typename":"Rank","id":"rank:61","position":9,"name":"MYOB Staff","color":"A130F5","icon":null,"rankStyle":"TEXT"},"User:user:202751":{"__typename":"User","id":"user:202751","uid":202751,"login":"Komal_S","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.myob.com/t5/s/myob/images/dS0yMDI3NTEtMjQ0ODNpMjhCRjUwMDdGQ0U2QUE1MA"},"rank":{"__ref":"Rank:rank:61"},"email":"","messagesCount":8280,"biography":null,"topicsCount":14,"kudosReceivedCount":745,"kudosGivenCount":1005,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-06-17T12:44:13.038+10:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":1164,"entityType":"USER","eventPath":"community:myob/user:202751"},"ModerationData:moderation_data:679844":{"__typename":"ModerationData","id":"moderation_data:679844","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ModerationData:moderation_data:679410":{"__typename":"ModerationData","id":"moderation_data:679410","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:679410":{"__typename":"ForumReplyMessage","id":"message:679410","revisionNum":1,"uid":679410,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"conversation":{"__ref":"Conversation:conversation:678539"},"subject":"Re: Exporting Reports to Excel","readOnly":true,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:679410"},"body":"
I export the reports to Excel and then send the spreadsheet on via email. This month they are 200x the size they normally are and I can not email as they are way to big.
","body@stringLength":"182","rawBody":"I export the reports to Excel and then send the spreadsheet on via email. This month they are 200x the size they normally are and I can not email as they are way to big.
","author":{"__ref":"User:user:229640"},"isEscalated":null,"postTime":"2020-10-08T10:15:42.760+11:00","solution":false,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"kudosSumWeight":0,"repliesCount":7,"images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:679410_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":1549},"visibilityScope":"PUBLIC","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":[]}}}},"Revision:revision:679844_1":{"__typename":"Revision","id":"revision:679844_1","lastEditTime":"2020-10-12T11:42:38.924+11:00"},"QueryVariables:ReplyList:message:679844:1":{"__typename":"QueryVariables","id":"ReplyList:message:679844:1","value":{"id":"message:679844","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":false,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1744329197109","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1744329197109","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1744329197109","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-components/messages/ThreadedReplyList-1744329197109":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1744329197109","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},"Rank:rank:165":{"__typename":"Rank","id":"rank:165","position":52,"name":"Ultimate Cover User","color":"333333","icon":null,"rankStyle":"TEXT"},"Revision:revision:683798_1":{"__typename":"Revision","id":"revision:683798_1","lastEditTime":"2020-11-06T11:21:04.825+11:00"},"Revision:revision:679410_1":{"__typename":"Revision","id":"revision:679410_1","lastEditTime":"2020-10-08T10:15:42.760+11:00"},"ModerationData:moderation_data:682260":{"__typename":"ModerationData","id":"moderation_data:682260","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:682260":{"__typename":"ForumReplyMessage","uid":682260,"id":"message:682260","revisionNum":1,"author":{"__ref":"User:user:229640"},"readOnly":true,"repliesCount":5,"depth":4,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"parent":{"__ref":"ForumReplyMessage:message:679844"},"conversation":{"__ref":"Conversation:conversation:678539"},"subject":"Re: Exporting Reports to Excel","moderationData":{"__ref":"ModerationData:moderation_data:682260"},"body":"it is profit and loss, balance sheet etc nothing long or big that should cause that size.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"91","kudosSumWeight":0,"postTime":"2020-10-29T09:54:05.244+11:00","lastPublishTime":"2020-10-29T09:54:05.244+11:00","metrics":{"__typename":"MessageMetrics","views":1479},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/message:678539/message:682260","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wzfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:683065"}},{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wzfDE0OjAsMzk6MXwy","node":{"__ref":"ForumReplyMessage:message:683042"}}]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"editFrozen":false,"body@stringLength":"96","rawBody":"it is profit and loss, balance sheet etc nothing long or big that should cause that size.
","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:682260_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:683065":{"__typename":"ModerationData","id":"moderation_data:683065","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:683065":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1368"},"id":"message:683065","revisionNum":1,"uid":683065,"depth":5,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"parent":{"__ref":"ForumReplyMessage:message:682260"},"conversation":{"__ref":"Conversation:conversation:678539"},"subject":"Re: Exporting Reports to Excel","moderationData":{"__ref":"ModerationData:moderation_data:683065"},"body":"Hi SueSSA , a couple of links that have suggestions that may help:
https://www.excelefficiency.com/reduce-excel-file-size/
https://www.exceltip.com/tips/why-is-my-excel-file-so-large-how-to-reduce-the-excel-file-size.html
Re the used range, if you press Ctrl+Shift+End, what cell does Excel jump to? If it's XFQ1048576 for example (the bottom-most, right-most cell in Excel 2016), then the file will be huge, and all the rows below your report should be selected and deleted.
Do you add anything to the file after exporting, or just save it? What version of Excel are you using?
Are you using the standard MYOB Excel template for this report, or a modified version?
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"213","kudosSumWeight":1,"repliesCount":0,"postTime":"2020-11-03T12:25:56.965+11:00","lastPublishTime":"2020-11-03T12:25:56.965+11:00","metrics":{"__typename":"MessageMetrics","views":1455},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:AccountRight/category:Support/community:myobboard:Sales_and_Purchases/message:678539/message:683065","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"readOnly":true,"editFrozen":false,"body@stringLength":"1397","rawBody":"Hi
https://www.excelefficiency.com/reduce-excel-file-size/
https://www.exceltip.com/tips/why-is-my-excel-file-so-large-how-to-reduce-the-excel-file-size.html
Re the used range, if you press Ctrl+Shift+End, what cell does Excel jump to? If it's XFQ1048576 for example (the bottom-most, right-most cell in Excel 2016), then the file will be huge, and all the rows below your report should be selected and deleted.
Do you add anything to the file after exporting, or just save it? What version of Excel are you using?
Are you using the standard MYOB Excel template for this report, or a modified version?
","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:683065_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:683042":{"__typename":"ModerationData","id":"moderation_data:683042","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:683042":{"__typename":"ForumReplyMessage","uid":683042,"id":"message:683042","revisionNum":1,"author":{"__ref":"User:user:202751"},"readOnly":true,"repliesCount":3,"depth":5,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Sales_and_Purchases"},"parent":{"__ref":"ForumReplyMessage:message:682260"},"conversation":{"__ref":"Conversation:conversation:678539"},"subject":"Re: Exporting Reports to Excel","moderationData":{"__ref":"ModerationData:moderation_data:683042"},"body":"Hi SueSSA
\n
Upon further investigation, we've not found any specific issues with the report sizes in 2020.3. The balance sheet or profit and loss reports should not grow massively in size as the data retreived for these reports are just the account values as you mentioned. However, if your reports are custom reports or have logos/images on them, try removing them as that could cause a difference.
Also, what happens when you print the same reports from Clearwater sample file? If they are normal in size, the issue would be with the customisation of reports as previously mentioned.
Please do not hesitate to post if you have further concerns on this.
Hi
Upon further investigation, we've not found any specific issues with the report sizes in 2020.3. The balance sheet or profit and loss reports should not grow massively in size as the data retreived for these reports are just the account values as you mentioned. However, if your reports are custom reports or have logos/images on them, try removing them as that could cause a difference.
Also, what happens when you print the same reports from Clearwater sample file? If they are normal in size, the issue would be with the customisation of reports as previously mentioned.
Please do not hesitate to post if you have further concerns on this.
/discussions/bus-invent/item-no-will-not-print-on-purchase-order/887248/replies/679844